Section 1 - Instruction

In the previous unit, you learned how critical it is to catch bad data at the door. Now let's get some hands-on practice designing and applying data quality rules.

Engagement Message

Ready to build some robust quality gates?

Section 2 - Practice

Identify the correct quality check for each issue by swiping left or right.

Type

Swipe Left or Right

Practice Question

Identify the correct quality check for each issue by swiping left or right.

Labels

  • Left Label: Validation
  • Right Label: Standardization

Left Label Items

  • Order amount is negative
  • Email field is empty
  • Date is in the future
  • Zip code is not 5 digits

Right Label Items

  • States are "CA" and "ca"
  • Phone numbers vary
  • Names are mixed case
  • Dates are in US/EU format
Section 3 - Practice

When a data record fails a quality check, what should be the response? Sort these scenarios into the appropriate action box.

Type

Sort Into Boxes

Practice Question

When a data record fails a quality check, what should be the response? Sort these scenarios into the appropriate action box.

Labels

  • First Box Label: Reject Record
  • Second Box Label: Quarantine for Review

First Box Items

  • Missing primary key
  • Invalid credit card
  • Failed schema check

Second Box Items

  • Address unverified
  • Slightly old data
  • Optional field empty
Sign up
Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal