DMF-1220 Practice Exam Questions and Answers

A.  

Managing performance of data assets

B.  

Focus on the business goals

C.  

Managing the availability of data throughout the data lifecycle

D.  

Start with the end in mind

E.  

Managing the performance of data transactions

F.  

Collaborate

A.  

TRUE

B.  

FALSE

A.  

Write the Data Security Policy

B.  

Send all Data Security questions to the legal department

C.  

Have no role in the Data Security Policy

D.  

Review and approve the Data Security Policy

E.  

Own and maintain the Data Security Policy

A.  

Metadata

B.  

Data architecture

C.  

Data governance

D.  

Data security

E.  

Data modelling and design

F.  

Data storage and operations

A.  

To estimate the enterprise needs for these services and provide the justification for staffing and funding to provide these services

B.  

To provide a funnel for data and information issues to take the administration load off IT

C.  

To ensure that data and information is still managed by IT and business only plays an advisory role

D.  

To enable the business to maintain oversight on data and information projects

E.  

To provide data stewards as and when needs to perform services where IT resources are either not available or do not exist

A.  

Business data modelling

B.  

Business rules

C.  

Business continuity

D.  

Hardware sales

E.  

Business process optimization

A.  

FALSE

B.  

TRUE

A.  

TRUE

B.  

FALSE

A.  

The source system populates specific data elements.

B.  

Application automated interfaces

C.  

The source system processes copy data that has changed into a separate object as part of the transaction, which is then used for the extract process.

D.  

The source systems send binary code through ASCI that makes the process rapid.

E.  

The source system processes add to a simple list of objects and identifiers when changing data, which is then used to control selection of data extraction.

F.  

None of the above

A.  

Also known as a candidate key, it is a superkey without duplicated attributes. I.e., any set of attributes without duplicates that uniquely identify an entity instance

B.  

A synonym for a surrogate key

C.  

An artificial key, made up of several meaningful components to help the reader understand the nature of the entity from the key alone

D.  

Any set of attributes where each attribute that makes up the key is a foreign key in its own right

E.  

A type of advanced index key structure, in the same family as Hash, Heap, B-Tree, and Inverted

A.  

A way of sewing together different data concepts into a single data warehouse

B.  

A metadata repository

C.  

A form of data lake that automates data acquisition and initial data quality processing

D.  

A superior star schema strategy

E.  

Just another data warehouse with no distinguishing features

A.  

Primary key

B.  

Foreign key

C.  

Network key

D.  

Applications key

E.  

Door key

F.  

All of the above

A.  

FALSE

B.  

TRUE

A.  

Schema

B.  

Database

C.  

Node

D.  

Instance

A.  

TRUE

B.  

FALSE