DMF-1220 Exam Questions

The Data Warehouse (DW) is a combination of three primary components: An integrated decision support database, related software programs and business intelligence reports.

Within projects, conceptual data modelling and logical data modelling are part of requirements planning and analysis activities, while physical data modelling is a design activity.

A dimensional physical data model is usually a star schema, meaning there is one structure for each dimension.

Data Warehouse describes the operational extract, cleansing, transformation, control and load processes that maintain the data in a data warehouse.

A Metadata repository contains information about the data in an organization, including:

ANSI 859 recommends taking into account the following criteria when determining which control level applies to a data asset:

Inputs in the data quality context diagram include:

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

Big data primarily refers specifically to the volume of the data.

Accomplish repository scanning in two distinct approaches, including:

A change management program supporting formal data governance should focus communication on: Obtaining buy-in from all stakeholders

XML is the abbreviation for standard mark-up language.

Issue management is the process for identifying, quantifying, prioritizing and resolving data governance related issues, including:

When assessing security risks it is required to evaluate each system for the following:

A general principle for managing metadata includes Responsibility.

Possible application coupling designs include:

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

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

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

Layers of data governance are often part of the solution. This means determining where accountability should reside for stewardship activities and who the owners of the data are.

Data flows map and document relationships between data and locations where global differences occur.

Uniqueness, as a dimension of data quality, states no entity exists more than once within the data set.

The biggest business driver for developing organizational capabilities around Big Data and Data Science is the desire to find and act on business opportunities that may be discover...

The four main types of NoSQL databases are:

Business rules describe why business should operate internally, in order to be successful and compliant with the outside world.

Different types of product Master Data solutions include:

Elements that point to differences between warehouses and operational systems include:

The deliverables of the data modelling process include:

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

An advantage of a centralized repository include: Quick metadata retrieval, since the repository and the query reside together.

SOA stands for:

One common KPI of e-discovery is cost reduction.

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

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; a...

Data security internal audits ensure data security and regulatory compliance policies are followed should be conducted regularly and consistently.

Controlling data availability requires management of user entitlements and of structures that technically control access based on entitlements.

Data governance requires control mechanisms and procedures for, but not limited to, assignment and tracking of action items.

Measuring the effects of change management on in five key areas including: Awareness of the need to change; Desire to participate and support the change; Knowledge about how to cha...

Managing business party Master Data poses these unique challenges:

Metrics tied to Reference and Master Data Quality include:

Databases are categorized in three general ways:

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

The warehouse has a set of storage areas, including:

Corporate Information Factory (CIF) components include:

Metadata is described using three sets od categories, including:

Metadata management solutions include architectural layers including:

Resource Description Framework (RDF), a common framework used to describe information about any Web resource, is a standard model for data interchange in the Web.

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

Coupling describes the degree to which two systems are intertwined.

Wat data architecture designs represent should be clearly documented. Examples include: