Data Quality Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Profile and Clean the Data

What you'll be asked

  1. While reviewing a dataset, you notice that a 'Phone Number' column contains various formats such as (555) 123-4567, 5551234567, and 555-123-4567. What is the first step you should take to clean this data for analysis?
  2. Which of the following best describes the purpose of 'Data Profiling' in the context of data preparation?
  3. You find that 30% of the 'Annual Income' column in a survey dataset is missing. If the missingness is random and you want to maintain the sample size without introducing significant bias to the mean, which technique is most appropriate?
  4. A data analyst discovers that a 'TransactionDate' column contains several entries for February 30th. This is an example of what type of data quality issue?
  5. In a relational database, you perform a profile check and find 'Order' records associated with a 'CustomerID' that does not exist in the 'Customers' master table. How should this 'Hard' data quality issue be classified and addressed?

Answers and explanations come after you submit.