We would expect to consult the Metadata Library when:

Formulating a Governance policy

Implementing a Data Quality tool

Selecting a Data Storage device

What is the difference between an Industry and a Consensus Meta-Data Standard?

The terms are used interchangeably to describe the same concept.

Consensus standards are formed by an international panel of experts whereas industry standards are dictated by a panel of vendors.

Consensus standards are formed by government legislation whereas industry standards evolve from best practice.

Industry Standards refer to internationally approved global standards such as ISO whereas consensus standards refer to those agreed to within an organisation.

Industry standards are determined by regulators within a given global region and consensus standards are agreed on the Data Governance Council within an organisation.

Data Governance touch points throughout the project lifecycle are facilitated by this organization:

The Data Governance Steering Committee

A document management system is an application used to track and store electronic documents and electronic images of paper documents which provides the following capabilities:

Storage, versioning, security, meta-data management, indexing and retrieval

Scanning and transcoding of documents

Local disk storage and indexing of documents

Securing forwarding of documents to colleagues, never having to dispose of documents

Wiki, collaboration, online editing

Which of the following is the best example of the data quality dimension of 'consistency':

All the records in the CRM have been accounted for in the data warehouse

The customer file has 50% duplicated entries

The revenue data in the dataset is always $100 out

The source data for the end of month report arrived 1 week late

'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.

It balances business relevance and the actual state of the data.

Data quality tools are more productive when they are effectively configured.

A CRUD matrix helps organisations map responsibilities for data changes in the business process work flow. CRUD stands for:

Confidential, Restricted, Unclassified, Destroy

Create, React, Utilise, Delegate

Cost, Revenue, Uplift, Depreciate

What would you not expect to find in the MetaData repository

Data Lineage diagrams and models

Metadata repository processes will not include:

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.

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.

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

The library of information about our data (our metadata) is built so that:

We can have a shared formalised view of requirements (e.g. what data quality we need)

We can be consistent in our use of terminology

Which of these does NOT characterize an effective data steward?

Is a highly experienced technical expert in a variety of data management disciplines tools

Is a recognized subject matter expert in the data subject area / business domain that he or she is responsible for

He / She works in association with the Data Owner to protect and enhance the data assets under his or her control

He / she works collaboratively across the organization with data stakeholders and others identifying data problems issues

He / She is an effective communicator

Master Data Management:

Controls the definition of business entities

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

Ensures coded values are always used

Is synonymous with Reference Data Management

Is time-consuming with questionable impact on data quality

Which of these are NOT true of Data Governance?

A DG initiative should always be led by the IT department

There are different organization models for DG

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

DG is a continuous process of data improvement

Which of the following are primary deliverables of proper document and record management?

Managed records in many media formats, e-discovery records, policies and procedures, contracts and financial documents

Local drives of laptops, transcripts of phone calls

Spreadsheets, company library books, sales transactions

Relational databases, database logs, paper documents

Data from tracking devices, building sensor data

In Dimensional data models, which of these is NOT true regarding Measures:

Measures can always be added across all dimensions

Measures are found in Fact tables

Care must be taken if a measure is a snapshot figure

Just because a value is numerical does not mean it is a measure

Measures should be numeric and additive

A data quality program should limit its scope to:

The data most critical to the enterprise and its customers.

All the data stored in the enterprise.

The data that is of interest to the Chief Executive Officer.

The highest profile program with the best benefits.

The data that changes most often.

Which of these statements best defines Data Security Management?

The planning, development, and execution of security policies and procedures to provide proper authentication, authorization, access, and auditing of data and information assets

The planning, implementation, and testing of security technologies, authentication mechanisms, and other controls to prevent access to information

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

The implementation and execution of checkpoints, checklists, controls, and technical mechanisms to govern the access to information in an enterprise

Usually has fewer attributes than Master Data

Is more difficult to Govern than Master Data

Usually has more attributes than Master Data

According to the DAMA DMBoK, the Data Governance Council (DGC) is the highest authority organization for data governance in an organization. Who should typically chair this Council?

Chief Data Steward (Business) / Chief Data Officer

The chair should rotate across the Data Owners

The Chief Information Officer (CIO)

Any Executive / C-level participant in the DGC

In a recursive relationship

The foreign key must have a role name to avoid attribute duplication

The relationship could be an identifying relationship

None of these, recursive relationships are not allowed in Data Models

The relationship could be mandatory at either end

