Free DMF-1220 Exam Dumps Preview

Question 1

Single choice

A database uses foreign keys from code tables for column values. This is a way of implementing:

1. A

   Master data

2. B

   Event data

3. C

   Reference data

4. D

   Star schema data

5. E

   Temporal data

Reveal answer details Close answer details

Correct answerC

Question 2

Multiple choice

Examples of technical metadata include:

1. A

   Access permission

2. B

   Recovery and backup rules

3. C

   Colum properties

4. D

   Data subject properties

Reveal answer details Close answer details

Correct answersA, B, C, D

Question 3

Single choice

In Resource Description Framework (RDF) terminology, a triple store is composed of a subject that denotes a resource, the predicate that expresses a relationship between the subject and the object, and the object itself.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 4

Single choice

The best way to validate that a database backup is working is to:

1. A

   Check for the automatic email notification of backup success

2. B

   Check the size of the backup file

3. C

   Periodically recover from the backup file

4. D

   Appoint a special DBA in charge of backups

5. E

   Check the backup logs every day

Reveal answer details Close answer details

Correct answerC

Question 5

Single choice

On example of a transformation process in ETL is:

1. A

   Re-ordering

2. B

   Recording

3. C

   Duping

4. D

   Servicing

Reveal answer details Close answer details

Correct answerA

Question 6

Single choice

One of the percentages to measure success of a records management system implantation is the percentage of the identified corporate records declared as such and put under records control.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 7

Single choice

The IT security policy provides categories for individual application, database roles, user groups and information sensitivity.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 8

Single choice

The disclosure of sensitive addresses may occur through:

1. A

   Inappropriate use of photocopier toner

2. B

   Ineffective implementation of data architecture

3. C

   Cloud-based databases

4. D

   Stored procedures being called directly

5. E

   Software ignoring privacy tags on the data.

Reveal answer details Close answer details

Correct answerE

Question 9

Single choice

What type of key is used in physical and sometimes logical relational data modelling schemes to represent a relationship?

1. A

   Primary key

2. B

   Foreign key

3. C

   Network key

4. D

   Applications key

5. E

   Door key

6. F

   All of the above

Reveal answer details Close answer details

Correct answerB

Question 10

Multiple choice

Managing business party Master Data poses these unique challenges:

1. A

   Difficulties in unique dimensions

2. B

   Difficulties in unique identification

3. C

   Reference data anomaly detection

4. D

   The number of data sources and the differences between them

Reveal answer details Close answer details

Correct answersB, C, D

Question 11

Single choice

Which statement best describes the relationship between documents and records?

1. A

   Documents and records are the same thing

2. B

   Documents are written and records are audio

3. C

   Documents and records are not related

4. D

   Records are a sub-set of documents

5. E

   Documents are a sub-set of records

Reveal answer details Close answer details

Correct answerD

Question 12

Single choice

It is unwise to implement data quality checks to ensure that the copies of the attributes are correctly stored.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 13

Multiple choice

In designing and building the database, the DBA should keep the following design principles in mind:

1. A

   Assessments

2. B

   Maintainability

3. C

   Reusability

4. D

   Performance and ease of use

5. E

   Security

6. F

   Integrity

Reveal answer details Close answer details

Correct answersB, C, D, E, F

Question 14

Single choice

Data parsing is the process of analysing data using pre-determined rules to define its content or value.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 15

Single choice

How can the Data Governance process best support Regulatory reporting requirements?

1. A

   By providing a look up service for definitions

2. B

   By ensuring that data is properly owned, understood, defined, documented and controlled

3. C

   By performing a data audit

4. D

   By creating a map of the enterprise data stores where copies of information may be found

5. E

   By highlighting challenges of multiple definitions within the enterprise

Reveal answer details Close answer details

Correct answerB

Question 16

Single choice

To become data-centric, organizations need to think differently. They need to recognize:

1. A

   That managing data is the same as delivering reporting

2. B

   That managing data is different from managing IT

3. C

   That managing data is the same as making better business decisions

4. D

   That managing data is the same as managing finance

5. E

   That managing data is the same as managing IT

Reveal answer details Close answer details

Correct answerB

Question 17

Multiple choice

Enterprise Architecture domains include:

1. A

   Business Architecture

2. B

   Data Architecture

3. C

   Data Management Architecture

4. D

   Systems Architecture

5. E

   Application Architecture

6. F

   Technology Architecture

Reveal answer details Close answer details

Correct answersA, B, E, F

Question 18

Multiple choice

Device security standard include:

1. A

   Installation of anti-malware and encryption software

2. B

   Relational security policies

3. C

   Access policies regarding connections using mobile devices

4. D

   Regulation compliance standards

5. E

   None of the above

6. F

   Awareness of security vulnerabilities

Reveal answer details Close answer details

Correct answersA, C, F

Question 19

Single choice

What are the three qualities of an effective Data Governance function?

1. A

   Optimism, objective, sustainable

2. B

   Sustainable, embedded, measured

3. C

   Measured, objective, embedded

4. D

   Embedded, systematic, sustainable

5. E

   Sustainable, realistic, embedded

Reveal answer details Close answer details

Correct answerD

Question 20

Single choice

An application DBA leads the review and administration of procedural database objects.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 21

Multiple choice

Examples of interaction models include:

1. A

   Hub-and-spoke

2. B

   Publish - subscribe

3. C

   Point-to-point

4. D

   Wheel-and-spike

Reveal answer details Close answer details

Correct answersA, B, C

Question 22

Single choice

Operationality and interoperability depends on the data quality. In order to measure the efficiency of a repository the data quality needs to be:

1. A

   Stored in a Cloud for easy access

2. B

   Quantified by some type of metrics

3. C

   Be certified by a Data Governance team

4. D

   Have complete definitions

5. E

   Verified by the organization's legal department

Reveal answer details Close answer details

Correct answerB

Question 23

Multiple choice

The Shewhart chart contains the following elements:

1. A

   Plan

2. B

   Utilization

3. C

   Do

4. D

   Check

5. E

   Act

6. F

   All of the above

Reveal answer details Close answer details

Correct answersA, C, D, E

Question 24

Single choice

Characteristics that minimise distractions and maximise useful information include, but not limited to, consistent object attributes

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 25

Single choice

Achieving near-real-time data replication, using a source accumulation technique, triggers on:

1. A

   Posting of messages on the enterprise bus

2. B

   Arrival of streaming data

3. C

   Daily batch loads

4. D

   Reaching a threshold or frequency schedule

5. E

   Request from a target system to pull data

Reveal answer details Close answer details

Correct answerD

Question 26

Single choice

A sandbox environment can either be a sub-set of the production system, walled off from production processing or a completely separate environment.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 27

Single choice

The steps followed in managing data issues include:

1. A

   Standardization, Allocation, Assignment, and Correction

2. B

   Standardization, Explanation, Ownership, and Completion

3. C

   Read, Guess, Code, Release

4. D

   Standardization, Assignment, Escalation, and Completion

5. E

   Escalation, Review, Allocation and Completion

Reveal answer details Close answer details

Correct answerD

Question 28

Multiple choice

Inputs in the Data Integration and Interoperability context diagram include:

1. A

   Data needs & standards

2. B

   Data semantics

3. C

   Business goals & strategies

4. D

   Source data

Reveal answer details Close answer details

Correct answersA, B, C, D

Question 29

Single choice

Real-time data integration is usually triggered by batch processing, such as historic data.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 30

Multiple choice

A change management program supporting formal data governance should focus communication on:

Obtaining buy-in from all stakeholders

1. A

   Implementing data management training

2. B

   Monitoring the resistance

3. C

   Promoting the value of data assets

4. D

   Addressing all queries

5. E

   Implementing new metric and KPIs

Reveal answer details Close answer details

Correct answersA, C, E

Question 31

Single choice

Subtype absorption: The subtype entity attributes are included as nullable columns into a table representing the supertype entity

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 32

