ORACLE FCC CERTIFICATION PREP
QUESTIONS AND VERIFIED ANSWERS|
100% CORRECT | GRADE A
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 FCCS_Rate Override
FCCS_Elimination
Which three fields must be defined when registering a file-based source system in
Data Management? (Choose three)
A. Source Type
B. Drill Type
C. Cloud Type
D. Description
E. Name - Correct Answer Source Type
Description
,Name
Which is NOT a member of the Data Source Dimension created by FCCS?
A. FCCS_No Data Source
B. FCCS_Data Input
C. FCCS_SystemTypes
D. FCCS_Proportion - Correct Answer FCCS_Proportion
How is drill-back enabled to Supplemental Data Manager (SDM) from the
Supplemental Data
member within the Multi-source dimension?
A. Drill-back to SDM is not an available feature.
B. Droll-back is available from any Multi-source dimension member by default, know
the source of
the origination data load.
C. By selecting Track Multi-source Data Input option for Supplemental Data during
the application
creation process.
D. By selecting Track Multi-source Data Input option for Other Data during the
application creation
process. - Correct Answer Drill-back is available from any Multi-source dimension
member by default, know the source of the origination data load
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 5.
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 January and February should be consolidated.
Which three fields must be defined when registering a file-based source system in
Data Management? (Choose three)
A. Source Type
B. Drill Type
C. Cloud Type
D. Description
E. Name - Correct Answer Source Type
Description
Name
Which is NOT a member of the Data Source Dimension created by FCCS?
A. FCCS_No Data Source
B. FCCS_Data Input
, C. FCCS_SystemTypes
D. FCCS_Proportion - Correct Answer FCCS_Proportion
How is drill-back enabled to Supplemental Data Manager (SDM) from the
Supplemental Data
member within the Multi-source dimension?
A. Drill-back to SDM is not an available feature.
B. Droll-back is available from any Multi-source dimension member by default, know
the source of
the origination data load.
C. By selecting Track Multi-source Data Input option for Supplemental Data during
the application
creation process.
D. By selecting Track Multi-source Data Input option for Other Data during the
application creation
process. - Correct Answer Drill-back is available from any Multi-source dimension
member by default, know the source of the origination data load
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 5.
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.
QUESTIONS AND VERIFIED ANSWERS|
100% CORRECT | GRADE A
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 FCCS_Rate Override
FCCS_Elimination
Which three fields must be defined when registering a file-based source system in
Data Management? (Choose three)
A. Source Type
B. Drill Type
C. Cloud Type
D. Description
E. Name - Correct Answer Source Type
Description
,Name
Which is NOT a member of the Data Source Dimension created by FCCS?
A. FCCS_No Data Source
B. FCCS_Data Input
C. FCCS_SystemTypes
D. FCCS_Proportion - Correct Answer FCCS_Proportion
How is drill-back enabled to Supplemental Data Manager (SDM) from the
Supplemental Data
member within the Multi-source dimension?
A. Drill-back to SDM is not an available feature.
B. Droll-back is available from any Multi-source dimension member by default, know
the source of
the origination data load.
C. By selecting Track Multi-source Data Input option for Supplemental Data during
the application
creation process.
D. By selecting Track Multi-source Data Input option for Other Data during the
application creation
process. - Correct Answer Drill-back is available from any Multi-source dimension
member by default, know the source of the origination data load
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 5.
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 January and February should be consolidated.
Which three fields must be defined when registering a file-based source system in
Data Management? (Choose three)
A. Source Type
B. Drill Type
C. Cloud Type
D. Description
E. Name - Correct Answer Source Type
Description
Name
Which is NOT a member of the Data Source Dimension created by FCCS?
A. FCCS_No Data Source
B. FCCS_Data Input
, C. FCCS_SystemTypes
D. FCCS_Proportion - Correct Answer FCCS_Proportion
How is drill-back enabled to Supplemental Data Manager (SDM) from the
Supplemental Data
member within the Multi-source dimension?
A. Drill-back to SDM is not an available feature.
B. Droll-back is available from any Multi-source dimension member by default, know
the source of
the origination data load.
C. By selecting Track Multi-source Data Input option for Supplemental Data during
the application
creation process.
D. By selecting Track Multi-source Data Input option for Other Data during the
application creation
process. - Correct Answer Drill-back is available from any Multi-source dimension
member by default, know the source of the origination data load
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 5.
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.
