CDMP-Associate基礎(chǔ)級歷年考試真題試題庫（含答案）

CDMP-Associate基礎(chǔ)級歷年考試真題試題庫（含答案）1.DataStewardsaremostlikelytoberesponsiblefor：A、DataGovernanceandDataQualityB、DataIntegrationandInteroperabilityC、DataStorageandOperationsD、DataModellingandDataSecurityE、ContentandDocumentManagement答案：A2.ThenumberofartefactsthatmustbesearchedintheMetadatarepositoryforallBusinesschangeprojectsareA、TheBusinessDataGlossarySystemsInventorymustbeconsultedB、ConceptualdatamodelsandtheBusinessDataGlossarymustbeexaminedC、ThereisnomandatorynumberofartefactstobesearchedbutitishighlyrecommendedthatthelibraryisexaminedD、Conceptual,LogicalandPhysicalmodelsmustbeexaminedE、TheBusinessDataGlossaryDataDictionarymustbeexamined答案：C解析：不同的情況，肯定要搜索不同的制品，這個是按業(yè)務(wù)需求定義的，而非固定的3.TheDMBok'EnvironmentalFactorshexagon'showstherelationshipbetween:A、Inputs,activitiesanddeliverablesB、Business,applicationandtechnologyarchitectureC、People,softwareandtoolsD、People,processandtechnologyE、DMBokknowledgeareas答案：D解析：人、流程、技術(shù)4.AccountabilityinDataGovernanceprogramsA、AllB、IsseparatedfromauthorityrolesC、CanbedelegatedD、IsassignedtoteamsE、Cannotbedelegated答案：E5.DataarchitectureforgovernancepurposesneedsallofthefollowingEXCEPTA、SubjectmodelthatdescribesthevariousdatadomainsB、LogicalmodelsthatdescribebusinessviewsofthedataC、ImplementationmapsshowingwhereentitydataresidesphysicallyD、DirectaccesstoalldatasourcesE、All答案：E6.TheISOMetadataRegistryStandardthatprovidesaframeworkfordefiningametadataregistryis:A、ISO4590B、ISO9001C、ISOMD1D、ISO/IEC11179E、ISO4-20-99答案：D7.Initsbroadestcontext,thedatawarehouseincludes:A、DatastoresandextractsthatcanbetransformedintostarschemasB、EitheranInmonorKimballapproachC、AnydatastoresorextractsusedtosupportthedeliveryforBIpurposesD、AllthedataintheenterpriseE、Anintegrateddatastore,ETLlogic,andextensivedatacleansingroutines答案：C解析：這章考的是數(shù)據(jù)與商業(yè)智能這一章節(jié)，直接考概念，P553，我截取出來如下：大家可能會有疑問，那為什么“Anintegrateddatastore,ETLlogic,andextensivedatacleansingroutines”不行呢，內(nèi)容其實(shí)沒有太多問題的，只是因?yàn)榭荚嚲褪强荚?，所以不是最合適而已8.DatagovernancepolicyalignmentintheprivatesectorbeginswithallofthefollowingEXCEPTA、Understandregulationsthatdrivepolicy.B、AllC、EstablishingcontrolsnecessarytoassurecomplianceD、Understandgoalsandpurposeofeachpolicy.E、Identifydatamanagementpolicies答案：C9.Acomparativelynewarchitecturalapproachiswherevolatiledataisprovisionedinadatawarehousestructuretoprovidetransactionalsystemswithacombinationofhistoricalandnearrealtimedatatomeetcustomerneeds.Thisisadefinitionof:A、OperationalDataStoreB、OnLineAnalyticalProcessingCubeC、OnLineTransactionalProcessingSystemD、BehaviouralDecisionSupportSystemsE、ActiveDataWarehousing答案：E解析：這題是超綱的內(nèi)容，叫動態(tài)數(shù)據(jù)倉庫，其實(shí)就是我們平時聽到的“實(shí)時數(shù)倉”，如用FLINK（實(shí)時數(shù)據(jù)數(shù)據(jù)處理技術(shù)）+KUDU（實(shí)時存儲技術(shù)）/DataLake（數(shù)據(jù)湖）搭建的LakeHouse（湖倉一體）。而傳統(tǒng)的數(shù)倉一般是T+1的分析模式，當(dāng)天的數(shù)據(jù)，需要明天才能給出分析結(jié)果，而不是給出實(shí)時的結(jié)果。實(shí)時數(shù)據(jù)處理技術(shù)，在互聯(lián)網(wǎng)應(yīng)用是很廣泛，如今日頭條，需求是實(shí)時分析讀者喜歡什么新聞，便推送什么新聞給讀者。而這些實(shí)時數(shù)據(jù)的采集，一般用CDC的模式進(jìn)行采集（當(dāng)然也可以是源系統(tǒng)雙寫兩份數(shù)據(jù)）