Multiple choice

The four main types of NoSQL databases are:

1. A

   Document

2. B

   Row-orientated

3. C

   Graph

4. D

   Strategic

5. E

   Key-value

6. F

   Column-orientated

Reveal answer details Close answer details

Correct answersA, C, E, F

Question 33

Single choice

One of the first steps in a master data management program is to:

1. A

   Decommission similar data collection systems

2. B

   Review data security protocols

3. C

   Secure funding for 20 years of operations

4. D

   Build multiple data marts

5. E

   Evaluate and assess data sources

Reveal answer details Close answer details

Correct answerE

Question 34

Single choice

In Data Modelling, the generalization of the concept of person and organization into a party enables:

1. A

   The implementation of relationships between persons and organizations

2. B

   Single person organizations to be managed consistently

3. C

   Faster implementation into packages that use the same vocabulary

4. D

   Them to act in roles in agreements, shared address usages, and common interaction processes

5. E

   Greater security as users are unaware if this party is a person or an organization

Reveal answer details Close answer details

Correct answerD

Question 35

Multiple choice

Match rules for different scenarios require different workflows, including:

1. A

   Consistency rules

2. B

   Duplicate identification match rules

3. C

   Match-merge rules

4. D

   Match-split rules

5. E

   Match-link rules

6. F

   All of the above

Reveal answer details Close answer details

Correct answersB, C, E

Question 36

Single choice

The loading of country codes into a CRM is a classic:

1. A

   Reference data integration

2. B

   Fact data integration

3. C

   Master data integration

4. D

   Analytics data integration

5. E

   Transaction data integration

Reveal answer details Close answer details

Correct answerA

Question 37

Multiple choice

ISO 8000 will describe the structure and the organization of data quality management, including:

1. A

   Data Quality Availability

2. B

   Data Quality Planning

3. C

   Data Quality Control

4. D

   Data Quality Assurance

5. E

   Data Quality Improvement

Reveal answer details Close answer details

Correct answersB, C, D, E

Question 38

Multiple choice

Business glossaries have the following objectives:

1. A

   Improve the alignment between technology assets and the business organization

2. B

   All of the above

3. C

   Cultural factors that might improve the concepts and terminology

4. D

   Maximise search capability and enable access to documented institutional knowledge

5. E

   Enable common understanding of the core business concepts and terminology

6. F

   Reduce the risk that data will be misused due to inconsistent understanding of the business concepts.

Reveal answer details Close answer details

Correct answersA, D, E, F

Question 39

Single choice

JSON is an open, lightweight standard format for data interchange.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 40

Single choice

A metadata repository is essential to assure the integrity and consistent use of an enterprise data model across business processes.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 41

Single choice

An organization will create an uncover valuable Metadata during the process of developing Data Integration and Interoperability solutions.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 42

Single choice

Which of the following activities is most likely to maintain bias in data analysis?

1. A

   Re-baselining the data set after each period of analysis to remove assumptions

2. B

   Working with external stakeholders to assess data quality

3. C

   Using more data sets with same data

4. D

   Remove sources of likely bias from data sets before analysis

5. E

   Using more data sets with diverse data sources

Reveal answer details Close answer details

Correct answerC

Question 43

Single choice

You have completed analysis of a Data Governance issue in your organisation and have presented your findings to the executive management team. However, your findings are not greeted warmly and you find yourself being blamed for the continued existence of the issue.

What is the most likely root cause for this?

1. A

   You did not secure appropriate budget or resources for the engagement and did not properly define the project charter

2. B

   You failed to correctly scope the analysis project and did not secure resources to deliver a fully executed solution to address root causes

3. C

   You failed to communicate to your team the importance of achieving a workable solution to the issues identified

4. D

   You failed to correctly manage expectations about the roles, responsibilities, and accountabilities for Data Governance in the organisation and are dependent on other areas to execute your recommendations

5. E

   You adopted an incorrect methodology to your Data Governance and have failed to execute necessary information management tasks

Reveal answer details Close answer details

