DMF-1220 Practice Test Questions

479 Questions


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


A. TRUE


B. FALSE





A.
  TRUE

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





B.
  Supertype partition

D.
  Subtype 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





C.
  Data aggregation

D.
  Data marking

E.
  Data masking

Common OLAP operations include:


A. Drill down/up


B. Roll-up


C. Slice


D. Dice


E. All of the above


F. Cut





A.
  Drill down/up

B.
  Roll-up

C.
  Slice

D.
  Dice

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





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





A.
  TRUE

Disciplines within the enterprise architecture practice does not include:


A. Technology architecture


B. Application architecture


C. Information architecture
Service Architecture


D. Business architecture





C.
  Information architecture
Service Architecture

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


A. TRUE


B. FALSE





A.
  TRUE

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





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





C.
  Data change activity

D.
  Total cost of ownership

The Data Model Scorecard provides 10 data model quality metrics


A. TRUE


B. FALSE





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





F.
  All of the above


Page 9 out of 40 Pages
Previous