Oracle Hyperion Data Relationship Management Essentials Exam Prep
Free practice questions

Free DRM Practice Questions

10 exam-style questions with answers and explanations, straight from our 1,030-question bank. Tap an answer to check yourself. When you're ready, take the scored version in the free practice test.

Start the free practice test → ★★★★★4.9/5 from 2,400+ candidates · No signup

The DRM exam has 73 questions and runs 2 hours.

These 10 free DRM questions are organized by exam domain, so you can see how each part of the Oracle Hyperion Data Relationship Management Essentials blueprint is tested. Reveal the answer and explanation under each question.

Domain 1: Implementation Scope and Risks

Question 1

A phased DRM implementation is ready to publish a chart of accounts to consolidation. Its agreed acceptance tests, business sign-off, and recovery rehearsal are complete. An unresolved employee-identifier issue belongs to the next phase; it shares no keys, properties, or interfaces with the account release. The sponsor asks whether today's rollout should change. The implementation lead should:

Show answer & explanation

Correct answer: C - Release the accepted account scope and track the employee issue against the next phase's entry criteria.

Domain 2: DRM Overview

Question 2

Minutes before a production feed runs, an administrator notices that a queued Action Script will Delete leaf cost center CC840. The approved change is only to remove CC840 from Management reporting. It must remain active under a different parent in Legal reporting, in the same version. There is no approved replacement cost center. What intervention prevents the unintended loss of master data?

Show answer & explanation

Correct answer: D - Hold the script and replace Delete with Remove at the Management parent.

Domain 3: Managing the Initial Data Load

Question 3

The approved source crosswalk identifies ERP_A/100 and ERP_B/720 as the same cash account, but ERP_B/100 as a different expense account. The initial-load design requires one canonical node per business account in a single DRM version. How should the load represent these source identifiers?

Show answer & explanation

Correct answer: A - Create two canonical nodes; map ERP_A/100 and ERP_B/720 to the same node.

Domain 4: Managing Properties and Property Categories

Question 4

In one version, Custom.TaxRegion is globally inherited and controlled by Legal. At account A620, the applicable Legal ancestor supplies EMEA; the Management parent supplies APAC. A620 has no explicit value. What are its effective values when viewed in Legal and Management, respectively?

Show answer & explanation

Correct answer: B - EMEA in Legal; EMEA in Management

Domain 5: Versioning

Question 5

Cost center CC510 is a leaf in the Legal hierarchy. In the same version, a new Management hierarchy must include that cost center under both Retail and Digital, while Legal remains unchanged. CC510 is not yet in Management, and shared nodes are enabled. Select the construction that preserves one underlying business identity.

Show answer & explanation

Correct answer: B - Insert CC510 under Retail, then create an explicit shared occurrence under Digital.

Domain 6: Business Rules

Question 6

An ETL load consumes an approved DRM allocation table. S10 maps 40% to T_A and 60% to T_B; S20 maps 75% to T_A and 25% to T_C. Source amounts are 12,000 for S10 and 8,000 for S20. The test load reports T_A = 6,800, T_B = 11,200, and T_C = 2,000. Although the grand total is 20,000, what should the mapping reviewer conclude?

Show answer & explanation

Correct answer: A - T_A should receive 10,800; the matching grand total conceals an allocation error.

Domain 7: Users

Question 7

During a blend, source department D30 has children but target D30 is a leaf. The target is a saved Working version. Both hierarchies exist; Process Structure and Process Inserts are enabled. Permissions and rules allow the new rollup. Select the option that permits the target to accommodate D30's children.

Show answer & explanation

Correct answer: C - Allow Leaf Promotion

Domain 8: Workflow

Question 8

A Submitted version has two Interactive Users with matching node and category Edit rights on an unlocked, defined property. Mira owns the version; Jon does not. Neither is a Data Manager. During review, who can make an authorized correction without a status change?

Show answer & explanation

Correct answer: D - Mira can edit; Jon cannot edit while the version remains Submitted.

Domain 9: API Integration

Question 9

Two target applications legitimately reuse external account code 410 for different accounts. Their separate DRM hierarchies contain different global nodes with that explicitly entered code; no hierarchy contains a duplicate code. The requirement is uniqueness within each target hierarchy, not across the version. A VersionUniqueProp validation rejects the data. Which correction aligns enforcement with the requirement?

Show answer & explanation

Correct answer: C - Use UniqueProp to check external-code uniqueness within each target hierarchy.

More DRM practice questions

Question 10

An Interactive User is testing two tasks in a Working version: moving an existing leaf to another parent and editing its Custom.Description value. Effective node access is Insert on every node involved. Custom.Description is defined and unlocked, but the user's access to its only property category is Read. No additional roles or ownership privileges apply, and both changes satisfy the business rules. Which task can the user complete?

Show answer & explanation

Correct answer: B - Move the leaf, but not edit Custom.Description.

That's 10 of 1,030

The full bank has 1,020 more DRM questions with explanations.

Continue in the free practice test →

View plans