CDMP（基础级）数据管理专业认证备考试题库大全（含答案）.docx

1、CDMP（基础级）数据管理专业认证备考试题库大全（含答案）1 .Dataqualityrulesandmeasurementresultsareexamplesof:A、operationalmetadataB、industrymetadataC、businessmetadataD、strategicmetadataE、technicalmetadata答案：C2 .GoalsandPrinciplesareoneofthesevenbasicEnvironmentElementsoftheFunctionalframeworkfordatagovernancethatincludesA、St

2、rategicGals.Dependencies.AlternativeTechniques.ReportingStructures.B、jectives.C、VisionMission.BusinessBenefits.StrategicGals,andSpecificD、Inputsoutputs.CriticalSuccessFactors.UseCaseScenarios,andRecognizedBestPractices.E、All答案：C3 .Acommondriverfordatagovernanceis:A、RegulatorycomplianceB、Theappointme

3、ntofaCDOC、IrreconcilablefiguresinreportsD、OutsouringE、Internalaudits答案：A4 .Thequalityofdatawillbeimprovedby:A、World,sbestpracticesoftwaretoolsB、PeriodicdataqualityinitiativesthatleavethedatabetterthantheyfounditC、EstablishingaregimeofpenaltiesforpoordataqualityD、Identifyinganddeletingalltheerroneous

4、dataintheorganisationE、Amindsetthathelpsemployeesandstakeholderstoactwhilealwaysthinkingofthequalityofdata答案:E5 .Atermreferstounsolicitedcommercialemailmessagessentoutinbulkusuallytotensofmillionsofusersinhopesthatafewmayreply.thistermiscalledA、AdwareB、SpamC、SocialengineeringD、DMZE、threatB6.Dataarch

5、itecturecomplianceratemeasures:A、HowfastthedatabasecanretrievedataB、HowcloselyprojectscomplywithestablisheddataarchitecturesC、HowcompleteanattributelistisinanentityD、HowcloselyprojectscomplywiththedevelopmentlifecycleE、Howcloselyprojectsaremeetingtheirtimelines答案：B7.1fyouhaveaBusinessIntelligenceorI

6、nformationManagementgroup,youcanneverdoenoughconnectingbetween()and()A、dataarchitects;DBAsB、strategicplanningorganizationinformationteleologyorganizationC、informationtechnology;therestofthebusinessD、technologyarchitect,sbusinessanalystsE、informationtechnology;businessanalysts答案:C8.Recordsaredefineda

7、s()anorganizationbusinessactivitiesandregulatorycompliance.A、containersofB、storageofC、documentationofD、evidenceofE、fileof9.RegulatorydataretentionrequirementsdrivetheneedtokeepdataforsetperiodsforA、submittingdatasetstoregulatorsB、historicalreportingC、customeranalytics.Dlegalobligations.E、alternateba

