1z1-588 Exam Training Practice Tests (Oracle Hyperion Data Relationship Management Essentials)]

Question 1

Per the Example:

You need to load both the Product and Market hierarchies to multiple Essbase databases.
Identify three DRM objects that could be used across both Product and Market hierarchies?

A. Generation export definitions B. Common Essbase system validations C. Parent/Child export definitions D. Level export definitions E. Common Essbase system properties

Correct Answer: B,C,E

Question 2

Identify the two true statements about node access groups.

A. Node access groups may be assigned by the Application Administrator or Access
Manager. B. Access levels are assigned separately for leaf and limb nodes. C. Valid node access levels are Read, Edit,LimitedEdit, Insert, Inactivate, and Add. D. Node access groups use inheritance to assign the same access to descendants of a node but this inherited security may be overwritten at lower levels. E. Node access groups can be used to filter the display of the hierarchy so that users only see the section of the hierarchy for which they have access.

Correct Answer: A,C

Question 3

Per the example:

What are the three outcomes after running the action script?

A. The two lines with the "Move" command will fail, because a value is missing from the last column for those lines. B. A hierarchy called "Product" will be created in the Reorganization version in DRM. C. Nothing changes in DRM, because the action script will fail to import due to formatting issues. D. The top node in the hierarchy is All Products. E. Products 100-10, 100-20, 100-30, 200-10, 200-20, 200-40, 400-10, and 400-30 are some of the leaf nodes in the hierarchy. F. Products 100, 200, 300, and 400 are first created under the incorrect parent but are subsequently moved in the action script.

Correct Answer: C,E,F

Question 4

Identify the three true statements about External Connections.

A. Only Administrators can configure or use External Connections. B. You must explicitly choose the allowed tables for external database connections; this preventsusers from exporting to the incorrect table. C. Passwords will display for connections. D. They allow you to have multiple exports or books target the same network folder or database, sothat, if the folder changes, you can just update the External Connection, rather than all the individual exports. E. Defined connections for FTP or UNC file path representing a target or source for an import/export.

Correct Answer: A,B,D

Question 5

Identify the three true statements about version types.

A. A normal version type is a version that can be editedand its status changed. B. You may change the status of an "As Of version. C. Finalized versions can never have their status changed. D. An "As Of" version is a historical view of a normal version based on a date or transaction
ID. E. Baseline version is a copy of a normal version at the time that it was created.

Correct Answer: A

Question 6

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

A. 1, 3, 4, 5, 6 only B. 1, 3, 4, 5, 7 only C. 1, 2, 3, 4, 5, 6, 7 D. 1, 2, 4, 5, 6 only E. 1, 2, 4, 5 only F. 1, 2, 4, 5, 7 only

Correct Answer: E

Question 7

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, For both the SAP and
PS account properties, users should be able to select from a drop-down list the correct accounts that should be mapped to the consolidated account. Many SAP or PS accounts could be mapped to a single consolidated account.
What property type should you set for the SAP Account Property and PS Account Property, assuming that you have built the SAP and PS chart of account hierarchies in DRM?

A. List B. Lookup C. AscNode D. RangeList E. AscNodes

Correct Answer: A

Question 8

What two DRM features allow you to group hierarchies used for data mappings for easier selection and browsing?

A. Property category B. Node type C. Hierarchy master D. Hierarchy group E. Version

Correct Answer: A,D

Oracle Hyperion Data Relationship Management Essentials - 1z1-588 Exam Practice Test