CDMP Mock Test 2
CDMP Mock Test 2
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
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
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!
PMO
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
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 Champions
You Answered
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
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:
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
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?
Question 10
0 / 1 pts
Which statement best describes the relationship between documents and records?
You Answered
Question 11
0 / 1 pts
Which of these statements has the most meaningful relationship label?
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
Correct!
The verb phrases describing the business rules in each direction between two entities
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 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 automated cleanse and correction tools with results manually checked before
committing outputs
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:
Correct!
Data element value, data instance or record, and data set
Question 20
1 / 1 pts
Which of these is a key process in defining data quality business rules?
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!
Question 22
1 / 1 pts
Which of these statements best defines Data Security Management?
Correct!
The definition of controls, technical standards, frameworks, and audit trail capabilities to
identify who has or has had access to information
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
Question 24
0 / 1 pts
Stakeholders whose concerns must be addressed in data security management include:
You Answered
All of these
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?
You Answered
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?
Data Mining
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!
How much do the canned processes in the tool match our business
Question 31
0 / 1 pts
Reference data:
When incorrect has a greater impact than errors in Master and Transaction data
Question 32
0 / 1 pts
Master Data Management:
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 if missing or incorrect will cause transactions and processes to fail
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?
You Answered
Question 35
1 / 1 pts
Which of these is a valid definition of Reference Data?
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
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:
You Answered
Question 39
0 / 1 pts
A business perspective product in the MetaData repository is:
ETL flow
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:
Correct!
There is no mandatory number of artefacts to be searched but it is highly recommended
that the library is examined
Conceptual data models and the Business Data Glossary must be examined