1. Home
  2. Oracle
  3. Data Relationship Management
  4. 1z0-588
  5. Oracle Hyperion Data Relationship Management Essentials Questions and Answers

Pass the Oracle Data Relationship Management 1z0-588 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

Options:
A.

1, 2, 4, 5 only

B.

1, 2, 4, 5, 6 only

C.

1, 3, 4, 5, 6 only

D.

1, 2, 4, 5, 7 only

E.

1, 3, 4, 5, 7 only

F.

1, 2, 3, 4, 5, 6, 7

Expert Solution
Questions # 2:

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.

Options:
A.

Concat(Abbrev,"-",Descr)

B.

Concat(Abbrev(), -,Descr())

C.

Concat(PropValue(Core.Abbrev)| - | PropValue(Core. Descr))

D.

Concat(PropValue(Core.Abbrev),-,PropValue(Core.Descr))

E.

Concat() Abbrev, -, Descr

F.

ConcatO Abbrev," -", Descr

Expert Solution
Questions # 3:

Identify the three true statements about the timing of DRM integrations.

Options:
A.

Exports may be run any time on any version.

B.

Imports may be run any time on any version.

C.

Property queries may be run any time on any version.

D.

DRM integrations may be scheduled or run on demand.

E.

Once a version has been finalized, only data Managers may run exports.

Expert Solution
Questions # 4:

Identify the three true statements about using the "Asc" property types.

Options:
A.

They are used to sort hierarchies in ascending order.

B.

They are used to help maintain one-to-one or one-to-many mappings.

C.

Associated nodes do not need to exist prior to import of the hierarchy.

D.

They can reference nodes in different hierarchies.

E.

They should be used with local node—level properties.

F.

They pull in the node hierarchy and the node name.

G.

They support bidirectional references.

Expert Solution
Questions # 5:

Identify three common issues that are addressed by DRM out of the box.

Options:
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

Expert Solution
Questions # 6:

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

Options:
A.

Create an export of the mapping data and load to a relational table accessible to the ETL tool.

B.

Use the Batch interface to connect the ETLto the underlying DRM tables.

C.

Use the API to connect the ETL tool to the underlying DRM tables.

D.

Access the database directly with the DRM user.

E.

Access the data files directly through the DRM's application server.

Expert Solution
Questions # 7:

Which three statements are true about the stakeholders in a DRM implementation?

Options:
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.

Expert Solution
Questions # 8:

Your budget office is preparing the Entity dimension for the upcoming year with organisation changes. They are working in a version called '"Budget". This version has a Working status until the Entity hierarchy is finalized. The budget office user has received new information from management that requires him to back out the numerous changes he has made over the last five days. The AllowAsOf system preference is set to True. What is the next step?

Options:
A.

To manually back out the changes in the Budget version.

B.

To recover the DRM application from a backup.

C.

To use the copy feature to copy the version and enter the "As Of" date to create the version as of the certain date.

D.

To use the Create As Of Version feature to create a copy of the version as of a specified date.

E) To use the Copy feature to copy the baseline version to a new version and re-apply changes "As Of" the desired date.

Expert Solution
Questions # 9:

You have three hierarchies for the Entity dimension. One hierarchy rolls up entities by geography, one hierarchy rolls up entities by function, and one hierarchy rolls up entities by legal structure. In your Hyperion Financial Management (HFM) application, these three hierarchies exist within a single Entity dimension. You want to be able to manage the properties for the nodes once.

Identify the three ways that DRM can be designed to support this requirement.

Options:
A.

Maintain the three separate DRM hierarchies within a single version with the HFM properties set to Global; combine the hierarchies into a single export.

B.

Create the three structures in a single DRM hierarchy with the Geography hierarchy as the primary hierarchy and the Function and Legal structures as shared nodes.

C.

Maintain each hierarchy in its own version; set the Geography hierarchy to Primary and the Function and Legal hierarchies to Shared.

D.

Maintain the three separate DRM hierarchies within a single version with the HFM properties set to Global and combine the hierarchies into a single export book.

E.

Maintain the three separate DRM hierarchies within a single version with the HFM properties set to Global; Use the Blend feature to combine the hierarchies into a single export.

Expert Solution
Questions # 10:

Which three types of mappings are managed via properties in DRM?

Options:
A.

One-to-one mapping

B.

Mapping nodes across versions

C.

Many-to-many mapping

D.

One-to-many mapping

E.

Validations for format of mapped nodes

Expert Solution
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions