Data+ Lesson 17 Quiz

A data analyst is working at a firm that just went through a merger with another company. They are currently checking to make sure the required fields are entered. What are they checking for?

• Accuracy

• Completeness

• Consistency

• Case sensitivity

A data analyst is working for a company that went through a recent acquisition of another company that sells many of the same products and wants to ensure the combined two data sets of products match up. What are they checking to ensure?

• Completeness

• Accuracy

• Consistency

• Release approval

A data analyst is going through data from a project being implemented and discovers a date field of the text data type, but the system that it is going to is an actual date field. What is this referred to as?

• Completeness

• Loss

• Governance

• Record link restrictions

A data analyst at a consulting company must confirm that all the historical invoices are loaded into the Customer Relationship Management (CRM). What should they use to accomplish this?

• Automated validation

• Cross-validation

• Audit

• Entity Relationship Diagram (ERD)

A medical company is offering quick tests for cholesterol where the patient comes in, takes the test, then is notified of the results by text or email in order to expedite throughput. However, a data analyst has discovered an error in which thousands of patients were not notified due to data inconsistencies. What is this referred to as?

• Completeness

• Accuracy

• Consistency

• Loss

A website administrator is setting up a new customer portal with both IIS and Apache frontward facing servers, as well as the backend database. Which team should determine the list of rules and metrics for the quality standards?

• C-level executives

• HR

• Legal

• Governance

A data scientist at a research firm is developing machine learning models based on exabytes of data and wants to test the models. What should the data scientist do to test?

• Modeling

• Automated validation

• Profiling

• Cross-validation

A new data analyst recently loaded data into a new system and wants to create a quick health check on the data. What is a quick and easy way to verify this?

• Record count

• Check state info against state codes.

• Cross-validation

• Profiling

A database administrator wants to have reasonable expectations and provide valuable information to check their work prior to working with a data set. What could they use?

• Cross-validation

• Audit

• Profiling

• Constraint

A data analyst has begun working with PowerQuery and wants to verify things are working as they should. What is a common error with PowerQuery?

• Invalid calculation

• Case sensitivity

• Rule change

• Improper data join