A dimensional physical data model is usually a star schema, meaning there is one structure for each dimension.

1. A. FALSE
2. B. TRUE

Correct Answer: B

What is the best way to ensure you have high quality data?

1. A. Do corrective action after a problem has occurred because data only needs to be 'fit for use'
2. B. Inspect all data that is in production and get the business areas to certify that the data is correct
3. C. Implement Data Governance and Stewardship
4. D. Create drop-down menus for data entry to prevent all invalid data
5. E. Instruct users of data in downstream systems flag data errors and put them in a error log

Correct Answer: C

Where does the ethical responsibility lie with respect to managing data to reduce risks of misrepresentation, misuse, or misunderstanding?

1. A. Business owns the data and is therefore ethically responsible for managing data across the data lifecycle
2. B. Everybody that makes use of data within the organization is responsible for the ethical use of the data
3. C. Data modellers carry responsibility to ensure that data handling ethics are achieved by design
4. D. The ethical responsibility lies with Data Management professionals to manage data and to manage the associated risks
5. E. Risk Management is responsible for ethical data management

Correct Answer: B

Master data is an aggregation of:

1. A. Transaction Structure Data
2. B. Database Structure Data
3. C. Reference Data
4. D. Enterprise Structure Data

Correct Answer: ACD

Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.

1. A. TRUE
2. B. FALSE

Correct Answer: A