Copyright2019?McGraw-HillEducation.Allrightsreserved.NoreproductionordistributionwithoutthepriorwrittenconsentofMcGraw-HillEducation.

DataAnalyticsforAccounting,1e(Richardson)

Chapter2DataPreparationandCleaning

1)Masteringthedatarequiresafirmunderstandingofwhatdataisavailabletoyouandwhereitisstored,aswellasbeingskilledintheprocessofextracting,transforming,andloading(ETL).

2)Aflatfileisameansofstoringdatainoneplace,suchasinanExcelspreadsheet,asopposedtostoringthedatainmultipletables,suchasinarelationaldatabase.

3)Aforeignkeyisanattributethatisrequiredtoexistineachtableofarelationaldatabaseandservesastheuniqueidentifierforeachrecordinatable.

4)Aprimarykeyisanattributethatisrequiredtoexistineachtableofarelationaldatabaseandservesastheuniqueidentifierforeachrecordinatable.

5)Aforeignkeyisanattributethatexistsinrelationaldatabasesinordertocarryouttherelationshipbetweentwotables.

6)Acompositeprimarykeyismadeupofthethreeormoreprimarykeysinthetablesthatitislinking.

7)Descriptiveattributesareattributesthatexistinrelationaldatabasesthatareneitherprimarynorforeignkeys.

8)Onceyouhaveextractedthedataofinterest,itwillneedtobevalidatedforcompletenessandexistence.

9)TheMinIMPACTCyclerepresentsManipulatingtheData.

10)TheTinIMPACTCyclerepresentsTransfer.

11)TheIinIMPACTCyclerepresentsInquiry.

12)Inordertoobtaintherightdata,itisimportanttohaveafirmgraspofwhatdataisavailableandhowitisstored.

13)Datanormalizationcanreducedataredundancyandimprovedataintegrity.

14)MuchliketheIMPACTcycle,requestingdataisoftenaniterativeprocess.

15)UnliketheIMPACTcycle,requestingdataisnotaniterativeprocess.

16)Iftheextractionandtransformationstepshavebeendonecorrectly,theloadingpartoftheETLprocessshouldbethesimpleststep.

17)Afterobtainingthedataanddeterminingthepurposeandscopeofthedatarequest,thenextstepistovalidatethedata.

18)Comparingthenumberofrecordsthatwereextractedtothenumberofrecordsinthesourcedatabaseisanexampleofvalidatingthedataforintegrity.

19)Formattingnegativenumbersisanexampleofcleaningthedata.

20)Atemplatecanmakecommunicationeasierbetweendatarequestorandprovider.

21)MasteringthedatacanalsobedescribedviatheETLprocess.TheETLprocessstandsfor:

A)Extract,total,andloaddata.

B)Extract,transform,andloaddata.

C)Enter,transform,andloaddata.

D)Enter,total,andloaddata.

22)AllofthefollowingareAuditDataStandards(ADS)developedbytheAmericanInstituteofCertifiedAccountantsexcept:

A)Investmentssubledgerstandards

B)GeneralLedgerstandards

C)Procure-to-Paysubledgerstandards

D)Order-to-Cashsubledgerstandards

23)Whenusing[EmployeeID]astheuniqueidentifieroftheEmployeetable,[EmployeeID]isanexampleofwhichofthefollowing:

A)Foreignkey

B)Compositekey

C)Primarykey

D)Keyattribute

24)Thepurposeofextractingdatais:

A)Tovalidatethedataforcompletenessandintegrity

B)Toloadthedataintotheappropriatetoolforanalysis

C)Toidentifyandobtainthedatafromtheappropriatesource

D)Toidentifywhichapproachtodataanalyticsshouldbeused

25)Thepurposeoftransformingdatais:

A)Tovalidatethedataforcompletenessandintegrity

B)Toloadthedataintotheappropriatetoolforanalysis

C)Toidentifyandobtainthedatafromtheappropriatesource

D)Toidentifywhichapproachtodataanalyticsshouldbeused

26)Thepurposeofloadingdatais:

A)Tovalidatethedataforcompletenessandintegrity

B)Toputthedataintotheappropriatetoolforanalysis

C)Toidentifyandobtainthedatafromtheappropriatesource

D)Toidentifywhichapproachtodataanalyticsshouldbeused

27)AllofthefollowingareincludedinthefivestepsoftheETLprocessexcept:

A)Determinethepurposeandscopeofthedatarequest

B)Obtainthedata

C)Validatethedataforcompletenessandintegrity

D)Scrubthedata

28)Whichofthefollowingbestexemplifiesawaythatdatawillneedtobecleanedafterextractionandvalidation?

A)Removeheadingsandsubtotals

B)Validatedate/timefields

C)Removetrailingzeroes

D)Comparestringlimitsfortextfields

29)________isthemetadatathatdescribeseachattributeinadatabase.

A)Relationaldatabase

B)Datadictionary

C)Descriptiveattributes

D)Flatfile

30)Removingheadingsorsubtotalsfromdataisanexampleofwhichofthefollowing?

A)Validatingthedataforcompleteness

B)Validatingthedataforintegrity

C)Cleaningthedata

D)Obtainingthedata

31)Correctinginconsistenciesacrossdataisanexampleofwhichofthefollowing?

A)Validatingthedataforcompleteness

B)Validatingthedataforintegrity

C)Cleaningthedata

D)Obtainingthedata

32)Formattingnegativenumbersinthedataisanexampleofwhichofthefollowing?

A)ValidatingtheDataforCompleteness

B)ValidatingtheDataforIntegrity

