DMF-1220 Free Practice Test

Differentiating between data and information. Please select the correct answers based on the sentence below: Here is a marketing report for the last month [1]. It is based on data from our data warehouse[2]. Next month these results [3] will be used to generate our month-over-month performance measure [4].

1. A. [1] Information, [2] Information, [3] Data, [4] Information
2. B. [1] Data, [2] Information, [3] Data, [4] Data
3. C. [1] Data, [2] Data, [3] Data, [4] Information
4. D. [1] Information, [2] Data, [3] Data, [4] Information

Correct Answer: D

Examples of the ??What?? entity category include the following nouns:

1. A. Product
2. B. Service
3. C. Time
4. D. Sales amount
5. E. Payment quantity
6. F. All of the above

Correct Answer: AB

Referential Integrity (RI) is often used to update tables without human intervention. Would this be a good idea for reference tables?

1. A. Yes, since Standards Bodies typically supply reference data, the enterprise can automatically update when a new code or value is received
2. B. No, updates should always be made directly via data entry or through a specific batch interface based on operator-entered information partly because of regulatory reporting and archiving
3. C. Yes, you do not have to worry about archived data with reference data so tables can beupdated automatically
4. D. No, but an enterprise can use program logic to do updates as there is little potential for problems to occur with reference data
5. E. Yes, older transactions do not have to be removed because with the Cloud there is unlimited database storage

Correct Answer: B

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

1. A. Institute a formal change control
2. B. Define and enforce rules
3. C. Implement data governance and stewardship
4. D. None of the above
5. E. Train data procedures
6. F. Establish data entry controls

Correct Answer: ABCEF

OCR is the abbreviation for Optical Character Recognition.

1. A. TRUE
2. B. FALSE

Correct Answer: A