Data quality measurements can be taken at three levels of granularity. They are:

"Data element value, data instance or record, and data set."

"Person data, location data, and product data."

"Fine data, coarse data, and rough data."

"Historical data, current data and future dated data."

"Departmental data, regional data, and enterprise data."

When performing an evaluation of analytic applications, which of the following questions is least relevant to identify the level of effort needed?

Annual costs such as license, maintenance, etc.

No. of source systems we need to integrate into the tool

The Standard source systems for which ETL is supplied

How much of the tool infrastructure meets our organisational infrastructure

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

Critical to the incremental development of the data warehouse is:

A strong release management process

The assurance to include velocity, variety and veracity measurement

A strong capacity management process

A strong incident management process

The role of the Conceptual data model in the Metadata repository is:

To summarise the key data subject areas for a business area at a high level of abstraction to enable the major data concepts to be understood

To determine how many records are stored for each conceptual data entity

To agree the cardinality and optionality of relationships between all entities

To determine the primary, alternate and foreign keys of entities

Which of these is a valid definition of Reference Data?

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 has a common and widely understood data definition

Data that is fixed and never changes

Master data differs from Reference data in the following way:

Unlike Reference data, Master data is not usually limited to predefined domain values

Master data does not require a data steward

Master data is stipulated and controlled by Data Governance where Reference data is not

Master data should be held to a higher data quality standard than Reference data

Master data does not require business definitions

Which of these is a valid definition of Master Data?

Data about the business entities that provide context for business transactions

Data that is only held in one data source

Data that rarely, if ever, changes

Data that other data sits hierarchically beneath

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

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

Everyone in the Data Management Community

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

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

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

Write a report and discuss with management the required budget

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

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

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

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

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

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

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

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.

What is the difference between cardinality rules and data integrity rules?

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 define the quantity of each entity instance that can participate in a relationship between two entities and cardinality rules ensure valid values.

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

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

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

In a non-identifying relationship

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

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

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

The primary key of the child entity is concatenated

The primary key of the child entity is removed

CDMP

Authored by CDMP Practice

Information Technology (IT)

Professional Development

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

100 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What are relationship labels?

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

A foreign key that has been role-named.

The nullability setting on a foreign key.

A relationship without cardinality.

A non-identifying relationship.

Answer explanation

-

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of these statements has the most meaningful relationship label?

An order is related to order lines.

An order is composed of order lines.

An order is associated with order lines.

An order line contains orders.

An order is connected with order lines.

Answer explanation

-

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is not a good example of BI?

Strategic Analytics for Business Decisions

Supporting Risk Management Decision Reporting

Decision Support Systems

Statutory reporting to a Regulatory Body

Answer explanation

-

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of these is NOT a type of key found in a data model?

Surrogate key

Primary key

Foreign key

Local key

Alternate key

Answer explanation

-

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is a Meta-Data scheme focused specifically on documents?

Preservation Meta-Data

Structural Meta-Data

Business Meta-Data

Descriptive Meta-Data

Administrative Meta-Data

Answer explanation

-

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In 2009, ARMA International published GARP for managing records and information. GARP stands for:

G20 Approved Recordkeeping Principles

Generally Acceptable Recordkeeping Principles

Gregarious Archive of Recordkeeping Processes

Generally Available Recordkeeping Practices

Global Accredited Recordkeeping Principles

Answer explanation

-

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following define the data security touch points in an organisation?

Business rules and process workflow

Industry standards

Risk Assessment

Legislation

Internal Audit

Answer explanation

-

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Popular Resources on Wayground

20 questions

Math Review

Quiz

•

3rd Grade

15 questions

Fast food

Quiz

•

7th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

19 questions

Classifying Quadrilaterals

Quiz

•

3rd Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

10 questions

Identify Fractions, Mixed Numbers & Improper Fractions

Quiz

•

3rd - 4th Grade

Discover more resources for Information Technology (IT)

20 questions

Guess The App

Quiz

•

KG - Professional Dev...

10 questions

Food Quiz

Quiz

•

Professional Development

11 questions

NFL Football logos

Quiz

•

KG - Professional Dev...

19 questions

Minecraft

Quiz

•

6th Grade - Professio...

20 questions

Block Buster Movies

Quiz

•

10th Grade - Professi...

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

23 questions

super heros

Quiz

•

KG - Professional Dev...

11 questions

SOCCER PLAYERS AND TEAMS

Quiz

•

KG - Professional Dev...