Question 1
What are three functions that can be performed by the Data Creator role?
Correct Answer:
A. Manage all hierarchies; B. Create hierarchies; E. Manage standard queries
Free Oracle Hyperion Data Relationship Management Essentials 1Z0-588 Exam Questions
Question 2
Identify the three true statements about the Initial Data Load process when you first implement DRM.
Correct Answer:
B. Duplicate node identifier information should be consistent with the Shared Node Maintenance system preferences so that you can import duplicate nodes as shared nodes.; D. You must setup node types before building property definitions.; E. Skipping blank values and using default values to minimize the size of the data loaded is recommended.
Question 3
Identify the three true statements about using the "Asc" property types.
Correct Answer:
A. They are used to sort hierarchies in ascending order.; C. Associated nodes do not need to exist prior to import of the hierarchy.; F. They pull in the node hierarchy and the node name.
Question 4
Identify three ways to narrow the scope of the first phase of the DRM implementation.
Correct Answer:
B. Design and build the DRM process for a single target and single source.; D. Exclude validations and verifications.; E. Focus the design to a single version.
Question 5
Choose three validations that are often implemented for downstream systems.
Correct Answer:
C. Length of a property category value.; D. Property value has the correct format.; E. Node exists in multiple downstream systems.
Question 6
How can downstream systems receive exported data from DRM?
1. Database query
2. Export
3. Export Book
4. API
5. DRM Migration utility
Correct Answer:
A. 2, 3 only
Question 7
Identify the three true statements about Workflow in DRM.
Correct Answer:
A. Change requests are stored in a draft state for approval.; C. Change requests pending approval cannot be changes until the change has been approved.; D. Change requests are committed to a version once the request is approved.
Question 8
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.
Correct Answer:
C. 3, 1, 2, 5, 6
Question 9
Identify the two true statements about node access groups.
Correct Answer:
B. Valid node access levels are Read, Edit, LimitedEdit, Insert, Inactivate, and Add.; E. Node access groups may be assigned by the Application Administrator or Access Manager.
Question 10
Per the following example:
All Products
The product team has decided to group 300 and 400 product categories into a single "Fruity" product category. Which three statements are true about performing this change within a single hierarchy?
Correct Answer:
B. Users can use the right-click menu items to Take and Put the nodes under a new node called
'Fruity.'