ORACLE FCCS CERTIFICATION EXAM 2024 ACTUAL EXAM COMPLETE 200 QUESTIONS WITH DETAILED VERI, Exams of Nursing

Download ORACLE FCCS CERTIFICATION EXAM 2024 ACTUAL EXAM COMPLETE 200 QUESTIONS WITH DETAILED VERI and more Exams Nursing in PDF only on Docsity!

ORACLE FCCS CERTIFICATION EXAM 2024 ACTUAL EXAM COMPLETE 2 00 QUESTIONS WITH DETAILED VERIFIED ANSWERS (100% CORRECT ANSWERS) ALREADY GRADED A+ Which three key requirements does the Financial Consolidation and Close Cloud Service (FCCS) deliver to ensure a modern consolidation and close solution? (Choose three.) A. Ensure security of sensitive data B. Integrate with source systems. C. Provide predictive analysis and modeling D. Provide a strong compliance framework that includes auditing and segregation of duties. - CORRECT ANSWER >>>>A. Ensure security of sensitive data B. Integrate with source systems.

D. Provide a strong compliance framework that includes auditing and segregation of duties. When designing a report in Financial Reporting Studio, which two items are NOT an insert-able report object? A. Chart B. Grid C. Image D. Header E. Footer - CORRECT ANSWER >>>>D. Header E. Footer 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. - CORRECT ANSWER >>>>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. What is the primary function of enabling the Track Intercompany Elimination option during the application creation?

A. enables the Elimination member in the Consolidation dimension B. process will separate total elimination values by Data Source. C. enables the application to include Intercompany data. D. enables the application to perform Intercompany eliminations - CORRECT ANSWER >>>>B. process will separate total elimination values by Data Source. Which three combinations of dimensions could be valid for a Financial Consolidation and Close (FCCS) application? (Choose three.) A. Period, Year, Entity B. From Currency, Movement, Scenario C. Multi-GAAP, Data Type, Intra-company D. Value, Entity, Account E. Data source, Consolidation, View - CORRECT ANSWER >>>>A. Period, Year, Entity B. From Currency, Movement, Scenario E. Data source, Consolidation, View

Which is NOT a member of the Data Source Dimension created by Financial Consolidation and Close (FCCS)? A. FCCS_No Data Source B. FCCS_Data Input C. FCCS_SystemTypes D. FCCS_Proportion - CORRECT ANSWER >>>>D. FCCS_Proportion What will Financial Consolidation and Close (FCCS) do when adding a new member that is an expense type account under a parent that is set as an income type account? A. this setting will not affect additions or subtractions to the next parent B. subtract amounts consolidated to the parent C. add amounts consolidated to the parent D. you can't load data to this account - CORRECT ANSWER

A. this setting will not affect additions or subtractions to the next parent

Which four items are active components of the Currency dimension? (Choose four.) A. Entity Currency Adjustments B. Reporting Currencies C. Input Currencies D. Translated Currencies E. Entity Currency F. Parent Currency - CORRECT ANSWER >>>>B. Reporting Currencies C. Input Currencies E. Entity Currency F. Parent Currency Financial Consolidation Close Cloud maintains the status calculation for which combination of dimensions? A. Scenario, Account, Base Entity and Parent Entity B. Year, Scenario, Base Entity and Account

C. Scenario, View, Parent Entity and Account D. Period, Scenario, Base Entity and Parent Entity - CORRECT ANSWER >>>>D. Period, Scenario, Base Entity and Parent Entity A company would like to capture Fixed Asset additions and disposals within the Movement dimension. Which three tasks are necessary to achieve this goal? (Choose three.) A. Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals B. Add custom members for Additions and Disposals as dependents of FCCS_Mvmts_CapitalExpenditures. C. Load detailed Fixed Asset data to Movement members D. Add custom Movement members to the FCCS_CashFlow hierarchy. E. Create a Roll Forward in the account dimension - CORRECT ANSWER >>>>A. Build a custom Movement member for Fixed Assets with dependent custom members for Additions and Disposals B. Add custom members for Additions and Disposals as dependents of FCCS_Mvmts_CapitalExpenditures. C. Load detailed Fixed Asset data to Movement members

