Oracle Oracle Financial Consolidation and Close Cloud Service 1Z0-1081-22 Questions & Answers

• 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.

  Correct Answer: CE

• 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

  Correct Answer: ACE

• Question 3:

  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

  Correct Answer: C

• Question 4:

  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.

  Correct Answer: AD

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

  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.

  Correct Answer: C

• 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

  Correct Answer: A

• Question 7:

  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

  Correct Answer: A

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

• 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.

  Correct Answer: B

• Question 9:

  Which statement explains why, in the Consolidation dimension, the data for an entity in the FCCS_Entity Input member might be different than the data in the FCCS_Proportion member?

  A. A rate was entered into the FCCS_Rate Override account.

  B. An ownership percentage for the entity other than 100 was entered.

  C. An intercompany elimination was performed.

  D. The parent entity has a different currency than the child.

  Correct 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.

  Correct Answer: A