DMF-1220 Data Management Fundamentals Question and Answers

Data governance requires control mechanisms and procedures for, but not limited to, identifying, capturing, logging and updating actions.

Instant Messaging (IM) allows a user to message each other in real-time.

Poorly managed metadata leads to:

A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process.

One common KPI of e-discovery is cost reduction.

Data replication can be active or passive.

The goals of data storage and operations include:

A change management program supporting formal data governance should focus communication on:

Obtaining buy-in from all stakeholders

Risk classifications describe the sensitivity of the data and the likelihood that it might be sought after for malicious purposes.

To build models, data modellers heavily rely on previous analysis and modelling work.

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

In the Abate Information Triangle the past moves through the following echelons befor it comes insight:

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

In an information management context, the short-term wins and goals often arise from the resolution of an identified problem.

The best preventative action to prevent poor quality data from entering an organisation include:

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

Time-based patterns are used when data values must be associated in chronological order and with specific time values.

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

The term data quality refers to only the characteristics associated with high quality data.

The ethics of data handling are complex, but is centred on several core concepts. Please select the correct answers.

Enterprise Architecture domains include:

Access to data for Multidimensional databases use a variant of SQL called MDX or Multidimensional expression.

Data governance and IT governance are the same thing.

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

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:

Class operations can be:

Domains can be identified in different ways including: data type; data format; list; range; and rule-based.

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.

Business requirements is an input in the Data Warehouse and Business Intelligence context diagram.

Document and content management is defined as planning, implementation and control activities for storage management of data and information found in any form or medium.

Normalisation is the process of applying rules in order to organise business complexity into stable data structures.

Deliverables in the data management maturity assessment context diagram include:

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

A ‘Golden Record’ means that it is always a 100% complete and accurate representation of all entities within the organization.

Technical Metadata provides data about the technical data, the systems that store data, and the processes that move between systems.

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

Business Intelligence tool types include:

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

Deliverables in the document and content management context diagram include:

Data modelling is most infrequently performed in the context of systems and maintenance efforts, known as SDLC.

Please select the answer that best fits the following description: Contains only real-time data.

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

Data profiling is a form of data analysis used to inspect data and assess quality.

ISO 8000 will describe the structure and the organization of data quality management, including:

What type of key is used in physical and sometimes logical relational data modelling schemes to represent a relationship?

The first two steps of the Reference data Change request process, as prescribed DMBOk2, include:

Value is the difference between the cost of a thing and the benefit derived from that thing.

Please select the correct component pieces that form part of an Ethical Handling Strategy and Roadmap.

The four A’s in security processes include:

Temporal aspects usually include:

Please select correct term for the following sentence: Any collection of stored data regardless of structure or content. Some large databases refer to instances and schema.

Customer relationship management systems manage Master Data about customers.

Machine learning explores the construction and study of learning algorithms.

There are numerous methods of implementing databases on the cloud. The most common are:

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

A control activity in the metadata management environment includes loading statistical analysis.

BI tool types include:

Data and enterprise architecture deal with complexity from two viewpoints:

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

The primary goal of data management capability assessment is to evaluate the current state of critical data management activities in order to plan for improvement.

An implemented warehouse and its customer-facing BI tools is a technology product.

Data Storage and Operations: The design, implementation and support of stored data to maximize its value.

Please select the three types of data models:

The flow of data in a data integration solution does not have to be designed and documented.

Coupling describes the degree to which two systems are intertwined.

Inputs in the data modelling and design context diagram include:

A data governance strategy defines the scope and approach to governance efforts. Deliverables include:

When constructing models and diagrams during formalisation of data architecture there are certain characteristics that minimise distractions and maximize useful information. Characteristics include:

The deliverables of the data modelling process include: