Oracle Financial Consolidation and Close Cloud Service 2017 Implementation Essentials (1z1-983) Free Practice Test

Question 1

When creating a Financial Consolidation and Close (FCCS) application, which initial Multi-source data options can be selected? (Choose two)

A. Supplemental Data

B. ERP r12

C. ERP Cloud

D. Data Management

Correct Answer: A,D

Question 2

PQR Company has the ownership structure shown above.
If H_1 lends money to P_2, the intercompany elimination of H_1's receivable occurs as data from Hickory consolidates into PQR. What is this principle called?

A. First order relation

B. First common parent

C. Lowest common denominator

D. Generation 0

Correct Answer: B

Question 3

Which statement is true regarding shared members and valid intersection rules?

A. If a base member is included in a valid intersection rule, then any shared member is not included in the rule

B. If a shared member is selected for a valid intersection rule, then the base member is not included in the rule

C. Shared members are supported in valid intersection rules

D. Shared members are not supported in valid intersection rules

Correct Answer: C

Question 4

What is the primary function of enabling the Track Intercompany Elimination option during the application creation?

A. process will separate total elimination values by Data Source.

B. enables the Elimination member in the Consolidation dimension

C. enables the application to include Intercompany data.

D. enables the application to perform Intercompany eliminations

Correct Answer: A

Question 5

In which two instances will the FCCS_Mvmts_FX_to_CTA movement member populate in a translated currency?

A. A variance in the Average rate and the Ending rate

B. Movement of FX impact for historical rate accounts to the FCCS_CTA account

C. The account is FCCS_Net Income

D. The current FCCS_CTA account balance does not change from the prior period

Correct Answer: D

Question 6

A new Sheet tab in Excel is copied from an existing tab that contains a Smart View query, but clicking Refresh does not refresh the data and the Smart View (Point of View) POV bar does not display.
Which additional step is required to pull data in the new tab and change the POV?

A. Change one of the Row or Column dimension members and click Refresh.

B. Disconnect from the Smart View connection, and relog in.

C. Close out of Excel, and relog in to Smart View.

D. Activate the Connection.

Correct Answer: A

Question 7

You are required to create a form to allow users to input data. Which three actions or form components selected should accomplish this?

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

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

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

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

Correct Answer: A,B,D

Question 8

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

A. the ID of the user performing the extract

B. the data load cube name

C. the domain and application name

D. the application name

Correct Answer: D

Question 9

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 not work since Data Management does not support scripting.

C. The script will work if the script is referenced in the In mapping type with #SQL as the target.

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

Welcome to TestSimulate

Oracle Financial Consolidation and Close Cloud Service 2017 Implementation Essentials (1z1-983) Free Practice Test