Oracle Hyperion Enterprise Test

AWSCORP uses Hyperion Planning and plans a major reorganization of the company structure. As part of the change, you are asked to rebuild the Entity dimension from scratch. To start, you have to delete members in the Entity dimension. Which of these would you do:

A. You must delete members one by one.
B. You must delete a reference to a member from all data forms before deleting it from the dimension.
C. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
D. A database refresh is required after deleting members from the Entity dimension.

Zendaya works as Hyperion Planning Developer at Oscars Inc. When opening data forms, users are experiencing slow performance. What 3 steps could Zendaya do to improve the time it takes to open the data form?

A: Reduce the number of rows and columns displayed in the data form
B: Upgrade the client machine's operating system processing speed and RAM
C: In the data form definition, remove the option to display alias
D: Reduce the number of page dimension used on the Web form
E: Tune the index and data caches in Essbase

Two companies A and B hired developers from the year 2001 to 2005. The given bar graph shows the hiring details. 

Now select the statements that are true based on the given details.

A: The data given for Company A is skewed to the left.
B: The data given for Company B is skewed to the right.
C: The data given for Company A is skewed to the right.
D: For Company B, mean and mode are equal.
E: For Company B, mean is equal to median but less than mode.
F: For Company A, median is less than mode but greater than mean.

Saffi, one of the popular schools in San Francisco did a school wide study of the students in middle school. The study found that there is a negative correlation between the time spent on Facebook per day by students and their academic achievement. How can we understand the results of this study?

A: An increase in time spent on Facebook per day causes a drop in the academic achievement of students at the middle school level.

B: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at Saffi. 

C: An increase in the time spent on Facebook per day causes a drop in the academic achievement of students at Saffi. 

D: There is an association between an increase in time spent on Facebook per day and the drop in the academic achievement of students at the middle school level.

Su is the project manager for a Bengaluru based video storage company. The allowable deviation for video compression time is ±150 milliseconds. They use a third party service which offers an API for video compression. The third party service delivers documentation with the latest version of the API which states that the requirements are being met as per specification. Su’s team conducts multiple quality tests on the API. The aggregate deviation found by her team is 155 milliseconds, but the team says this variation from the permissible deviation is negligible. What should Su do?

A: Allow the API since the third party vendor provided the product on time
B: Allow the API for now, but ask the third party vendor for an explanation
C: Document the low level of quality, allow the API to be used and work with the third party vendor to find a solution
D: Reject the API and ask the third party vendor to provide the product within the allowable deviation
E: Use the API for now, and start developing their own video compression API to use in the future
F: Halt the project and start developing their own video compression API

You are the project manager for a software product that is scheduled for launch in two weeks. Your team brings two bugs to your attention.

Bug 1, if unattended, could lead to loss of critical customer data but is hard to replicate. There's an estimated 2% chance it could occur under normal conditions.

Bug 2 affects the usability of a secondary feature and happens frequently. The feature is nice-to-have and does not impact core functionality.

To address these bugs, you have five options:

A) Delay the launch by one week and deploy resources to fix both bugs.

B) Proceed with the launch as scheduled, with a built-in monitoring system to alert if Bug 1 occurs. If it does, immediately release a patch. Bug 2 will be addressed in the next scheduled update.

C) Share the information about both bugs with the stakeholders, highlighting the potential risks and impacts, and ask them for guidance.

D) Ignore Bug 2 and deploy additional resources to fix Bug 1 without delaying the launch.

E) Delay the launch by two weeks to conduct a thorough investigation and ensure that both bugs are resolved.

What is the most suitable course of action according to project management principles?

You are the project manager of a software development team following Agile methodologies. Your team is planning for the next two-week sprint. The team's composition and capacity (in story points) for the upcoming sprint is as follows:

- 2 Backend Developers: 15 each
- 2 Frontend Developers: 15 each
- 1 QA Analyst: 15

On Day 5 of the sprint, the Product Owner introduces a new high-priority user story from a key stakeholder. This story, estimated at 5 story points, requires 2 points of backend work, 2 points of frontend work, and 1 point of QA.

Your team's current sprint status (utilized/total capacity) is:

- Backend Developers: 7/15 each
- Frontend Developers: 9/15 each
- QA Analyst: 10/15

Here are your options:

A) Reallocate 5 story points worth of work (in a way that it matches the new story requirements) from the team's current tasks to the Product Owner's high-priority story.

B) Reject the new story citing the team's current workload, and suggest considering it for the next sprint.

C) Ask the team to stretch their capacity by 5 points (appropriately distributed among team members) to accommodate the new story.

D) Remove a yet-to-be-started user story worth 5 points (requiring 2 backend, 2 frontend, and 1 QA points) from the current sprint to make room for the new story.

E) Split the high-priority story into two smaller stories and distribute it over the current and next sprint.

Which is the most appropriate course of action according to Agile project management principles?