考題總是有延后性，所以這里特意標(biāo)注及解釋一下。10.Theprocessofidentifyinghowdifferentrecordsmayrelatetoasingleentityiscalled:A、MirroringB、MatchingC、MungingD、ManglingE、Meshing答案：B11.Thekeyconceptsofthedatavaultare:A、Hubs,linksandsatellitesB、Facts,dimensionsandtimeC、Facts,linksandsatellitesD、Hubs,linksandplanetsE、Keys,locksandcombinations答案：A12.WhichoftheseisNOTatypeofkeyfoundinadatamodelA、SurrogatekeyB、LocalkeyC、ForeignkeyD、PrimarykeyE、Alternatekey答案：B解析：沒有LocalKey13.PeriodicarchivingoftransactiondatafromaproductionCRMsystemiscriticalfor：A、ManagingdeletedcustomerrecordsB、ProvidingalternatesourcesforreportingsystemsC、TrainingjuniorDBAsD、EnablingthedistributionoftransactiondataacrosstheenterpriseE、Themaintenanceofdatabaseperformance答案：E解析：見P58014.Whenassessingtoolstoimplementmasterdatamanagementsolutions,functionalitymustinclude:A、Auto-normalizationfeaturesB、AdvancedanalyticscapabilitiesC、DocumentandcontentmanagementD、BackupandrecoveryutilitiesE、Sophisticatedintegrationcapability答案：E解析：該題并不是考主數(shù)據(jù)管理本身，而是在考多個主數(shù)據(jù)源的情況下，如何集成。四種主數(shù)據(jù)模式，見下面“圖二”（圖一）（圖二）15.HowdoesDataSecuritycontributetocompetitiveadvantage?A、DataSecuritymakesyourcompetitorsinvestmoreeffortintotryingtofindoutyourtradesecretsB、DataSecurityhelpstoprotectproprietaryinformationandintellectualproperty,aswellascustomerandpartnerinformationC、DataSecuritymakesitharderforyourcompetitorstofindoutaboutwhoyoudobusinesswithD、GovernmentsdonotalloworganisationstotradeiftheydonotmanageDataSecurityE、Stopsorganisationsgoingoutofbusinessduetoaninformationleak答案：B解析：B類型題，這一段話是屬于數(shù)據(jù)安全大章節(jié)的內(nèi)容，所以答案選擇：DataSecurityhelpstoprotectproprietaryinformationandintellectualproperty,aswellascustomerandpartnerinformation16.Whichofthefollowingisnotapreventativeactionforcreatinghighqualitydata?A、InstituteformaldatachangecontrolB、ImplementdatagovernanceandstewardshipC、EstablishdataentrycontrolsD、TraindataproducersE、Automatedcorrectionalgorithmscapableofdetectingandcorrectingerrors答案：E17.Whichofthefollowingisnotagoalofdatamanagement？A、Preventingunauthorizedaccess,manipulationoruseofdataandinformationB、Capturing,storing,protectingandensuringtheintegrityofdataassetsC、EnsuringthequalityofdataandinformationD、UnderstandingtheprocessneedsoftheenterpriseE、Ensuringtheprivacyandconfidentialityofstakeholderdata答案：D18.ThefollowingarealldatawarehousingandbusinessintelligencetoolsEXCEPTA、DatabasemanagementsystemsB、Datasecuritydevices.C、Volumetricmeasures.D、NoneE、Performancemanagementworkbenches答案：C19.WhichofthefollowingservicesistypicallyNOTprovidedbyDatabaseAdministrationOperations？A、ImplementingdatastandardsB、ValidatingtransactiondataC、ValidatingdatamodelsD、PlanningfordatadistributionE、All答案：B20.TheacronymPDCAstandsforwhatqualityimprovementprocess？A、Pan-Do-Check-ActB、Project-Derivation-Completeness-ActionC、Plan-Deploy-Check-ActD、Process-Definition-Clarity-AccessibilityE、Precision-Data-Control-Accuracy答案：C21.ACRUDmatrixhelpsorganisationsmapresponsibilitiesfordatachangesinthebusinessprocessworkflow.CRUDstandsforA、Cost,Revenue,Uplift,DepreciateB、Create,Review,Use,DestroyC、Confidential,Restricted,Unclassified,DestroyD、Create,Read,Update,DeleteE、Create,React,Utilise,Delegate答案：D解析：CRUD矩陣就是記錄了哪個角色有創(chuàng)建、讀取、更新、刪除的權(quán)限，見書本：P380矩陣的內(nèi)容是可以變的，最常見的是：流程與角色矩陣，功能與角色矩陣等。我從網(wǎng)上找來了一個截圖，協(xié)助大家理解：22.TheDataGovernanceSteeringCommitteeisbestdescribedas：A、Thecommunityofinterest,focusedonspecificsubjectareasorprojectsB、AburdentotheagiledeliveryinamodernenterpriseC、Thelocalordivisionalcouncil,workingunderauspicesoftheCDOD、TherepresentativesofdatauseonprojectsteeringcommitteesE、Theprimaryandhighestauthorityresponsiblefortheoversightandsupportofdatagovernanceactivities答案：E23.Whereisthebestplacetofindthefollowingmetadata:databasetablenames,columnnamesandindexes?A、DetailedbusinessprocessesB、LogicaldatamodelC、DatabasecatalogueD、EnterprisedatamodelE、Securityaccessauthorization答案：C解析：數(shù)據(jù)庫目錄，顯然是放置“數(shù)據(jù)庫表名、列名和索引”等信息的元數(shù)據(jù)的最佳位置24.AtypeofMasterdataarchitectureisA、VirtualisedB、AlloftheseC、HybridD、RegistryE、Repository答案：B解析：這題的答案是全選，但實(shí)話說，DAMA的定義跟世界主流的定義不一致，少了一種主數(shù)據(jù)的模式。DAMA教科書上主數(shù)據(jù)模式的定義有三種，請見：P532回到大家常見的主數(shù)據(jù)模式，業(yè)界主流的四種模式分別是：該部分內(nèi)容說起來較復(fù)雜，我另開視頻專題講吧。值得一提的是，業(yè)界一般會把Virtualised和Registry兩種模式認(rèn)為是同一種。25.OneimplementationformasterdatathatservesasthehubforallreferenceandmasterdataforallOnlineTransactionalProcessing（OLTP）applicationsistheA、DatabusB、OperationalDataStore（ODS）C、NoneD、MessagingsystemE、Federateddatabase.答案：B26.DatasecuritypoliciesincludeallofthefollowingEXCEPTA、Role-basedupdateB、Role-baseddeleteC、Role-basedaccess.D、DataqualityrequirementsE、Dataclassification答案：D27.DataarchitecturerelatesinformationneedsandbusinessfunctionsoftheenterprisethroughA、ThemastersetofmodelsandrequirementsB、AllC、BusinessprojectsanddatabasesD、BusinessrequirementsandinformationconsumersE、Meta-datarepositoriesand答案：A28.WhichofthefollowingisNOTrequiredtoeffectivelytrackdataqualityincidents?A、Awelldefinedsystemofescalationbasedontheimpact,durationorurgencyofanissueB、AneffectiveservicelevelagreementwithdefinedrewardsandpenaltiesC、AnoperationalworkflowthatensureseffectiveresolutionD、AstandardvocabularyforclassifyingdataqualityissuesE、Anassignmentprocesstoappropriateindividualsandteams答案：B29.Adatamodelthatconsistsofasinglefacttablelinkedtoimportantconceptsofthebusinessisa:A、RelationalModelB、MachineLearningModelC、ProcessModelD、DimensionalModelE、TransitionStateModel答案：D30.Topreasonscitedforworkingaroundexistingdatagroupsinorganizationsincludeallofthefollowing_______EXCEPTA、ToodifficulttoworkwithB、UnknowntothebusinessstakeholdersC、PerceivedtobetooslowD、UnknownvalueprovidedbythedatagroupE、Noanswer答案：E31.Whichoneofthefollowingstatementsistrue?A、MasterDataManagementrequirestechniquesforsplittingormerginganinstanceofabusinessentity.B、Managingreferencedatarequiresthesameactivitiesandtechniquesasdoesmanagingmasterdata.C、ReferenceDataManagementinvolvesidentifyingthebestorgoldenrecordforeachdomain.D、Businessdatastewardsmaintainlistsofvaliddatavaluesformasterdatainstances.E、MasterDataManagementinvolvesidentifyingandmaintainingapprovedcodedvalues答案：A解析：其余答案：Businessdatastewardsmaintainlistsofvaliddatavaluesformasterdatainstances.：應(yīng)該是數(shù)據(jù)管理員與業(yè)務(wù)人員協(xié)作維護(hù)，而不是只由“業(yè)務(wù)數(shù)據(jù)管理員”維護(hù)Managingreferencedatarequiresthesameactivitiesandtechniquesasdoesmanagingmasterdata.：還是有些不一樣的，見P504MasterDataManagementinvolvesidentifyingandmaintainingapprovedcodedvalues：管理碼值，應(yīng)該是參考數(shù)據(jù)的事ReferenceDataManagementinvolvesidentifyingthebestorgoldenrecordforeachdomain.：黃金記錄應(yīng)該是主數(shù)據(jù)的事32.Anindustrydatamodelisusedto:A、DeriveindustryprocessmodelsB、ReducethedataintegrationrequirementacrossanindustryC、ConfirmthecorrectnessofadatamodelD、QuicklyestablishacommonvocabularytoaidtheintegrationofdisparatesystemsE、Replacetheneedforexperienceddatamodelers答案：B解析：其實(shí)在建模的章節(jié)，行業(yè)數(shù)據(jù)模型用于減少開發(fā)時的工作量，不需要從零開始建立模型，提供更多的參考。在本題中，最相近的答案只有“Reducethedataintegrationrequirementacrossanindustry”33.BadhabitsofdatanaminganddefinitionmustincludeallofthefollowingEXCEPTA、AdoptinginformalabbreviationsB、UsinglocallyunavailabledefinitionsC、AllD、UsingrecognizableabbreviationpatternsthatarenotstandardizedE、Capturingcompletedefinitionbutwithnosizelimit.答案：E34.Whichofthefollowingisnotagoalofdatamanagement？A、EnsuringtheprivacyandconfidentialityofstakeholderdataB、Capturing,storing,protectingandensuringtheintegrityofdataassetsC、UnderstandingtheprocessneedsoftheenterpriseD、Preventingunauthorizedaccess,manipulationoruseofdataandinformationE、Ensuringthequalityofdataandinformation答案：C35.DatasecurityregulationsarecriticaltoreviewA、WhenimplementinganynewsystemB、Onlywhencreatingnewreports.C、AllD、WhenarchivingE、Onlywhenexportingnewdata答案：C36.DatagovernancestakeholdersincludeallofthefollowingEXCEPTA、RegulatorycomplianceofficersB、ThoseoperationalintereststhatdriveefficiencyandeffectivenessC、Financialmanagement.D、ProductconsumersE、All答案：D37.TheessenceofdataprivacyinitiativesincludeallofthefollowingEXCEPTA、IntegrityB、UseC、DisclosureD、CollectionE、Noanswer答案：E38.ThefactthatinformationsystemsoftendoNOTaddressthecriticalproblemsofabusinessasawholeismostlikelyanindicationoftheneedforimprovedA、InformationsystemsarchitectureB、InformationsystemsplanningC、ServiceorientedmethodologiesD、EnterpriseServiceBusE、Databasemanagementsystems答案：B39.WhichofthesestatementsaretrueofaMetadatarepository?A、DatamodelsarecomponentsofaMetadatarepository.B、Itisalwaysdecentralised.C、NoneofthetheseD、Itisalwayscentralised.E、Itisalwaysahybridarchitecture.答案：A解析：在書中P621，描述了元數(shù)據(jù)存儲庫架構(gòu)有四種，集中式的，非集中式的（分式布式），混合的，雙向的，而這些架構(gòu)都是按需選擇的，所以“Itisalwaysahybridarchitecture.”、“Itisalwaysdecentralised.”、“Itisalwayscentralised.”這三個都不正確。

