You face five different data preparation scenarios. Match a data quality issue to each scenario. Each data quality issue can be used only
once.
#
Scenario
Data Quality Issue
Grace received a data set that had a column titled ClientInfo. Each record
in that field contained a client's mailing address.
The data in the Sales column are the dollar amounts of the sale
transactions. However, Quinn noted that the data type was classified as
alphanumeric characters or text data.
Upon inspection of data transferred from the payroll system to a data
warehouse, Molly noticed that employee payroll records only included
employees with last names beginning A through
Barnes received a table of data from the IT group. One of the columns
contains both customer name data and payment term data.
Devon extracted data from the company's shipping department log In
addition to shipment data, the log also contains summary statistics such
as the total quantity shipped. Upon inspection of the extracted data,
Devon notes that the total quantity shipped for the extracted data does
not match the total quantity shipped number in the log