Correct answerD

Question 44

Multiple choice

The ethics of data handling are complex, but is centred on several core concepts. Please select the correct answers.

1. A

   Impact on machines

2. B

   Impact on people

3. C

   Potential for data management

4. D

   Potential for misuse

5. E

   Economic value of ethics

6. F

   Economics value of data

Reveal answer details Close answer details

Correct answersB, D, F

Question 45

Single choice

A complexity in documenting data lineage is:

1. A

   Establishing data quality metrics

2. B

   Conflicting application requirements from data owners

3. C

   Choosing which content management software to use

4. D

   Identifying source databases

5. E

   Different data element names and formats

Reveal answer details Close answer details

Correct answerE

Question 46

Single choice

An organization can enhance its Data Governance program and thereby improve its approach to enterprise data management. This is important for the following reason:

1. A

   Since most organizations start Data Governance in silos and not at the enterprise level, it is important to be able to assess current state and determine desired targeted state that supports the overall vision

2. B

   Often organizations have a data repository or dictionary that is just as good as Data Governance

3. C

   Data Governance programs are rarely enhanced once they are launched

4. D

   Assessing current state for Data Governance may not tell the organization the current state of other components

5. E

   Starting a Data Governance program does not require that the organization start a data management program

Reveal answer details Close answer details

Correct answerA

Question 47

Multiple choice

Sample value metrics for a data governance program include:

1. A

   Reduction of risk

2. B

   Improved efficiency in operations

3. C

   Effectiveness of education

4. D

   Achievements of goals and objectives

5. E

   Contributions to business objectives

6. F

   Effectiveness of communication

Reveal answer details Close answer details

Correct answersA, B, E

Question 48

Single choice

Risk classifications describe the sensitivity of the data and the likelihood that it might be sought after for malicious purposes.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 49

Single choice

In a SQL injection attack, a perpetrator inserts authorized database statements into a vulnerable SQL data channel, such as a stored procedure.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerA

Question 50

Single choice

Data replication can be active or passive.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 51

Single choice

What model is the highest level model within the enterprise data model?

1. A

   Logical model

2. B

   Physical model

3. C

   Conceptual model

4. D

   Subject Area model

Reveal answer details Close answer details

Correct answerC

Question 52

Single choice

A deliverable in the data security context diagram is the data security architecture.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 53

Single choice

Please select the answer that does not represent a machine learning algorithm:

1. A

   Reinforcement learning

2. B

   Supervised learning

3. C

   Artificial learning

4. D

   Unsupervised learning

Reveal answer details Close answer details

Correct answerC

Question 54

Multiple choice

SPARC published their three-schema approach to database management. The three key components were:

1. A

   Internal

2. B

   Logical

3. C

   Generic

4. D

   Conceptual

5. E

   External

Reveal answer details Close answer details

Correct answersA, D, E

Question 55

Multiple choice

The goals of Data Integration and Interoperability include:

1. A

   Provide data securely, with regulatory compliance, in the format and timeframe needed.

2. B

   Lower cost and complexity of managing solutions by developing shared models and interfaces.

3. C

   Managing the availability of data throughout the data lifecycle

4. D

   Provide the starting point for customizations, integration or even replacement of an application

5. E

   Identify meaningful events and automatically trigger alerts and actions.

6. F

   Support business intelligence, analytics, master data management and operational efficiency efforts.

Reveal answer details Close answer details

Correct answersA, B, E, F

Question 56

Multiple choice

Why is it important to create short-term wins when rolling out a Data Governance initiative?

1. A

   Staff turnover in most organisations makes longer term planning impossible

2. B

   Short term wins help ensure on-going political support

3. C

   Short term wins help to distract stakeholders from delayed delivery on bigger issues

4. D

   You need to align your deliverables with internal project budgeting cycles

5. E

   People find it hard to sustain commitment to change if they do not see compelling results within a
   relatively short time period

Reveal answer details Close answer details

Correct answersB, E

Question 57

Single choice

