Data+ Quiz Lesson 18

A data analyst has started at a small organization where the previous data analyst left but did not leave documentation behind. They begin looking at certain data that was used for dimension data, not transactional data. It also does not seem to change very frequently. What is the data analyst most likely looking at?

• Data dictionary

• Data model

• Master data

• Entity Relationship Diagram (ERD)

A database administrator is putting master data together to be shared by people across the organization to make critical decisions. Which of the following would least likely be considered master data?

• Customer emails

• Employees

• Assets

• Products

A database manager is trying to make a case for a strong master data management program. Which of the following would be the least likely to support that cause?

• Regulations

• Mergers

• Legacy systems

• Maintenance

A database analyst is looking at a regularly scheduled report on data and has to perform a fair amount of transformation and cleaning every time. What will help to alleviate this on the back end?

• Policies

• Data model

• Relationships

• Standardization

A database administrator has been studying master data management and wants to implement the concept with the organization. What are the biggest benefits of implementation that the administrator might use to sell master data management to the manager? (Select all that apply.)

• Customer outreach

• Quality

• Confidentiality

• Integrity

A database manager wants to set up a governance program to help make the organization and operations better. Where should they start?

• Policies

• Security

• Legacy systems

• Quality assurance

A database administrator is setting up a data dictionary in order to be the authority on all definitions that are agreed upon for the organization. Which of the following will the data dictionary least likely contain?

• Data elements

• Field attributes

• Policies

• Data structure

A big corporation has made several aggressive acquisitions of other companies in the course of a few short years. They want to consolidate multiple fields of information to establish a single, reliable source of truth. What software will help them accomplish this?

• Customer relationship management (CRM) software

• Master data management (MDM) software

• Middleware

• Entity relationship diagram (ERD)

A data analyst must spearhead a master data management effort program. Which of the following will the program be least helpful with?

• New system integration

• Data quality improvement

• Customer relations

• Compliance

A data analyst must put together a data dictionary. What are the primary components that the analyst should focus on? (Select all that apply.)

• Definitions

• Attributes

• Regulations

• Relationships