Free DMF-1220 Practice Test Questions 2026

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

A. TRUE

B. FALSE

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

A. The DAMA Wheel

B. Supertype partition

C. Subtype partition

D. Subtype absorption

E. Supertype absorption

Obfuscating or redacting data is the practice of making information anonymous ot removing sensitive information. Risks are present in the following instances:

A. Data storage

B. Data marketing

C. Data aggregation

D. Data marking

E. Data masking

F. Data integration

Common OLAP operations include:

A. Drill down/up

B. Roll-up

C. Slice

D. Dice

E. All of the above

F. Cut

A sandbox is an alternate environment that allows write-only connections to production data and can be managed by the administrator.

A. TRUE

B. FALSE

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

A. TRUE

B. FALSE

Disciplines within the enterprise architecture practice does not include:

A. Technology architecture

B. Application architecture

C. Information architecture
Service Architecture

D. Business architecture

Self-service is a fundamental delivery channel in the BI portfolio.

A. TRUE

B. FALSE

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.

A. FALSE

B. TRUE

Metrics tied to Reference and Master Data quality include:

A. Strategic usage reporting

B. Amsterdam Information Model

C. Data change activity

D. Total cost of ownership

The Data Model Scorecard provides 10 data model quality metrics

A. TRUE

B. FALSE

Principles for data asset accounting include:

A. Accounting Principle

B. Due Diligence Principle

C. Asset Principle

D. Audit Principle

E. Going Concern Principle

F. All of the above