FCCS Exam| FCCS Exam questions and a
kz kz kz kz kz kz
nswers| multiple choice answers verified
kz kz kz kz kz
A+
InkzFinancialkzClosekzManager,kzwhenkzwouldkzyoukzchoosekztokzdefinekztaskskzinkzakzTemplatekzratherkzthan
createkzakznewkzSchedulekzeachkzmonth?
A.kzwhenkzthekztaskskzarekzrepeatablekzoverkzmultiplekzclosekzcycles
B.kzwhenkzthekztaskskzrequirekzconsistentkzdefinitionkzacrosskzclosekzschedules
C.kzwhenkzthekztaskskzarekzoftenkzlatekzinkzcompletionkzandkztheykzneedkztokzbekzmonitoredkzmorekzclosely
D.kzwhenkzthekztaskskzrequirekzmultiplekzlevelskzofkzapproverskz-kzcorrectkzanswers-
A.kzwhenkzthekztaskskzarekzrepeatablekzoverkzmultiplekzclosekzcycles
Whichkzrolekzcankzthekz"ApprovalskzSupervisor"kzperform?
A)Theykzcankzstartkzandkzstopkzakzplanningkzunit
B)Theykzcankzstartkzandkzstopkzakzplanningkzunitkzandkztakekzanykzactionkzonkzakzplanningkzunit
C)Theykzcankzstartkzbutkznotkzstopkzakzplanningkzunit
D)Theykzcannotkzstopkzorkzstartkzakzplanningkzunitkzbutkzcankzonlykzgivekzapprovalkz-kzcorrectkzanswers-
B)kzTheykzcankzstartkzandkzstopkzakzplanningkzunitkzandkztakekzanykzactionkzonkzakzplanningkzunit
WhichkztwokzdatakzextractkzexportkzfilekztypeskzarekzavailablekzwithinkzFinancialkzConsolidationkzandkzClose
(FCCS)?kz(Choosekztwo.)
A.kzDATkzfilekztype
B.kzExcelkzXLSkzfilekztype
C.kzCommakzdelimited
D.kzTabkzdelimitedkz-kzcorrectkzanswers-C.kzCommakzdelimited
D.kzTabkzdelimited
WhenkzcreatingkzakzmemberkzmappingkzforkzaccountkzSaleskzinkzDatakzManagement,kzthekzfollowingkzscript
iskzentered.
UD5kzreferskztokzakzProductkzcustomkzdimension:
WHENkzUD5kzLIKEkz'CAR_%'kzTHENkz'AUTO_SALES'
,ELSEkz'SALES'
WhichkzstatementkziskzTrue?
A.kzThekzscriptkzcankzbekzeliminatedkzbykzusingkzakzmulti-
dimkzmapkzonkzthekzProductkzdimensionkzthatkzalsokzlooks
forkzthekzaccountkzSales.
B.kzThekzscriptkzwillkzworkkzifkzthekzscriptkziskzreferencedkzinkzthekzInkzmappingkztypekzwithkz#SQLkzaskzthekztarget.
C.kzThekzscriptkzwillkznotkzworkkzsincekzDatakzManagementkzdoeskznotkzsupportkzscripting.
D.kzThekzscriptkzwillkznotkzworkkzsincekzthekzUD5kzmemberkzreferencedkzdoeskznotkzstartkzwithkzFCCS_
E.kzThekzscriptkzwillkzworkkzifkzthekzscriptkziskzreferencedkzinkzthekzExplicitkzmappingkztypekzwithkz#SQLkzaskzthekztarg
et.kz-kzcorrectkzanswers-
B.kzThekzscriptkzwillkzworkkzifkzthekzscriptkziskzreferencedkzinkzthekzInkzmappingkztypekzwithkz#SQLkzaskzthekztarget.
P,kzQ,kzandkzRkzarekzchildrenkzofkzakzmid-levelkzparentkzentity,kzAceCo.kzInkzFebruarykzeachkzentitykzhaskzcashkzin
thekzamountskzofkz10,kz20,kzandkz30,kzrespectively,kzandkzAceCokzhaskzbeenkzconsolidatedkzandkzhaskzcashkzofkz60.k
zA
priorkzperiodkzadjustmentkztokzQkzadjustskzcashkzwithkzakzdebitkzofkz5.
Whichkzstatementkzregardingkzconsolidationkziskzcorrect?
A.kzTherekziskznokzwaykztokzdokzakzpriorkzperiodkzentrykzlikekzthis.
B.kzJanuarykzandkzFebruarykzshouldkzbekzconsolidated.
C.kzFebruarykzshouldkzbekzconsolidated,kzafterkzwhichkzthekzcashkzatkzAceCokziskznowkz65.
D.kzJanuarykzshouldkzbekzconsolidatedkzforkzthekzchangekzandkznothingkzneedskztokzhappenkzforkzFebruary.kz-
kzcorrectkzanswers-B.kzJanuarykzandkzFebruarykzshouldkzbekzconsolidated.
WhichkzstatementkzcorrectlykzdescribeskzthekzConsolidationkzdimension?
A.kzThekzdimensionkzcontainskzmemberskztokzstorekznon-controllingkzinterestkzandkzjointkzventurekzdata.
B.kzThekzdimensionkzuseskzakzseparatekzmemberkztokzstorekzdatakzfromkzankzentity'skzdescendants.
C.kzThekzdimensionkzallowskzuserskztokzseekzinputkzversuskzjournalkzadjustmentkzdata.
D.kzThekzdimensionkzaggregateskzinput,kzconsolidated,kzandkzeliminationkzdatakztogether.kz-kzcorrectkzanswers-
B.kzThekzdimensionkzuseskzakzseparatekzmemberkztokzstorekzdatakzfromkzankzentity'skzdescendants.
Whykzshouldkzyearskzbekzconsolidatedkzsequentially;kzi.e.,kzfirstkz2018,kzthenkz2019,kzthenkz2020?
A)Eachkzperiodkzinkzthekzyearkzmustkzconsolidatekzseparately
B)Parentkzaccountkzcalculationskzdependkzonkzthekzsequencing
C)Therekziskznokzreasonkztokzconsolidatekzthekzyearskzsequentially
, D)Rollforwardkzcalculationskzarekzpopulatedkzwithkzcorrectkzresultskz-kzcorrectkzanswers-
D)Rollforwardkzcalculationskzarekzpopulatedkzwithkzcorrectkzresults
WhichkzstatementkziskztruekzregardingkzDatakzManagementkzcategories?
A.kzCategorieskzarekzdefinedkzonkzthekzGlobalkzMappingkztabkzandkzthenkzthekzfrequencykziskzspecifiedkzonkzthe
ApplicationkzMappingkztab
B.kzCategorieskzmustkzbeginkzwithkzFCCS_kztokzmatchkztheirkzFinancialkzConsolidationkzandkzClosekzcounterparts.
C.kzApplicationkzmappingkziskznotkzrequiredkzifkzthekzglobalkzmappingkztargetkzcategorykziskzexactlykzcorrect.
D.kzThekzcategory'skztimekzfrequencykzallowskzdatakztokzbekzloadedkztokzdaily,kzweekly,kzandkzmonthlykzscenarios.k
z-kzcorrectkzanswers-
C.kzApplicationkzmappingkziskznotkzrequiredkzifkzthekzglobalkzmappingkztargetkzcategorykziskzexactlykzcorrect.
Akzclientkzcompanykzhaskzexpandedkzquicklykzinkzthekzpastkzyearkzandkzhaskzrecognizedkzthekzneedkztokzmovekzthei
r
financialkzteamkzoffkzspreadsheetskzandkztokzakzmorekzverifiablekzandkzautomatedkzsolution.
WhichkztwokzrequirementskzfromkzthiskzteamkzwouldkzOracle'skzFinancialkzConsolidationkzandkzClosekzCloud
Servicekzsatisfy?kz(Choosekztwo.)
A.kzrobustkzconsolidationkzenginekzthatkzprovideskzautomatedkzaggregations,kzintercompanykzeliminations
andkztranslationskzwithoutkzrequiringkzakzstrongkzITkzfootprint
B.kzdashboardkzreportingkzwithkzdailykzrevenuekzcomparisonskzandkzKPI'skzthatkzmeasurekzcostkzcontrols
C.kzleveragekzcompliancekzeffortskztokzfixkzprocesskzissueskzacrosskzallkzbusinesseskzandkzprovidekzoversightkzfor
riskkzawareness
D.kzakzconfigurablekzreportingkzsolutionkzwithkzprebuildkzdimensions,kzKPIs,kzreportskzalongkzwithkzakzprocesskzto
adjustkzdata,kzmonitorkzthekzclosekzstatuskzandkzviewkzdatakzandkzcompliancekzresultskzinkzdashboards
E.kzprovidekzthekzabilitykztokzcollaboratekzduringkzclosekzandkzanalysekztransactionkz-kzcorrectkzanswers-
A.kzrobustkzconsolidationkzenginekzthatkzprovideskzautomatedkzaggregations,kzintercompanykzeliminations
andkztranslationskzwithoutkzrequiringkzakzstrongkzITkzfootprint
D.kzakzconfigurablekzreportingkzsolutionkzwithkzprebuildkzdimensions,kzKPIs,kzreportskzalongkzwithkzakzprocesskzto
adjustkzdata,kzmonitorkzthekzclosekzstatuskzandkzviewkzdatakzandkzcompliancekzresultskzinkzdashboards
WhichkztwokzprebuiltkzcalculationskzrunkzonkzthekzMovementkzdimensionkztokzdeterminekzCTAkzbykzaccount?
A)PriorkzAveragekzRatekzminuskzCurrentkzAveragekzRatekzmultipliedkzbykzFCCS_Mvmts_Subtotal
B)PriorkzEndingkzRatekzminuskzCurrentkzEndingkzRatekzdividedkzbykzFCCS_Mvmts_Subtotal
C)FCCS_OpeningBalancekzmultipliedkzbykzEndingkzRatekzminuskzFCCS_OpeningBalancekzcarrykzforward
D)FCCS_Mvmts_SubtotalkzmultipliedkzbykzEndingkzRatekzminuskzFCCS_Mvmts_SubtotalkzmultipliedkzbyAverag
ekzRatekz-kzcorrectkzanswers-
C)kzFCCS_OpeningBalancekzmultipliedkzbykzEndingkzRatekzminuskzFCCS_OpeningBalancekzcarrykzforward
kz kz kz kz kz kz
nswers| multiple choice answers verified
kz kz kz kz kz
A+
InkzFinancialkzClosekzManager,kzwhenkzwouldkzyoukzchoosekztokzdefinekztaskskzinkzakzTemplatekzratherkzthan
createkzakznewkzSchedulekzeachkzmonth?
A.kzwhenkzthekztaskskzarekzrepeatablekzoverkzmultiplekzclosekzcycles
B.kzwhenkzthekztaskskzrequirekzconsistentkzdefinitionkzacrosskzclosekzschedules
C.kzwhenkzthekztaskskzarekzoftenkzlatekzinkzcompletionkzandkztheykzneedkztokzbekzmonitoredkzmorekzclosely
D.kzwhenkzthekztaskskzrequirekzmultiplekzlevelskzofkzapproverskz-kzcorrectkzanswers-
A.kzwhenkzthekztaskskzarekzrepeatablekzoverkzmultiplekzclosekzcycles
Whichkzrolekzcankzthekz"ApprovalskzSupervisor"kzperform?
A)Theykzcankzstartkzandkzstopkzakzplanningkzunit
B)Theykzcankzstartkzandkzstopkzakzplanningkzunitkzandkztakekzanykzactionkzonkzakzplanningkzunit
C)Theykzcankzstartkzbutkznotkzstopkzakzplanningkzunit
D)Theykzcannotkzstopkzorkzstartkzakzplanningkzunitkzbutkzcankzonlykzgivekzapprovalkz-kzcorrectkzanswers-
B)kzTheykzcankzstartkzandkzstopkzakzplanningkzunitkzandkztakekzanykzactionkzonkzakzplanningkzunit
WhichkztwokzdatakzextractkzexportkzfilekztypeskzarekzavailablekzwithinkzFinancialkzConsolidationkzandkzClose
(FCCS)?kz(Choosekztwo.)
A.kzDATkzfilekztype
B.kzExcelkzXLSkzfilekztype
C.kzCommakzdelimited
D.kzTabkzdelimitedkz-kzcorrectkzanswers-C.kzCommakzdelimited
D.kzTabkzdelimited
WhenkzcreatingkzakzmemberkzmappingkzforkzaccountkzSaleskzinkzDatakzManagement,kzthekzfollowingkzscript
iskzentered.
UD5kzreferskztokzakzProductkzcustomkzdimension:
WHENkzUD5kzLIKEkz'CAR_%'kzTHENkz'AUTO_SALES'
,ELSEkz'SALES'
WhichkzstatementkziskzTrue?
A.kzThekzscriptkzcankzbekzeliminatedkzbykzusingkzakzmulti-
dimkzmapkzonkzthekzProductkzdimensionkzthatkzalsokzlooks
forkzthekzaccountkzSales.
B.kzThekzscriptkzwillkzworkkzifkzthekzscriptkziskzreferencedkzinkzthekzInkzmappingkztypekzwithkz#SQLkzaskzthekztarget.
C.kzThekzscriptkzwillkznotkzworkkzsincekzDatakzManagementkzdoeskznotkzsupportkzscripting.
D.kzThekzscriptkzwillkznotkzworkkzsincekzthekzUD5kzmemberkzreferencedkzdoeskznotkzstartkzwithkzFCCS_
E.kzThekzscriptkzwillkzworkkzifkzthekzscriptkziskzreferencedkzinkzthekzExplicitkzmappingkztypekzwithkz#SQLkzaskzthekztarg
et.kz-kzcorrectkzanswers-
B.kzThekzscriptkzwillkzworkkzifkzthekzscriptkziskzreferencedkzinkzthekzInkzmappingkztypekzwithkz#SQLkzaskzthekztarget.
P,kzQ,kzandkzRkzarekzchildrenkzofkzakzmid-levelkzparentkzentity,kzAceCo.kzInkzFebruarykzeachkzentitykzhaskzcashkzin
thekzamountskzofkz10,kz20,kzandkz30,kzrespectively,kzandkzAceCokzhaskzbeenkzconsolidatedkzandkzhaskzcashkzofkz60.k
zA
priorkzperiodkzadjustmentkztokzQkzadjustskzcashkzwithkzakzdebitkzofkz5.
Whichkzstatementkzregardingkzconsolidationkziskzcorrect?
A.kzTherekziskznokzwaykztokzdokzakzpriorkzperiodkzentrykzlikekzthis.
B.kzJanuarykzandkzFebruarykzshouldkzbekzconsolidated.
C.kzFebruarykzshouldkzbekzconsolidated,kzafterkzwhichkzthekzcashkzatkzAceCokziskznowkz65.
D.kzJanuarykzshouldkzbekzconsolidatedkzforkzthekzchangekzandkznothingkzneedskztokzhappenkzforkzFebruary.kz-
kzcorrectkzanswers-B.kzJanuarykzandkzFebruarykzshouldkzbekzconsolidated.
WhichkzstatementkzcorrectlykzdescribeskzthekzConsolidationkzdimension?
A.kzThekzdimensionkzcontainskzmemberskztokzstorekznon-controllingkzinterestkzandkzjointkzventurekzdata.
B.kzThekzdimensionkzuseskzakzseparatekzmemberkztokzstorekzdatakzfromkzankzentity'skzdescendants.
C.kzThekzdimensionkzallowskzuserskztokzseekzinputkzversuskzjournalkzadjustmentkzdata.
D.kzThekzdimensionkzaggregateskzinput,kzconsolidated,kzandkzeliminationkzdatakztogether.kz-kzcorrectkzanswers-
B.kzThekzdimensionkzuseskzakzseparatekzmemberkztokzstorekzdatakzfromkzankzentity'skzdescendants.
Whykzshouldkzyearskzbekzconsolidatedkzsequentially;kzi.e.,kzfirstkz2018,kzthenkz2019,kzthenkz2020?
A)Eachkzperiodkzinkzthekzyearkzmustkzconsolidatekzseparately
B)Parentkzaccountkzcalculationskzdependkzonkzthekzsequencing
C)Therekziskznokzreasonkztokzconsolidatekzthekzyearskzsequentially
, D)Rollforwardkzcalculationskzarekzpopulatedkzwithkzcorrectkzresultskz-kzcorrectkzanswers-
D)Rollforwardkzcalculationskzarekzpopulatedkzwithkzcorrectkzresults
WhichkzstatementkziskztruekzregardingkzDatakzManagementkzcategories?
A.kzCategorieskzarekzdefinedkzonkzthekzGlobalkzMappingkztabkzandkzthenkzthekzfrequencykziskzspecifiedkzonkzthe
ApplicationkzMappingkztab
B.kzCategorieskzmustkzbeginkzwithkzFCCS_kztokzmatchkztheirkzFinancialkzConsolidationkzandkzClosekzcounterparts.
C.kzApplicationkzmappingkziskznotkzrequiredkzifkzthekzglobalkzmappingkztargetkzcategorykziskzexactlykzcorrect.
D.kzThekzcategory'skztimekzfrequencykzallowskzdatakztokzbekzloadedkztokzdaily,kzweekly,kzandkzmonthlykzscenarios.k
z-kzcorrectkzanswers-
C.kzApplicationkzmappingkziskznotkzrequiredkzifkzthekzglobalkzmappingkztargetkzcategorykziskzexactlykzcorrect.
Akzclientkzcompanykzhaskzexpandedkzquicklykzinkzthekzpastkzyearkzandkzhaskzrecognizedkzthekzneedkztokzmovekzthei
r
financialkzteamkzoffkzspreadsheetskzandkztokzakzmorekzverifiablekzandkzautomatedkzsolution.
WhichkztwokzrequirementskzfromkzthiskzteamkzwouldkzOracle'skzFinancialkzConsolidationkzandkzClosekzCloud
Servicekzsatisfy?kz(Choosekztwo.)
A.kzrobustkzconsolidationkzenginekzthatkzprovideskzautomatedkzaggregations,kzintercompanykzeliminations
andkztranslationskzwithoutkzrequiringkzakzstrongkzITkzfootprint
B.kzdashboardkzreportingkzwithkzdailykzrevenuekzcomparisonskzandkzKPI'skzthatkzmeasurekzcostkzcontrols
C.kzleveragekzcompliancekzeffortskztokzfixkzprocesskzissueskzacrosskzallkzbusinesseskzandkzprovidekzoversightkzfor
riskkzawareness
D.kzakzconfigurablekzreportingkzsolutionkzwithkzprebuildkzdimensions,kzKPIs,kzreportskzalongkzwithkzakzprocesskzto
adjustkzdata,kzmonitorkzthekzclosekzstatuskzandkzviewkzdatakzandkzcompliancekzresultskzinkzdashboards
E.kzprovidekzthekzabilitykztokzcollaboratekzduringkzclosekzandkzanalysekztransactionkz-kzcorrectkzanswers-
A.kzrobustkzconsolidationkzenginekzthatkzprovideskzautomatedkzaggregations,kzintercompanykzeliminations
andkztranslationskzwithoutkzrequiringkzakzstrongkzITkzfootprint
D.kzakzconfigurablekzreportingkzsolutionkzwithkzprebuildkzdimensions,kzKPIs,kzreportskzalongkzwithkzakzprocesskzto
adjustkzdata,kzmonitorkzthekzclosekzstatuskzandkzviewkzdatakzandkzcompliancekzresultskzinkzdashboards
WhichkztwokzprebuiltkzcalculationskzrunkzonkzthekzMovementkzdimensionkztokzdeterminekzCTAkzbykzaccount?
A)PriorkzAveragekzRatekzminuskzCurrentkzAveragekzRatekzmultipliedkzbykzFCCS_Mvmts_Subtotal
B)PriorkzEndingkzRatekzminuskzCurrentkzEndingkzRatekzdividedkzbykzFCCS_Mvmts_Subtotal
C)FCCS_OpeningBalancekzmultipliedkzbykzEndingkzRatekzminuskzFCCS_OpeningBalancekzcarrykzforward
D)FCCS_Mvmts_SubtotalkzmultipliedkzbykzEndingkzRatekzminuskzFCCS_Mvmts_SubtotalkzmultipliedkzbyAverag
ekzRatekz-kzcorrectkzanswers-
C)kzFCCS_OpeningBalancekzmultipliedkzbykzEndingkzRatekzminuskzFCCS_OpeningBalancekzcarrykzforward