Location Master Data includes business party addresses and business party location, as well as facility addresses for locations owned by organizations.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 58

Single choice

Data Management Professionals only work with the technical aspects related to data.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 59

Single choice

A key feature of the Bill Inmon's approach to data warehousing is:

1. A

   A preference for supporting operational reporting

2. B

   An exclusive focus on star schemas and cubes

3. C

   A normalized relational model to store and manage data

4. D

   A tight management of data dimensions

5. E

   Its ability to operate on open source platforms

Reveal answer details Close answer details

Correct answerC

Question 60

Single choice

Open by default' document control will assist data sharing by:

1. A

   Allocating more metadata to each document

2. B

   Automatically opening the document when it is selected on the desktop

3. C

   Keeping the documents open on the desktop ready for use

4. D

   Setting the security to shared unless overwritten

5. E

   Automatically moving the data to the warehouse where everybody can access it

Reveal answer details Close answer details

Correct answerD

Question 61

Multiple choice

The first two steps in the data science process are:

1. A

   Define Big Data data strategy & Business Need(s)

2. B

   Choose Data Sources

3. C

   Develop Data Science Hypotheses and Mehods

4. D

   Acquire & Ingest Data source(s)

Reveal answer details Close answer details

Correct answersA, B

Question 62

Multiple choice

Data quality rules and standards are a critical form of Metadata. Ti be effective they need to be managed as Metadata. Rules include:

1. A

   None of the above

2. B

   Tied to business impact

3. C

   Document consistency

4. D

   Accessible to all data customers

5. E

   Hierarchical consistency

6. F

   Confirmed by SMEs

Reveal answer details Close answer details

Correct answersB, C, D, F

Question 63

Single choice

A staff member has been detected inappropriately accessing client records from usage logs. The security mechanism being used is an:

1. A

   Access

2. B

   Audit

3. C

   Entitlement

4. D

   Authorisation

5. E

   Authentication

Reveal answer details Close answer details

Correct answerB

Question 64

Single choice

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.

1. A

   Principle of integrity

2. B

   Principle of availability

3. C

   Principle of retention

4. D

   Principle of accountability

Reveal answer details Close answer details

Correct answerD

Question 65

Single choice

Data replication is useful as it provides:

1. A

   The ability to spread the workload across multiple databases

2. B

   Opportunities to secure sensitive data

3. C

   An alternative to backups

4. D

   Enables different table structures to be built

5. E

   Insights into customer retention

Reveal answer details Close answer details

Correct answerA

Question 66

Single choice

As part of its transformation, the organization must identify and respond to different kinds of roadblocks.
Please select the answer that is not a roadblock:

1. A

   Active resistance

2. B

   Psychological

3. C

   Systematic

4. D

   Structural

Reveal answer details Close answer details

Correct answerC

Question 67

Single choice

A business driver for Master Data Management program is managing data quality.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 68

Single choice

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.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 69

Multiple choice

Select three correct attributes a data governance programme must be:

1. A

   Embedded

2. B

   Flexible

3. C

   Measures

4. D

   Rigid

5. E

   Independent responsibility

6. F

   Sustainable

Reveal answer details Close answer details

Correct answersA, C, F

Question 70

Single choice

An Operational Data Mart is a data mart focused on tactical decision support.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 71

Single choice

DMMA ratings represent a snapshot of the organization's capability level.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 72

Single choice

Malware refers to any infectious software created to damage, change or improperly access a computer or network.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 73

Single choice

Data lineage is useful to the development of the data governance strategy.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 74

Multiple choice

Advantages if a centralized metadata repository include:

1. A

   Quick metadata retrieval

2. B

   None of the above

3. C

   Combining data from multiple other tables in advance to avoid costly run-time joins

4. D

   All of the above

5. E

   High availability

6. F

   Low latency, since it is independent of the source systems

Reveal answer details Close answer details

Correct answersA, E

Question 75

Single choice

Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 76

Single choice

Basic profiling of data involves analysis of:

1. A

   Data sources, data visualisations, data latency and ownership

