DMF-1220 Sample Questions Answers

Corrective actions are implemented after a problem has occurred and been detected.

The accuracy dimension has to do with the precision of data values.

Data governance and IT governance are the same thing.

Please select the correct general cost and benefit categories that can be applied consistently within an organization.

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:

Metadata management solutions include architectural layers including:

Change Data Capture is a method of reducing bandwidth by filtering to include only data that has been changed within a defined timeframe.

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

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:

A goal of data architecture is to identify data storage and processing requirements.

Data science depends on:

A node is a group of computers hosting either processing or data as part of a distributed database.

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

Tools required to manage and communicate changes in data governance programs include

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.

Volume refers to the amount of data. Big Data often has thousands of entities or elements in billions of records.

The Data Model Scorecard provides 10 data model quality metrics

CMA is an abbreviation for Capability Maturity Assessment.

Logical abstraction entities become separate objects in the physical database design using one of two methods.

The acronym CMDB stands for:

Data quality management is a key capability of a data management practice and organization.

Technical metadata describes details of the processing and accessing of data.

Triplestores can be classified into these categories:

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

Please select the 2 frameworks that show high-level relationships that influence how an organization manages data.

A goal of Data warehouse and business intelligence is to support and enable ineffective business analysis and decision making by knowledge workers.

Examples of technical metadata include:

Please select the correct principles of the General Data Protection Regulation (GDPR) of the EU.

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

The goals of data security include:

Archiving is the process of moving data off immediately accessible storage media and onto media with lower retrieval performance.

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

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.

Issues caused by data entry processes include:

The most common drivers for initiating a Mater Data Management Program are:

The language used in file-based solutions is called MapReduce. This language has three main steps:

Enterprise data architecture description must include both [1] as well as [2]

Data governance requires control mechanisms and procedures for, but not limited to, facilitating subjective discussions where managers’ viewpoints are heard.

There are three techniques for data-based change data capture, namely:

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

Field overloading: Unnecessary data duplication is often a result of poor data management.

Enterprise data architecture influences the scope boundaries of project and system releases. An example of influence is data replication control.

The deliverables in the data architecture context diagram include:

Data modeller: responsible for fata model version control an change control

Please select the correct name for the LDM abbreviation

Select three correct attributes a data governance programme must be:

BI tool types include:

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.

The acronym BASE is made up of:

Accomplish repository scanning in two distinct approaches, including:

Business activity information is one of the types of data that can be modelled.

Content needs to be modular, structured, reusable and device and platform independent.

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.

Communication should start later in the process as too many inputs will distort the vision.

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.

Effective data management involves a set of complex, interrelated processes that enable an organisation to use its data to achieve strategic goals.

Data flows map and document relationships between data and:

An input in the Metadata management context diagram does not include:

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

Examples of data enhancement includes:

Data professionals involved in Business Intelligence, analytics and Data Science are often responsible for data that describes: who people are; what people do; where people live; and how people are treated. The data can be misused and counteract the principles underlying data ethics.

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

Reference and Master Data Management follow these guiding principles:

DBAs and database architects combine their knowledge of available tools with the business requirements in order to suggest the best possible application of technology to meet organizational goals.

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.

The data in Data warehouses and marts differ. Data is organized by subject rather than function

A goal of data governance is to enable an organisation to manage its data as a liability.

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

To mitigate risks, implement a network-based audit appliance, which can address most of the weaknesses associated with the native audit tools. This kind of appliance has the following benefits: