DMF-1220 Free Practice Test

Periodic archiving of transaction data from a production CRM system is critical for:

1. A. Training junior DBAs
2. B. Managing deleted customer records
3. C. The maintenance of database performance
4. D. Enabling the distribution of transaction data across the enterprise
5. E. Providing alternate sources for reporting systems

Correct Answer: C

Examples of transformation include:

1. A. Format changes, structure changes, replication conversion, re-duplication anddata ordering
2. B. Application changes, infrastructure changes, software conversion, de-duplicationand re- ordering
3. C. Data modelling changes, structure changes, metric conversion, de-duplicationand reordering
4. D. Format changes, structure changes, semantic conversion, de-duplication and re- ordering
5. E. Organisation changes, location changes, business strategy conversion, down-sizing and outsourcing

Correct Answer: D

Databases are categorized in three general ways:

1. A. Warped
2. B. Non-relational
3. C. Relational
4. D. Accessible
5. E. None of the above
6. F. Hierarchical

Correct Answer: BCF

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

1. A. FALSE
2. B. TRUE

Correct Answer: A

Data handling ethics are concerned with how to procure, store, manage, use and dispose of data in ways that are aligned with ethical principles.

1. A. TRUE
2. B. FALSE

Correct Answer: A