Oracle 1Z0-1081-21 問題集

質問 1：
Which two statements are true about Cash Flow in the Movement dimension?
A. The FCCS_Mvmts_AccountsPayable member isunder FCCS_CashFlow_NetAssets in the FCCS_CashFlow hierarchy.
B. When you add a level 0 member to FCCS_Mvmts_Subtotal, it is automatically added as a shared member to the FCCS_CashFlow hierarchy.
C. You can add shared members to the FCCS_CashChange hierarchy.
D. The seeded level 0 members under FCCS_Mvmts_Subtotal are shared members in the FCCS_CashFlow hierarcy.
正解：B,D

質問 2：
What will Financial Consolidation and Close do when aggregating data for a member that is set as an expense type account to a parent that is set as an income type account?
A. Addamounts aggregated to the parent.
B. Subtract amounts aggregated to the parent.
C. You cannot load data to this account.
D. This setting does not affect aggregation to the parent.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two data extract export file types are available within Financial Consolidation and Close (FCCS)?
(Choose two.)
A. DAT file type
B. Comma delimited
C. Tab delimited
D. Excel XLS file type
正解：B,C

質問 4：
Which statement is false regarding establishing security for Financial Consolidation and Close?
A. Security is mandatory for one dimension.
B. The Identity Domain Administrator inherits full access privileges.
C. All members are accessiblefor dimensions with no security applied.
D. Security can be assigned at a prevent level.
E. Security can be disabled for any dimension.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which four sample ratios can be created during the application creation process? (Choose four.)
A. Earnings per Share
B. Debt Ratio
C. Inventory Ratios
D. Contribution Margin
E. Days Sales in Receivables
F. Gross Margin
正解：B,C,E,F

質問 6：
By default, security access is set to "None" for which three dimensions? (Choose three.)
A. Account
B. Movement
C. Data Source
D. Year
E. Entity
正解：A,C,E

質問 7：
Whencreating 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 will not work since Data Management does not support scripting.
B. The script will not work since the UD5 member referenced does not start with FCCS_
C. The script will work if the script is referenced in the Explicit mapping type with #SQL as the target.
D. The script will work if the script is referenced in the In mapping type with #SQL as the target.
E. The script can be eliminated byusing a multi-dim map on the Product dimension that also looks for the account Sales.
正解：D

質問 8：
Which statement is correct regardingintercompany eliminations?
A. Intercompany eliminations are required for sustainability reporting to show the company's waste output.
B. Intercompany eliminations are generally required to remove the effect of transactions within the company.
C. Intercompany eliminations are needed when a company divests itself of a division.
D. Intercompany eliminations are optional in FCCS and use one of the custom dimensions when enabled.
正解：B

質問 9：
Which two prebuilt calculations run on the Movement dimension to determine CTA by account?
A. Prior AverageRate minus Current Average Rate multiplied by FCCS_Mvmts_Subtotal
B. FCCS_Mvmts_Subtotalmultiplied by ending Rate minus FCCS_Mvmts_Subtotal multiplied by Average Rate
C. Prior Ending Rate minus Current Ending Rate divided by FCCS_Mvmts_Subtotal
D. FCCS_OpeningBalance multiplied by Ending Rate minus FCCS_OpeningBalance carry forward
正解：B,D