2. B

   Data clusters, data clouds, data repositories and metadata libraries

3. C

   Data lakes, data warehouses and operational data stores

4. D

   Data formats, data values, patterns and relationships

5. E

   Data criteria, data acquisition, data policy and procedures inside dataGovernance

Reveal answer details Close answer details

Correct answerD

Question 77

Multiple choice

Business Intelligence tool types include:

1. A

   Technology reporting

2. B

   Operational reporting

3. C

   Descriptive, self-service analytics

4. D

   Operations performance management (OPM)

5. E

   Business performance management (BPM)

6. F

   Predictive, self-service analytics

Reveal answer details Close answer details

Correct answersB, C, E

Question 78

Single choice

When developing a Data Governance operating framework, what areas should be considered?

1. A

   Impacts of regulations, the value of data to the organization, data modelling skills, & third-party data policies

2. B

   Data inputs, context diagrams, methods and procedures

3. C

   Data management skills, budget considerations & organization strategy

4. D

   Cultural factors, the role of a data steward, & third-party data policies

5. E

   A model that documents the business, cultural factors, the impacts of regulations, and the value of data to the organization

Reveal answer details Close answer details

Correct answerE

Question 79

Multiple choice

Inputs in the data storage and operations context diagram include:

1. A

   Data requirements

2. B

   Service level agreements

3. C

   Data Management Architecture

4. D

   Systems Architecture

5. E

   Data architecture

6. F

   Data models

Reveal answer details Close answer details

Correct answersA, B, E, F

Question 80

Multiple choice

Three data governance operating models types include:

1. A

   Centralized

2. B

   Decentralized

3. C

   Feathered

4. D

   Federated

5. E

   Replicated

6. F

   Duplicated

Reveal answer details Close answer details

Correct answersA, D, E

Question 81

Single choice

The Data Model Scorecard provides 10 data model quality metrics

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 82

Single choice

Repositories facilitate the collection, publishing and distribution of data in a centralized and possibly standardized way. Data is most often used to:

1. A

   Make sure the DBAs are not creating new tables and columns

2. B

   Document and organize the provided data

3. C

   To support the business users not the technical users

4. D

   Give developers all the data they will need for programming

5. E

   Find new initiatives for the business to pursue

Reveal answer details Close answer details

Correct answerB

Question 83

Single choice

Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 84

Single choice

Business Intelligence, among other things, refer to the technology that supports this kind of analysis.

1. A

   FALSE

2. B

   TRUE

Reveal answer details Close answer details

Correct answerB

Question 85

Single choice

Please select the answer that best fits the following description: Contains only real-time data.

1. A

   Batch layer

2. B

   Speed layer

3. C

   Serving layer

4. D

   Real-time layer

Reveal answer details Close answer details

Correct answerB

Question 86

Single choice

Assessment criteria are broken into levels, and most capability maturity models use five (5) levels. This is important since:

1. A

   It is not important how many levels there are; vendors do this to show they have a complex model

2. B

   Each capability level will have specific criteria associated with its completion. To move to the next higher level, all the capabilities of the current level must be satisfied

3. C

   Each capability is separate, so each level represents a separate stage in development

4. D

   Assessments are difficult and breaking them into levels makes them more difficult to perform

5. E

   The organization must be able to manage each criterion, and breaking them into levels is the only way to do that

Reveal answer details Close answer details

Correct answerB

Question 87

Single choice

In gathering requirements for DW/BI projects, begin with the data goals and strategies first.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 88

Multiple choice

Accomplish repository scanning in two distinct approaches, including:

1. A

   Semi-proprietary integration

2. B

   Proprietary interface

3. C

   Semi-proprietary interface

4. D

   Proprietary integration

Reveal answer details Close answer details

Correct answersB, C

Question 89

Single choice

The search function associated with a document management store is failing to return known artefacts.
This is due to a failure of:

1. A

   Effective data quality metrics

2. B

   Business intelligence implementation

3. C

   Maintaining public access to all documents in the document management store

4. D

   Maintaining appropriate metadata on each document

