0% found this document useful (0 votes)
374 views

CDMP Mock Test 2

The document contains questions and answers about data governance. It covers topics like the role of data governance in regulatory compliance, appropriate organization structures for data governance, responsibilities for communication and promotion of data governance, and how to maintain stakeholder commitment to data initiatives. Key responsibilities of data governance are discussed such as defining security policies and reviewing classification frameworks.

Uploaded by

iamjainneha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
374 views

CDMP Mock Test 2

The document contains questions and answers about data governance. It covers topics like the role of data governance in regulatory compliance, appropriate organization structures for data governance, responsibilities for communication and promotion of data governance, and how to maintain stakeholder commitment to data initiatives. Key responsibilities of data governance are discussed such as defining security policies and reviewing classification frameworks.

Uploaded by

iamjainneha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 19

Question 1

0 / 1 pts
Every enterprise is subject to many governmental and industry regulations, many of which
regulate how data and information is used and managed. Part of the Data Governance
Function is to:
You Answered

Enforce enterprise-wide mandatory compliance to regulations

This is a risk and audit responsibility; Data Governance plays no role in this

This is about data; Data Governance is accountable for the whole process, with Risk and
Audit reporting to DG

Perform ad-hoc audits of possible regulations to report to the DG Council on an information


only basis

Monitor and ensure that organisations meet any regulatory compliance requirements

Question 2
1 / 1 pts
What Organization Structure should set the overall direction for Data Governance?

IT Leadership Team
Correct!

Data Governance Steering Committee

Data Quality Board

PMO

Data Governance Office

Question 3
1 / 1 pts
Which of these are NOT true of Data Governance?

DG is the exercise of authority and control over the management of data assets

IT is a key stakeholder in DG

DG is a continuous process of data improvement

There are different organization models for DG

Correct!
A DG initiative should always be led by the IT department

Question 4
0 / 1 pts
Who is most responsible for communicating and promoting awareness on the value of Data
Governance in the organization?

Data Owners and Stewards

Data Champions

You Answered

The Data Governance Council

Everyone in the Data Management Community

The Data Governance Office

Question 5
1 / 1 pts
How do data management professionals maintain commitment of key stakeholders to the data
management initiative?
It is not necessary, as the stakeholders signed up at the beginning of the program

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

Rely on the stakeholder group to be self-sustaining

Find and deliver benefits to the stakeholders early in the initiative

Correct!
Continuous communication education and promotion of the importance and value of
of data and information assets

Question 6
1 / 1 pts
An umbrella term for any classification or controlled vocabulary is:

Metadata

Correct!
Taxonomy

English

Dictionary

Data model

Question 7
1 / 1 pts
Non value-added information is often not removed because:

Data is an asset. It is likely to be recognized as valuable in the future

We might need the information at a later stage


Legislation is unclear on what should be kept

Correct!
The policies are unclear of what is defined as non-value-added, storage is cheap so there
is no cost driver, and it takes more effort to dispose than to keep

It should not be removed. All data is value-added

Question 8
1 / 1 pts
Documents and records should be classified based on the _______ level of confidentiality for
information found in the record.

Average

General

Overall
rect!

Highest

Question 9
1 / 1 pts
Which of these describes activities in the document/record management lifecycle?

Encryption, backup, disposal, extraction

Storage, disposal, managing access

Acquisition, classification, storage, purging

Acquisition, editing, storage, printing, backup, disposal


Correct!

Identification, management of policies, classification, retention, storage, retrieval and


circulation, preservation and disposal

Question 10
0 / 1 pts
Which statement best describes the relationship between documents and records?

Documents are written and records are audio

Records are a sub-set of documents

Documents and records are the same thing

Documents and records are not related

You Answered

Documents are a sub-set of records

Question 11
0 / 1 pts
Which of these statements has the most meaningful relationship label?

An order is related to order lines

An order is connected with order lines

An order is associated with order lines

An order is composed of order lines

You Answered
An order line contains orders

Question 12
0 / 1 pts
What is the difference between cardinality rules and data integrity rules?

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

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

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

You Answered

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

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