至于“DatamodelsarecomponentsofaMetadatarepository.”，數(shù)據(jù)模型的確是元數(shù)據(jù)存儲庫的內(nèi)容之一，大家也不要去追究這個選項講得不完整，DAMA的題都一樣，但至少比其它幾個選項要好，至少沒錯。40.TheMetadatarepositoryenablesustoestablishmultipleperspectivesofdata.Theseare:A、InternalandexternalB、TheBusinessandTechnicalPerspectiveC、Dimensionalandnon-dimensionalperspectiveD、3rdnormalformandun-normalisedE、Structuredandunstructured答案：B解析：三種主要元數(shù)據(jù)類型，業(yè)務(wù)元數(shù)據(jù)，技術(shù)元數(shù)據(jù)，操作元數(shù)據(jù)。41.Tocontinuallyimprovethequalityofdataandinformationanorganizationmustconsiderwhichoneofthefollowing？A、Theclarityandsharedacceptanceofdatadefinitions.B、MaximizetheeffectiveuseandvalueofdataandinformationassetsC、Controlthecostofdatamanagement.D、UnderstandtheinformationneedsoftheenterpriseanditsstakeholdersE、All答案：A42._________governanceconsistsofaddressingacurrentcriticalissueA、PerformanceB、CentralC、Pre-emptiveD、ProtectiveE、Reactive答案：E43.Asearchenginedatabaseispopulatedbyawebcrawlerorspidersoftwarethatusuallyprocessesas:A、Linearlyindependent,nearexact(LINE)B、Fundamentallyavailable,consistentlytrue(FACT)C、Atomic,consistent,isolated,durable(ACID)D、Basicallyavailable,softstate,eventually,consistent(BASE)E、Continuallyrepeating,alwaysperforming(CRAP)答案：D解析：ACID和BASE是兩個對立體，BASE強(qiáng)調(diào)擴(kuò)展，更適合互聯(lián)網(wǎng)見P27344.Agoalof'DocumentandContentManagement'istoensureeffectiveandefficientretrievalanduseof:A、data,butnotinformationinunstructuredformats.B、information,butnotdatainunstructuredformats.C、Dataandinformationinstructuredformats.D、Dataandinformationinunstructuredformats.E、Dataandinformationinrelationalformats.答案：D解析：文件是非結(jié)構(gòu)化數(shù)據(jù)45.InDimensionaldatamodels,whichoftheseisNOTtrueregardingMeasuresA、MeasuresarefoundinFacttablesB、CaremustbetakenifameasureisasnapshotfigureC、MeasurescanalwaysbeaddedacrossalldimensionsD、MeasuresshouldbenumericandadditiveE、Justbecauseavalueisnumericaldoesnotmeanitisameasure答案：C解析：該題考的是維度建模，稍后我做個完整的視頻解釋，這里稍作簡述。Measurescanalwaysbeaddedacrossalldimensions：中的維度表，某種意義上來說，跟參考數(shù)據(jù)是同義的，如地區(qū)維表，這里表是不能累加的，也不含指標(biāo)相關(guān)的內(nèi)容的，也不能單獨(dú)使用，必須和事實(shí)表關(guān)聯(lián)才能使用的。MeasuresarefoundinFacttables：事實(shí)表就是記錄過程數(shù)據(jù)的，如訂單數(shù)據(jù)，所以是可以找到指標(biāo)相關(guān)的信息的Caremustbetakenifameasureisasnapshotfigure：這種中性描述，沒錯，雖然沒把原因?qū)懗鰜硎Ｏ聝蓚€答案：指標(biāo)是累加的數(shù)值（請參閱《華為數(shù)據(jù)之道》）46.Inadatawarehouse,wheretheclassificationlistsfororganizationtypeareinconsistentindifferentsourcesystemsthereisanindicationthatthereisalackoffocusonA、ReferencedataB、MetadataManagementC、DataModellingD、DataStorageE、Masterdata答案：A解析：組織架構(gòu)屬參考數(shù)據(jù)在DAMA中，若見到分類這種詞語，一般就指參考數(shù)據(jù)47.DatagovernancediffersfromitgovernanceinthatA、Seriousproblemscanoccurintheprojectcycle,andafteroperationalizedversusupfrontfeaturesanalysisanddesignintechnologyprojectsB、YoubuyanddeploysolutionsatincreasinglevelsofspecificationthroughtheprojectC、Seriousproblemscanbediscoveredatanyleveloftheorganizationversustop-downidentificationofrisksandissuesintechnologyD、NosinglegrouphascontrolofdataasitflowsthroughouttheorganizationversussingleownerassignmentoftechnologyE、None答案：D解析：該題用排除法，除了所選答案外，其余均是IT治理內(nèi)容，與數(shù)據(jù)治理無關(guān)，題目是讓我們選擇數(shù)據(jù)治理的解釋48.AdataownerhasresponsibilityandauthorityforA、AllB、Quality,access,distributionandbusinessdefinitions.C、BusinessdefinitionsanddatasecuritymanagementD、Regulationspolicies,knowledgeofdataprivacylaws,businessrulesandbusinessobjectivesE、Distributionsandretentionofdata答案：B49.Thedeliverablesforadatamodellingprocessdoesnothavetoinclude:A、LineagedescribingwherethedatacamefromB、IssuesandoutstandingquestionsC、OneormorediagramsD、ThestepsinthebusinessprocessthatusethedataE、Definitionsforentities,attributesandrelationships答案：D解析：Thestepsinthebusinessprocessthatusethedata：應(yīng)該是業(yè)務(wù)架構(gòu)要交付的內(nèi)容50.Forbusinessintelligence,businessdatastewardshelpwithallofthefollowingEXCEPTA、DataqualityMetricsB、BIrequirementsC、BIissueD、ManagementmetricsE、Dimensionalmodeldevelopment答案：E51.Whatarerelationshiplabels?A、Arelationshipwithoutcardinality.B、Theverbphrasesdescribingthebusinessrulesineachdirectionbetweentwoentities.C、Aforeignkeythathasbeenrole-named.D、Thenullabilitysettingonaforeignkey.E、Anon-identifyingrelationship.答案：B解析：請P202，relationship，指兩個實(shí)體之間的關(guān)聯(lián)關(guān)系。52.Adatalineagetoolenablesauserto:A、Enablesrapiddevelopmentofdashboardreporting.B、Lineupthedatatosupportsophisticatedglossarymanagement.C、Visualisehowthedatagetstothedatalake.D、Trackthedatafromsourcesystemtoatargetdatabase;understandingitstransformations.E、Trackthehistoricalchangestoadatavalue.答案：D解析：請見P245，書上的定義：53.De-identifyingsensitivedatainadatawarehouseenables：A、CertaintyofcompletedatasetsforinterrogationB、AbypassintheneedtoassessdataqualityC、AreducedcomplexityinthedatamodelsD、IncreasedutilizationwithoutcompromisingdataprivacyE、Afocusonre-identifyingrecordswith3rdpartydatasets答案：D解析：見P330~P331，從書上可知，增加數(shù)據(jù)安全的能力，將降低效率；該題難點(diǎn)在于“在不泄露數(shù)據(jù)隱私的情況下提高利用率”，如何達(dá)成。因除了敏感數(shù)據(jù)單獨(dú)管理外，還可以用物理隔離，賬號體系等諸多手段保障安全。54.AdatawarehousedeploymentwithmultipleETL,storageandqueryingtoolsoftensuffersduetothelackof:A、CommondatatypesinthesourcedatasetsB、QualitydatamodelersC、DiskspaceonthebigdataplatformD、IntegrationofthedictionariestoachievecommonunderstandingE、Conflictbetweensoftwarevendors答案：D解析：只有答案：“Integrationofthedictionariestoachievecommonunderstanding”相對靠譜55.AstrongargumentforpursuingaReferenceDataand/orMasterDatamanagementinitiativeis:A、TheyareessentialfunctionsinthedatamanagementframeworkB、BycentralizingthemanagementofReferenceandMasterdata,theorganizationcanconformcriticaldataneededforanalysisC、JobsecurityforthedatapeopleD、ItwillnotrequirealotofeffortE、Itwillnotrequirealotoftime答案：B解析：主數(shù)據(jù)及參考數(shù)據(jù)，就是保證各實(shí)體或關(guān)鍵數(shù)據(jù)的唯一性，也就是使全企業(yè)的關(guān)鍵數(shù)據(jù)保持一致，如：客戶、門店、會員等。56.ThestarschemaisA、BuiltonacentraldimensiontableandasetoffacttableB、Basedondimensionssuchas'customer'and'product'C、AllD、AcommondatamodelfordatawarehouseapplicationsE、Veryefficientfortransactionprocessing答案：D57.De-identifyingsensitivedatainadatawarehouseenables：A、CertaintyofcompletedatasetsforinterrogationB、IncreasedutilizationwithoutcompromisingdataprivacyC、AbypassintheneedtoassessdataqualityD、AreducedcomplexityinthedatamodelsE、Afocusonre-identifyingrecordswith3rdpartydatasets答案：B解析：見P330~P331，從書上可知，增加數(shù)據(jù)安全的能力，將降低效率；該題難點(diǎn)在于“在不泄露數(shù)據(jù)隱私的情況下提高利用率”，如何達(dá)成。因除了敏感數(shù)據(jù)單獨(dú)管理外，還可以用物理隔離，賬號體系等諸多手段保障安全。58.DataManagementprinciplesincludeeachofthefollowingEXCEPTA、AllB、ThattimemustbesetasideforInformationSystemsservicesC、TheconceptthatendusersaretheownersofthedataD、TherealizationthatNOTeverytechnologyinvestmentwillmakemoneyE、Acommitmenttotheintegrationofbusinessandtechnologygoalandstrategies答案：D59.Informationgaps-thedifferencebetweenwhatinformationisneededandwhatevertrustworthyinformationiscurrentlyavailable-representA、BusinessassetsB、InadequateinformationC、BusinessliabilitiesD、Lostrevues答案：B60.StakeholderswhoseconcernsmustbeaddressedindatasecuritymanagementincludeA、AlloftheseB、Clients,Patients,Citizens,Suppliers,orBusinessPartnersC、Mediaanalysts,InternalRiskManagement,Suppliers,orRegulatorsD、TheInternalAuditandRiskcommitteesoftheorganisationE、ExternalStandardsorganisations,Regulators,ortheMedia答案：B解析：該題考的是在數(shù)據(jù)安全中，利益相關(guān)方的定義，見P326，我截圖如下：61.Howdodatamanagementprofessionalsmaintaincommitmentofkeystakeholderstothedatamanagementinitiative?A、ContinuouscommunicationeducationpromotionoftheimportanceandvalueofdataandinformationassetsB、Relyonthestakeholdergrouptobeself-sustainingC、FindanddeliverbenefitstothestakeholdersearlyintheinitiativeD、Itisnotnecessary,asthestakeholderssignedupatthebeginningoftheprogramE、Weeklyemailreportsshowingmetricsondatamanagementprogress/lackthereof答案：A解析：這題不能直接在書上面找到答案，其實(shí)數(shù)據(jù)這塊內(nèi)容比較技術(shù)，很多業(yè)務(wù)部門其實(shí)很難理解為什么要搞治理，為什么要做這么多事，數(shù)不準(zhǔn)了就天天投訴好了（其實(shí)很多CEO、CIO也沒概念），因?yàn)樵跇I(yè)務(wù)部門的心目就只有一個理念：我想即時看到某某指標(biāo)，至于后面的事，他們是不會管的。所以，必須要數(shù)據(jù)治理專家不停地在他們耳邊吹風(fēng)，教育，潛移默化改變他們。同時在吹風(fēng)的過程中，還要考慮到組織文化及流程的等的個性化問題（CDMA有一題就是考這個），才能建立較好的數(shù)據(jù)治理框架。62.WhendevelopingadatagovernancescorecardA、Develophighlevelmeasuresonly：itisastrategicinitiativeB、LinkeverymetrictoadimensionqualityC、DevelopmeasuresthatrollupD、AssignownershipofthemeasurestructureE、None答案：C63.Thesearchfunctionassociatedwithadocumentmanagementstoreisfailingtoreturnknownartefacts.Thisisduetoafailureof：A、DataprivacyandconfidentialityproceduresB、MaintainingappropriatemetadataoneachdocumentC、BusinessintelligenceimplementationD、MaintainingpublicaccesstoalldocumentsinthedocumentmanagementstoreE、Effectivedataqualitymetrics答案：B解析：見P46564.Anenterprisedatamodelwouldbecomposedof：A、Conceptualmodels,subjectareamodelsandlogicalmodelsB、Conceptualmodels,starschemamodelsandinterfacemodels.C、Enterprisemodels,datamodelsandcompositionalmodelsD、Conceptualmodels,logicalmodelsandphysicalmodelsE、Logicalmodels,physicalmodelsandinfrastructuremodels答案：A解析：見P166，概念、主題域、邏輯、物理65.Discoveringanddocumentingmetadataaboutphysicaldataassetsprovides:A、ScopingboundariesofthedatadictionaryB、InformationonhowdataistransformedasitmovesbetweensystemsC、AnestimationofbalancesheetvalueofenterprisedataD、EffectiveprojectscopemanagementE、Insightsintothetemporaldataquality答案：B解析：見P636，該題考的是數(shù)據(jù)血緣，66.DimensiontablesA、DonotcontainhierarchiesB、ContainmeasuresC、HavefewcolumnsbutmanyrowsD、ArethesameasFactsE、Havemanycolumnsbutfewrows答案：E解析：題目解釋：這題是Havemanycolumnsbutfewrows與Havefewcolumnsbutmanyrows二選一。維表與主數(shù)據(jù)差不多等同了，維表就是一些業(yè)務(wù)實(shí)體和業(yè)務(wù)對象，如會員、組織等（參考數(shù)據(jù)當(dāng)然也是維表的一份子，只是量不大）；與維表相對的就是事實(shí)表，事實(shí)表通常表示過程，如交易過程（訂單表）等。

