A logistics company receives shipment tracking data from multiple carriers. The data includes a 'status' column with expected values: 'delivered', 'in_transit', 'out_for_delivery', and 'exception'. During a recent load, the team found rows with status 'completed' and 'pending'. What is the most effective validation rule to prevent this from happening in future loads?

Convert all status values to lowercase before loading.

Define a whitelist of allowed status values and reject any row where status is not in that list.

Check that the status column is not null and has a length greater than zero.

Map unknown statuses to 'exception' automatically during the load.

An e-commerce company collects user sign-up data. The sign-up form includes an email field. The data team wants to validate that the email format is correct before storing it. Which validation method is most appropriate for this task?

Verify that the email is unique in the database.

Use a regular expression to check that the email matches a standard pattern (e.g., local@domain.tld).

Check that the email field is not empty and contains at least one character.

Convert the email to lowercase and store it without any further checks.

A financial firm processes loan applications. Each application must have a unique application_id, and the applicant's credit_score must be between 300 and 850. The firm wants to ensure that no duplicate applications are processed and that invalid credit scores are flagged. Which combination of validation rules best achieves this?

Sort the data by credit_score before loading.

Use a format check on application_id to ensure it is alphanumeric.

Enforce a uniqueness constraint on application_id and a range check on credit_score.

Only check that credit_score is not null.

A healthcare analytics team maintains a patient records database. A new data entry form allows users to input patient age. The team wants to enforce a validation rule that rejects any age value below 0 or above 120 at the point of entry. Which validation approach best implements this rule?

Apply a range check in the application code that rejects ages outside 0–120 before the data is written to the database.

Allow all values to be stored and run a weekly SQL query to find and correct out-of-range ages.

Use a database trigger that only warns about out-of-range values but still inserts them.

Store age as a string and rely on the database to sort values alphabetically.

Python InstitutePCAD - Certified Associate in Data Analytics with Python

Domain 1Objective 3

Data Validation and Integrity PCAD-31 Practice Questions (Page 2)

Part of the Data Acquisition and Pre-Processing domain, which accounts for 29.2% of the PCAD-31 exam. Python Institute does not publish an official question count, but from its 60-minute exam (~25–40 total, ~7–7 in this domain), expect 2–2 from this objective — we provide 10 practice questions to prepare you well beyond it. (estimate)

10questions here

2free pages

2concepts

29.2%of the exam

Questions 6–10

6foundation · easy
A data analyst needs to verify that a column named 'age' contains only integer values. Which pandas attribute is used to inspect the data type of a Series?
Select an answer first
7application · medium
A logistics company receives shipment tracking data from multiple carriers. The data includes a 'status' column with expected values: 'delivered', 'in_transit', 'out_for_delivery', and 'exception'. During a recent load, the team found rows with status 'completed' and 'pending'. What is the most effective validation rule to prevent this from happening in future loads?
Select an answer first
8application · medium
An e-commerce company collects user sign-up data. The sign-up form includes an email field. The data team wants to validate that the email format is correct before storing it. Which validation method is most appropriate for this task?
Select an answer first
9application · medium
A financial firm processes loan applications. Each application must have a unique application_id, and the applicant's credit_score must be between 300 and 850. The firm wants to ensure that no duplicate applications are processed and that invalid credit scores are flagged. Which combination of validation rules best achieves this?
Select an answer first
10application · medium
A healthcare analytics team maintains a patient records database. A new data entry form allows users to input patient age. The team wants to enforce a validation rule that rejects any age value below 0 or above 120 at the point of entry. Which validation approach best implements this rule?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to PCAD-31

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Python Institute. “PCAD-31” is a trademark of its owner, used for identification only.

Data Validation and Integrity PCAD-31 Practice Questions (Page 2)

Questions 6–10

A data analyst needs to verify that a column named 'age' contains only integer values. Which pandas attribute is used to inspect the data type of a Series?

An e-commerce company collects user sign-up data. The sign-up form includes an email field. The data team wants to validate that the email format is correct before storing it. Which validation method is most appropriate for this task?

A healthcare analytics team maintains a patient records database. A new data entry form allows users to input patient age. The team wants to enforce a validation rule that rejects any age value below 0 or above 120 at the point of entry. Which validation approach best implements this rule?

Keep studying — Data Acquisition and Pre-Processing