DAMA-CDMP真题详解_第一套试卷_046~050题

DAMA-CDMP真题详解_第一套试卷_046~050题

​说明：​一些复杂题目的解释，因文字描述比较痛苦，后续对一些知识面涉及比较广的题目，会配以视频说明。目前因时间关系，把第一套真题文字版讲解先更新完毕，再考虑视频录制，若有同学对某些题目需要单独与鄙人进行讨论，可私信鄙人。

对于一些比较体系的知识，会独立以专题的形式发布一个视频集，如：数据建模、指标体系设计专题等。

题目中提到的“书本”，均是指《DMBOK 2nd中英双语对照版 v0.9》

​046、Who is most responsible for communicating and promoting awareness on the value of Data Governance in the organization?​

​谁对企业内部数据治理价值概念推广沟通及负责？​

A. Data Champions

​数据支持者​

B. The Data Governance Office

​数据治理办公室​

C. Data Owners Stewards

​数据管理员​

D. Everyone in the Data Management Community

​数据管理过程中的所有人​

E. The Data Governance Council

​数据治理委员会​

正确答案：D题目解释：数据治理在DAMA的概念中，基本上所有都是所有人都要参加的，包括组织建设、数据质量等，在书本上多次多个地方都有提到

​047、When defining your business continuity plan, which of the following should one  consider doing?​

​当你要进行业务连续计划的定义，下面哪一个是你第一个考虑去实现的？​

A. Make sure that the data is retained sufficiently long, check that critical data is encrypted, check access rights

​确保数据的保留期足够地长，检查数据是被加密的，检查访问的正确性​

B. Consider written policies and procedures, impact mitigating measures, required recovery time and acceptable amount of disruption, the criticality of the documents

​考虑书面制度和程序、减轻影响的措施、所需的恢复时间、可接受的中断量、以及文档的重要性​

C. Write a report and discuss with management the required budget

​编写报告和讨论管理的预算​

D. Have the contracts in place to acquire new hardware in case of technical problems, define policies

​需要定义政策以便发生技术问题时，能及时得到新硬件合同​

E. Determine the risk, probability and impact, check document backup frequency

​定义风险、概念及影响，检查文档备份频率​

​048、All of the following are TRUE statements on relationship types except:​

​下面关于关系的陈述都是正确的，除了：​

A. A recursive relationship relates instances of an entity to other instances of the same entity.

​递归关系讲述了同一个实体不同实例之间的关系​

B. A one-to-one relationship says that a parent entity may have one and only one child entity.

​一对一关系，描述了一个父实体只有一个子实体​

C. A one-to-many relationship says that a child entity may have one or more parent entities.

​一对多关系，描述了一个子实体有一个或多个父实体​

D. A one-to-many relationship says that a parent entity may have one or more child entities.

​一对多关系，描述了一个实体有一个或多个子实体​

E. A many-to-many relationship says that an instance of each entity may be associated with many instances of the other entity, and vice versa.

​多对多关系，讲述了每一个实体实例之间，都会关联着其它多个实体的实例，反之亦然​

​049、What is the difference between cardinality rules and data integrity rules?​

​基数规则与引用完整性规则差异点在？​

A. Cardinality rules define the quantity of each entity instance that can participate in a relationship between two entities and referential integrity rules ensure valid values.

​基数规则定义了所有两两实体之间的所有定量关系，而引用完整性规则用于确保数据值是有效的​

B. Referential integrity rules define the quantity of each entity instance that can participate in a relationship between two entities and cardinality rules ensure valid values.

​引用完整性规则定义了所有两两实体之间的所有定量关系，而基数规则用于确保数值是有效的​

C. There is no difference. Cardinality rules and Referential integrity rules are synonyms.

​基数规则与引用完整性规则两者之间没有区别，是同义词​

D. Referential integrity rules only appear on a relational data model and cardinality rules only appear on a dimensional data model.

​引用完整性规则只会出现在关系型数据库模型，而基数规则只会出现在维度数据库模型​

E. Referential integrity rules quantify the relationships between two or more entities and cardinality rules quantify the common attributes across entities.

​引用完整性规则是指两个或两个以上实体之间关系的量化描述，而基数规则是实体间共同属性的量化描述​

​050、In a non-identifying relationship​

​在非标识关系中​

A. The foreign key of the parent entity migrates to the child entity

​父实体的外键转移到子实体​

B. The primary key of the parent entity becomes part of the primary key of the child entity

​父实体的主键，成为子实体主键的一部分​

C. The primary key of the parent entity becomes a foreign key in the child entity

​父实体的主键，成为子实体的外键​

D. The primary key of the child entity is concatenated

​子实体的主键是连接的​

E. The primary key of the child entity is removed

​子实体的主键被移除​

正确答案：C题目解释：这里有两个概念，非标识关系，标识关系，这里先作概述，详细的请等待视频对建模做完整性介绍标非识关系：一般用于联合主键才能标识实体记录的唯一性标识关系：不需要联合主键，也能标识实体记录的唯一性，本文048题，就是标识关系其实现在的数据库设计中，特别是计算机硬件便宜了之后，几乎见不到联合主键的情况，用联合主键只是为了节省一个代理键（surrogate keys，自增长ID或GUID等，ID无意义，只是作为唯一标识，所以才叫代理键）字段的存储空间，没有这个必要性这一题的答案跟48题是一样的，只是换了一表述，请本试卷参阅48题也就父实体与子实体是一对多的关系（一个老爸有多个儿子），主外键我也在48题举例了

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。