oracle 1z0-1081-21 practice test

Question 1

Which two statements are correct with regard to Data Management locations? (Choose two.)

• A. A company with three instances of Oracle EBS R12 should only use one location to maintain proper accounting controls.
• B. Location security allows users to be provisioned in Shared Services for read or modify access to each location.
• C. Locations can share dimension member mappings by specifying a location as a parent location of others.
• D. The logic account group is required in order to effect running of calculations after the data load.
• E. Locations must specify an import format, which may be used by other locations.
• F. Data load rules can be shared across locations.

Answer:

C,E

Question 2

Which three scenarios result in foreign currency translation during the default consolidation process?

• A. A parent entity has a different default currency than its parent.
• B. A parent entity has the same default currency as its parent.
• C. A base entity has a different default currency than its parent.
• D. A base entity has the same default currency as its parent.
• E. A shared entity has a different default currency than its parent

Answer:

A, C, E

Question 3

Which two statements are true regarding the Copy Data function?

• A. You can copy data for historical rate and amount overrides.
• B. You cannot select which Account members to copy.
• C. You can select which Consolidation dimension member to copy.
• D. When you select the Regular Data option, journals data is included.

Answer:

A, D

Explanation:
You can copy these types of data:
Regular Data (including journals)
Override Data rates and amounts entered on the Override Rates form for historical rate override
accounts
Reference:
https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/data_copy.html

Question 4

Which of the following is allowed for accounts with the data storage type of “Dynamic Calc”?

• A. Load data to this account.
• B. Create member formulas.
• C. Load data to this account and create member formulas.
• D. Enter data through a data form

Answer:

C

Question 5

Audit is enabled by default for which task categories?

• A. Data only
• B. All task categories
• C. No task categories
• D. Metadata Administration and Security

Answer:

A

Explanation:
Reference:
https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/pfusa/audit_overview.html

Question 6

What information is included in the data extract export file delimited format?

• A. the ID of the user performing the extract
• B. the domain and application name
• C. the data load cube name
• D. the application name

Answer:

A

Question 7

When defining a batch in Data Management, which statement is True?

• A. Each data load rule must specify the period or the batch will default to the POV period.
• B. Batches can import from source or export to target, but not both.
• C. Batches can execute data loads for multiple locations.
• D. A batch replaces the need for data load rules.
• E. A batch can load to multiple plan types.

Answer:

C

Question 8

When creating a member mapping for account Sales in Data Management, the following script is
entered. UD5 refers to a Product custom dimension:
WHEN UD5 LIKE CAR_% THEN AUTO_SALES
ELSE SALES
Which statement is True?

• A. The script can be eliminated by using a multi-dim map on the Product dimension that also looks for the account Sales.
• B. The script will work if the script is referenced in the In mapping type with #SQL as the target.
• C. The script will not work since Data Management does not support scripting.
• D. The script will not work since the UD5 member referenced does not start with FCCS_
• E. The script will work if the script is referenced in the Explicit mapping type with #SQL as the target.

Answer:

B

Question 9

How can Metadata be imported into any Financial Consolidation and Close (FCCS) application?

• A. by selecting Application, then Overview, then Dimensions, and then Export
• B. by selecting Dimension, then Import, and then Metadata
• C. by selecting Application, then Overview, then Dimensions, and then Import
• D. by selecting Tasks, then Metadata, and then Import

Answer:

C

Question 10

Which statement correctly describes what happens to parent entities during consolidation?

• A. From each child of the entity, data from the FCCS_Contribution Consolidation dimension member is added together and stored in the FCCS_Entity Consolidation member of the entity.
• B. The changes in the relational database are synced to the underlying Essbase cube.
• C. Since parent entities are tagged as dynamic calc, the consolidation has no effect on the entity dimension.
• D. The data in the FCCS_Intercompany Eliminations Data Source dimension member is subtracted from the FCCS_TotalInputAndAdjusted Data Source dimension member for each descendant and then added together.

Answer:

A