維表有兩個特征：（1）字段（列）數(shù)量大：如會員，可能會有二、三十個字段（2）維表記錄數(shù)與事實(shí)表比不大，如阿里巴巴的會員記錄可能十億行（維表），但事實(shí)表（交易記錄）估計已經(jīng)超過萬億行。我拿阿里來舉例，是因?yàn)榘⒗锘敬砹司S度建模的金字塔頂端。實(shí)際上更多的情況是一千幾百個產(chǎn)品，數(shù)百萬行交易記錄。

切記，這里提的多與少，是維表與事實(shí)表作比較，千萬不要與主數(shù)據(jù)及參考數(shù)據(jù)一同分析，這是兩個概念。67.Discoveringanddocumentingmetadataaboutphysicaldataassetsprovides:A、EffectiveprojectscopemanagementB、AnestimationofbalancesheetvalueofenterprisedataC、InformationonhowdataistransformedasitmovesbetweensystemsD、InsightsintothetemporaldataqualityE、Scopingboundariesofthedatadictionary答案：C解析：見P636，該題考的是數(shù)據(jù)血緣，68.Inadatawarehouse,wheretheclassificationlistsfororganizationtypeareinconsistentindifferentsourcesystemsthereisanindicationthatthereisalackoffocusonA、DataStorageB、MasterdataC、MetadataManagementD、DataModellingE、Referencedata答案：E解析：組織架構(gòu)屬參考數(shù)據(jù)在DAMA中，若見到分類這種詞語，一般就指參考數(shù)據(jù)69.Referencedataisusedto:A、EnforceenterprisesecuritystandardsB、PopulatefacttablesinadatamartC、CategorizeorclassifydataD、DescribebackupstrategiesE、Removeduplicatecustomerrecords答案：C解析：參考數(shù)據(jù)，如地區(qū)等，某種意義上來說，是把事實(shí)數(shù)據(jù)按地區(qū)進(jìn)行切片（或者說歸類）70.Bysetting,enforcingandauditingmetadatastandards,organizationshopeto:A、StandardizebusinessrulesinoperationalprocessesB、EaseofunderstandingdatadictionariesC、Ensuretheappropriateclassificationormeta-metadataD、SimplifyintegrationandenableuseE、Provideactivitiesforthedatagovernanceoffice答案：D解析：見P60871.WhichofthefollowingBESTdescribestheroleofadataintermediary？A、SomeonewhodecideswhatdataisimportanttothebusinessB、AllC、SomeonewhoisresponsiblefortranslatingbusinessrequirementsintoadatabasedesignD、Someonewhoisresponsibleformanagingthemeta-datarepositoryE、Someonewhoreceivesdatainoneformandtranscribesitintoanotherfor答案：E72.WhichofthefollowingisNOTaprimaryMasterDataManagementareaoffocus?A、IdentifyingduplicaterecordsB、ProducingreadonlyversionsofkeydataitemsC、Generatingagoldenrecord/bestversionofthetruthD、ProducingcleardatadefinitionsforMasterDataE、Providingaccesstogoldendatarecords答案：B解析：B類型題目，相關(guān)的書上的介紹請見P518，我截圖如下：并未見到提及“Producingreadonlyversionsofkeydataitems”73.AcharacteristicofinformationqualitythatmeasuresthedegreeofthedatagranularityisknownA、AggregationB、DatasetC、ScaleD、Precision答案：D74.Anapplicationusesasingleserviceaccountforalldatabaseaccess.Oneoftherisksofthisapproachis:A、ItconstrainstheapplicationfromrunningparallelprocessesB、ThedatabaserunsoutofthreadsC、TheapplicationfreezesmoreoftenD、TheabilitytotracewhomadechangestothedataE、Thedatabecomesoutoforder答案：C解析：serviceaccount指的是非操作人員帳戶，如SQLSERVER中的SYSTEM帳戶等，他們是沒有密碼的；如果所有數(shù)據(jù)庫都用一個serviceaccount，如dev，prd，uat，那假設(shè)其中某個地方引致這個account出現(xiàn)問題（如拒絕訪問WINDOW的某個目錄，而這個目錄剛好是保存數(shù)據(jù)的父目錄），將會出現(xiàn)所有環(huán)境不能訪問；又或者在修改后臺服務(wù)帳戶權(quán)限后，導(dǎo)至前臺桌面應(yīng)用不能訪問（Tableau會有此問題）

