Oracle Hyperion Data Relationship Management Essentials - 1z1-588 Exam Practice Test
Question 1
You want an import to stop if a duplicate node is found. How do you do this?
Correct Answer: A
Question 2
An issue exists in which "reserved" key words have been used or included in the custom alias property for a downstream system. The reserved words are "Dynamic" and
"MBRNAME".
The steps for creating a real-time validation are:
1. Create a custom property to verify that the value input in the custom alias property does not contain the reserved words.
2 . Test the custom property.
3 . Create a custom Validation with the "Property Equals Value" class.
4 . Test the validation.
5 . Assign the Validation to a version.
"MBRNAME".
The steps for creating a real-time validation are:
1. Create a custom property to verify that the value input in the custom alias property does not contain the reserved words.
2 . Test the custom property.
3 . Create a custom Validation with the "Property Equals Value" class.
4 . Test the validation.
5 . Assign the Validation to a version.
Correct Answer: D
Question 3
You want to create a derived field that concatenates the name and description of a node to display "Name-Description."
Select the two valid syntax types for a derived property using a formula.
Select the two valid syntax types for a derived property using a formula.
Correct Answer: C,D
Question 4
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 accountsstructure 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.
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 accountsstructure 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: D
Question 5
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.
Identify two valid version statuses that allow batch validations to be run and issues to be corrected before the exports to target systems.
Correct Answer: A,E
Question 6
Select the three options that will complete this sentence to make it a true statement:
"A customer who uses best practices in the master data management of relationships and hierarchies _____."
"A customer who uses best practices in the master data management of relationships and hierarchies _____."
Correct Answer: B,C,D
Question 7
Identify the valid Import sections and the required columns for each section.
1 . Version, Required column: version name
2 . Hierarchy, Required columns: hierarchy name, top node
3 . Hierarchy, Required columns: hierarchy name
4 . Node, Required column: node name
5 . Relationship, Required columns: parent node name, child node name
6 . Hierarchy Node, Required columns: hierarchy name, node name
7 . Hierarchy Node, Required columns: hierarchy name
1 . Version, Required column: version name
2 . Hierarchy, Required columns: hierarchy name, top node
3 . Hierarchy, Required columns: hierarchy name
4 . Node, Required column: node name
5 . Relationship, Required columns: parent node name, child node name
6 . Hierarchy Node, Required columns: hierarchy name, node name
7 . Hierarchy Node, Required columns: hierarchy name
Correct Answer: B
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_____."
"Batch validations in DRM may be run for a_____."
Correct Answer: C