C)CleaningtheData

D)ObtainingtheData

33)Removingleadingzeroesandnon-printablecharactersfromthedataisanexampleofwhichofthefollowing?

A)Validatingthedataforcompleteness

B)Validatingthedataforintegrity

C)Cleaningthedata

D)Obtainingthedata

34)Comparingdescriptivestatisticsfornumericfieldswithinthedataisanexampleofwhichofthefollowing?

A)Validatingthedataforcompleteness

B)Validatingthedataforintegrity

C)Cleaningthedata

D)Obtainingthedata

35)Comparingthenumberofrecordswithinthedataisanexampleofwhichofthefollowing?

A)Validatingthedataforcompleteness

B)Validatingthedataforintegrity

C)Cleaningthedata

D)Obtainingthedata

36)Validatingdate/timefieldswithinthedataisanexampleofwhichofthefollowing?

A)Validatingthedataforcompleteness

B)Validatingthedataforintegrity

C)Cleaningthedata

D)Obtainingthedata

37)Whichofthefollowingbestdescribesthepurposeofaprimarykey?

A)Toensurethateachrowinthetableisunique

B)Tocreatetherelationshipbetweentwotables

C)Toprovidebusinessinformation,butarenotrequiredtobuildadatabase

D)Tosupportbusinessprocessesacrosstheorganization

38)Whichofthefollowingbestdescribesthepurposeofanon-keyattribute?

A)Toensurethateachrowinthetableisunique

B)Tocreatetherelationshipbetweentwotables

C)Toprovidebusinessinformation

D)Tosupportbusinessprocessesacrosstheorganization

39)Whichofthefollowingbestdescribesthepurposeofrelationaldatabases?

A)Toensurethatbusinessrulesareenforced

B)Toincreaseinformationredundancyintheorganization

C)Toprovidebusinessinformationtodataanalysts

D)Tosupportbusinessprocessesacrosstheorganization

40)Whichofthefollowingbestdescribesthepurposeofaforeignkey?

A)Toensurethateachrowinthetableisunique

B)Tocreatetherelationshipbetweentwotables

C)Toprovidebusinessinformation

D)Tosupportbusinessprocessesacrosstheorganization

41)Adatadictionaryisparamountinhelpingdataanalystsdowhichofthefollowing?

A)Maintaindatabases.

B)Identifythedatatheyneedtouse.

C)Communicatinginsights.

D)Trackoutcomes.

42)Adatadictionaryisparamountinhelpingdatabaseadministratorsdowhichofthefollowing?

A)Maintaindatabases.

B)Identifythedatatheyneedtouse.

C)Communicatinginsights.

D)Trackoutcomes.

43)AtwhichstepoftheETLprocessshouldyoutrytoanswerthequestion"Whattoolswillbeusedtoperformdataanalytictestsorproceduresandwhy?"

A)Step1:Determinethepurposeandscopeofthedatarequest.

B)Step2:Obtainthedata.

C)Step3or4:Transformation.

D)Step5:Loadingthedatafordataanalysis.

44)AtwhichstepoftheETLprocessshouldyoutrytoanswerthequestion"Whatotherinformationwillimpactthenature,timingandextentofthedataanalysis?"

A)Step1:Determinethepurposeandscopeofthedatarequest.

B)Step2:Obtainthedata.

C)Step3or4:Transformation.

D)Step5:Loadingthedatafordataanalysis.

45)AtwhichstepoftheETLprocessshouldyoutrytoanswerthequestion"Whatbusinessproblemwillthedataaddress?"

A)Step1:Determinethepurposeandscopeofthedatarequest.

B)Step2:Obtainthedata.

C)Step3or4:Transformation.

D)Step5:Loadingthedatafordataanalysis.

46)AtwhichstepoftheETLprocessshouldyoutrytoanswerthequestion"Wherearethedatalocatedinthefinancialorotherrelatedsystems?"

A)Step1:Determinethepurposeandscopeofthedatarequest.

B)Step2:Obtainthedata.

C)Step3or4:Transformation.

D)Step5:Loadingthedatafordataanalysis.

47)Whenobtainingthedatayourself,youshoulddoallofthefollowingbeforeyoubeginexcept:

A)Identifythetablesthatcontaintheinformationyouneed.

B)Identifywhichattributesspecificallyholdtheinformationyouneedineachtable.

C)Identifyhowthosetablesarerelatedtoeachother.

D)Identifyanyerrorsorissuesfromtheextraction.

48)Thereareavarietyofmethodsthatyoucouldtaketoretrievethedata,includingSQL.WhatdoesSQLstandfor?

A)SystemsQueryLanguage.

B)SystemsQuestionLanguage.

C)StructuredQuestionLanguage.

D)StructuredQueryLanguage.

49)Allofthefollowingarebenefitsofusinganormalizedrelationaldatabaseexcept:

A)Completeness.

B)Noredundancy.

C)Businessrulesareenforced.

D)Dataisstoredinoneplace.

50)WhichofthefollowingismostlikelytobetheprimarykeyinanEmployeetable?

A)EmployeeID

B)EmployeeSocialSecurityNumber

C)EmployeeName

D)EmployeeType

51)Chapter2describes,thevariouswaysinwhichdatacanbestoredfordifferingpurposes.Describethetwowaysdatacanbeorganizedandthepurposeforeachorganizationalstructure.

52)Taylorisanewstaffaccountantforafortune100company.AfterhearingthatshejustsuccessfullycompletedanAccountingDataAnalyticscourse,herbosssaid,"Getmealistingofallourdeadbeatcustomer,so