Question 13
1 / 1 pts
What are relationship labels?

A non-identifying relationship

A foreign key that has been role-named

Correct!

The verb phrases describing the business rules in each direction between two entities

The nullability setting on a foreign key


A relationship without cardinality

Question 14
1 / 1 pts
The highest level of these data model types is the:

Logical model

Correct!
Conceptual model

Physical model

Database model

Dimensional model

Question 15
1 / 1 pts
All of the following are TRUE statements on relationship types except:

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

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

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

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

A many-to-many relationship says that an instance of each entity may be associated with
many instances of the other entity, and vice versa
Question 16
1 / 1 pts
Top down' and 'bottom up' data analysis and profiling is best done in concert because:

It allows the profiler to show the business the true state of the data

It gets everyone involved


orrect!

It balances business relevance and the actual state of the data

It gives something for the architects to do while the profilers get on with the work

Data quality tools are more productive when they are effectively configured

Question 17
1 / 1 pts
What is Manual Directed Data Quality Correction?

The use of spreadsheets to manually inspect and correct data

The automation of all data cleanse and correction routines


ect!

The use of automated cleanse and correction tools with results manually checked before
committing outputs

Teams of data correctors supervised by data subject matter experts

Using a data quality improvement manual to guide data cleanse and correction activities

Question 18
0 / 1 pts
The Data Quality Management cycle has four stages. Three are Plan, Monitor and Act. What
is the fourth stage?
Manage

Reiterate

You Answered

Improve

Prepare

Deploy

Question 19
1 / 1 pts
Data quality measurements can be taken at three levels of granularity. They are:

Historical data, current data and future dated data

Departmental data, regional data, and enterprise data

Correct!
Data element value, data instance or record, and data set

Fine data, coarse data, and rough data

Person data, location data, and product data

Question 20
1 / 1 pts
Which of these is a key process in defining data quality business rules?

De-duplicating data records

Producing data quality reports & dashboards


Producing data management policies

Matching data from different data sources

Correct!
Separating data that does not meet business needs from data that does

Question 21
1 / 1 pts
Which of these are increasingly driving legislation for information security and data privacy?

GDPRrect!

A recognition of Ethical issues in information management

An objective of making life more challenging for information management professionals

A desire for economic protectionism

A resistance to open data and transparency

Question 22
1 / 1 pts
Which of these statements best defines Data Security Management?
Correct!

The planning, development, and execution of security policies and procedures to


provide proper authentication, authorization, access, and auditing of data and
information assets

The definition of controls, technical standards, frameworks, and audit trail capabilities to
identify who has or has had access to information

The planning, implementation, and testing of security technologies, authentication


mechanisms, and other controls to prevent access to information
None of these

The implementation and execution of checkpoints, checklists, controls, and technical


mechanisms to govern the access to information in an enterprise

Question 23
1 / 1 pts
What is the role of the Data Governance Council in defining an Information Security policy?

The Data Governance Council should implement the Data Security Policy

Correct!
The Data Governance Council should review and approve the high-level Data Security
Policy

The Data Governance Council should define the Data Security Policy

The Data Governance Council should draft early versions of the Data Security Policy

The Data Governance Council should have no role in Data Security

Question 24
0 / 1 pts
Stakeholders whose concerns must be addressed in data security management include:

External Standards organisations, Regulators, or the Media

You Answered

All of these

Media analysts, Internal Risk Management, Suppliers, or Regulators

Clients, Patients, Citizens, Suppliers, or Business Partners


The Internal Audit and Risk committees of the organisation

Question 25
1 / 1 pts
Which of the following define the data security touch points in an organisation?

Industry standards

Risk Assessment

Internal Audit

Correct!
Business rules and process workflow

Legislation

Question 26
0 / 1 pts
Which of the following is not a good example of BI?

Statutory reporting to a Regulatory Body

Strategic Analytics for Business Decisions

You Answered

Supporting Risk Management Decision Reporting

Decision Support Systems

Question 27
1 / 1 pts
You need to discover possible relationships or to show data patterns in an exploratory fashion
when you do not necessarily have a specific question to ask. What kind of data tool would
you use to identify patterns of data using various algorithms?