BTW：該題目不嚴(yán)謹(jǐn)，不需要深究，屬1%的S+題目75.Datathatisusedinfrequentlyornotatallmaybemovedtoanalternativedatastore.Thisiscalled:A、AuthenticationB、AuditingC、ArchivingD、ReplicationE、Analysis答案：C解析：見P40876.Masterdataisdataabout:A、AuthoritytograntaccesstodataacrossanorganizationB、Businessentities,e.g.products,customers,assetsandlocationsC、DatavaluesstoredanddisplayedinuppercaseD、Businesstransactions,e.g.financialtransactions,enquiresandservicecallinteractionsE、Databasestructuresandresponsetimeperformancetargets答案：B解析：見P514~P51577.ComponentsofaBusinessIntelligencestrategydoNOTincludeA、SimplifieddatadeliveryB、SeamlessdataandtechnologyintegrationC、Endusertrainingmodules.D、AllE、Zerolatency.答案：C78.MasterDataManagementencompassesalltheseactivitiesEXCEPTA、IntegrationofnewdatasourcesB、NoneC、ClassificationofdataD、AdministeringgoldendataE、Developmentofnewproceduresandpolicies答案：C79.TheDataGovernanceSteeringCommitteeisbestdescribedas：A、Thelocalordivisionalcouncil,workingunderauspicesoftheCDOB、TherepresentativesofdatauseonprojectsteeringcommitteesC、Thecommunityofinterest,focusedonspecificsubjectarea