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
免费区 
