New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-588 Dumps Questions Answers

Page: 1 / 3
Total 73 questions

Oracle Hyperion Data Relationship Management Essentials Questions and Answers

Question 1

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.

Buy Now
Question 2

For the Product Hierarchy in DRM, you need a way to identify the active products. Some target systems will accept active products only while the BI and Reporting solution requires both current and discontinued products. Identify the two ways to address this requirement in DRM.

Options:

A.

Use the Orphan List to identify and load discontinued products to the active product list when youneed the complete Product hierarchy.

B.

Use the Inactivate feature to flag discontinued products and then use the Node Inactive propertyto filter products accordingly during exports.

C.

Use the Delete feature to remove discontinued products from the Product Hierarchy.

D.

Maintain the full product hierarchy with both active and discontinued products. Create a customproperty called "Product Status" that users can update to Active or Discontinued. Use this property to filter products accordingly during exports.

E.

Use the Blend feature to blend inactive products; this allows inactive nodes to be loaded with active nodes when you need the complete Product hierarchy.

Question 3

Identify the three true statements about External Connections.

Options:

A.

Defined connections for FTP or UNC file path representing a target or source for an import/export.

B.

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.

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.

Question 4

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?

Options:

A.

Lookup

B.

List

C.

AscNodes

D.

AscNode

E.

RangeList

Question 5

Identity the three true statements about property categories assuming that you do not use node types.

Options:

A.

A System property category is automatically created out of the box.

B.

If enabled in the system preferences, the Oracle EPM property categories are created, out of thebox.

C.

If enabled in the system preferences, the Oracle EBS categories are created, out of the box.

D.

Property categories are unique to a version.

E.

Property categories are unique to a hierarchy.

F.

Node access groups are assigned to property categories.

G.

A property categories assigned to a user may be read or edit.

Question 6

After the requirements and analysis phase of the DRM implementation, you documented key findings pertinent to the project.

Choose the three findings that pose risk to the implementation of DRM.

Options:

A.

Lack of understanding about how the data elements 3r& used by the business

B.

Proper business involvement

C.

Inexperience with DRM

D.

Unclear owners of data and unclear data process

E.

Phase includes single dimension with many sources and targets

F.

There is a well defined data governance model.

Question 7

Which option describes the benefits of the Import DRM feature over the Action Script DRM feature?

Options:

A.

Import supports the import of hierarchies into new and existing versions.

B.

You can preview hierarchies and metadata before merging with existing data sets.

C.

It is easy to create formats directly from source systems.

D.

You can view twi^nr11"1 and failures.

E.

It can be automated through the batch client.

Question 8

Identify the three true statements about Workflow in DRM.

Options:

A.

Change requests are stored in a draft state for approval.

B.

Change requests are validated against a version and committed to the draft version.

C.

Change requests pending approval cannot be changes until the change has been approved.

D.

Change requests are committed to a version once the request is approved.

E.

Workflow is exposed through the API.

Question 9

New cost centers are added to the Entity hierarchy nightly from the ERP system. Identify the two true statements about the ERP system.

Options:

A.

It is considered an upstream system.

B.

It is considered a downstream system.

C.

Because it is used as a source for the Entity dimension, you may not feed entity data back to the ERP system.

D.

It may be imported into an existing version using Import.

E.

The ERP system feed can be automated using the batch client.

Question 10

The Data Relationship Management API Adapter is required for the DRM API. Identify three other components that are required to use the DRM API.

Options:

A.

Oracle WebLogic Server 11g

B.

JDeveloper

C.

EPM Workspace

D.

Oracle Web Services Manager (OWSM)

E.

Shared Services

Page: 1 / 3
Total 73 questions