CDMP Data Management Fundamentals Exam Questions PDF

Preface Have you already taken a CDMP (Certified Data Management Professional) Data Management Fundamentals course from a Registered Training Provider? Or Have you self-studied using the DAMA - DMBOK2? Are you still not quite confident that you are ready to take the certification exam? If so, you'...

Preface Have you already taken a CDMP (Certified Data Management Professional) Data Management Fundamentals course from a Registered Training Provider? Or Have you self-studied using the DAMA - DMBOK2? Are you still not quite confident that you are ready to take the certification exam? If so, you've come to the right place! Guideline to get most out of this book: 1. Study the applicable chapter in the DMBOK2. 2. Summarize the most important points in the chapter. 3. Take the quiz for the applicable chapters and check your answers. 4. If there are incorrect answers, refer back to the DMBOK2 and your notes. 5. Retake the quiz on a chapter and try to achieve a higher score (>80%). 6. Finally, when you are ready, take the practice exams at the end. You will have 90 minutes in the actual examination to complete the 100 questions. Please take note of the question type when completing the questions: Multiple-choice: One correct answer Multi-select: One or multiple correct answers Disclaimer The questions in this book have been formulated on the chapters in DMBOK2. The DMBOK2 should first be procured and studied before attempting these questions. It is also recommended to attend an official course from a Registered Training Provider. These questions are not official training material for the CDMP and not endorsed by DAMA. They were purely constructed to provide final revision and solidify knowledge. Contents Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10 Chapter 11 Chapter 12 Chapter 13 Chapter 14 Chapter 15 Chapter 16 Chapter 17 Practice Test 1 Practice Test 2 Correct Response At the top of each page the correct response to the question on the previous page will be stated. Explanation The page in DMBOK2 will be referenced for your convenience. Knowledge Area The chapter name. Chapter 1 Question 1 Please select the correct definition of Data Management from the options below. Question Type multiple-choice Answer 1 Data Management is the strict control of all plans, policies, programs and practices that enable the business strategy to be successfully executed. Answer 2 Data Management is the development, execution and supervision of plans, policies, programs and practices that deliver, control, protect and enhance the value of data and information assets throughout their lifecycles. Answer 3 Data Management is the development, execution and supervision of plans, policies, programs and practices that deliver, control, protect and enhance the value of data assets throughout their lifecycles. Answer 4 Data Management is the development, execution and supervision of plans, policies, programs and practices that deliver, control, protect and enhance the value of information assets throughout their lifecycles. Correct Response 2 Explanation Please refer to page 17 of DMBOK2. Knowledge Area Data Management Question 2 Data Management Professionals only work with the technical aspects related to data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 17 of DMBOK2. Knowledge Area Data Management Question 3 Differentiating between data and information. Please select the correct answers based on the sentence below: Here is a marketing report for the last month. It is based on data from our data warehouse. Next month these results will be used to generate our month-over-month performance measure. Question Type multiple-choice Answer 1 Information, Information, Data, Information Answer 2 Data, Information, Data, Data Answer 3 Data, Data, Data, Information Answer 4 Information, Data, Data, Information Correct Response 4 Explanation Please refer to page 17 of DMBOK2. Knowledge Area Data Management Question 4 Please select the answers that correctly describes the set of principles that recognizes salient features of data management and guide data management practice. Question Type multi-select Answer 1 Data is an asset with unique properties. Answer 2 It takes Metadata to manage data. Answer 3 The most important part of data management is security. Answer 4 Data management is lifecycle management. Answer 5 Effective data management requires leadership commitment. Answer 6 Efficient data management requires a team of IT professionals only. Correct Response 1,2,4,5 Explanation Please refer to page 22-23 of DMBOK2. Knowledge Area Data Management Question 5 Value is the difference between the cost of a thing and the benefit derived from that thing. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 24 of DMBOK2. Knowledge Area Data Management Question 6 Please select the correct general cost and benefit categories that can be applied consistently within an organization. Question Type multi-select Answer 1 Cost of erasing data from servers Answer 2 Cost of improving data Answer 3 What the data could be sold for Answer 4 Benefit of higher quality data Answer 5 Cost of replacing data if it were lost Answer 6 What competitors would pay for data Correct Response 2,3,4,5,6 Explanation Please refer to page 24 of DMBOK2. Knowledge Area Data Management Question 7 Please select the answers that correctly describes where the costs of poor quality data comes from. Question Type multi-select Answer 1 Scrap and rework Answer 2 Organizational conflict Answer 3 High job satisfaction Answer 4 High productivity Answer 5 Reputational costs Answer 6 Compliance costs Correct Response 1,2,5,6 Explanation Please refer to page 25-26 of DMBOK2. Knowledge Area Data Management Question 8 Reduced risk is a benefit of high quality data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 25-26 of DMBOK2. Knowledge Area Data Management Question 9 The better an organization understands the lifecycle and lineage of its data, the better able it will be to manage its data. Please select correct implication of the focus of data management on the data lifecycle. Question Type multiple-choice Answer 1 Data Quality must be managed throughout the data lifecycle Answer 2 Data Security must only be managed at the start of the data lifecycle Answer 3 Metadata Quality is the most important part of the management process Answer 4 Data Management efforts should focus on the most critical data last Correct Response 1 Explanation Please refer to page 29 of DMBOK2. Knowledge Area Data Management Question 10 Information gaps represent enterprise liabilities with potentially profound impacts on operational effectiveness and profitability. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 30 of DMBOK2. Knowledge Area Data Management Chapter 2 Question 1 Data handling ethics are concerned with how to procure, store, manage, use and dispose of data in ways that are aligned with ethical principles. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 49 of DMBOK2. Knowledge Area Data Handling Ethics Question 2 The ethics of data handling are complex, but is centred on several core concepts. Please select the correct answers. Question Type multi-select Answer 1 Impact on machines Answer 2 Impact on people Answer 3 Potential for data management Answer 4 Potential for misuse Answer 5 Economic value of ethics Answer 6 Economics value of data Correct Response 2,4,6 Explanation Please refer to page 49 of DMBOK2. Knowledge Area Data Handling Ethics Question 3 Within the Data Handling Ethics Context Diagram a key deliverable is the Ethical Data Handling Strategy. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 50 of DMBOK2. Knowledge Area Data Handling Ethics Question 4 The Belmont principles that may be adapted for Information Management disciplines, include: Question Type multi-select Answer 1 Respect for Persons Answer 2 Respect for Machines Answer 3 Beneficence Answer 4 Criminality Answer 5 Justice Correct Response 1,3,5 Explanation Please refer to page 52 of DMBOK2. Knowledge Area Data Handling Ethics Question 5 Please select the correct principles of the General Data Protection Regulation (GDPR) of the EU. Question Type multi-select Answer 1 Purpose Limitation Answer 2 Data Minimisation Answer 3 Accuracy Answer 4 Storage Limitation Answer 5 Accountability Answer 6 All of the above Correct Response 6 Explanation Please refer to page 54 of DMBOK2. Knowledge Area Data Handling Ethics Question 6 Misleading visualisations could be an example where a base level of truthfulness and transparency are not adhered to. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 57 of DMBOK2. Knowledge Area Data Handling Ethics Question 7 Bias refers to an inclination of outlook. Please select the types of data bias: Question Type multi-select Answer 1 Data collection for pre-defined results Answer 2 Hunch and search Answer 3 Positive reinforcement Answer 4 Context and Emotion Answer 5 Biased use of data collected Answer 6 Biased sampling methodology Correct Response 1,2,5,6 Explanation Please refer to page 58-59 of DMBOK2. Knowledge Area Data Handling Ethics Question 8 If data is not integrated with care it presents risk for unethical data handling. These ethical risks intersect with fundamental problems in data management including: Limited knowledge of data’s origin and lineage; Data of poor quality; Unreliable Metadata; and Documentation of error remediation. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 59-60 of DMBOK2. Knowledge Area Data Handling Ethics Question 9 Obfuscating or redacting data is the practice of making information anonymous ot removing sensitive information. Risks are present in the following instances: Question Type multi-select Answer 1 Data storage Answer 2 Data marketing Answer 3 Data aggregation Answer 4 Data marking Answer 5 Data masking Answer 6 Data integration Correct Response 3,4,5 Explanation Please refer to page 60 of DMBOK2. Knowledge Area Data Handling Ethics Question 10 Improving an organization’s ethical behaviour requires an informal Organizational Change Management (OCM) process. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 61 of DMBOK2. Knowledge Area Data Handling Ethics Chapter 3 Question 1 The purpose of data governance is to ensure that data is managed properly, according to policies and best practices. Data governance is focused on how decisions are made about data and how people and processes are expected to behave in relation to data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 67-68 of DMBOK2. Knowledge Area Data Governance Question 2 The scope and focus of any data governance program depend on organizational needs, but most programs include: Question Type multi-select Answer 1 Strategy Answer 2 Policy Answer 3 Data Management Projects Answer 4 Compliance Answer 5 Oversight Answer 6 All of the above Correct Response 6 Explanation Please refer to page 68 of DMBOK2. Knowledge Area Data Governance Question 3 A goal of data governance is to enable an organisation to manage its data as a liability. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 69 of DMBOK2. Knowledge Area Data Governance Question 4 Drivers for data governance most often focus on reducing risk or improving processes. Please select the elements that relate to the reduction in risk: Question Type multi-select Answer 1 Specific risk management Answer 2 General risk management Answer 3 Data ethics Answer 4 Data security Answer 5 Publicity Answer 6 Privacy Correct Response 2,4,6 Explanation Please refer to page 70 of DMBOK2. Knowledge Area Data Governance Question 5 Drivers for data governance most often focus on reducing risk or improving processes. Please select the elements that relate to the improvement of processes: Question Type multi-select Answer 1 Regulatory compliance Answer 2 Data quality improvements Answer 3 Metadata management Answer 4 Efficiency in development projects Answer 5 Vendor management Answer 6 All of the above Correct Response 6 Explanation Please refer to page 70 of DMBOK2. Knowledge Area Data Governance Question 6 Data governance and IT governance are the same thing. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 71 of DMBOK2. Knowledge Area Data Governance Question 7 Select three correct attributes a data governance programme must be: Question Type multi-select Answer 1 Embedded Answer 2 Flexible Answer 3 Measures Answer 4 Rigid Answer 5 Independent responsibility Answer 6 Sustainable Correct Response 1,3,6 Explanation Please refer to page 71 of DMBOK2. Knowledge Area Data Governance Question 8 Governance ensures data is managed, but is not include the actual act of managing data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 72 of DMBOK2. Knowledge Area Data Governance Question 9 Data governance can be understood in terms of political governance. It includes the following three function types: Question Type multi-select Answer 1 Legislative-like functions Answer 2 Judicial-like functions Answer 3 Ethical-like functions Answer 4 Executive functions Answer 5 Data-like functions Answer 6 Morality-like functions Correct Response 1,2,4 Explanation Please refer to page 73-74 of DMBOK2. Knowledge Area Data Governance Question 10 The Data Governance Council (DGC) manages data governance initiatives, issues, and escalations. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 74 of DMBOK2. Knowledge Area Data Governance Question 11 Data Governance Office (DGO) focuses on enterprise-level data definitions and data management standards across all DAMA-DMBOK knowledge areas. Consists of coordinating data management roles. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 74 of DMBOK2. Knowledge Area Data Governance Question 12 Three data governance operating models types include: Question Type multi-select Answer 1 Centralized Answer 2 Decentralized Answer 3 Feathered Answer 4 Federated Answer 5 Replicated Answer 6 Duplicated Correct Response 1,4,5 Explanation Please refer to page 75 of DMBOK2. Knowledge Area Data Governance Question 13 Data stewardship is the least common label to describe accountability and responsibility for data and processes to ensure effective control and use of data assets. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 75 of DMBOK2. Knowledge Area Data Governance Question 14 Please select the correct types of data stewards: Question Type multi-select Answer 1 Executive Data Steward Answer 2 Chief Data Steward Answer 3 Enterprise Data Steward Answer 4 Business Data Steward Answer 5 A Data Seller Answer 6 All of the above Correct Response 1,2,3,4 Explanation Please refer to page 76-77 of DMBOK2. Knowledge Area Data Governance Question 15 Data asset valuation is the process of understanding and calculating the economic value of data to an organisation. Value comes when the economic benefit of using data outweighs the costs of acquiring and storing it, as Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 77 of DMBOK2. Knowledge Area Data Governance Question 16 Some ways to measure value of data include: Question Type multi-select Answer 1 Replacement cost Answer 2 Market value Answer 3 Selling Data Answer 4 Risk cost Answer 5 Identified opportunities Answer 6 All of the above Correct Response 6 Explanation Please refer to page 78 of DMBOK2. Knowledge Area Data Governance Question 17 Please select the correct General Accepted Information Principles: Question Type multi-select Answer 1 Asset Principle Answer 2 Audit Principle Answer 3 Due Diligence Principle Answer 4 Going Concern Principle Answer 5 Ethical Principle Answer 6 All of the above Correct Response 1,2,3,4 Explanation Please refer to page 78 of DMBOK2. Knowledge Area Data Governance Question 18 Data governance program must contribute to the organization by identifying and delivering on specific benefits. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 80 of DMBOK2. Knowledge Area Data Governance Question 19 Part of alignment includes developing organizational touchpoints for data governance work. Some examples of touchpoints include: Procurement and Contracts; Budget and Funding; Regulatory Compliance; and the SDLC framework. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 81 of DMBOK2. Knowledge Area Data Governance Question 20 A data governance strategy defines the scope and approach to governance efforts. Deliverables include: Question Type multi-select Answer 1 Charter Answer 2 Operating framework and accountabilities Answer 3 Implementation roadmap Answer 4 Plan for operational success Answer 5 All of the above Answer 6 None of the above Correct Response 5 Explanation Please refer to page 82 of DMBOK2. Knowledge Area Data Governance Chapter 4 Question 1 Architecture is the fundamental organization of a system, embodied in its components, their relationships to each other and the environment and the principles governing its design and evolution. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 97-98 of DMBOK2. Knowledge Area Data Architecture Question 2 Enterprise Architecture domains include: Question Type multi-select Answer 1 Business Architecture Answer 2 Data Architecture Answer 3 Data Management Architecture Answer 4 Systems Architecture Answer 5 Application Architecture Answer 6 Technology Architecture Correct Response 1,2,5,6 Explanation Please refer to page 98 of DMBOK2. Knowledge Area Data Architecture Question 3 The most informal enterprise data model is the most detailed data architecture design document. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 98 of DMBOK2. Knowledge Area Data Architecture Question 4 The goal of data architecture is to: Question Type multiple-choice Answer 1 Serve as a platform to enable data governance and management Answer 2 Bridge between business strategy and technology execution Answer 3 Provide the organisation with clear system of the architecture Answer 4 Make the integration between data management and data analytics possible Correct Response 2 Explanation Please refer to page 99 of DMBOK2. Knowledge Area Data Architecture Question 5 Data architects facilitate alignment between and Question Type multiple-choice Answer 1 Business and IT Answer 2 Technology and Data Answer 3 Governance and Management Answer 4 Strategy and Execution Correct Response 1 Explanation Please refer to page 99 of DMBOK2. Knowledge Area Data Architecture Question 6 A goal of data architecture is to identify data storage and processing requirements. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 100 of DMBOK2. Knowledge Area Data Architecture Question 7 The deliverables in the data architecture context diagram include: Question Type multi-select Answer 1 Data flows Answer 2 Enterprise data Answer 3 Implementation roadmap Answer 4 Data Value Chains Answer 5 None of the above Answer 6 All of the above Correct Response 6 Explanation Please refer to page 100 of DMBOK2. Knowledge Area Data Architecture Question 8 The purpose of enterprise application architecture is to describe the structure and functionality of applications in an enterprise. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 101 of DMBOK2. Knowledge Area Data Architecture Question 9 The dependencies of enterprise technology architecture are that it acts on specified data according to business requirements. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 102 of DMBOK2. Knowledge Area Data Architecture Question 10 The roles associated with enterprise data architecture are data architect, data modellers and data stewards. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 102 of DMBOK2. Knowledge Area Data Architecture Question 11 The Zachman Framweork’s communication interrogative columns provides guidance on defining enterprise architecture. Please select answer(s) that is(are) coupled correctly: Question Type multi-select Answer 1 What -> The inventory Column Answer 2 What -> The entity column Answer 3 When -> The timing column Answer 4 Why -> The motivation column Answer 5 Who -> The responsibility column Answer 6 How -> The process column Correct Response 1,3,4,5,6 Explanation Please refer to page 103 of DMBOK2. Knowledge Area Data Architecture Question 12 What model is the highest level model within the enterprise data model? Question Type multiple-choice Answer 1 Logical model Answer 2 Physical model Answer 3 Conceptual model Answer 4 Subject Area model Correct Response 3 Explanation Please refer to page 106 of DMBOK2. Knowledge Area Data Architecture Question 13 For each subject area logical model: Decrease detail by adding attributes and less-significant entities and relationships. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 106 of DMBOK2. Knowledge Area Data Architecture Question 14 Data flows map and document relationships between data and: Question Type multi-select Answer 1 Locations where local differences occur Answer 2 Situations where local differences occur Answer 3 Network segments Answer 4 Applications within a business process Answer 5 None of the above Answer 6 All of the above Correct Response 1,3,4 Explanation Please refer to page 108 of DMBOK2. Knowledge Area Data Architecture Question 15 Enterprise data architecture usually include the following work streams: Question Type multi-select Answer 1 Strategy Answer 2 Governance Answer 3 Organization Answer 4 Results Answer 5 Working methods Answer 6 All of the above Correct Response 1,3,4,5 Explanation Please refer to page 110 of DMBOK2. Knowledge Area Data Architecture Question 16 A roadmap for enterprise data architecture describes the architecture’s 3 to 5- year development path. The roadmap should be guided by a data management maturity assessment. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 111-112 of DMBOK2. Knowledge Area Data Architecture Question 17 Enterprise data architecture project-related activities include: Question Type multi-select Answer 1 Define maturity assessment Answer 2 Define scope Answer 3 Design Answer 4 Implement Answer 5 None of the above Answer 6 All of the above Correct Response 2,3,4 Explanation Please refer to page 113-114 of DMBOK2. Knowledge Area Data Architecture Question 18 The process of building architectural activities into projects also differ between methodologies. They include: Question Type multi-select Answer 1 Waterfall methods Answer 2 Incremental methods Answer 3 Kanban method Answer 4 Agile iterative method Answer 5 Duck and dive method Answer 6 Pump and dump method Correct Response 1,2,4 Explanation Please refer to page 114 of DMBOK2. Knowledge Area Data Architecture Question 19 Data modelling tools and model repositories are necessary for managing the enterprise data model in all levels. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 115 of DMBOK2. Knowledge Area Data Architecture Question 20 Characteristics that minimise distractions and maximise useful information include, but not limited to, consistent object attributes Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 82 of DMBOK2. Knowledge Area Data Architecture Chapter 5 Question 1 A deliverable in the data modelling and design context diagram is the logical data model. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 124 of DMBOK2. Knowledge Area Data Modelling and Design Question 2 Inputs in the data modelling and design context diagram include: Question Type multi-select Answer 1 Data standards Answer 2 Data sets Answer 3 Data Management Architecture Answer 4 Systems Architecture Answer 5 Data architecture Answer 6 Enterprise taxonomy Correct Response 1,2,5,6 Explanation Please refer to page 124 of DMBOK2. Knowledge Area Data Modelling and Design Question 3 Data models comprise and contain metadata essential to data consumers. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 125 of DMBOK2. Knowledge Area Data Modelling and Design Question 4 Data models are critical to effective management of data. They: Question Type multi-select Answer 1 Provide a common vocabulary around data Answer 2 Capture and document explicit knowledge about an organization’s data and systems Answer 3 Serve as a primary communication tool during projects Answer 4 Provide the starting point for customizations, integration or even replacement of an application Answer 5 Provide the organisation with clear system of the architecture Answer 6 Make the integration between data management and data analytics possible Correct Response 1,2,3,4 Explanation Please refer to page 125 of DMBOK2. Knowledge Area Data Modelling and Design Question 5 Confirming and documenting understanding of different perspectives facilitate: Question Type multi-select Answer 1 Formalization Answer 2 Normalization Answer 3 Scope definition Answer 4 Knowledge retention/documentation Correct Response 1,3,4 Explanation Please refer to page 125 of DMBOK2. Knowledge Area Data Modelling and Design Question 6 Data modelling is most infrequently performed in the context of systems and maintenance efforts, known as SDLC. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 126 of DMBOK2. Knowledge Area Data Modelling and Design Question 7 SDLC stands for: Question Type multiple-choice Answer 1 System development leverage cycle Answer 2 System design lifecycle Answer 3 System and design long cycle Answer 4 System development lifecycle Correct Response 4 Explanation Please refer to page 126 of DMBOK2. Knowledge Area Data Modelling and Design Question 8 Category information is one of the types of data that can be modelled. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 126 of DMBOK2. Knowledge Area Data Modelling and Design Question 9 Business activity information is one of the types of data that can be modelled. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 127 of DMBOK2. Knowledge Area Data Modelling and Design Question 10 Examples of the ‘Who’ entity category include: employee; patient; player; and suspect. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 127 of DMBOK2. Knowledge Area Data Modelling and Design Question 11 Examples of the ‘What’ entity category include the following nouns: Question Type multi-select Answer 1 Product Answer 2 Service Answer 3 Time Answer 4 Sales amount Answer 5 Payment quantity Answer 6 All of the above Correct Response 1,2 Explanation Please refer to page 128 of DMBOK2. Knowledge Area Data Modelling and Design Question 12 High quality data definition exhibit three characteristics: Question Type Multi-select Answer 1 Clearness Answer 2 Clarity Answer 3 Accuracy Answer 4 Completeness Correct Response 2,3,4 Explanation Please refer to page 129 of DMBOK2. Knowledge Area Data Modelling and Design Question 13 The number of entities in a relationship is the arity of the relationship. The most common are: Question Type multi-select Answer 1 Unary Answer 2 Binary Answer 3 Trinary Answer 4 Ternary Correct Response 1,2,4 Explanation Please refer to page 131 of DMBOK2. Knowledge Area Data Modelling and Design Question 14 What type of key is used in physical and sometimes logical relational data modelling schemes to represent a relationship? Question Type multiple-choice Answer 1 Primary key Answer 2 Foreign key Answer 3 Network key Answer 4 Applications key Answer 5 Door key Answer 6 All of the above Correct Response 2 Explanation Please refer to page 132 of DMBOK2. Knowledge Area Data Modelling and Design Question 15 Please select valid modelling schemes or notations Question Type multi-select Answer 1 NoSQL Answer 2 Dimensional Answer 3 Relational Answer 4 Object-orientated Answer 5 Fact-based Answer 6 Matrix-based Correct Response 1,2,3,4,5 Explanation Please refer to page 136 of DMBOK2. Knowledge Area Data Modelling and Design Question 16 Domains can be identified in different ways including: data type; data format; list; range; and rule-based. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 135-136 of DMBOK2. Knowledge Area Data Modelling and Design Question 17 Snowflaking is the term given to normalizing the flat, single-table, dimensional structure in a star schema into the respective component hierarchical or network structures. Question Type multi-select Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 139 of DMBOK2. Knowledge Area Data Modelling and Design Question 18 Class operations can be: Question Type multi-select Answer 1 General: Hidden Answer 2 Public: Externally visible Answer 3 Internally visible: Visible to children objects Answer 4 Private: Hidden Correct Response 2,3,4 Explanation Please refer to page 141 of DMBOK2. Knowledge Area Data Modelling and Design Question 19 The data-vault is an object-orientated, time-based and uniquely linked set of normalized tables that support one or more functional areas of business. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 141 of DMBOK2. Knowledge Area Data Modelling and Design Question 20 Time-based patterns are used when data values must be associated in chronological order and with specific time values. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 142 of DMBOK2. Knowledge Area Data Modelling and Design Chapter 6 Question 1 Data Storage and Operations: The design, implementation and support of stored data to maximize its value. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 170 of DMBOK2. Knowledge Area Data Storage and Operations Question 2 Inputs in the data storage and operations context diagram include: Question Type multi-select Answer 1 Data requirements Answer 2 Service level agreements Answer 3 Data Management Architecture Answer 4 Systems Architecture Answer 5 Data architecture Answer 6 Data models Correct Response 1,2,5,6 Explanation Please refer to page 170 of DMBOK2. Knowledge Area Data Storage and Operations Question 3 Companies do not rely on their information systems to run their operations. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 171 of DMBOK2. Knowledge Area Data Storage and Operations Question 4 The goals of data storage and operations include: Question Type multi-select Answer 1 Managing performance of data assets Answer 2 Capture and document explicit knowledge about an organization’s data and systems Answer 3 Managing the availability of data throughout the data lifecycle Answer 4 Provide the starting point for customizations, integration or even replacement of an application Answer 5 Managing the performance of data transactions Answer 6 Make the integration between data management and data analytics possible Correct Response 1,3,5 Explanation Please refer to page 171 of DMBOK2. Knowledge Area Data Storage and Operations Question 5 Please select correct term for the following sentence: Any collection of stored data regardless of structure or content. Some large databases refer to instances and schema. Question Type multiple-choice Answer 1 Schema Answer 2 Database Answer 3 Node Answer 4 Instance Correct Response 2 Explanation Please refer to page 172 of DMBOK2. Knowledge Area Data Storage and Operations Question 6 A node is a group of computers hosting either processing or data as part of a distributed database. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 172 of DMBOK2. Knowledge Area Data Storage and Operations Question 7 SLA Stands for: Question Type multiple-choice Answer 1 Service Level Agreement Answer 2 System Lifecycle Audit Answer 3 System Latitude Audit Answer 4 Service Lifecycle Audit Correct Response 1 Explanation Please refer to page 170 of DMBOK2. Knowledge Area Data Storage and Operations Question 8 The database administrator (DBA) is the most established and the most widely adopted data professional role. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 173 of DMBOK2. Knowledge Area Data Storage and Operations Question 9 DBAs exclusively perform all the activities of data storage and operations. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 173 of DMBOK2. Knowledge Area Data Storage and Operations Question 10 An application DBA leads the review and administration of procedural database objects. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 174 of DMBOK2. Knowledge Area Data Storage and Operations Question 11 Please select the types of DBA specializations: Question Type multi-select Answer 1 Data Answer 2 Application Answer 3 Innovation Answer 4 Development Answer 5 Procedural Answer 6 All of the above Correct Response 2,4,5 Explanation Please refer to page 173 of DMBOK2. Knowledge Area Data Storage and Operations Question 12 Please select the two classifications of database types: Question Type Multi-select Answer 1 Centralized Answer 2 Generic Answer 3 Distributed Answer 4 MapReduce Correct Response 1,3 Explanation Please refer to page 175 of DMBOK2. Knowledge Area Data Storage and Operations Question 13 There are numerous methods of implementing databases on the cloud. The most common are: Question Type multi-select Answer 1 Virtual machine image Answer 2 Distributed machine image Answer 3 DAAS Answer 4 Managed database hosting on the cloud Correct Response 1,3,4 Explanation Please refer to page 178 of DMBOK2. Knowledge Area Data Storage and Operations Question 14 The CAP theorem asserts that the distributed system cannot comply with all the parts of the ACID. A distributed system must instead trade-off between the following properties: Question Type multi-select Answer 1 Consistency Answer 2 Utilization Answer 3 Availability Answer 4 System development Answer 5 Partition tolerance Answer 6 All of the above Correct Response 1,3,5 Explanation Please refer to page 180 of DMBOK2. Knowledge Area Data Storage and Operations Question 15 The acronym BASE is made up of: Question Type multi-select Answer 1 Basically available Answer 2 Basically not available Answer 3 Software state Answer 4 Soft state Answer 5 Eventual consistency Answer 6 Everything considered Correct Response 1,4,5 Explanation Please refer to page 179 of DMBOK2. Knowledge Area Data Storage and Operations Question 16 The CAP theorem states that at most two of the three properties: consistency, availability and partition tolerance can exist in any shared data system. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 180 of DMBOK2. Knowledge Area Data Storage and Operations Question 17 SSD is the abbreviation for Solid State Dimension. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 182 of DMBOK2. Knowledge Area Data Storage and Operations Question 18 Test environments serve many uses: Question Type multi-select Answer 1 Quality Assurance Testing (QA) Answer 2 Integration Testing Answer 3 User Acceptance Testing (UAT) Answer 4 Performance Testing Answer 5 All of the above Answer 6 None of the above Correct Response 5 Explanation Please refer to page 183 of DMBOK2. Knowledge Area Data Storage and Operations Question 19 A sandbox environment can either be a sub-set of the production system, walled off from production processing or a completely separate environment. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 184 of DMBOK2. Knowledge Area Data Storage and Operations Question 20 A sandbox is an alternate environment that allows write-only connections to production data and can be managed by the administrator. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 184 of DMBOK2. Knowledge Area Data Storage and Operations Chapter 7 Question 1 Data security includes the planning, development and execution of security policies and procedures to provide authentication, authorisation, access and auditing of data and information assets. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 217 of DMBOK2. Knowledge Area Data Security Question 2 The goals of data security practices is to protect information assets in alignment with privacy and confidentiality regulations, contractual agreements and business requirements. These requirements come from: Question Type multi-select Answer 1 Stakeholders Answer 2 Government regulations Answer 3 Proprietary business concerns Answer 4 Legitimate access needs Answer 5 Contractual obligations Answer 6 None of the above Correct Response 1,2,3,4,5 Explanation Please refer to page 217-218 of DMBOK2. Knowledge Area Data Security Question 3 A deliverable in the data security context diagram is the data security architecture. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 219 of DMBOK2. Knowledge Area Data Security Question 4 The goals of data security include: Question Type multi-select Answer 1 Managing performance of data assets Answer 2 Enable appropriate access to enterprise data assets Answer 3 Managing the availability of data throughout the data lifecycle Answer 4 Understand and comply with all relevant regulations and policies for privacy and confidentiality Answer 5 Managing the performance of data transactions Answer 6 Ensure that the privacy and confidentiality needs of all stakeholders are enforced and audited Correct Response 2,4,6 Explanation Please refer to page 219 of DMBOK2. Knowledge Area Data Security Question 5 What are the primary drivers of data security activities? Question Type multi-select Answer 1 Risk reduction Answer 2 Risk alleviation Answer 3 Business growth Answer 4 Business compliance Correct Response 2,3 Explanation Please refer to page 220 of DMBOK2. Knowledge Area Data Security Question 6 Data security issues, breaches and unwarranted restrictions on employee access to data cannot directly impact operational success. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 220 of DMBOK2. Knowledge Area Data Security Question 7 Vulnerability is defined as: Question Type multiple-choice Answer 1 a patch in a system that allows it to be successfully unpatched and compromised. Answer 2 being highly data risk rated Answer 3 a strength in a system that allows external stakeholders to view data records. Answer 4 a weakness or defect in a system that allows it to be successfully attacked and compromised. Correct Response 4 Explanation Please refer to page 223 of DMBOK2. Knowledge Area Data Security Question 8 Risk classifications describe the sensitivity of the data and the likelihood that it might be sought after for malicious purposes. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 224 of DMBOK2. Knowledge Area Data Security Question 9 Data integrity is the state of being partitioned – protected from being whole. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 226 of DMBOK2. Knowledge Area Data Security Question 10 The four A’s in security processes include: Question Type multi-select Answer 1 Audit Answer 2 Authentication Answer 3 Access Answer 4 Authorization Answer 5 Aliment Answer 6 Applicable Correct Response 1,2,3,4 Explanation Please refer to page 225 of DMBOK2. Knowledge Area Data Security Question 11 There are several methods for masking data: Question Type multi-select Answer 1 Substitution Answer 2 Temporal variance Answer 3 Temporal stagnation Answer 4 Value stagnation Answer 5 Value variance Answer 6 All of the above Correct Response 1,2,5 Explanation Please refer to page 228-229 of DMBOK2. Knowledge Area Data Security Question 12 Please select the two concepts that drive security restrictions: Question Type Multi-select Answer 1 Regulation Answer 2 Regression Answer 3 Confidence level Answer 4 Confidentiality level Correct Response 1,4 Explanation Please refer to page 234-235 of DMBOK2. Knowledge Area Data Security Question 13 Device security standards include: Question Type multi-select Answer 1 Access policies regarding connections using mobile devices Answer 2 Awareness of security vulnerabilities Answer 3 Installation of malware software Answer 4 Storage of data on fixed devices Correct Response 1,2 Explanation Please refer to page 233 of DMBOK2. Knowledge Area Data Security Question 14 Confidentiality classification schemas might include two or more of the five confidentiality classification levels. Three correct classifications levels are: Question Type multi-select Answer 1 Consistency Answer 2 Internal use only Answer 3 Restricted confidential Answer 4 System development Answer 5 Confidential Answer 6 None of the above Correct Response 2,3,5 Explanation Please refer to page 235 of DMBOK2. Knowledge Area Data Security Question 15 Malware types include: Question Type multi-select Answer 1 Trojan horse Answer 2 Worm Answer 3 Weasel Answer 4 Virus Answer 5 Adware Answer 6 Camware Correct Response 1,2,4,5 Explanation Please refer to page 243-244 of DMBOK2. Knowledge Area Data Security Question 16 Malware refers to any infectious software created to damage, change or improperly access a computer or network. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 242 of DMBOK2. Knowledge Area Data Security Question 17 Instant Messaging (IM) allows a user to message each other in real-time. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 244 of DMBOK2. Knowledge Area Data Security Question 18 Different levels of policy are required to govern behavior to enterprise security. For example: Question Type multi-select Answer 1 Data security policy Answer 2 Business Security Policy Answer 3 IT security policy Answer 4 Enterprise security policy Answer 5 All of the above Answer 6 None of the above Correct Response 1,3,4 Explanation Please refer to page 247 of DMBOK2. Knowledge Area Data Security Question 19 The IT security policy provides categories for individual application, database roles, user groups and information sensitivity. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 247 of DMBOK2. Knowledge Area Data Security Question 20 Data access control can be organized at an individual level or group level, depending on the need. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 249 of DMBOK2. Knowledge Area Data Security Chapter 8 Question 1 Data Integration and Interoperability (DII) describes processes related to the movement and consolidation of data within and between data stores, applications and organizations. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 269 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 2 Data Integration and Interoperability is dependent on these other areas of data management: Question Type multi-select Answer 1 Metadata Answer 2 Data architecture Answer 3 Data governance Answer 4 Data security Answer 5 Data modelling and design Answer 6 Data storage and operations Correct Response 1,2,3,4,5,6 Explanation Please refer to page 270 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 3 The need to manage data movement efficiently is a primary driver for Data Integration and Interoperability. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 270 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 4 The goals of Data Integration and Interoperability include: Question Type multi-select Answer 1 Provide data securely, with regulatory compliance, in the format and timeframe needed. Answer 2 Lower cost and complexity of managing solutions by developing shared models and interfaces. Answer 3 Managing the availability of data throughout the data lifecycle Answer 4 Provide the starting point for customizations, integration or even replacement of an application Answer 5 Identify meaningful events and automatically trigger alerts and actions. Answer 6 Support business intelligence, analytics, master data management and operational efficiency efforts. Correct Response 1,2,5,6 Explanation Please refer to page 271 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 5 One of the deliverables in the Data Integration and Interoperability context diagram is: Question Type multiple-choice Answer 1 Data Integration and Interoperability Strategy Answer 2 Data hogging Answer 3 Data access agreements Answer 4 Data security plan Correct Response 3 Explanation Please refer to page 271 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 6 ETL is the basic process which is central to all areas in Data Integration and Interoperability. It is an abbreviation for extract, transition and load. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 273 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 7 On example of a transformation process in ETL is: Question Type multiple-choice Answer 1 Re-ordering Answer 2 Recording Answer 3 Duping Answer 4 Servicing Correct Response 1 Explanation Please refer to page 273-274 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 8 The load step of ETL is physically storing or presenting the results of the transformation in the target system. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 274 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 9 A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 275 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 10 Change Data Capture is a method of reducing bandwidth by filtering to include only data that has been changed within a defined timeframe. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 275 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 11 There are three techniques for data-based change data capture, namely: Question Type multi-select Answer 1 The source system populates specific data elements. Answer 2 Application automated interfaces Answer 3 The source system processes copy data that has changed into a separate object as part of the transaction, which is then used for the extract process. Answer 4 The source systems send binary code through ASCI that makes the process rapid. Answer 5 The source system processes add to a simple list of objects and identifiers when changing data, which is then used to control selection of data extraction. Answer 6 None of the above Correct Response 1,3,5 Explanation Please refer to page 276 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 12 Latency can be: Question Type Multi-select Answer 1 Batch Answer 2 Event-driven Answer 3 Distributed Answer 4 Real-time synchronous Correct Response 1,3,4 Explanation Please refer to page 275 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 13 Examples of interaction models include: Question Type multi-select Answer 1 Hub-and-spoke Answer 2 Publish - subscribe Answer 3 Point-to-point Answer 4 Wheel-and-spike Correct Response 1,2,3 Explanation Please refer to page 280-281 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 14 As an often-overlooked aspects of basic data movement architecture, Process controls include: Question Type multi-select Answer 1 Consistency logging Answer 2 Exception logs Answer 3 Database activity logs Answer 4 Alerts Answer 5 Exception logs Answer 6 All of the above Correct Response 2,3,4,5 Explanation Please refer to page 282 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 15 Use business rules to support Data Integration and Interoperability at various points, to: Question Type multi-select Answer 1 Direct the flow of data in the organization Answer 2 Monitor the organization’s operational data Answer 3 Software alerts when events are triggered Answer 4 Direct when to automatically trigger events and alerts Answer 5 Consistency in allocation event resources Answer 6 None of the above Correct Response 1,2,4 Explanation Please refer to page 289 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 16 The flow of data in a data integration solution does not have to be designed and documented. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 291 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 17 Preparation and pre-processing of historical data needed in a predictive model may be performed in nightly batch processes or in near real-time. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 293 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 18 Developing complex event processing solutions require: Question Type multi-select Answer 1 Preparation of historical data and pre-population of a predictive model Answer 2 Integration testing for subsequent logging requirements Answer 3 Processing of real-time data stream to fully populate a predictive model and identify meaningful events Answer 4 Executing the triggered action in response to the prediction Answer 5 All of the above Answer 6 None of the above Correct Response 1,3,4 Explanation Please refer to page 292 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 19 Real-time data integration is usually triggered by batch processing, such as historic data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 291 of DMBOK2. Knowledge Area Data Integration and Interoperability Question 20 Integration of ETL data flows will usually be developed within tools specialised to manage those flows in a proprietary way. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 291 of DMBOK2. Knowledge Area Data Integration and Interoperability Chapter 9 Question 1 E-discovery is the process of finding electronic records that might serve as evidence in a legal action. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 305 of DMBOK2. Knowledge Area Document and content management Question 2 Deliverables in the document and content management context diagram include: Question Type multi-select Answer 1 Metadata and reference data Answer 2 Policy and procedure Answer 3 Data governance Answer 4 Content and records management strategy Answer 5 Audit trail and log Answer 6 Data storage and operations Correct Response 2,3,4,5 Explanation Please refer to page 304 of DMBOK2. Knowledge Area Document and content management Question 3 Document and content management is defined as planning, implementation and control activities for storage management of data and information found in any form or medium. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 304 of DMBOK2. Knowledge Area Document and content management Question 4 The goals of implementing best practices around document and content management include: Question Type multi-select Answer 1 Ensuring effective and efficient retrieval and use of data and information in unstructured formats Answer 2 Ensuring integration capabilities between structured and unstructured data Answer 3 Complying with legal obligations and customer expectations Answer 4 Enduring integration competencies between semi-structured systems Answer 5 Managing the performance of data transactions Answer 6 Make the integration between data management and data analytics possible Correct Response 1,2,3 Explanation Please refer to page 305 of DMBOK2. Knowledge Area Document and content management Question 5 Please select correct term for the following sentence: An organization shall assign a senior executive to appropriate individuals, adopt policies and processes to guide staff and ensure program audibility. Question Type multiple-choice Answer 1 Principle of integrity Answer 2 Principle of availability Answer 3 Principle of retention Answer 4 Principle of accountability Correct Response 4 Explanation Please refer to page 306 of DMBOK2. Knowledge Area Document and content management Question 6 Content refers to the data and information inside a file, document or website. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 307 of DMBOK2. Knowledge Area Document and content management Question 7 ECM is an abbreviation for: Question Type multiple-choice Answer 1 Enterprise compliance management Answer 2 Enterprise compliance manager Answer 3 Enterprise component management Answer 4 Enterprise content management Correct Response 4 Explanation Please refer to page 307 of DMBOK2. Knowledge Area Document and content management Question 8 Content management includes the systems for organizing information resources so that they can specially be stored. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 307 of DMBOK2. Knowledge Area Document and content management Question 9 Content needs to be modular, structured, reusable and device and platform independent. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 308 of DMBOK2. Knowledge Area Document and content management Question 10 A controlled vocabulary is a defined list of explicitly allowed terms used to index, categorize, tag, sort and retrieve content through browsing and searching. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 309 of DMBOK2. Knowledge Area Document and content management Question 11 Taxonomies can have different structures, including: Question Type multi-select Answer 1 Polyhierarchy Answer 2 Application Answer 3 Facet taxonomy Answer 4 Network taxonomy Answer 5 Flat taxonomy Answer 6 All of the above Correct Response 1,3,4,5 Explanation Please refer to page 312-313 of DMBOK2. Knowledge Area Document and content management Question 12 Well prepared records have characteristics such as: Question Type Multi-select Answer 1 Context Answer 2 Content Answer 3 Compliance Answer 4 Timeliness Correct Response 1,2,4 Explanation Please refer to page 317 of DMBOK2. Knowledge Area Document and content management Question 13 Information architecture is the process of creating structure for a body of information or content. It includes the following components: Question Type multi-select Answer 1 Navigation maps Answer 2 User flows Answer 3 Use cases Answer 4 Controlled technologies Correct Response 1,2,3 Explanation Please refer to page 320 of DMBOK2. Knowledge Area Document and content management Question 14 Most document programs have policies related to: Question Type multi-select Answer 1 Scope and compliance audits Answer 2 Proper destruction of records Answer 3 Proper construction of records Answer 4 Identification and protection of vital records Answer 5 Partition tolerance Answer 6 All of the above Correct Response 1,2,4 Explanation Please refer to page 324 of DMBOK2. Knowledge Area Document and content management Question 15 ANSI standard 859 has three levels of control of data, based on the criticality of the data and the perceived harm that would occur if data were corrupt or otherwise unavailable, including: Question Type multi-select Answer 1 Basic Answer 2 Formal Answer 3 Informal Answer 4 Custody Answer 5 Revision Answer 6 None of the above Correct Response 2,4,5 Explanation Please refer to page 326 of DMBOK2. Knowledge Area Document and content management Question 16 A content strategy should end with an inventory of current state and a gap assessment. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 324 of DMBOK2. Knowledge Area Document and content management Question 17 Record management starts with a vague definition of what constitutes a record. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 323 of DMBOK2. Knowledge Area Document and content management Question 18 Some document management systems have a module that may support different types of workflows such as: Question Type multi-select Answer 1 Quality Assurance Testing (QA) Answer 2 Manual workflows that indicate where the user send the document Answer 3 User Acceptance Testing (UAT) Answer 4 Dynamic rules that allow for different workflows based on content Answer 5 All of the above Answer 6 None of the above Correct Response 2,4 Explanation Please refer to page 331 of DMBOK2. Knowledge Area Document and content management Question 19 An image processing system captures, transforms and manages images of paper and electronic documents. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 331 of DMBOK2. Knowledge Area Document and content management Question 20 OCR is the abbreviation for Optical Character Recognition. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 332 of DMBOK2. Knowledge Area Document and content management Chapter 10 Question 1 Reference and Master data definition: Managing shared data to meet organizational goals, reduce risks associated with data redundancy, ensure higher quality, and reduce the costs of data integration. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 348 of DMBOK2. Knowledge Area Reference and master data Question 2 The most common drivers for initiating a Mater Data Management Program are: Question Type multi-select Answer 1 Metadata insecurity Answer 2 Managing data quality Answer 3 Reducing risk Answer 4 Managing the costs of data integration Answer 5 Meeting organizational data requirements Answer 6 Reducing latency Correct Response 2,3,4,5 Explanation Please refer to page 349 of DMBOK2. Knowledge Area Reference and master data Question 3 A goal of reference and master data is to provide authoritative source of reconciled and quality-assessed master and reference data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 348 of DMBOK2. Knowledge Area Reference and master data Question 4 Reference and Master Data Management follow these guiding principles: Question Type multi-select Answer 1 Quality Answer 2 Stewardship Answer 3 Authority Answer 4 Ownership Answer 5 Exclusivity Answer 6 Inclusivity Correct Response 1,2,3,4 Explanation Please refer to page 350 of DMBOK2. Knowledge Area Reference and master data Question 5 Master data is an aggregation of: Question Type multi-select Answer 1 Transaction Structure Data Answer 2 Database Structure Data Answer 3 Reference Data Answer 4 Enterprise Structure Data Correct Response 1,3,4 Explanation Please refer to page 350-351 of DMBOK2. Knowledge Area Reference and master data Question 6 Reference data management entails the preventative maintenance of undefined domain values, definitions and the relationship within and across domain values. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 353 of DMBOK2. Knowledge Area Reference and master data Question 7 SOR Stands for: Question Type multiple-choice Answer 1 Service of Record Answer 2 System of Record Answer 3 System on Record Answer 4 Service over Record Correct Response 2 Explanation Please refer to page 358 of DMBOK2. Knowledge Area Reference and master data Question 8 A System of Reference is an authoritative system where data consumers can obtain reliable data to support transactions and analysis, even if the information did not originate in the system reference. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 358 of DMBOK2. Knowledge Area Reference and master data Question 9 A ‘Golden Record’ means that it is always a 100% complete and accurate representation of all entities within the organization. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 359 of DMBOK2. Knowledge Area Reference and master data Question 10 Master data management includes several basic steps, which include: Develop rules for accurately matching and merging entity instances. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 360 of DMBOK2. Knowledge Area Reference and master data Question 11 Data preparation for Question Type multi-select Answer 1 Realistic Answer 2 Opportunistic Answer 3 Deterministic Answer 4 Probabilistic Answer 5 Procedural Answer 6 All of the above Correct Response 3,4 Explanation Please refer to page 363 of DMBOK2. Knowledge Area Reference and master data Question 12 Two risks with the Matching process are: Question Type Multi-select Answer 1 False positives Answer 2 False Certainties Answer 3 False Negatives Answer 4 False Uncertainties Correct Response 1,3 Explanation Please refer to page 363 of DMBOK2. Knowledge Area Reference and master data Question 13 Consistent input data reduces the chance of errors in associating records. Preparation processes include: Question Type multi-select Answer 1 Standardization Answer 2 Enrichment Answer 3 Validation Answer 4 Database management Correct Response 1,2,3 Explanation Please refer to page 362 of DMBOK2. Knowledge Area Reference and master data Question 14 Match rules for different scenarios require different workflows, including: Question Type multi-select Answer 1 Consistency rules Answer 2 Duplicate identification match rules Answer 3 Match-merge rules Answer 4 Match-split rules Answer 5 Match-link rules Answer 6 All of the above Correct Response 2,3,5 Explanation Please refer to page 364-365 of DMBOK2. Knowledge Area Reference and master data Question 15 There are three basic approaches to implementing a Master Data hub environment, including: Question Type multi-select Answer 1 Transaction hub Answer 2 Distributed hub Answer 3 Registry Answer 4 Consolidated approach Answer 5 Eventual consistency Answer 6 Transparent hub Correct Response 1,3,4 Explanation Please refer to page 371-372 of DMBOK2. Knowledge Area Reference and master data Question 16 A Global ID is the MDM solution-assigned and maintained unique identifier attached to reconciled records. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 365 of DMBOK2. Knowledge Area Reference and master data Question 17 Customer relationship management systems manage Master Data about customers. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 366 of DMBOK2. Knowledge Area Reference and master data Question 18 Key processing steps for MDM include: Question Type multi-select Answer 1 Data model management Answer 2 Data acquisition Answer 3 Data validation, standardization and enrichment Answer 4 Entity resolution Answer 5 Data sharing and stewardship Answer 6 None of the above Correct Response 1,2,3,4,5 Explanation Please refer to page 361 of DMBOK2. Knowledge Area Reference and master data Question 19 In matching, false positives are three references that do not represent the same entity are linked with a single identifier. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 363 of DMBOK2. Knowledge Area Reference and master data Question 20 Product Master data can only focus on an organization’s internal product and services. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 367 of DMBOK2. Knowledge Area Reference and master data Chapter 11 Question 1 Business requirements is an input in the Data Warehouse and Business Intelligence context diagram. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 382 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 2 Primary deliverables of the Data Warehouse and Business Intelligence context diagram include: Question Type multi-select Answer 1 Data Products Answer 2 Data Stewardship Answer 3 Governance Activities Answer 4 Release Plan Answer 5 Load Tuning Activities Answer 6 BI Activity Monitoring Correct Response 1,3,4,5,6 Explanation Please refer to page 382 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 3 A goal of Data warehouse and business intelligence is to support and enable ineffective business analysis and decision making by knowledge workers. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 382 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 4 The implementation of a Data Warehouse should follow these guiding principles: Question Type multi-select Answer 1 Managing performance of data assets Answer 2 Focus on the business goals Answer 3 Managing the availability of data throughout the data lifecycle Answer 4 Start with the end in mind Answer 5 Managing the performance of data transactions Answer 6 Collaborate Correct Response 2,4,6 Explanation Please refer to page 383-384 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 5 The difference between warehouses and operational systems do not include the following element: Question Type multiple-choice Answer 1 Time variant Answer 2 Database Answer 3 Subject-orientated Answer 4 Historical Correct Response 2 Explanation Please refer to page 386 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 6 Data warehousing describes the operational extract, cleaning, transformation, control and load processes that maintain the data in a data warehouse. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 385 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 7 CIF stands for: Question Type multiple-choice Answer 1 Company Information Factory Answer 2 Corporate Information Floor Answer 3 Corporate Information Factories Answer 4 Corporate Information Factory Correct Response 4 Explanation Please refer to page 386 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 8 The data in Data warehouses and marts differ. Data is organized by subject rather than function Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 387 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 9 An Operational Data Mart is a data mart focused on tactical decision support. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 387 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 10 Operational reports are outputs from the data stewards. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 387 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 11 The Data Warehouse encompasses all components in the data staging and data presentation areas, including: Question Type multi-select Answer 1 Data Access Tool Answer 2 Application Tool Answer 3 Operational source systems Answer 4 Data staging area Answer 5 Data presentation area Answer 6 All of the above Correct Response 1,3,4,5 Explanation Please refer to page 389 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 12 The Data Warehouse has a set of storage areas, including: Question Type Multi-select Answer 1 Staging areas Answer 2 Data marts Answer 3 Cubes Answer 4 Kubernetes Correct Response 1,2,3 Explanation Please refer to page 391-392 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 13 The impact of the changes from new volatile data must be isolated from the bulk of the historical, non-volatile DW data. There are three main approaches, including: Question Type multi-select Answer 1 Streaming Answer 2 Messaging Answer 3 DAAS Answer 4 Trickle Feeds Correct Response 1,2,4 Explanation Please refer to page 394 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 14 Typically, DW/BI have three concurrent development tracks: Question Type multi-select Answer 1 Data mart Answer 2 Business Intelligence tools Answer 3 Data Answer 4 System development Answer 5 Techonology Answer 6 None of the above Correct Response 2,3,5 Explanation Please refer to page 396 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 15 Business Intelligence tool types include: Question Type multi-select Answer 1 Technology reporting Answer 2 Operational reporting Answer 3 Descriptive, self-service analytics Answer 4 Operations performance management (OPM) Answer 5 Business performance management (BPM) Answer 6 Predictive, self-service analytics Correct Response 2,3,5 Explanation Please refer to page 404 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 16 An implemented warehouse and its customer facing BI tool is a data product. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 399 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 17 Release management is critical to batch development processes that grows new capabilities. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 399 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 18 Three classic implementation approaches that support Online Analytical Processing include: Question Type multi-select Answer 1 QOLAP Answer 2 ROLAP Answer 3 OLAP2 Answer 4 HOLAP Answer 5 MOLAP Answer 6 None of the above Correct Response 2,4,5 Explanation Please refer to page 407 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 19 Self-service is a fundamental delivery channel in the BI portfolio. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 408 of DMBOK2. Knowledge Area Data warehouse and business intelligence Question 20 A data dictionary is necessary to support the use of a DW. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 402 of DMBOK2. Knowledge Area Data warehouse and business intelligence Chapter 12 Question 1 With reliable Metadata an organization does not know what data it has, what the data represents and how it moves through the systems, who has access to it, or what it means for the data to be of high quality. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 418 of DMBOK2. Knowledge Area Metadata management Question 2 Deliverables in the Metadata Management context diagram include: Question Type multi-select Answer 1 Metadata Strategy Answer 2 Metadata Standards Answer 3 Data Lineage Answer 4 Metadata Architecture Answer 5 Metadata design Answer 6 Data storage and operations Correct Response 1,2,3,4 Explanation Please refer to page 419 of DMBOK2. Knowledge Area Metadata management Question 3 Poorly managed Metadata leads to, among other, redundant data and data management processes. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 420 of DMBOK2. Knowledge Area Metadata management Question 4 The goals of Metadata management include: Question Type multi-select Answer 1 Managing performance of data assets Answer 2 Ensure metadata quality, consistency, currency and security Answer 3 Managing the availability of data throughout the data lifecycle Answer 4 Provide standard ways to make metadata accessible to metadata consumers Answer 5 Managing the performance of data transactions Answer 6 Establish or enforce the use of technical Metadata standards to enable data exchange Correct Response 2,4,6 Explanation Please refer to page 420-421 of DMBOK2. Knowledge Area Metadata management Question 5 Metadata is described using a different set of categories, not including: Question Type multiple-choice Answer 1 Descriptive metadata Answer 2 Database metadata Answer 3 Structural metadata Answer 4 Administrative metadata Correct Response 2 Explanation Please refer to page 422 of DMBOK2. Knowledge Area Metadata management Question 6 Business metadata focuses largely on the content and condition of the data and includes details related to data governance. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 422 of DMBOK2. Knowledge Area Metadata management Question 7 Operational Metadata describes details of the processing and accessing of data. Which one is not an example: Question Type multiple-choice Answer 1 Error logs Answer 2 Schedule anomalies Answer 3 Purge criteria Answer 4 Failure logs Correct Response 4 Explanation Please refer to page 423-424 of DMBOK2. Knowledge Area Metadata management Question 8 Technical Metadata provides data about the technical data, the systems that store data, and the processes that move between systems. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 423 of DMBOK2. Knowledge Area Metadata management Question 9 Metadata is essential to the management of unstructured data as it id to the management of structured data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 424 of DMBOK2. Knowledge Area Metadata management Question 10 The minority of operational metadata is generated as data is processed. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 425 of DMBOK2. Knowledge Area Metadata management Question 11 The business glossary application is structured to meet the functional requirements of the three core audiences: Question Type multi-select Answer 1 Data users Answer 2 Application users Answer 3 Innovation users Answer 4 Business users Answer 5 Data stewards Answer 6 Technical users Correct Response 4,5,6 Explanation Please refer to page 426-427 of DMBOK2. Knowledge Area Metadata management Question 12 Examples of business metadata include: Question Type Multi-select Answer 1 Data models Answer 2 Data quality rules Answer 3 Data usage notes Answer 4 Data Standards Correct Response 1,2,3,4 Explanation Please refer to page 423 of DMBOK2. Knowledge Area Metadata management Question 13 Examples of technical metadata include: Question Type multi-select Answer 1 Access permission Answer 2 Recovery and backup rules Answer 3 Colum properties Answer 4 Data subject properties Correct Response 1,2,3 Explanation Please refer to page 423 of DMBOK2. Knowledge Area Metadata management Question 14 The business glossary should capture business terms attributes such as: Question Type multi-select Answer 1 Lineage Answer 2 Utilization Answer 3 Common misunderstanding in terms Answer 4 System development Answer 5 Algorithms to supporting definitions Answer 6 All of the above Correct Response 1,3,5 Explanation Please refer to page 427 of DMBOK2. Knowledge Area Metadata management Question 15 The acronym CMDB stands for: Question Type multiple-choice Answer 1 Customization management tools or databases Answer 2 Classic management technologies or databases Answer 3 Cached management technologies or databases Answer 4 Configuration management tools or databases Answer 5 Cached management tools or databases Answer 6 Classic monitoring technologies or databases Correct Response 4 Explanation Please refer to page 427 of DMBOK2. Knowledge Area Metadata management Question 16 CMDB provide the capability to manage and maintain Metdata specifically related to the IT assets, the relationships among them, and contractual details of the assets. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 427 of DMBOK2. Knowledge Area Metadata management Question 17 SOA stand for Service Orchestrated Architecture Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 430 of DMBOK2. Knowledge Area Metadata management Question 18 All metadata management solutions include architectural layers including: Question Type multi-select Answer 1 Metadata Quality Assurance Testing Answer 2 Metadata integration Answer 3 Metadata usage Answer 4 Metadata delivery Answer 5 Metadata control and management Answer 6 None of the above Correct Response 2,3,4,5 Explanation Please refer to page 431 of DMBOK2. Knowledge Area Metadata management Question 19 An advantage of a centralized repository include: High availability since it is independent of the source systems. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 431 of DMBOK2. Knowledge Area Metadata management Question 20 A limitation of the centralized approach include: Maintenance of a decentralized repository is costly. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 431 of DMBOK2. Knowledge Area Metadata management Chapter 13 Question 1 Effective data management involves a set of complex, interrelated processes that enable an organisation to use its data to achieve strategic goals. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 449 of DMBOK2. Knowledge Area Data quality Question 2 Deliverables in the data quality context diagram include: Question Type multi-select Answer 1 DQM Procedures Answer 2 Data architecture Answer 3 Data governance Answer 4 DQ Policies and guidelines Answer 5 Analyses from data profiling Answer 6 Data quality Service Level Agreements Correct Response 1,4,5,6 Explanation Please refer to page 451 of DMBOK2. Knowledge Area Data quality Question 3 The term data quality refers to only the characteristics associated with high quality data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 453 of DMBOK2. Knowledge Area Data quality Question 4 Data can be assessed based on whether it is required by: Question Type multi-select Answer 1 Regulatory reporting Answer 2 Capturing policy Answer 3 Ongoing operations Answer 4 Provide the starting point for customizations, integration or even replacement of an application Answer 5 Business policy Answer 6 Make the integration between data management and data analytics possible Correct Response 1,3,5 Explanation Please refer to page 454 of DMBOK2. Knowledge Area Data quality Question 5 Please select the incorrect item that does not represent a dimension in the Data Values category in Data Quality for the Information age. Question Type multiple-choice Answer 1 Currency Answer 2 Timeliness Answer 3 Consistency Answer 4 Completeness Correct Response 2 Explanation Please refer to page 455-456 of DMBOK2. Knowledge Area Data quality Question 6 The accuracy dimension of data quality refers to the degree that data correctly respresents ‘real-life’ entities. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 458 of DMBOK2. Knowledge Area Data quality Question 7 What ISO standard defines characteristics that can be tested by any organisation in the data supply chain to objectively determine conformance of the data to this ISO standard. Question Type multiple-choice Answer 1 ISO 9000 Answer 2 ISO 7000 Answer 3 ISO 8000 Answer 4 ISO 9001 Correct Response 3 Explanation Please refer to page 461 of DMBOK2. Knowledge Area Data quality Question 8 The accuracy dimension has to do with the precision of data values. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 460 of DMBOK2. Knowledge Area Data quality Question 9 Data Integrity includes ideas associated with completeness, accuracy, and consistency. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 459 of DMBOK2. Knowledge Area Data quality Question 10 Validity, as a dimension of data quality, refers to whether data values are consistent with a defined domain of values. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 459 of DMBOK2. Knowledge Area Data quality Question 11 Dimensions of data quality include: Question Type multi-select Answer 1 Validity Answer 2 Privacy Answer 3 Innovation Answer 4 Accessibility Answer 5 Currency Answer 6 All of the above Correct Response 1,2,4,5 Explanation Please refer to page 460 of DMBOK2. Knowledge Area Data quality Question 12 ISO 8000 will describe the structure and the organization of data quality management, including: Question Type Multi-select Answer 1 Data Quality Availability Answer 2 Data Quality Planning Answer 3 Data Quality Control Answer 4 Data Quality Assurance Answer 5 Data Quality Improvement Correct Response 2,3,4,5 Explanation Please refer to page 462 of DMBOK2. Knowledge Area Data quality Question 13 Some common data quality business rule types are: Question Type multi-select Answer 1 Definitional conformance Answer 2 Format compliance Answer 3 Range conformance Answer 4 Mapping conformance Correct Response 1,2,3,4 Explanation Please refer to page 464 of DMBOK2. Knowledge Area Data quality Question 14 The Shewhart chart contains the following elements: Question Type multi-select Answer 1 Plan Answer 2 Utilization Answer 3 Do Answer 4 Check Answer 5 Act Answer 6 All of the above Correct Response 1,3,4,5 Explanation Please refer to page 463 of DMBOK2. Knowledge Area Data quality Question 15 Issues caused by data entry processes include: Question Type multi-select Answer 1 Training issues Answer 2 List entry replacement Answer 3 Software issues Answer 4 Soft state issues Answer 5 Change to business processes Answer 6 Inconsistent business process execution Correct Response 1,2,5,6 Explanation Please refer to page 466-467 of DMBOK2. Knowledge Area Data quality Question 16 Data quality issues only emerge at initial stages of the data lifecycle. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 465 of DMBOK2. Knowledge Area Data quality Question 17 Field overloading: Unnecessary data duplication is often a result of poor data management. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 469 of DMBOK2. Knowledge Area Data quality Question 18 Data profiling examples include: Question Type multi-select Answer 1 Counts of null Answer 2 Max/Min value Answer 3 Max/Min length Answer 4 Frequency distribution Answer 5 Data type and format Answer 6 None of the above Correct Response 1,2,3,4,5 Explanation Please refer to page 470 of DMBOK2. Knowledge Area Data quality Question 19 Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 470 of DMBOK2. Knowledge Area Data quality Question 20 While the focus of data quality improvement efforts is often on the prevention of errors, data quality can also be improved through some forms of data processing. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 470 of DMBOK2. Knowledge Area Data quality Chapter 14 Question 1 Volume refers to the amount of data. Big Data often has thousands of entities or elements in billions of records. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 502 of DMBOK2. Knowledge Area Big data and data science Question 2 The list of V’s include: Question Type multi-select Answer 1 Volatility Answer 2 Volume Answer 3 Veracity Answer 4 Viscosity Answer 5 Variety Answer 6 Validity Correct Response 1,2,3,4,5 Explanation Please refer to page 502 of DMBOK2. Knowledge Area Big data and data science Question 3 Veracity refers to how difficult the data is to use or to integrate. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 502 of DMBOK2. Knowledge Area Big data and data science Question 4 Different storage volumes include: Question Type multi-select Answer 1 Gigabyte Answer 2 Petabyte Answer 3 Perabyte Answer 4 Exabyte Answer 5 Tetrabyte Answer 6 Terabyte Correct Response 1,2,4,6 Explanation Please refer to page 503 of DMBOK2. Knowledge Area Big data and data science Question 5 Please select the answer that does not represent a machine learning algorithm: Question Type multiple-choice Answer 1 Reinforcement learning Answer 2 Supervised learning Answer 3 Artificial learning Answer 4 Unsupervised learning Correct Response 3 Explanation Please refer to page 506 of DMBOK2. Knowledge Area Big data and data science Question 6 Machine learning explores the construction and study of learning algorithms. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 506 of DMBOK2. Knowledge Area Big data and data science Question 7 Please select the answer that best fits the following description: Contains only real-time data. Question Type multiple-choice Answer 1 Batch layer Answer 2 Speed layer Answer 3 Serving layer Answer 4 Real-time layer Correct Response 2 Explanation Please refer to page 505 of DMBOK2. Knowledge Area Big data and data science Question 8 SBA is an abbreviation for service-based architecture. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 505 of DMBOK2. Knowledge Area Big data and data science Question 9 Data mining is a sub-field of supervised learning where users attempt to model data elements and predict future outcomes through the evaluation of probability estimates. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 507 of DMBOK2. Knowledge Area Big data and data science Question 10 Media monitoring and text analysis are automated methods for retrieving insights from large unstructured or semi-structured data, such as transaction data, social media, blogs, and web news sites. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 507 of DMBOK2. Knowledge Area Big data and data science Question 11 Data and text mining use a range of techniques, including: Question Type multi-select Answer 1 Profiling Answer 2 Application reduction Answer 3 Association Answer 4 Data reduction Answer 5 Clustering Answer 6 All of the above Correct Response 1,3,4,5 Explanation Please refer to page 508 of DMBOK2. Knowledge Area Big data and data science Question 12 The first two steps in the data science process are: Question Type Multi-select Answer 1 Define Big Data data strategy & Business Need(s) Answer 2 Choose Data Sources Answer 3 Develop Data Science Hypotheses and Mehods Answer 4 Acquire & Ingest Data source(s) Correct Response 1,2 Explanation Please refer to page 501 of DMBOK2. Knowledge Area Big data and data science Question 13 Input in the Big Data and data science context diagram include: Question Type multi-select Answer 1 IT standards Answer 2 Data sources Answer 3 Business strategy & goals Answer 4 Database standards Correct Response 1,2,3 Explanation Please refer to page 499 of DMBOK2. Knowledge Area Big data and data science Question 14 Data science involves the iterative inclusion of data sources into models that develop insights. Dat science depends on: Question Type multi-select Answer 1 Consistency Answer 2 Rich data sources Answer 3 Information alignment and analysis Answer 4 Information delivery Answer 5 Presentation of findings and data insights Answer 6 All of the above Correct Response 2,3,4,5 Explanation Please refer to page 500 of DMBOK2. Knowledge Area Big data and data science Question 15 The language used in file-based solutions is called MapReduce. This language has three main steps: Question Type multi-select Answer 1 Map Answer 2 Shuffle Answer 3 Free Answer 4 Terminate Answer 5 Integrate Answer 6 Reduce Correct Response 1,2,6 Explanation Please refer to page 519-520 of DMBOK2. Knowledge Area Big data and data science Question 16 MPP is an abbreviation for Major Parallel Processing. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 518 of DMBOK2. Knowledge Area Big data and data science Question 17 Traditional tool sin data visualtization have both a data and a graphical component. Advanced visualization and discovery tools use in-memory architecture to allow users to interact with the data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 520 of DMBOK2. Knowledge Area Big data and data science Question 18 Analytics models are associated with different depths of analysis, including: Question Type multi-select Answer 1 Quality testing Answer 2 Explanatory modeling Answer 3 Descriptive modeling Answer 4 Performance modeling Answer 5 All of the above Answer 6 None of the above Correct Response 2,3 Explanation Please refer to page 521 of DMBOK2. Knowledge Area Big data and data science Question 19 Modeling Bid data is a non-technical challenge but critical if an organization that want to describe and govern its data. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 522 of DMBOK2. Knowledge Area Big data and data science Question 20 Business people must be fully engaged in order to realize benefits from the advanced analytics. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 524 of DMBOK2. Knowledge Area Big data and data science Chapter 15 Question 1 CMA is an abbreviation for Capability Maturity Assessment. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 531 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 2 Organizations conduct capability maturity assessments for a number of reasons, including: Question Type multi-select Answer 1 Organizational change Answer 2 Data management issues Answer 3 Regulation Answer 4 Data governance Answer 5 Data modeling Answer 6 New technology Correct Response 1,2,3,4,6 Explanation Please refer to page 532 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 3 A Data Management Maturity Assessment (DMMA) can be used to evaluate data management overall, or it can be used to focus on a single Knowledge Area or even a single process. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 532 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 4 Deliverables in the data management maturity assessment context diagram include: Question Type multi-select Answer 1 Maturity baseline Answer 2 Roadmap Answer 3 Executive briefings Answer 4 Recommendations Answer 5 Risk assessment Answer 6 Ratings and ranks Correct Response 1,2,3,4,5,6 Explanation Please refer to page 533 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 5 The primary goal of data management capability assessment is to evaluate the current state of critical data management activities in order to plan for improvement. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 534 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 6 When selecting a DMM framework one should consider of it is repeatable. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 546 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 7 The IBM Data Governance Council model is organized around four key categories. Select the answer that is not a category. Question Type multiple-choice Answer 1 Outcomes Answer 2 System Lifecycles Answer 3 Enablers Answer 4 Core disciplines Answer 5 Supporting disciplines Correct Response 2 Explanation Please refer to page 538-539 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 8 A communication plan includes an engagement model for stakeholders, the type of information to be shared, and the schedule for sharing information. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 545 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 9 Oversight for the DMMA process belongs to the Data Quality team. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to page 548 of DMBOK2. Knowledge Area Data Management Maturity Assessment Question 10 DMMA ratings represent a snapshot of the organization’s capability level. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 548 of DMBOK2. Knowledge Area Data Management Maturity Assessment Chapter 16 Question 1 A critical step in data management organization design is identifying the best-fit operating model for the organization. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 553 of DMBOK2. Knowledge Area Data Management Organization and Role Expectations Question 2 RACI is an acronym that is made up of the following terms. Question Type multi-select Answer 1 Control Answer 2 Responsible Answer 3 Accountable Answer 4 Informed Answer 5 Reliable Answer 6 Consulted Correct Response 2,3,4,6 Explanation Please refer to page 554 of DMBOK2. Knowledge Area Data Management Organization and Role Expectations Question 3 Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 1 Explanation Please refer to page 554 of DMBOK2. Knowledge Area Data Management Organization and Role Expectations Question 4 Data management organizational constructs include the following type of model. Question Type multi-select Answer 1 Network operating model Answer 2 Decentralized operating model Answer 3 Centralized operating model Answer 4 Federation operating model Answer 5 Hybrid operating model Answer 6 Integrated operating model Correct Response 1,2,3,5 Explanation Please refer to page 553-557 of DMBOK2. Knowledge Area Data Management Organization and Role Expectations Question 5 Factors that have shown to play a key role in the success in the success of effective data management organizations does not include: Question Type multiple-choice Answer 1 Clear vision Answer 2 Orientation and training Answer 3 Leadership alignment Answer 4 IT sponsorship Correct Response 4 Explanation Please refer to page 559 of DMBOK2. Knowledge Area Data Management Organization and Role Expectations Question 6 Communication should start later in the process as too many inputs will distort the vision. Question Type multiple-choice Answer 1 True Answer 2 False Correct Response 2 Explanation Please refer to pag