1z0-588 by Oracle Valid Free Exam Practice Test

Question 1

Choose three validations that are often implemented for downstream systems.

A. Property value has the correct format. B. Length of a property category value. C. Property has been populated. D. Node exists in multiple downstream systems. E. Name or description is unique.

Correct Answer: A,B,D

Question 2

Acme Corporation just finished the initial DRM data load.
The files were sourced from several different applications and some of the data files required manual modification.
Identify potential data quality issues found when reviewing the data loaded into DRM

A. Duplicate nodes across hierarchies. B. Property values are substantially different from the stated and documented business rules. C. A failure in enforcing unique values for specific properties. D. The user does not have access to run an import. E. Duplicate nodes within each hierarchy.

Correct Answer: C

Question 3

Review the example below:
Product
All Products

Alternate Product Hierarchy
All Products
High Calorie, Sugar Filled Products

Your target Essbase database requires an alternate of the Product, rolling up product
SKUs by Caffeinated and NonCaffeinated. You currently maintain this value as a property.
Once a valid export is built, what are the two ways you can create the new hierarchy in an existing version?

A. Use the DRM Migration utility to build the alternate hierarchy into a new version and then the Blend feature to blend into an existing version. B. Use an Import to build the alternate hierarchy into a new version and then the Blend feature to blend into an existing version. C. Use the DRM Migration utility to build the alternate hierarchy into an existing version. D. Use an Action script to build the alternate hierarchy into the existing version. E. Use an Import to build the alternate hierarchy in DRM into the existing version.

Correct Answer: B,E

Question 4

You have built avalidationto ensure that ahierarchyhas no more than 20,000 nodes. What is the correct validation level?

A. Global Node B. Node C. Merge D. Version E. Global Hierarchy F. Hierarchy

Correct Answer: A

Question 5

Your ETL must leverage a mapping maintained in DRM. How can your ETL access the mapping data from DRM?

A. Use the Batch interface to connect the ETLto the underlying DRM tables. B. Use the API to connect the ETL tool to the underlying DRM tables. C. Access the database directly with the DRM user. D. Access the data files directly through the DRM's application server. E. Create an export of the mapping data and load to a relational table accessible to the
ETL tool.

Correct Answer: C

Question 6

Identify the three true statements about External Connections.

A. 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. B. Defined connections for FTP or UNC file path representing a target or source for an import/export. C. Only Administrators can configure or use External Connections. D. Passwords will display for connections. E. You must explicitly choose the allowed tables for external database connections; this preventsusers from exporting to the incorrect table.

Correct Answer: A,C,E

Question 7

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, 4 only D. 1, 2, 3, 4, 5 E. 1, 2, 3 only

Correct Answer: A

Question 8

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. Create the export and assign security for the export to the Budget Office. B. Make sure that you have Application Administrator access at a minimum. C. Save the Export as a Standard object. D. Grant the Budget Office access to the Entity hierarchy. E. Save the Export as a System object.

Correct Answer: A

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