oracle 1z0-588 practice test
Oracle Hyperion Data Relationship Management Essentials Exam
Question 1
Which three statements are true about the stakeholders in a DRM implementation?
- A. Business users are initially brought into the project during the testing process.
- B. Source and target systems administrators have minimal involvement during the DRM implementation.
- C. The DRM administrator use both prebuilt and custom property definitions and property categories to create versions and hierarchies as dictated by requirements and design.
- D. The DRM administrator creates validations dictated by requirements and design.
- E. A data governance team defines overall standards for the DRM implementation.
Answer:
ABC
Question 2
You have defined Essbase properties for the First entity, E01. You would now like to apply those same
values to the remaining entity list including siblings and descendants.
What are two ways to complete this step?
- A. Using the Match feature in DRM
- B. Using the Model After feature in DRM for each new entity
- C. Using the Model After feature in an import script
- D. Changing the properties to turn on inheritance
- E. Using the Copy/Put Properties feature for the siblings and descendants of E01
Answer:
AB
Question 3
You are ready to run batch validations against a version before exporting to target systems. Identify
two valid version statuses that allow batch validations to be run and issues to be corrected before the
exports to target systems.
- A. Working
- B. Submitted
- C. Final
- D. Expired
- E. Baseline
Answer:
BC
Question 4
What are the four valid functions available in the DRM Migration utility?
- A. Extract hierarchies and property values from one DRM version.
- B. Extract property definitions, property categories, validations, and queries from a DRM application to an XML file.
- C. Load hierarchies and property values to a DRM version.
- D. Load metadata from an XML file into a Data Relationship Management application.
- E. Compare metadata differences between two sources, such as a development DRM instance to a production DRM instance.
- F. Generate an HTML report from the results.
Answer:
BCEF
Question 5
How can downstream systems receive exported data from DRM?
1. Database query
2. Export
3. Export Book
4. API
5. DRM Migration utility
- A. 2, 3 only
- B. 2, 3, 4 only
- C. 1, 2, 3 only
- D. 1, 2, 3, 4 only
- E. 1, 2, 3, 4, 5
Answer:
A
Question 6
Identify three common issues that are addressed by DRM out of the box.
- A. Physical reconciliation of fact data from transaction systems
- B. No central point of maintenance for a dimension
- C. Hierarchies are maintained by IT
- D. Rationalization of hierarchies across systems
- E. Lengthy reconciliations and manual process to make changes in data relationships
Answer:
BDE
Question 7
Per the example:
Your organization has two ERPs: PeopleSoft (PS) and SAP. Each ERP has its own chart of accounts.
Each chart of accounts is mapped to a consolidated chart of accounts. The Finance department
maintains the consolidated account hierarchy.
Identify the steps in the correct order to manage the mapping of the local chart of accounts in the
consolidated chart of accounts structure using DRM hierarchies.
1. Build the consolidated chart of accounts hierarchy.
2. Build the PeopleSoft and SAP chart of accounts hierarchies.
3. Create a property category called CoA Map with two property definitions: PS CoA Mapping and
SAP CoA Mapping.
4. Create an alternate Market hierarchy with limb nodes "large", "Medium", and "Small". Insert cities
as leaf nodes under the appropriate Market Size nodes.
5. Use the Blend function to merge the PeopleSoft and sap chart of accounts to the correct
consolidated account node In the consolidated hierarchy.
6. Drag and drop the PeopleSoft and SAP chart of accounts to the correct consolidated account in the
consolidated hierarchy.
- A. 1, 2, 3, 4, 5, 6
- B. 3, 1, 2, 4, 6
- C. 3, 1, 2, 5, 6
- D. 1, 2, 4, 6
- E. 4, 3, 1, 2, 5, 6
Answer:
C
Question 8
Select the three options that will complete this sentence to make it a true statement:
"Batch validations in DRM may be run for a_____."
- A. Version
- B. Node Type
- C. Hierarchy
- D. Node
- E. Node and its ancestors
Answer:
C
Question 9
If you want to create an export for the Budget Office to export the Entity hierarchy. Which two steps
must be completed in order to accomplish this?
- A. Make sure that you have Application Administrator access at a minimum.
- B. Create the export and assign security for the export to the Budget Office.
- C. Save the Export as a System object.
- D. Save the Export as a Standard object.
- E. Grant the Budget Office access to the Entity hierarchy.
Answer:
B
Question 10
The images or icons in the first two columns of the properties Tab indicate the following about a
property:
1. Local property or global property
2. Locally inherited or globally inherited
3. Value is overridden
4. Value is default
5. Value is calculated
6. Value is manually entered
- A. 1, 2 only
- B. 1, 2, 3 only
- C. 1, 2, 4 only
- D. 1, 4 only
- E. 1, 2, 3, 4, 6 only
- F. 1, 2, 3, 4, 5 only
Answer:
F