,DOWNLOAD THE Test Bank for Data Analytics for Accounting 1st Edition Richard
m m m m m m m m m m m
son
DatamAnalyticsmformAccounting,m1em (Richardson
)mChapterm2 DatamPreparationmandmCleaning
1) Masteringmthemdatamrequiresmamfirmmunderstandingmof mwhat mdatamismavailablemtomyoumand mwher
emit mismstored,masmwellmasmbeingmskilled minmthemprocessmof mextracting,mtransforming,mand mloadingm(
ETL).
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m How mDatamAremUsed mand mStored minmThemAccountingmCycle
LearningmObjective:m 02-
01mUnderstand mhow mdatamaremorganized minmanmaccountingminformationmsystem.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
2) A mflat mfilemismammeansmof mstoringmdataminmonemplace,msuchmasminmanmExcelmspreadsheet,masmoppo
sed mtomstoringmthemdataminmmultiplemtables,msuchmasminmamrelationalmdatabase.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology
3) A mforeignmkeymismanmattributemthat mismrequired mtomexist minmeachmtablemof mamrelationalmdatabasem
and mservesmasmthemuniquemidentifiermformeachmrecord minmamtable.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology
1
Copyright m2019 m©mMcGraw-
HillmEducation.mAllmrightsmreserved.mNo mreproduction mormdistribution mwithout mthempriormwritten mconsent mof mMc
Graw-HillmEducation.
mynursytest.store
,DOWNLOAD THE Test Bank for Data Analytics for Accounting 1st Edition Richard
m m m m m m m m m m m
son
4) A mprimarymkeymismanmattributemthat mismrequired mtomexist minmeachmtablemof mamrelationalmdatabasem
and mservesmasmthemuniquemidentifiermformeachmrecord minmamtable.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Understand
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology
5) A mforeignmkeymismanmattributemthat mexistsminmrelationalmdatabasesminmordermtomcarrymout m
themrelationshipmbetweenmtwomtables.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
6) A mcompositemprimarymkeymismmademupmof mthemthreemormmoremprimarymkeysminmthemtablesmthat mi
t mismlinking.
Answer:m FALSEm Difficult
y:m2mMediumm Topic:m Relat
ionalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Understand
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
7) Descriptivemattributesmaremattributesmthat mexist minmrelationalmdatabasesmthat maremneithermprima
rymnormforeignmkeys.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
2
Copyright m2019 m©mMcGraw-
HillmEducation.mAllmrightsmreserved.mNo mreproduction mormdistribution mwithout mthempriormwritten mconsent mof mMc
Graw-HillmEducation.
mynursytest.store
, DOWNLOAD THE Test Bank for Data Analytics for Accounting 1st Edition Richard
m m m m m m m m m m m
son
8) Oncemyoumhavemextracted mthemdatamofminterest,mit mwillmneed mtombemvalidatedmformcompletenessma
nd mexistence.
Answer:m FALSEmDiffi
culty:m2mMedium
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
9) ThemMminmIMPACTmCyclemrepresentsmManipulatingmthemData.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
10) ThemTminmIMPACTmCyclemrepresentsmtransfer.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
11) ThemI minmIMPACTmCyclemrepresentsmInquiry.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
3
Copyright m2019 m©mMcGraw-
HillmEducation.mAllmrightsmreserved.mNo mreproduction mormdistribution mwithout mthempriormwritten mconsent mof mMc
Graw-HillmEducation.
mynursytest.store
m m m m m m m m m m m
son
DatamAnalyticsmformAccounting,m1em (Richardson
)mChapterm2 DatamPreparationmandmCleaning
1) Masteringmthemdatamrequiresmamfirmmunderstandingmof mwhat mdatamismavailablemtomyoumand mwher
emit mismstored,masmwellmasmbeingmskilled minmthemprocessmof mextracting,mtransforming,mand mloadingm(
ETL).
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m How mDatamAremUsed mand mStored minmThemAccountingmCycle
LearningmObjective:m 02-
01mUnderstand mhow mdatamaremorganized minmanmaccountingminformationmsystem.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
2) A mflat mfilemismammeansmof mstoringmdataminmonemplace,msuchmasminmanmExcelmspreadsheet,masmoppo
sed mtomstoringmthemdataminmmultiplemtables,msuchmasminmamrelationalmdatabase.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology
3) A mforeignmkeymismanmattributemthat mismrequired mtomexist minmeachmtablemof mamrelationalmdatabasem
and mservesmasmthemuniquemidentifiermformeachmrecord minmamtable.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology
1
Copyright m2019 m©mMcGraw-
HillmEducation.mAllmrightsmreserved.mNo mreproduction mormdistribution mwithout mthempriormwritten mconsent mof mMc
Graw-HillmEducation.
mynursytest.store
,DOWNLOAD THE Test Bank for Data Analytics for Accounting 1st Edition Richard
m m m m m m m m m m m
son
4) A mprimarymkeymismanmattributemthat mismrequired mtomexist minmeachmtablemof mamrelationalmdatabasem
and mservesmasmthemuniquemidentifiermformeachmrecord minmamtable.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Understand
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology
5) A mforeignmkeymismanmattributemthat mexistsminmrelationalmdatabasesminmordermtomcarrymout m
themrelationshipmbetweenmtwomtables.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
6) A mcompositemprimarymkeymismmademupmof mthemthreemormmoremprimarymkeysminmthemtablesmthat mi
t mismlinking.
Answer:m FALSEm Difficult
y:m2mMediumm Topic:m Relat
ionalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Understand
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
7) Descriptivemattributesmaremattributesmthat mexist minmrelationalmdatabasesmthat maremneithermprima
rymnormforeignmkeys.
Answer:m TRUEmDiffic
ulty:m1mEasy
Topic:m m RelationalmDatabase
LearningmObjective:m 02-
02mUnderstand mhow mdatamaremstored minmamrelationalmdatabase.mBloom's:m Remember
AACSB:m m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
2
Copyright m2019 m©mMcGraw-
HillmEducation.mAllmrightsmreserved.mNo mreproduction mormdistribution mwithout mthempriormwritten mconsent mof mMc
Graw-HillmEducation.
mynursytest.store
, DOWNLOAD THE Test Bank for Data Analytics for Accounting 1st Edition Richard
m m m m m m m m m m m
son
8) Oncemyoumhavemextracted mthemdatamofminterest,mit mwillmneed mtombemvalidatedmformcompletenessma
nd mexistence.
Answer:m FALSEmDiffi
culty:m2mMedium
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
9) ThemMminmIMPACTmCyclemrepresentsmManipulatingmthemData.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
10) ThemTminmIMPACTmCyclemrepresentsmtransfer.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
11) ThemI minmIMPACTmCyclemrepresentsmInquiry.
Answer:m FALSEmDiffi
culty:m1mEasy
Topic:m m Extraction,mTransformation,mand mLoadingm(ETL)mof mData
LearningmObjective:m 02-
03mExplainmand mapplymextraction,mtransformation,mand mloadingm(ETL)mtechniques.
Bloom's:m Rememberm AACS
B:m ReflectivemThinking
AICPA:m m BBmLeveragingmTechnology;mFN mLeveragingmTechnology;mFNmDecisionmMaking
3
Copyright m2019 m©mMcGraw-
HillmEducation.mAllmrightsmreserved.mNo mreproduction mormdistribution mwithout mthempriormwritten mconsent mof mMc
Graw-HillmEducation.
mynursytest.store
