Oracle Oracle Certifications 1Z0-1081-20 Questions & Answers

• Question 61:

  Which two prebuilt calculations run on the Movement dimension to determine CTA by account?

  A. Prior Average Rate minus Current Average Rate multiplied by FCCS_Mvmts_Subtotal

  B. Prior Ending Rate minus Current Ending Rate divided by FCCS_Mvmts_Subtotal

  C. FCCS_OpeningBalance multiplied by Ending Rate minus FCCS_OpeningBalance carry forward

  D. FCCS_Mvmts_Subtotal multiplied by ending Rate minus FCCS_Mvmts_Subtotal multiplied by Average Rate

  Correct Answer: CD

• Question 62:

  Which statement accurately describes alternate hierarchies?

  A. Single entities having multiple parents

  B. Parent members having the same currency

  C. Contribution to parent members are similar

  D. Data must be entered multiple times for shared members

  Correct Answer: A

• Question 63:

  You are required to create a form to allow users to input data.

  Which three actions or form components selected should accomplish this?

  A. Set the currency on the form to the reporting currency member USD_Reporting

  B. Level 0 dimension members on POV, rows and columns

  C. Give data input users WRITE access to form dimension members

  D. Set access rights for data input users to the form

  Correct Answer: BCD

• Question 64:

  When designing a report in Financial Reporting Studio, which condition should NOT be considered for a Financial Consolidation and Close (FCCS) report?

  A. Designing dynamic reports

  B. Expanded vs. single data segments

  C. Report performance

  D. Suppress missing blocks

  Correct Answer: D

• Question 65:

  When can the Intercompany Dimension be enabled and n=made visible within your application?

  A. during application creation and selecting Multi-source Data Input of Other Data

  B. after application creation by selecting any Entity as IC_Entity_Yes for the Intercompany Entity attribute

  C. after application creation by selecting any Account as IC_Acc_Yes for the Intercompany Account attribute

  D. during application creation and selecting the Intercompany Data feature option

  Correct Answer: D

• Question 66:

  Which selection enables data to be imported directly into any Financial Consolidation and Close (FCCS) application?

  A. Select Application, then Overview, then Data, and then Export

  B. Select Application, then Overview, then Actions, and then Import Data

  C. Select Dimensions, then Actions, and then Import Data

  D. Select Import, then Actions, and then Data

  Correct Answer: B

• Question 67:

  For data load rules in Data Management, which two statements are FALSE?

  A. If specified, the import format will be used; if not, then the location's format will be used.

  B. A job must first run to import the data file before the user can run the data load rule.

  C. End users can upload a file when running a data load rule.

  D. Data load rules cannot be shared across locations.

  E. Valid load types are Merge and Replace.

  Correct Answer: BE

• Question 68:

  What is the function of Source Mapping in Data Management?

  A. Map local dimension members to the application dimension members.

  B. Manage source periods in relation to global periods.

  C. Defined the input currency for each data source supplying data to the application.

  D. Define the close calendar periods.

  Correct Answer: C

  Data Management supports the ability to load data that is of a currency different from the default currency of the selected location. This option enables you to specify the location in the input line that specifies the currency for the related amount field. Reference: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management- common/erpia/ GUIDF8001C5A-A922-43C7-A0C6-4025F1EB7BDF.pdf

• Question 69:

  If the Intercompany Data feature is not enabled when the Financial Consolidation and Close (FCC) business process is created, which statement is true?

  A. The FCCS_No Intercompany member of the ICP dimension is used for all data.

  B. The ICP dimension is omitted.

  C. An extra custom dimension is available.

  D. Data can be stored by intercompany partner but no eliminations will occur.

  Correct Answer: A

  Reference: https://docs.oracle.com/en/cloud/saas/tax-reporting-cloud/agtrc/ admin_dimensions_intercompany_124x5ae77515.html

• Question 70:

  For which three dimensions is security enabled by default?

  A. Data Source

  B. Entity

  C. Consolidation

  D. Scenario

  E. Account

  Correct Answer: BDE

  By default, the Account, Entity, Scenario, and Data Source dimensions. Reference: https:// docs.oracle.com/en/cloud/saas/financial-consolidation- cloud/agfcc/dimension_security.html