Meta-Data Data Lineage View

Data Quality Profilerct!

Data Mining

Data Visualisation Application

ETL Jobs

Question 28
0 / 1 pts
A Data Integration approach that updates a Data Warehouse with small changes from
Operational systems is called:

EII

CDC

ELT

SOA

You Answered

ETL

Question 29
1 / 1 pts
One of the key differences between operational systems and data warehouses is:

Operational systems focus on historical data; data warehouses contain current data
Operational systems focus on business processes; data warehouses focus on business
strategies
Correct!

Operational systems focus on current data; data warehouses contain historical data

Operational systems focus on data quality; data warehouses focus on data security

Operational systems are available 24x7; data warehouses are available during business hours

Question 30
1 / 1 pts
When performing an evaluation of analytic applications, which of the following questions is
least relevant to identify the level of effort needed?
Correct!

Annual costs such as license, maintenance, etc.

The Standard source systems for which ETL is supplied

How much of the tool infrastructure meets our organisational infrastructure

Number of source systems we need to integrate into the tool

How much do the canned processes in the tool match our business

Question 31
0 / 1 pts
Reference data:

Is always supplied by outside vendors

Has obvious definitions


You Answered

When incorrect has a greater impact than errors in Master and Transaction data

Is used to categorize and classify other data

Has limited value

Question 32
0 / 1 pts
Master Data Management:

Is time-consuming with questionable impact on data quality

Ensures coded values are always used

Is synonymous with Reference Data Management

Controls the definition of business entities


You Answered

Allows applications to define business entities as needed and manages the mappings between
common data in a central location

Question 33
1 / 1 pts
Which of these is a valid definition of Master Data?

Data that is only held in one data source

Data that if missing or incorrect will cause transactions and processes to fail

Data that rarely, if ever, changes


Data that other data sits hierarchically beneath

Correct!
Data about the business entities that provide context for business transactions

Question 34
0 / 1 pts
Which of the following is NOT a primary Master Data Management area of focus?

Providing access to golden data records

Producing read only versions of key data items

Identifying duplicate records

Generating a golden record/best version of the truth

You Answered

Producing clear data definitions for Master Data

Question 35
1 / 1 pts
Which of these is a valid definition of Reference Data?

Data that has a common and widely understood data definition


ect!

Data used to classify or categorize other data

Data that provides metadata about other data entities

Data that is widely accessed and referenced across an organisation

Data that is fixed and never changes


Question 36
0 / 1 pts
Which of these statements are true about Metadata?

The repository is always a decentralized architecture

Data models are components of a Metadata repository


You Answered

The repository is always a centralized architecture

The repository is always a hybrid architecture

A Metadata repository and a Glossary are synonyms

Question 37
0 / 1 pts
Metadata repository processes will not include:

All of these

Controlling versions of data product will be required to manage the required single published
master copy in conjunction with the variants potentially established as work in progress

You Answered

Assessing impact where change to existing data product entries are proposed e.g. the impact
of change on related data on other systems

Selecting Data Management Library software, search, and storage technologies

Managing change to data products (e.g. Data Dictionary or Business Data Glossary) entries
e.g. new data term to be defined, new data requirement, new database tables added, new
system included into the technical landscape
Question 38
0 / 1 pts
The MetaData repository enables us to establish multiple perspectives of data. These are:

Internal and External

Business and Technical Perspective

3rd normal form and un normalised

You Answered

Dimensional and non dimensional perspective

Structured and unstructured

Question 39
0 / 1 pts
A business perspective product in the MetaData repository is:

ETL flow

Physical Data Model

Systems Inventory

You Answered

Data Dictionary

Data Glossary

Question 40
1 / 1 pts
The number of artifacts that must be searched in the Metadata repository for all Business
change projects are:

Conceptual, Logical and Physical models must be examined

Correct!
There is no mandatory number of artefacts to be searched but it is highly recommended
that the library is examined

The Business Data Glossary and Data Dictionary must be examined

Conceptual data models and the Business Data Glossary must be examined

The Business Data Glossary and Systems Inventory must be consulted

You might also like