Which statement is FALSE when setting up Shared Entities? A. The calculation status will not change in all instances when data is changed in one instance. B. The Data Storage Member Property must set to "Dynamic Calc". C. You build an alternate hierarchy by using partial share Entity members D. When data is posted to one shared entity, the data is posted to all instances. - CORRECT ANSWER >>>>B. The Data Storage Member Property must set to "Dynamic Calc". 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 >>>>C. the data load cube name (Dan's sheet says D)

What member of the Currency dimension should be used during data entry for historical override amounts? A. Parent Currency B. Input Currencies C. Reporting Currencies D. Entity Currency - CORRECT ANSWER >>>>B. Input Currencies What is the correct Currency dimension member to select when running an Intercompany Matching Report? A. Input Currency B. Reporting Currency C. Entity Currency D. Parent Currency - CORRECT ANSWER >>>>B. Reporting Currency What can the Intercompany Dimension be enabled and made visible within your application? A. after application creation by selecting any Account as IC_Acc_Yes for the Intercompany Account attribute

B. during application creation and selecting the Intercompany Data feature option C. after application creation by selecting any Account as IC_Acc_Yes for the Intercompany Entity attribute D. during application creation and selecting the Multi-source Data Input of Other Data - CORRECT ANSWER >>>>B. during application creation and selecting the Intercompany Data feature option To have access to Dimension Management from directly within Financial Consolidation and Close (FCCS) which security rights are required? A. Metadata Administrator B. Metadata Supervisor C. System Administrator D. Power User - CORRECT ANSWER >>>>C. System Administrator Which is true behavior of default FCCS_ members within an application? A. You can change the default FCCS_ member prefix at application creation.

B. You can change the Alias of these default FCCS_ members at any time. C. You can change the Name of these default FCCS_ members at any time. D. You cannot change the Alias of these default FCCS_ members. - CORRECT ANSWER >>>>B. You can change the Alias of these default FCCS_ members at any time. 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. The script will work if the script is referenced in the In mapping type with #SQL as the target. By default, security access is set to "None" for which three dimensions? (Choose three.) A. Movement B. Data Source C. Account D. Entity E. Year - CORRECT ANSWER >>>>B. Data Source C. Account D. Entity Which item describes the use for the Currency dimension property Triangulation Currency? A. The ability to force translations B. The ability to report in multiple currencies C. The ability to calculate foreign exchange rates

D. The ability to calculate CTA (Cumulative Translation Adjustment) E. The ability to input foreign exchange rates - CORRECT ANSWER >>>>C. The ability to calculate foreign exchange rates Which two members of the Data Source dimension are optional when you create a Financial Consolidation and Close (FCCS) application? (Choose two.) A. FCCS_Journal Input B. FCCS_PCON C. FCCS_Intercompany Eliminations D. FCCS_No Data Source - CORRECT ANSWER >>>>A. FCCS_Journal Input C. FCCS_Intercompany Eliminations What is the Data Storage value for an account that must remain at a historical exchange rate and not retranslate with current rates? A. Store B. Never Share

C. No Rate D. Dynamic Calc and Store E. Dynamic - CORRECT ANSWER >>>>A. Store 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. - CORRECT ANSWER >>>>B. Activate the Connection. (Dan's: D) Which three scenarios result in foreign currency translation during the default consolidation process? (Choose three.) A. A base entity currency has a parent entity with a matching default currency.

B. A base entity currency has a parent entity with a different default currency. C. A parent entity has the same default currency as its parent. D. A parent entity has a different currency from its parent. E. A shared entity has a parent with a different currency. - CORRECT ANSWER >>>>B. A base entity currency has a parent entity with a different default currency. D. A parent entity has a different currency from its parent. E. A shared entity has a parent with a different currency. Which four sample ratios can be created during the application creation process? (Choose four.) A. Inventory Ratios B. Contribution Margin C. Debt Ratio D. Earnings per Share E. Days Sales in Receivables F. Gross Margin - CORRECT ANSWER >>>>A. Inventory Ratios

C. Debt Ratio E. Days Sales in Receivables F. Gross Margin P, Q, and R are children of a mid-level parent entity, AceCo. In February each entity has cash in the amounts of 10, 20, and 30, respectively, and AceCo has been consolidated and has cash of

60. A prior period adjustment to Q adjusts cash with a debit of
61. Which statement regarding consolidation is correct? A. There is no way to do a prior period entry like this. B. January and February should be consolidated. C. February should be consolidated, after which the cash at AceCo is now 65. D. January should be consolidated for the change and nothing needs to happen for February. - CORRECT ANSWER >>>>B. January and February should be consolidated. Which statement correctly describes the Consolidation dimension? A. The dimension contains members to store non-controlling interest and joint venture data.

B. The dimension uses a separate member to store data from an entity's descendants. C. The dimension allows users to see input versus journal adjustment data. D. The dimension aggregates input, consolidated, and elimination data together. - CORRECT ANSWER >>>>B. The dimension uses a separate member to store data from an entity's descendants. On what days during the month does Oracle apply patch updates to fix bugs, apply code optimizations, and add new features? A. the third Friday of each month to apply to both TEST and PROD simultaneously B. the first and third Monday of each month; first Monday for TEST and third Monday for PROD C. the second and fourth Friday of each month; second Friday for Test and fourth Friday for PROD D. the first and third Friday of each month; first Friday for TEST and third Friday for PROD - CORRECT ANSWER >>>>D. the first and third Friday of each month; first Friday for TEST and third Friday for PROD

Which components are pre-built into Financial Consolidation and Close Cloud Service to provide a configurable and scalable consolidation solution? A. pre-built integration to combine narrative and data to produce both internal and external reporting packages B. calculations, dashboards and reports to provide analysis for cash flow modeling C. calculations, dashboards and reports as well as detailed data source tracking and an automated cash flow D. calculations, dashboards and reports built on planning frameworks to provide cash flow planning - CORRECT ANSWER

C. calculations, dashboards and reports as well as detailed data source tracking and an automated cash flow Which two members of the Consolidation dimension cause the standard foreign currency translation rules to be ignored? (Choose two.) A. FCCS_Amount_Override B. FCCS_Rate Override C. FCCS_Contribution

D. FCCS_Proportion E. FCCS_Elimination F. FCCS_Translation - CORRECT ANSWER >>>>A. FCCS_Amount_Override B. FCCS_Rate Override When setting an account property to a data storage type of "Dynamic Calc" which two are allowed? A. Member Formulas cannot be created B. load data to this account and make member formulas C. load data to this account D. create Member Formulas - CORRECT ANSWER >>>>B. load data to this account and make member formulas D. create Member Formulas What are two important first steps in initially setting up Close Manager? (Choose two.) A. Create a schedule and set it to Open status. B. Set up Users.

C. Assign tasks to users. D. Define system settings such as Organization units, Holiday rules and Task attachment size. - CORRECT ANSWER >>>>B. Set up Users. D. Define system settings such as Organization units, Holiday rules and Task attachment size. To show the Intercompany account and matching account balances on the Intercompany Matching Report, you make which selection? A. Intercompany Accounts B. Intercompany Partners C. Intercompany Plug Accounts D. Elimination Consolidation Dimension member - CORRECT ANSWER >>>>C. Intercompany Plug Accounts Changes in the balance of Accounts Payable are captured on a company's Cash Flow Report. Which two dimension members must be built into the row of the company's Cash Flow to report the impact of Accounts Payable? (Choose two.) A. FCCS_Accounts Payable account member

B. FCCS_CashFlow_Operating movement member C. FCCS_CashFlow_Accounts Payable movement member D. FCCS_Total Balance Sheet - Cash and NonCash account member E. FCCS_CashChange movement member - CORRECT ANSWER

C. FCCS_CashFlow_Accounts Payable movement member D. FCCS_Total Balance Sheet - Cash and NonCash account member PQR Company has the ownership structure shown above. If P_2 lends money to H_1, which point of view would the credit balance that offsets P_2's debit balance? A. Entity PQR, Consolidation FCCS_Elimination, Intercompany FCCS_No Intercompany B. Entity Paducah, Consolidation FCCS_Elimination, Intercompany FCCS_No Intercompany C. Entity P_2, Consolidation FCCS_Contribution, Intercompany ICP_H_1 D. Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_1

E. Entity P_2, Consolidation FCCS_Contribution, Intercompany H_1 - CORRECT ANSWER >>>>C. Entity P_2, Consolidation FCCS_Contribution, Intercompany ICP_H_1 (Dan's: C) If the Intercompany Property for an Entity is changed from marked to unmarked, which result occurs? A. The alias of the associated Intercompany member is automatically updated. B. The associated Intercompany member must be manually removed. C. The associated Intercompany member is automatically removed. D. The alias of the associated Intercompany member must be manually changed. - CORRECT ANSWER >>>>B. The associated Intercompany member must be manually removed. You have added a new task to a close schedule with a task due date past the defined end date of the schedule. What is the result of the change? A. The new task will run outside of the schedule end date. B. An error, you can't add a new task past the due date.

C. The schedule end date changes to match the end date of the task. D. The task will not run. - CORRECT ANSWER >>>>B. An error, you can't add a new task past the due date. Which two data extract export file types are available within Financial Consolidation and Close (FCCS)? (Choose two.) A. DAT file type B. Excel XLS file type C. Comma delimited D. Tab delimited - CORRECT ANSWER >>>>C. Comma delimited D. Tab delimited 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 - CORRECT ANSWER

C. 12-month and 13-month 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 H A. First common parent B. Generation 0 C. First order relation D. Lowest common denominator - CORRECT ANSWER >>>>A. First common parent 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 - CORRECT ANSWER >>>>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. (Dan's: D) 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. Batches can execute data loads for multiple locations. (Dan's: D) What member of the Consolidation dimension aggregates the Proportion member and the Elimination members?