Data Quality Quiz

Quiz covering Profile and Clean the Data

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 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. 2

   Which of the following best describes the purpose of 'Data Profiling' in the context of data preparation?

3. 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. 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. 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?