5. E

   Data privacy and confidentiality procedures

Reveal answer details Close answer details

Correct answerD

Question 90

Single choice

The acronym CMDB stands for:

1. A

   Customization management tools or databases

2. B

   Classic management technologies or databases

3. C

   Cached management technologies or databases

4. D

   Configuration management tools or databases

5. E

   Cached management tools or databases

6. F

   Classic monitoring technologies or databases

Reveal answer details Close answer details

Correct answerD

Question 91

Single choice

How do data management professionals maintain commitment of key stakeholders to the data management initiative?

1. A

   Talking to a stakeholder when passing them in the passage

2. B

   Weekly email reports showing metrics on data management progress/lack thereof

3. C

   Rely on the stakeholder group to be self-sustaining

4. D

   This is not necessary, stakeholders signed up at the beginning of the program

5. E

   Continuous communication identifying and promoting the value of data and information assets to the organization

Reveal answer details Close answer details

Correct answerE

Question 92

Multiple choice

Critical success factors throughout the BI/DW lifecycle include:

1. A

   Business readiness

2. B

   A clear and consistent focus

3. C

   Vision alignment

4. D

   Business sponsorship

5. E

   Linear symmetry

6. F

   A consistent line across display methods

Reveal answer details Close answer details

Correct answersC, D, F

Question 93

Single choice

Operational Metadata describes details of the processing and accessing of data. Which one is not an example:

1. A

   Error logs

2. B

   Schedule anomalies

3. C

   Purge criteria

4. D

   Failure logs

Reveal answer details Close answer details

Correct answerD

Question 94

Single choice

Data governance program must contribute to the organization by identifying and delivering on specific benefits.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 95

Single choice

When we consider the DMBoK2 definition of Data Governance, and the various practitioner definitions that exist in the literature, what are some of the key elements of Data Governance?

1. A

   Agreed models for data design and definition, decision rights regarding standards and controls, delegation of accountability

2. B

   Agreed models for decision making and decision rights, defined authority and escalation paths, structures for assigning accountability and delegating responsibility, alignment with business objectives

3. C

   Agreed architectures, transparent policies, shared language, effective tools, delegated authority,

   stewardship

4. D

   Exercise of authority, formalization of reporting lines, implementation of supporting technology, definition of common glossaries

5. E

   Alignment of Business and Technology strategies, definition of data standards, implementation of supporting metadata and process tools, management of responsibility

Reveal answer details Close answer details

Correct answerB

Question 96

Single choice

OCR is the abbreviation for Optical Character Recognition.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerA

Question 97

Single choice

Which artifact is the highest level of abstraction in the Enterprise Data Model?

1. A

   Data Ownership Model

2. B

   Top-level Process Model

3. C

   Subject Area Model

4. D

   Conceptual Model

5. E

   Systems Portfolio Model

Reveal answer details Close answer details

Correct answerD

Question 98

Single choice

Database monitoring tools measure key database metrics, such as:

1. A

   Capacity, availability, backup instances, data quality

2. B

   Capacity, design, normalization, user access

3. C

   Create, read, update, delete

4. D

   Create, read, normalization, user access

5. E

   Capacity, availability, cache performance, user statistics

Reveal answer details Close answer details

Correct answerE

Question 99

Single choice

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.

1. A

   TRUE

2. B

   FALSE

Reveal answer details Close answer details

Correct answerB

Question 100

Single choice

When presenting a case for an organization wide Data Governance program to your Senior Executive Board, which of these potential benefits would be of LEAST importance?

1. A

   Better corporate compliance with legal and regulatory demands, especially in relation to data protection, security and privacy

2. B

   Lower operational costs resulting from better data quality and a reduced need for cost of failure and rework activities

3. C

   The current corporate information policy states that company data must be managed and effectively governed

4. D

   Enhanced customer perceptions of your company's brand and enhanced customer acquisition, retention and loyalty

5. E

   New sales and revenue opportunities that better managed data will enable

Reveal answer details Close answer details

Correct answerC