1Z0-1081-24 Real Exam Questions and Verified Answers

Question 1 Single choice

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.

Show answer and explanation

Correct answer: B

Question 2 Single choice

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.

Show answer and explanation

Correct answer: A

Question 3 Multiple choice

Which four statements are true about the members in the FCCS_Cash Flow hierarchy in the Movement dimension? (Choose four.)

A
The Cash Change hierarchy cannot be modified.
B
All primary Movement members under the FCCS_Mvmts_Subtotal member must be included in the FCCS_CashFlow hierarchy.
C
The seeded member FCCS_Mvmts_AccountsPayable found within the FCCS_CashFlow hierarchy has a Subtraction operator.
D
Input level members under the FCCS_Mvmts_Subtotal are Shared members in the FCCS_CashFlow hierarchy.
E
Standard cash accounts are members of the FCCS_CashFlow_Operating hierarchy.
F
Siblings can be added to the FCCS_CashFlow_Investing member.

Show answer and explanation

Correct answers: C, D, E, F

Question 4 Single choice

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

A
Movement of FX impact for historical rate accounts to the FCCS_CTA account
B
A variance in the Average rate and the Ending rate
C
The current FCCS_CTA account balance does not change from the prior period
D
The account is FCCS_Net Income

Show answer and explanation

Correct answer: C

Question 5 Single choice

When creating an application in Financial Consolidation and Close (FCCS), what Time Periods sections can be made?

A
Any number of months can be selected
B
12-month only
C
12-month and 13-month
D
12-month, 13-month and a 14-month

Show answer and explanation

Correct answer: C

Question 6 Single choice

Which statement is true of the default FCCS_members within an application?

A
You can change the default FCCS_member prefix at application creation.
B
You can change the Alias.
C
You can change the Data Storage property.
D
You can change the Name.

Show answer and explanation

Correct answer: B

Explanation

The member names of the seeded accounts cannot be changed, but the aliases can.
References:
https://www.google.com/search?sxsrf=ALeKk01vTIkJ0rm1WblV1PEXOSkSLx2BmA%3A1613856380969&ei=fH4xYLrqOoj4gQbWz7-oDw&q=default+FCCS_+members+within+an+application+can+change+the+Alias&oq=default+FCCS_+members+within+an+application+can+change+the+Alias&gs_lcp=Cgdnd3Mtd2l6EAM6BwgAEEcQsAM6BAgjECc6BwghEAoQoAE6BAghEBVQ97gEWOXABGDQwQRoAXACeACAAaECiAHlCpIBAzItNZgBAKABAaoBB2d3cy13aXrIAQjAAQE&sclient=gwswiz&ved=0ahUKEwi6mLnCs_nuAhUIfMAKHdbnD_UQ4dUDCA0&uact=5

Question 7 Single choice

What file type / file extension format extracts data exports from Financial Consolidation and Close (FCCS)?

A
The data export format / file extension is always extracted in a XLS file format.
B
The data export format / file extension is always extracted in a ZIP file format.
C
The data export format / file extension is always extracted in a DAT file format.
D
The data export format / file extension is always extracted in a CSV file format.

Show answer and explanation

Correct answer: D

Explanation

The system creates an export file for each artifact (.csv).
References:
https://docs.oracle.com/en/cloud/saas/financial-consolidation-cloud/agfcc/
metadata_export.html

Question 8 Single choice

For which scenario would an On-Demand rule be an appropriate solution?

A
to perform a custom currency translation for a subset of accounts
B
to add a column with a calculation to a report
C
to copy data from one scenario to a different scenario
D
to allocate data to base entities prior to consolidation

Show answer and explanation

Correct answer: C

Explanation

Copy data from one scenario to another one.
References:
https://neonn.com/alwayson/demand-rules-hfm/

Question 9 Single choice

Which statement about the Equity Pickup feature is FALSE?

A
Seeded rule-sets are provided for Equity Pickup.
B
Equity Pickup rules run as part of the consolidation process.
C
Equity Pickup requires that the Ownership Management with Equity Pickup feature is enabled.
D
Equity Pickup rules are run on-demand from the Rules card by users with launch permissions.

Show answer and explanation

Correct answer: B

Question 10 Single choice

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
Disconnect from the Smart View connection, and relog in.
B
Activate the Connection.
C
Close out of Excel, and relog in to Smart View.
D
Change one of the Row or Column dimension members and click Refresh.

Show answer and explanation

Correct answer: D