8、ckupsourcesD10.Common(databasesecuritymeasuresincludeallofthefollowingEXCEPTA、theuseofschemas.B、theuseofsub-schemasC、sniffersD、rowlevellockingE、firewallC11 .DatagovernancestakeholdersincludeallofthefollowingEXCEPTA、productconsumersB、regulatorycomplianceofficersC、financialmanagement.Dthoseoperational

9、intereststhatdriveefficiencyandeffectivenessE、all12 .Whatisthepurposeofaninformationvaluechainartifact?A、MapsrelationshipsbetweendataandprocessesB、Providesahigh-levelorientationviewofanenterpriseandhowitinteractswiththeoutsideworldC、ShowsalistofentitiesD、MapsthemovementofdataE、all答案：A13 .Slice,Dice,

10、Roll-upandPivotaretermsusedinwhatkindofdataprocessing?A、OLAPB、OLTPC、EIEIOD、EDIE、ODSA14 .ReferencedataappearsinalltheseEXCEPTA、adatacontentmanagementtaglistB、athesaurusC、ETLcodeD、apicklist15 .TheacronymSOAstandsfor:A、ServiceOrientedArchitectureB、ServiceOrientedActuariesC、serviceOrientedAccuracyD、Syst

11、emOrientedArchitectureE、SystemOrientedAccuracyA16 .ProductionDBA,swouldnotnormallytakeresponsibilityfor:A、ImplementingmechanismsforclusteringandfailoverofthedatabaseB、ImplementingbackupandrecoverymechanismsCThefitnessofpurposefordatainthedatabaseD、Executingotherdatabasemaintenanceactivities,suchasar

12、chivingE、EnsuringperformanceandreliabilityofthadatabaseC17 .AmajorfocusofthedatabaseadministrationOperationsfunctionisA、databaseintegrity.B、conceptualdataarchitectureC、datamanagementpoliciesD、constructionofdatabaseinquiriesE、databasesecurityA18 .Reasonstogoverndataarchitectureincludeallofthefollowin

13、gEXCEPTA、yourequireamatrixmapOfbusinessunitinteractionswithdataentitiesB、youneedtoknowwheredataisreportedallthetimeC、thecoredatamanagementprocessesofitdepartmentstouchonlyasmallpercentageoftheenterprisedataresourceD、youneedasubjectmodelthatdescribesthevariousdatadomainsE、allB19 .Everyenterpriseissub

14、jecttomanygovernmentalandindustryregulationsmanyofwhichregulatehowdataandinformationisusedandmanagedpartofthedatagovernancefunctionA、MonitorandensurethatorganizationsmeetanyregulatorycompliancerequirementsB、Thisisaboutdata,datagovemmanceisaccountableforthewholeprocesswithRiskandauditreportingtodgC、E

15、nforceenterprise-widemandatorycompliancetoregulationD、Performad-hocauditsofpossibleregulationstoreporttotheDGcouncilonaninformationonlybasisE、ThisisariskandauditresponsibilityDataGovernanceplaysnoroleinthis.A20 .TotreatDataGovernanceintheenterpriseasisamisconceptionA、achangeB、re-engineeringC、aframew

16、orkD、AprojectE、AprogramD21 .AlineagedatatoolprovidesA、thecaptureandmaintenanceofsourcestructuresforeachattributeonthedatamodeB、 ancestorialoriginofdataDNAC、atemporaldistortionofdatavaluesacrosssystemsD、acleanlinebetweencolumnsinthesameentityE、scopeforreportingrequirements答案:B22 .Thekeyconceptsofthed

17、atavaultareA、HubsJinksandsatellitesB、KeysJocksandcombinationsC、Facts,dimensionsandtimeD、Hubs9IinksandplanetsE、Facts9Iinksandsatellites答案：A23.IndatamodelingsubjectareasareusefulforA、groupingdataattributesbydatatypeB、organizingaprojectintophasesCorganizingamanagementpresentationonyourapplicationDgroup

18、ingentitiestomakemodelmanagementeasier.E、noneD24 .Apieceofsoftwarethatcantranslatemeta-datafromoneproductintothatofanotheriscalledameta-dataA、interfaceB、routerC、bridgeD、translatorE、all答案：D25 .MasterdatamanagementinorganizationsmaybepartofallofthefollowingEXCEPTAanERPprogramB、abusinessprocessmanageme

19、ntprogramC、avendor,sparticularsolutiontoinconsistentcorporatedataD、acustomerdataintegrationprogramE、anCRMprogram26 .Nonvalue-addedinformationisoftennotremovedbecauseA、wWemightneedtheinformationatalaterstageB、LegislationisunclearonwhatshouldbekeptC、Thepoliciesareunclearofwhatisdefinedasnon-value-adde

20、d,storageischeapsothereisnocostdriver,andittakesmoreefforttodisposethantokeep.D、Dataisanasset.ltislikelytoberecognizedasvaluableinthefutureE、litshouldnotberemovedalldataisvalue-added答案:C27 .()and()aretwotechniquesthatmustbeappliedbypolicytoinformationtoeliminatebusinessriskoncedataisnolongerneededA、

21、BackuprecoveryB、DeclassificationredactionC、 sanitization;recoveryD、Shredding;expungementE、Sanitization,recoveryDD、 .TheacronymBASEstandsfor:A、BasicallyAvailable,softState9EventualConsistencyB、BasicallyAvailable9StateEventualConsistencyc、BasicallyAvailableSoftConsistency9EventualStateD、Basicallyartic

22、le,SoftConsistency9EventualStateEBasicallyArticle9SoftConsistency,EventualStateA解析：BASE就是为了解决关系数据库强一致性引起的问题而引起的可用性降低而提出的解决方案。BASE其实是下面三个术语的缩写：基本可用(BasicallyAvailable)软状态(Softstate)最终一致(Eventuallyconsistent)29 .Validateusers,access.Whenausertriestologintoasystemthesystemneedstoverifythatthepersoniswh

23、oheorsheclaimstobe.passwordsareonewayofdoingthisThisiscalledA、analysisB、replicationC、archivingD、AuthenticationEthreat答案:D30 .AdatawarehousebusmatrixrepresentsA、conformeddimensionsandtheirkeysB、anETLschemaC、businessprocessesandcommonfactsD、businessprocessesandcommondimensionsE、AlID31 .Atermreferstoho

24、wmalicioushackerstrytotrickpeopleintogivingthemeitherinformationoraccessthistermiscalledA、analysisB、HackingC、socialengineeringD、DMZEthreatC32 .ATermisaformofdataanalysisusedtoinspectdataandassessquality.thistermiscalledA、DataProfilingB、DataparsingC、DataModelingD、DataanalysisE、DataCleansing答案：A33.1 n

25、formationqualitytrainingtopicsforbusinessinformation/datastewardsshouldincludeallofthefollowingEXCEPTA、systemsdevelopmentprinciples.B、rolesandresponsibilities.C、datasecurityandprivacyD、informationvaluechainE、All答案：A33.2 hatisthedifferencebetweencardinalityrulesanddataintegrityrules?A、Referentialinte

26、grityrulesquantifytherelationshipsbetweentwoormoreentitiesandcardinalityrulesquantfythecommonattributesacrossentities.B、Referentialintegrityrulesdefinethequantityofeachentityinstancethatcanparticipateinarelationshipbetweentwoentitiesandcardinalityrulesensurevalidvalues.andreferentialintegrityC、There

27、isnodifference.Cardinalityrulesrulesaresynonyms.ofeachentityinstancethatcanD、Cardinalityrulesdefinethequantityparticipateinarelationshipbetweentwoentitiesandreferentialintegrityrulesensurevalidvalues.E、Referentialintegrityrulesonlyappearonarelationaldatamodelandcardinalityrulesonlyappearonadimension

28、aldatamodelD35.5 copeandprioritiesmanagementinadatagovernanceprogramisaprocessofA、proactivechangemanagementB、respondingtochangesinthebusinessenvironmentthatareoftenunanticipatedC、respondingtorapidshiftsinstakeholdersandstakeholderinterests.D、predictingvolatilebusinessenvironmentswhilemaintainingstat

29、icdataE、none答案：D36 .TheroleoftheConceptualdatamodelinthemetadatarepositoryisA、tosummariesthekeydatasubjectareasforabusinessareaatahighlevelofabstractiontoenablethemajordataconceptstobeunderstoodBtoagreethecardinalityandoptionalityofrelationshipsbetweenallentitiesC、alloftheseD、NoneofthetheseE、todeter

30、minetheprimaryalternateandforeignkeysofentities答案A37 .Thebestwaytovalidatethatadatabasebackupisworking,istoA、checkthesizeofthebackupfile.B、appointaspecialDBAinchargeofbackupsC、checkthebackuplogseveryday.D、periodicallyrecoverfromthebackupfileE、checkfortheautomaticemailnotificationofbackupsuccessD38.w

31、hoismostresponsibleforcommunicatingandpromotingawarenessonthevalueofDataGovernanceintheorganization?A、DataChampionsB、ThedatagovernanceofficeC、EveryoneintheDataManagementCommunityD、DataOwnersstewardsE、ThedatagovernancecouncilC39 .TheprocessaspectofDataGovernanceincludesallofthefollowingEXCEPTA、polici

32、esB、rules.C、accessprivilegesD、procedures40 .Atermisaprogrambuilttoreproduceandspreadacrossanetworkbyitself.ThistermiscalledA、AdwareB、computerwormC、socialengineeringD、DMZE、threat答案:B41 .ThefollowingaredeliverablesinadatagovernanceprogramEXCEPTA、themetricsfbrdataqualityscorecardB、datainputcontrolsC、in

33、dexingofdatamanagementtechniquesD、meta-datastandards.E、Datastrategy答案:B42 .Electronicdatainterchange(EDI)throughXMLtypicallyinvolveseachofthefollowingEXCEPTA、customerstransactions.B、areductionofpaperflowC、contractsbetweentradingpartnersD、transactionconvertersE、All答案：A43 .A1ContentDistributionNetwork

34、supportingamulti-nationalwebsiteislikelytouseA、anextracttransformandloadsolutionB、arecordsdisposalsolutionC、areplicationsolutionD、adatabasebackupandrestoresolutionE、anarchivingsolution答案:C44 .WhichofthefollowingisNOTastageintheShewhart/DemingCyclethatdrivesthedataqualityimprovementlifecycleA、PlanB、

35、CheckC、DoD、InvestigateE、Act答案：D45 .Themetadatastructureforacontentmanagementsystemcanberepresentedwitha:A、ProcessmodelB、MindmapC、AuthorizationmatrixD、DatamodelE、CRUDmatrix答案:B46 .Followingtherolloutofadataissueprocess,therehavebeennoissuesrecordedinthefirstmonth.Thereasonforthismightbe:A、Lackofcredi

36、bilityinthedatagovernanceprocesstoaffectchangesB、StaffstayingbacklatetoentertheissuesintothesystemC、theautomaticdeletionofallissuesinthedatabase.D、Therearenodataissuesintheenterprise.E、ThedenialofovertimerequestsA47 .whichofthefollowingBESTdescribestheroleofadataintermediary?A、Someonewhodecideswhatd

37、ataisimportanttothebusinessB、Someonewhoisresponsibleformanagingthemeta-datarepositoryC、someonewhoreceivesdatainoneformandtranscribesitintoanotherforD、SomeonewhoisresponsiblefortranslatingbusinessrequirementsintoadatabasedesignE、All答案：C48 .Duringplanningstageofadatamodelwhichofthefollowingisnotavalid

38、schemaA、Fact-basedB、RelationalC、DenormalisedD、NoSQLE、DimensionalC49 .ThegovernanceteamplaysapivotalroleinensuringtheareselectedA、definedrolesB、policiesandproceduresC、ROlfiguresD、rightprojectsE、allD50 .SignificantoperationalissueshavebeencausedbytheimplementationofadatamodelthatrepresentsaCustomerAgr

39、eementasaternieraryrelationshipbetweentheEnterpriserCustomer,andtheirContactPerson.Whichofthefollowingdescribesthelikelyoperationalissue?A、IntheeventofamergerbetweenenterprisesthecontactpersonaddressesneedtobeupdatedB、EverytimetheCustomerAgreementwasrenewedanewContactPersonrecordwasrequiredC、Everyti

40、methecustomerchangesaddressestheaddressforthecontactpersonmustchangeaswellD、ResponsetimeforretrievingtheCustomeragreementdegradesrapidlyduetothelackofindexing.E、Everytimethecontactpersonchanges,thecustomeragreementneedstobere-establishedE51 .Whenassessingtoolstoimplementmasterdatamanagementsolutions

41、functionalitymustincludeA、documentandcontentmanagement.B、advancedanalyticscapabilitiesC、auto-normalizationfeaturesD、backupandrecoveryutilities.E、sophisticatedintegrationcapability.E52 .Atermistypeofcontrolledvocabularyusedforcontentretrieval.Itcombinescharacteristicsofsynonymlistsandtaxonomies.this

42、termiscalledA、TaxonomiesB、DataMapC、OntologyD、thesaurusE、Records答案：D53 .whichoftheseisNOTastandardmotivationfordatagovernanceA、DevolvedgovernanceB、DecentralizedGovernanceC、Pre-emptivegovernanceD、ProactivegovernanceE、Reactivegovernance答案:A54 .InformationlifecycleelementsincludeallofthefollowingEXCEPTA

43、create/receiveB、distribute/useldispose.C、maintain/preserveDassiate/modelE、none答案：D55 .Adatalineagetoolenablesauserto:A、trackthedatafromsourcesystemtoatargetdatabaseunderstandingitstransformationsB、visualizehowthedatagetstothedatalakeC、trackthehistoricalchangestoadatavalueD、lineupthedatatosupportsop

44、histicatedglossarymanagementEenablesrapiddevelopmentofdashboardreportingA1.1 InformationgovernanceanddatagovernanceshouldbeA、managedbythechiefInformationOfficerB、managedasasinglefunctionC、managedasintegratedfunctions,withinformationgovernancereportingtodatagovernanceD、managedasintegratedfunctionswit

45、hdatagovernancereportingtoinformationgovernanceE、managedasseparatefunctions.答案：E57 .Alegaltermisalegaltermthatreferstopre-rialphaseofalawsuitwherebothpartiesrequestinformationfromeachothertofindfactsforthecaseandtoseehowstrongtheargumentsareoneithersidethistermiscalledA、TaxonomiesB、GDPRCDiscoveryD、F

46、RCPE、EDRM答案：C58 .Afterareasonableefforthasbeenexpendedtoproduceadatamodelforaprojectwhichofthefollowingwouldbethemostusefultechniquetovalidatethatthedatamodelsupportstheprojectadequately?A、ChecktoseewhatentitieshavebeencreatedforotherprojectsB、ReviewthelegalimplicationsofthemodelC、ModeltheeffectthateventsinthebusinesshaveonthemodelD、PrototypetheapplicationE、All答案：C1.1 Indatahandlingethics,sociallicence,referstothealignmentbetweenA、stakeholderdemandsandtechnologydeliverablesB、society,sneedsandtheirrighttoaccessd