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

CDMP（基础级）数据管理专业认证备考试题库大全（含答案）1 .Dataqualityrulesandmeasurementresultsareexamplesof:A、operationalmetadataB、industrymetadataC、businessmetadataD、strategicmetadataE、technicalmetadata答案：C2 .GoalsandPrinciplesareoneofthesevenbasicEnvironmentElementsoftheFunctionalframeworkfordatagovernancethatincludesA、StrategicGals.Dependencies.AlternativeTechniques.ReportingStructures.B、jectives.C、VisionMission.BusinessBenefits.StrategicGals,andSpecificD、Inputsoutputs.CriticalSuccessFactors.UseCaseScenarios,andRecognizedBestPractices.E、All答案：C3 .Acommondriverfordatagovernanceis:A、RegulatorycomplianceB、TheappointmentofaCDOC、IrreconcilablefiguresinreportsD、OutsouringE、Internalaudits答案：A4 .Thequalityofdatawillbeimprovedby:A、World,sbestpracticesoftwaretoolsB、PeriodicdataqualityinitiativesthatleavethedatabetterthantheyfounditC、EstablishingaregimeofpenaltiesforpoordataqualityD、IdentifyinganddeletingalltheerroneousdataintheorganisationE、Amindsetthathelpsemployeesandstakeholderstoactwhilealwaysthinkingofthequalityofdata答案:E5 .Atermreferstounsolicitedcommercialemailmessagessentoutinbulkusuallytotensofmillionsofusersinhopesthatafewmayreply.thistermiscalledA、AdwareB、SpamC、SocialengineeringD、DMZE、threatB6.Dataarchitecturecomplianceratemeasures:A、HowfastthedatabasecanretrievedataB、HowcloselyprojectscomplywithestablisheddataarchitecturesC、HowcompleteanattributelistisinanentityD、HowcloselyprojectscomplywiththedevelopmentlifecycleE、Howcloselyprojectsaremeetingtheirtimelines答案：B7.1fyouhaveaBusinessIntelligenceorInformationManagementgroup,youcanneverdoenoughconnectingbetween()and()A、dataarchitects;DBAsB、strategicplanningorganizationinformationteleologyorganizationC、informationtechnology;therestofthebusinessD、technologyarchitect,sbusinessanalystsE、informationtechnology;businessanalysts答案:C8.Recordsaredefinedas()anorganizationbusinessactivitiesandregulatorycompliance.A、containersofB、storageofC、documentationofD、evidenceofE、fileof9.RegulatorydataretentionrequirementsdrivetheneedtokeepdataforsetperiodsforA、submittingdatasetstoregulatorsB、historicalreportingC、customeranalytics.D>legalobligations.E、alternatebackupsourcesD10.Common(databasesecuritymeasuresincludeallofthefollowingEXCEPTA、theuseofschemas.B、theuseofsub-schemasC、sniffersD、rowlevellockingE、firewallC11 .DatagovernancestakeholdersincludeallofthefollowingEXCEPTA、productconsumersB、regulatorycomplianceofficersC、financialmanagement.D>thoseoperationalintereststhatdriveefficiencyandeffectivenessE、all12 .Whatisthepurposeofaninformationvaluechainartifact?A、MapsrelationshipsbetweendataandprocessesB、Providesahigh-levelorientationviewofanenterpriseandhowitinteractswiththeoutsideworldC、ShowsalistofentitiesD、MapsthemovementofdataE、all答案：A13 .Slice,Dice,Roll-upandPivotaretermsusedinwhatkindofdataprocessing?A、OLAPB、OLTPC、EIEIOD、EDIE、ODSA14 .ReferencedataappearsinalltheseEXCEPTA、adatacontentmanagementtaglistB、athesaurusC、ETLcodeD、apicklist15 .TheacronymSOAstandsfor:A、ServiceOrientedArchitectureB、ServiceOrientedActuariesC、serviceOrientedAccuracyD、SystemOrientedArchitectureE、SystemOrientedAccuracyA16 .ProductionDBA,swouldnotnormallytakeresponsibilityfor:A、ImplementingmechanismsforclusteringandfailoverofthedatabaseB、ImplementingbackupandrecoverymechanismsC>ThefitnessofpurposefordatainthedatabaseD、Executingotherdatabasemaintenanceactivities,suchasarchivingE、EnsuringperformanceandreliabilityofthadatabaseC17 .AmajorfocusofthedatabaseadministrationOperationsfunctionisA、databaseintegrity.B、conceptualdataarchitectureC、datamanagementpoliciesD、constructionofdatabaseinquiriesE、databasesecurityA18 .ReasonstogoverndataarchitectureincludeallofthefollowingEXCEPTA、yourequireamatrixmapOfbusinessunitinteractionswithdataentitiesB、youneedtoknowwheredataisreportedallthetimeC、thecoredatamanagementprocessesofitdepartmentstouchonlyasmallpercentageoftheenterprisedataresourceD、youneedasubjectmodelthatdescribesthevariousdatadomainsE、allB19 .EveryenterpriseissubjecttomanygovernmentalandindustryregulationsmanyofwhichregulatehowdataandinformationisusedandmanagedpartofthedatagovernancefunctionA、MonitorandensurethatorganizationsmeetanyregulatorycompliancerequirementsB、Thisisaboutdata,datagovemmanceisaccountableforthewholeprocesswithRiskandauditreportingtodgC、Enforceenterprise-widemandatorycompliancetoregulationD、Performad-hocauditsofpossibleregulationstoreporttotheDGcouncilonaninformationonlybasisE、ThisisariskandauditresponsibilityDataGovernanceplaysnoroleinthis.A20 .TotreatDataGovernanceintheenterpriseasisamisconceptionA、achangeB、re-engineeringC、aframeworkD、AprojectE、AprogramD21 .AlineagedatatoolprovidesA、thecaptureandmaintenanceofsourcestructuresforeachattributeonthedatamodeB、 ancestorialoriginofdataDNAC、atemporaldistortionofdatavaluesacrosssystemsD、acleanlinebetweencolumnsinthesameentityE、scopeforreportingrequirements答案:B22 .ThekeyconceptsofthedatavaultareA、HubsJinksandsatellitesB、KeysJocksandcombinationsC、Facts,dimensionsandtimeD、Hubs9IinksandplanetsE、Facts9Iinksandsatellites答案：A23.IndatamodelingsubjectareasareusefulforA、groupingdataattributesbydatatypeB、organizingaprojectintophasesC>organizingamanagementpresentationonyourapplicationD>groupingentitiestomakemodelmanagementeasier.E、noneD24 .Apieceofsoftwarethatcantranslatemeta-datafromoneproductintothatofanotheriscalledameta-dataA、interfaceB、routerC、bridgeD、translatorE、all答案：D25 .MasterdatamanagementinorganizationsmaybepartofallofthefollowingEXCEPTA>anERPprogramB、abusinessprocessmanagementprogramC、avendor,sparticularsolutiontoinconsistentcorporatedataD、acustomerdataintegrationprogramE、anCRMprogram26 .Nonvalue-addedinformationisoftennotremovedbecauseA、wWemightneedtheinformationatalaterstageB、LegislationisunclearonwhatshouldbekeptC、Thepoliciesareunclearofwhatisdefinedasnon-value-added,storageischeapsothereisnocostdriver,andittakesmoreefforttodisposethantokeep.D、Dataisanasset.ltislikelytoberecognizedasvaluableinthefutureE、litshouldnotberemovedalldataisvalue-added答案:C27 .()and()aretwotechniquesthatmustbeappliedbypolicytoinformationtoeliminatebusinessriskoncedataisnolongerneededA、BackuprecoveryB、DeclassificationredactionC、 sanitization;recoveryD、Shredding;expungementE、Sanitization,recoveryDD、 .TheacronymBASEstandsfor:A、BasicallyAvailable,softState9EventualConsistencyB、BasicallyAvailable9StateEventualConsistencyc、BasicallyAvailableSoftConsistency9EventualStateD、Basicallyarticle,SoftConsistency9EventualStateE>BasicallyArticle9SoftConsistency,EventualStateA解析：BASE就是为了解决关系数据库强一致性引起的问题而引起的可用性降低而提出的解决方案。BASE其实是下面三个术语的缩写：基本可用(BasicallyAvailable)软状态(Softstate)最终一致(Eventuallyconsistent)29 .Validateusers,access.Whenausertriestologintoasystemthesystemneedstoverifythatthepersoniswhoheorsheclaimstobe.passwordsareonewayofdoingthisThisiscalledA、analysisB、replicationC、archivingD、AuthenticationE>threat答案:D30 .AdatawarehousebusmatrixrepresentsA、conformeddimensionsandtheirkeysB、anETLschemaC、businessprocessesandcommonfactsD、businessprocessesandcommondimensionsE、AlID31 .AtermreferstohowmalicioushackerstrytotrickpeopleintogivingthemeitherinformationoraccessthistermiscalledA、analysisB、HackingC、socialengineeringD、DMZE>threatC32 .ATermisaformofdataanalysisusedtoinspectdataandassessquality.thistermiscalledA、DataProfilingB、DataparsingC、DataModelingD、DataanalysisE、DataCleansing答案：A33.1 nformationqualitytrainingtopicsforbusinessinformation/datastewardsshouldincludeallofthefollowingEXCEPTA、systemsdevelopmentprinciples.B、rolesandresponsibilities.C、datasecurityandprivacyD、informationvaluechainE、All答案：A33.2 hatisthedifferencebetweencardinalityrulesanddataintegrityrules?A、Referentialintegrityrulesquantifytherelationshipsbetweentwoormoreentitiesandcardinalityrulesquantfythecommonattributesacrossentities.B、Referentialintegrityrulesdefinethequantityofeachentityinstancethatcanparticipateinarelationshipbetweentwoentitiesandcardinalityrulesensurevalidvalues.andreferentialintegrityC、Thereisnodifference.Cardinalityrulesrulesaresynonyms.ofeachentityinstancethatcanD、Cardinalityrulesdefinethequantityparticipateinarelationshipbetweentwoentitiesandreferentialintegrityrulesensurevalidvalues.E、ReferentialintegrityrulesonlyappearonarelationaldatamodelandcardinalityrulesonlyappearonadimensionaldatamodelD35.5 copeandprioritiesmanagementinadatagovernanceprogramisaprocessofA、proactivechangemanagementB、respondingtochangesinthebusinessenvironmentthatareoftenunanticipatedC、respondingtorapidshiftsinstakeholdersandstakeholderinterests.D、predictingvolatilebusinessenvironmentswhilemaintainingstaticdataE、none答案：D36 .TheroleoftheConceptualdatamodelinthemetadatarepositoryisA、tosummariesthekeydatasubjectareasforabusinessareaatahighlevelofabstractiontoenablethemajordataconceptstobeunderstoodB>toagreethecardinalityandoptionalityofrelationshipsbetweenallentitiesC、alloftheseD、NoneofthetheseE、todeterminetheprimaryalternateandforeignkeysofentities答案A37 .Thebestwaytovalidatethatadatabasebackupisworking,istoA、checkthesizeofthebackupfile.B、appointaspecialDBAinchargeofbackupsC、checkthebackuplogseveryday.D、periodicallyrecoverfromthebackupfileE、checkfortheautomaticemailnotificationofbackupsuccessD38.whoismostresponsibleforcommunicatingandpromotingawarenessonthevalueofDataGovernanceintheorganization?A、DataChampionsB、ThedatagovernanceofficeC、EveryoneintheDataManagementCommunityD、DataOwnersstewardsE、ThedatagovernancecouncilC39 .TheprocessaspectofDataGovernanceincludesallofthefollowingEXCEPTA、policiesB、rules.C、accessprivilegesD、procedures40 .Atermisaprogrambuilttoreproduceandspreadacrossanetworkbyitself.ThistermiscalledA、AdwareB、computerwormC、socialengineeringD、DMZE、threat答案:B41 .ThefollowingaredeliverablesinadatagovernanceprogramEXCEPTA、themetricsfbrdataqualityscorecardB、datainputcontrolsC、indexingofdatamanagementtechniquesD、meta-datastandards.E、Datastrategy答案:B42 .Electronicdatainterchange(EDI)throughXMLtypicallyinvolveseachofthefollowingEXCEPTA、customerstransactions.B、areductionofpaperflowC、contractsbetweentradingpartnersD、transactionconvertersE、All答案：A43 .A1ContentDistributionNetwork,supportingamulti-nationalwebsiteislikelytouseA、anextracttransformandloadsolutionB、arecordsdisposalsolutionC、areplicationsolutionD、adatabasebackupandrestoresolutionE、anarchivingsolution答案:C44 .WhichofthefollowingisNOTastageintheShewhart/DemingCyclethatdrivesthedataqualityimprovementlifecycleA、PlanB、CheckC、DoD、InvestigateE、Act答案：D45 .Themetadatastructureforacontentmanagementsystemcanberepresentedwitha:A、ProcessmodelB、MindmapC、AuthorizationmatrixD、DatamodelE、CRUDmatrix答案:B46 .Followingtherolloutofadataissueprocess,therehavebeennoissuesrecordedinthefirstmonth.Thereasonforthismightbe:A、LackofcredibilityinthedatagovernanceprocesstoaffectchangesB、StaffstayingbacklatetoentertheissuesintothesystemC、theautomaticdeletionofallissuesinthedatabase.D、Therearenodataissuesintheenterprise.E、ThedenialofovertimerequestsA47 .whichofthefollowingBESTdescribestheroleofadataintermediary?A、SomeonewhodecideswhatdataisimportanttothebusinessB、Someonewhoisresponsibleformanagingthemeta-datarepositoryC、someonewhoreceivesdatainoneformandtranscribesitintoanotherforD、SomeonewhoisresponsiblefortranslatingbusinessrequirementsintoadatabasedesignE、All答案：C48 .DuringplanningstageofadatamodelwhichofthefollowingisnotavalidschemaA、Fact-basedB、RelationalC、DenormalisedD、NoSQLE、DimensionalC49 .ThegovernanceteamplaysapivotalroleinensuringtheareselectedA、definedrolesB、policiesandproceduresC、ROlfiguresD、rightprojectsE、allD50 .SignificantoperationalissueshavebeencausedbytheimplementationofadatamodelthatrepresentsaCustomerAgreementasaternieraryrelationshipbetweentheEnterpriserCustomer,andtheirContactPerson.Whichofthefollowingdescribesthelikelyoperationalissue?A、IntheeventofamergerbetweenenterprisesthecontactpersonaddressesneedtobeupdatedB、EverytimetheCustomerAgreementwasrenewedanewContactPersonrecordwasrequiredC、EverytimethecustomerchangesaddressestheaddressforthecontactpersonmustchangeaswellD、ResponsetimeforretrievingtheCustomeragreementdegradesrapidlyduetothelackofindexing.E、Everytimethecontactpersonchanges,thecustomeragreementneedstobere-establishedE51 .Whenassessingtoolstoimplementmasterdatamanagementsolutions,functionalitymustincludeA、documentandcontentmanagement.B、advancedanalyticscapabilitiesC、auto-normalizationfeaturesD、backupandrecoveryutilities.E、sophisticatedintegrationcapability.E52 .Atermistypeofcontrolledvocabularyusedforcontentretrieval.Itcombinescharacteristicsofsynonymlistsandtaxonomies.thistermiscalledA、TaxonomiesB、DataMapC、OntologyD、thesaurusE、Records答案：D53 .whichoftheseisNOTastandardmotivationfordatagovernanceA、DevolvedgovernanceB、DecentralizedGovernanceC、Pre-emptivegovernanceD、ProactivegovernanceE、Reactivegovernance答案:A54 .InformationlifecycleelementsincludeallofthefollowingEXCEPTA、create/receiveB、distribute/useldispose.C、maintain/preserveD>assiate/modelE、none答案：D55 .Adatalineagetoolenablesauserto:A、trackthedatafromsourcesystemtoatargetdatabaseunderstandingitstransformationsB、visualizehowthedatagetstothedatalakeC、trackthehistoricalchangestoadatavalueD、lineupthedatatosupportsophisticatedglossarymanagementE>enablesrapiddevelopmentofdashboardreportingA1.1 InformationgovernanceanddatagovernanceshouldbeA、managedbythechiefInformationOfficerB、managedasasinglefunctionC、managedasintegratedfunctions,withinformationgovernancereportingtodatagovernanceD、managedasintegratedfunctionswithdatagovernancereportingtoinformationgovernanceE、managedasseparatefunctions.答案：E57 .Alegaltermisalegaltermthatreferstopre-rialphaseofalawsuitwherebothpartiesrequestinformationfromeachothertofindfactsforthecaseandtoseehowstrongtheargumentsareoneithersidethistermiscalledA、TaxonomiesB、GDPRC>DiscoveryD、FRCPE、EDRM答案：C58 .Afterareasonableefforthasbeenexpendedtoproduceadatamodelforaprojectwhichofthefollowingwouldbethemostusefultechniquetovalidatethatthedatamodelsupportstheprojectadequately?A、ChecktoseewhatentitieshavebeencreatedforotherprojectsB、ReviewthelegalimplicationsofthemodelC、ModeltheeffectthateventsinthebusinesshaveonthemodelD、PrototypetheapplicationE、All答案：C1.1 Indatahandlingethics,sociallicence,referstothealignmentbetweenA、stakeholderdemandsandtechnologydeliverablesB、society,sneedsandtheirrighttoaccessd