Scenario: "The contract specifies a freshness SLA of 4 hours." What does data freshness mean as a contractual obligation?
Freshness SLA: "data is no older than X hours at any given time." Measured by: max(updated_at) vs NOW() delta. Breach triggers alert, producer notified, consumers may pause dependent processes.
Scenario: "The contract includes a referential integrity check." What is referential integrity as a data quality expectation?
Referential integrity is critical for analytics correctness — orphaned rows inflate metrics. Contract spec: "100% of customer_id values in orders must exist in customers."
Scenario: "Data quality monitoring detected an anomaly in the distribution of the status column." What does statistical anomaly detection monitor?
Distribution monitoring: track value frequency + standard deviation and alert on shifts. e.g., normally 70% 'active', 20% 'cancelled' — if 'cancelled' spikes to 50%, investigate.
Key vocab:distribution anomaly, value frequency monitoring, statistical baseline, enum distribution shift.
5 / 37
Scenario: "The contract defines a combined data quality score." How is it typically calculated?
PR Description
Subject: Fix: Incorrect Data Type in User Profile Table
We've identified a data quality issue where the 'date_of_birth' column in the User Profiles table was being stored as strings instead of dates. This has caused downstream reporting errors and inconsistencies. The fix converts all existing values to the correct date format, and we've added a comment to the SQL script detailing the change for future reference.
Which of the following best describes the *intent* behind this PR description in the context of a Data Quality Contract?
The correct answer highlights the importance of documenting the change and ensuring traceability – key elements of a robust Data Quality Contract. The PR description isn't just about fixing a bug; it's about demonstrating how the fix aligns with the contract's expectations for data type validation. Options A, C, and D misrepresent the purpose of a PR description in this scenario, focusing solely on technical fixes without acknowledging the contractual obligations related to data governance and accountability.
7 / 37
Sarah: 'Okay team, I've just reviewed the PR for updating the customer address data. The contract stipulates that all addresses must conform to the USPS standard format – including zip codes with five digits. This fix corrects a batch of addresses where the zip codes were missing entirely. We need to ensure this is fully documented in the commit message and any related monitoring alerts to demonstrate we're meeting our SLA.'
Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
Sarah's concern isn't simply about fixing missing data; it's about demonstrating adherence to a specific contractual obligation – the USPS standard format. The incorrect options all miss this key point: she's highlighting that the fix needs to be linked back to the *contract* and how it's being monitored. Option 1 correctly identifies that failing to meet the format requirement is a violation, while the others misinterpret her focus as purely technical or simply acknowledging the change without considering its contractual implications.
The correct answer emphasizes that documentation and monitoring are crucial for proving compliance with the Data Quality Contract.
8 / 37
Sarah is reviewing a PR to update the 'customer_segment' column in the CRM database. The Data Quality Contract specifies that this column *must* be populated with one of five pre-defined segments: 'High Value', 'Medium Value', 'Low Value', 'Potential', or 'Inactive'. The PR includes code to automatically assign segments based on customer purchase history, but the logic is currently only applied to new customers. Sarah notes, 'We need to ensure we're consistently applying these segment definitions and that any discrepancies are actively monitored – this is crucial for maintaining our agreed-upon data quality metrics.' Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
The correct answer is 1. Sarah's primary concern is that the PR doesn't account for existing customers without purchase history – this directly violates the contract's requirement of *consistent* application of the segment definitions. The other options represent potential issues (code quality, documentation), but they aren't the core element of her worry regarding adherence to the Data Quality Contract's expectations. Her emphasis on monitoring discrepancies highlights a need for continuous validation against the defined segments.
9 / 37
PR Description
Subject: Fix: Incorrect Data Type in User Profile Table
We've identified a data quality issue where the 'date_of_birth' column in the User Profiles table was being stored as strings instead of dates. This has caused downstream reporting errors and inconsistencies. The fix converts all existing values to the correct date format, and we've added a comment to the SQL script detailing the change for future reference.
Which of the following best describes the *intent* behind this PR description in the context of a Data Quality Contract?
The correct answer highlights the importance of documenting the change and ensuring traceability – key elements of a robust Data Quality Contract. The PR description isn't just about fixing a bug; it's about demonstrating how the fix aligns with the contract's expectations for data type validation. Options A, C, and D misrepresent the purpose of a PR description in this scenario, focusing solely on technical fixes without acknowledging the contractual obligations related to data governance and accountability.
10 / 37
Sarah: 'Okay team, I've just reviewed the PR for updating the customer address data. The contract stipulates that all addresses must conform to the USPS standard format – including zip codes with five digits. This fix corrects a batch of addresses where the zip codes were missing entirely. We need to ensure this is fully documented in the commit message and any related monitoring alerts to demonstrate we're meeting our SLA.'
Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
Sarah's concern isn't simply about fixing missing data; it's about demonstrating adherence to a specific contractual obligation – the USPS standard format. The incorrect options all miss this key point: she's highlighting that the fix needs to be linked back to the *contract* and how it's being monitored. Option 1 correctly identifies that failing to meet the format requirement is a violation, while the others misinterpret her focus as purely technical or simply acknowledging the change without considering its contractual implications.
The correct answer emphasizes that documentation and monitoring are crucial for proving compliance with the Data Quality Contract.
11 / 37
Sarah is reviewing a PR to update the 'customer_segment' column in the CRM database. The Data Quality Contract specifies that this column *must* be populated with one of five pre-defined segments: 'High Value', 'Medium Value', 'Low Value', 'Potential', or 'Inactive'. The PR includes code to automatically assign segments based on customer purchase history, but the logic is currently only applied to new customers. Sarah notes, 'We need to ensure we're consistently applying these segment definitions and that any discrepancies are actively monitored – this is crucial for maintaining our agreed-upon data quality metrics.' Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
The correct answer is 1. Sarah's primary concern is that the PR doesn't account for existing customers without purchase history – this directly violates the contract's requirement of *consistent* application of the segment definitions. The other options represent potential issues (code quality, documentation), but they aren't the core element of her worry regarding adherence to the Data Quality Contract's expectations. Her emphasis on monitoring discrepancies highlights a need for continuous validation against the defined segments.
12 / 37
PR Description
Subject: Fix: Incorrect Data Type in User Profile Table
We've identified a data quality issue where the 'date_of_birth' column in the User Profiles table was being stored as strings instead of dates. This has caused downstream reporting errors and inconsistencies. The fix converts all existing values to the correct date format, and we've added a comment to the SQL script detailing the change for future reference.
Which of the following best describes the *intent* behind this PR description in the context of a Data Quality Contract?
The correct answer highlights the importance of documenting the change and ensuring traceability – key elements of a robust Data Quality Contract. The PR description isn't just about fixing a bug; it's about demonstrating how the fix aligns with the contract's expectations for data type validation. Options A, C, and D misrepresent the purpose of a PR description in this scenario, focusing solely on technical fixes without acknowledging the contractual obligations related to data governance and accountability.
13 / 37
Sarah: 'Okay team, I've just reviewed the PR for updating the customer address data. The contract stipulates that all addresses must conform to the USPS standard format – including zip codes with five digits. This fix corrects a batch of addresses where the zip codes were missing entirely. We need to ensure this is fully documented in the commit message and any related monitoring alerts to demonstrate we're meeting our SLA.'
Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
Sarah's concern isn't simply about fixing missing data; it's about demonstrating adherence to a specific contractual obligation – the USPS standard format. The incorrect options all miss this key point: she's highlighting that the fix needs to be linked back to the *contract* and how it's being monitored. Option 1 correctly identifies that failing to meet the format requirement is a violation, while the others misinterpret her focus as purely technical or simply acknowledging the change without considering its contractual implications.
The correct answer emphasizes that documentation and monitoring are crucial for proving compliance with the Data Quality Contract.
14 / 37
Sarah is reviewing a PR to update the 'customer_segment' column in the CRM database. The Data Quality Contract specifies that this column *must* be populated with one of five pre-defined segments: 'High Value', 'Medium Value', 'Low Value', 'Potential', or 'Inactive'. The PR includes code to automatically assign segments based on customer purchase history, but the logic is currently only applied to new customers. Sarah notes, 'We need to ensure we're consistently applying these segment definitions and that any discrepancies are actively monitored – this is crucial for maintaining our agreed-upon data quality metrics.' Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
The correct answer is 1. Sarah's primary concern is that the PR doesn't account for existing customers without purchase history – this directly violates the contract's requirement of *consistent* application of the segment definitions. The other options represent potential issues (code quality, documentation), but they aren't the core element of her worry regarding adherence to the Data Quality Contract's expectations. Her emphasis on monitoring discrepancies highlights a need for continuous validation against the defined segments.
15 / 37
PR Description
Subject: Fix: Incorrect Data Type in User Profile Table
We've identified a data quality issue where the 'date_of_birth' column in the User Profiles table was being stored as strings instead of dates. This has caused downstream reporting errors and inconsistencies. The fix converts all existing values to the correct date format, and we've added a comment to the SQL script detailing the change for future reference.
Which of the following best describes the *intent* behind this PR description in the context of a Data Quality Contract?
The correct answer highlights the importance of documenting the change and ensuring traceability – key elements of a robust Data Quality Contract. The PR description isn't just about fixing a bug; it's about demonstrating how the fix aligns with the contract's expectations for data type validation. Options A, C, and D misrepresent the purpose of a PR description in this scenario, focusing solely on technical fixes without acknowledging the contractual obligations related to data governance and accountability.
16 / 37
Sarah: 'Okay team, I've just reviewed the PR for updating the customer address data. The contract stipulates that all addresses must conform to the USPS standard format – including zip codes with five digits. This fix corrects a batch of addresses where the zip codes were missing entirely. We need to ensure this is fully documented in the commit message and any related monitoring alerts to demonstrate we're meeting our SLA.'
Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
Sarah's concern isn't simply about fixing missing data; it's about demonstrating adherence to a specific contractual obligation – the USPS standard format. The incorrect options all miss this key point: she's highlighting that the fix needs to be linked back to the *contract* and how it's being monitored. Option 1 correctly identifies that failing to meet the format requirement is a violation, while the others misinterpret her focus as purely technical or simply acknowledging the change without considering its contractual implications.
The correct answer emphasizes that documentation and monitoring are crucial for proving compliance with the Data Quality Contract.
17 / 37
Sarah is reviewing a PR to update the 'customer_segment' column in the CRM database. The Data Quality Contract specifies that this column *must* be populated with one of five pre-defined segments: 'High Value', 'Medium Value', 'Low Value', 'Potential', or 'Inactive'. The PR includes code to automatically assign segments based on customer purchase history, but the logic is currently only applied to new customers. Sarah notes, 'We need to ensure we're consistently applying these segment definitions and that any discrepancies are actively monitored – this is crucial for maintaining our agreed-upon data quality metrics.' Which of the following best describes Sarah's primary concern regarding the PR, *specifically* in relation to the Data Quality Contract?
The correct answer is 1. Sarah's primary concern is that the PR doesn't account for existing customers without purchase history – this directly violates the contract's requirement of *consistent* application of the segment definitions. The other options represent potential issues (code quality, documentation), but they aren't the core element of her worry regarding adherence to the Data Quality Contract's expectations. Her emphasis on monitoring discrepancies highlights a need for continuous validation against the defined segments.
18 / 37
Review the following code review comment:
`@johndoe: 'The Data Quality Contract states that the `email` column must be validated against a regex pattern to ensure it conforms to RFC 5322. This change doesn't include any validation; it simply updates the existing value. Please add the necessary validation logic.' What is John Doe primarily pointing out?
John Doe's comment focuses on non-compliance with a specific data quality rule. The Data Quality Contract mandates validation against RFC 5322 for the `email` column, and this change bypasses that requirement. The key issue is not performance or refactoring, but rather a direct violation of the defined expectations.
19 / 37
Mark from DataOps sends the following Slack message:
`@team: 'Just ran an anomaly detection check on the `order_total` column in the `sales` table. We're seeing a significant spike – 3 standard deviations above the mean – for orders placed yesterday during peak hours. The contract defines acceptable ranges, and this clearly exceeds them. Investigate!'. What does Mark's message indicate about data quality?
Mark's message highlights a critical data quality concern. The anomaly detection flagged a substantial deviation (3 standard deviations) from the norm for `order_total`. This directly breaches the defined acceptable ranges stipulated in the Data Quality Contract, suggesting an underlying problem with data integrity or completeness that needs investigation.
20 / 37
Consider this API response from a data quality monitoring tool:
```json{
"status": "error",
"message": "Data Quality Rule Violation: Column 'product_category' in table 'inventory' contains values not present in the approved list.",
"rule_id": "DQ-INV-001"
}
```
What does this API response primarily communicate?
This API response clearly indicates a data quality violation. The `message` field specifies that the `product_category` column in the `inventory` table contains values not found within the approved list – directly referencing a defined rule (`DQ-INV-001`). This requires immediate attention to correct the inconsistent data.
21 / 37
Review this PR description:
`Subject: Refactor: Address Validation Logic. We've updated the address validation process to use a more robust library and improve data consistency. This ensures all addresses adhere to USPS standards.` What aspect of data quality is primarily addressed by this change?
This PR description focuses on a crucial aspect of data quality: compliance with external standards. By using a robust library and ensuring adherence to USPS standards, the change directly addresses the requirement that all addresses must conform to those specifications – as likely defined within the Data Quality Contract.
22 / 37
"Okay team, I've been working on updating the 'customer_tier' column in the CRM. The contract requires this field to be populated based on a pre-defined scoring system; we're implementing that today. It's important that we maintain accurate customer segmentation for targeted marketing campaigns." – David (Data Analyst).
What is David communicating regarding data quality?
David's update directly addresses data quality. He's stating that the `customer_tier` column must be populated according to a pre-defined scoring system – which aligns with the requirements outlined in the Data Quality Contract. This emphasizes the importance of accurate customer segmentation for business purposes.
23 / 37
Review the following code review comment:
`@johndoe: 'The Data Quality Contract states that the `email` column must be validated against a regex pattern to ensure it conforms to RFC 5322. This change doesn't include any validation; it simply updates the existing value. Please add the necessary validation logic.' What is John Doe primarily pointing out?
John Doe's comment focuses on non-compliance with a specific data quality rule. The Data Quality Contract mandates validation against RFC 5322 for the `email` column, and this change bypasses that requirement. The key issue is not performance or refactoring, but rather a direct violation of the defined expectations.
24 / 37
Mark from DataOps sends the following Slack message:
`@team: 'Just ran an anomaly detection check on the `order_total` column in the `sales` table. We're seeing a significant spike – 3 standard deviations above the mean – for orders placed yesterday during peak hours. The contract defines acceptable ranges, and this clearly exceeds them. Investigate!'. What does Mark's message indicate about data quality?
Mark's message highlights a critical data quality concern. The anomaly detection flagged a substantial deviation (3 standard deviations) from the norm for `order_total`. This directly breaches the defined acceptable ranges stipulated in the Data Quality Contract, suggesting an underlying problem with data integrity or completeness that needs investigation.
25 / 37
Consider this API response from a data quality monitoring tool:
```json{
"status": "error",
"message": "Data Quality Rule Violation: Column 'product_category' in table 'inventory' contains values not present in the approved list.",
"rule_id": "DQ-INV-001"
}
```
What does this API response primarily communicate?
This API response clearly indicates a data quality violation. The `message` field specifies that the `product_category` column in the `inventory` table contains values not found within the approved list – directly referencing a defined rule (`DQ-INV-001`). This requires immediate attention to correct the inconsistent data.
26 / 37
Review this PR description:
`Subject: Refactor: Address Validation Logic. We've updated the address validation process to use a more robust library and improve data consistency. This ensures all addresses adhere to USPS standards.` What aspect of data quality is primarily addressed by this change?
This PR description focuses on a crucial aspect of data quality: compliance with external standards. By using a robust library and ensuring adherence to USPS standards, the change directly addresses the requirement that all addresses must conform to those specifications – as likely defined within the Data Quality Contract.
27 / 37
"Okay team, I've been working on updating the 'customer_tier' column in the CRM. The contract requires this field to be populated based on a pre-defined scoring system; we're implementing that today. It's important that we maintain accurate customer segmentation for targeted marketing campaigns." – David (Data Analyst).
What is David communicating regarding data quality?
David's update directly addresses data quality. He's stating that the `customer_tier` column must be populated according to a pre-defined scoring system – which aligns with the requirements outlined in the Data Quality Contract. This emphasizes the importance of accurate customer segmentation for business purposes.
28 / 37
Review the following code review comment:
`@johndoe: 'The Data Quality Contract states that the `email` column must be validated against a regex pattern to ensure it conforms to RFC 5322. This change doesn't include any validation; it simply updates the existing value. Please add the necessary validation logic.' What is John Doe primarily pointing out?
John Doe's comment focuses on non-compliance with a specific data quality rule. The Data Quality Contract mandates validation against RFC 5322 for the `email` column, and this change bypasses that requirement. The key issue is not performance or refactoring, but rather a direct violation of the defined expectations.
29 / 37
Mark from DataOps sends the following Slack message:
`@team: 'Just ran an anomaly detection check on the `order_total` column in the `sales` table. We're seeing a significant spike – 3 standard deviations above the mean – for orders placed yesterday during peak hours. The contract defines acceptable ranges, and this clearly exceeds them. Investigate!'. What does Mark's message indicate about data quality?
Mark's message highlights a critical data quality concern. The anomaly detection flagged a substantial deviation (3 standard deviations) from the norm for `order_total`. This directly breaches the defined acceptable ranges stipulated in the Data Quality Contract, suggesting an underlying problem with data integrity or completeness that needs investigation.
30 / 37
Consider this API response from a data quality monitoring tool:
```json{
"status": "error",
"message": "Data Quality Rule Violation: Column 'product_category' in table 'inventory' contains values not present in the approved list.",
"rule_id": "DQ-INV-001"
}
```
What does this API response primarily communicate?
This API response clearly indicates a data quality violation. The `message` field specifies that the `product_category` column in the `inventory` table contains values not found within the approved list – directly referencing a defined rule (`DQ-INV-001`). This requires immediate attention to correct the inconsistent data.
31 / 37
Review this PR description:
`Subject: Refactor: Address Validation Logic. We've updated the address validation process to use a more robust library and improve data consistency. This ensures all addresses adhere to USPS standards.` What aspect of data quality is primarily addressed by this change?
This PR description focuses on a crucial aspect of data quality: compliance with external standards. By using a robust library and ensuring adherence to USPS standards, the change directly addresses the requirement that all addresses must conform to those specifications – as likely defined within the Data Quality Contract.
32 / 37
"Okay team, I've been working on updating the 'customer_tier' column in the CRM. The contract requires this field to be populated based on a pre-defined scoring system; we're implementing that today. It's important that we maintain accurate customer segmentation for targeted marketing campaigns." – David (Data Analyst).
What is David communicating regarding data quality?
David's update directly addresses data quality. He's stating that the `customer_tier` column must be populated according to a pre-defined scoring system – which aligns with the requirements outlined in the Data Quality Contract. This emphasizes the importance of accurate customer segmentation for business purposes.
33 / 37
Review the following code review comment:
`@johndoe: 'The Data Quality Contract states that the `email` column must be validated against a regex pattern to ensure it conforms to RFC 5322. This change doesn't include any validation; it simply updates the existing value. Please add the necessary validation logic.' What is John Doe primarily pointing out?
John Doe's comment focuses on non-compliance with a specific data quality rule. The Data Quality Contract mandates validation against RFC 5322 for the `email` column, and this change bypasses that requirement. The key issue is not performance or refactoring, but rather a direct violation of the defined expectations.
34 / 37
Mark from DataOps sends the following Slack message:
`@team: 'Just ran an anomaly detection check on the `order_total` column in the `sales` table. We're seeing a significant spike – 3 standard deviations above the mean – for orders placed yesterday during peak hours. The contract defines acceptable ranges, and this clearly exceeds them. Investigate!'. What does Mark's message indicate about data quality?
Mark's message highlights a critical data quality concern. The anomaly detection flagged a substantial deviation (3 standard deviations) from the norm for `order_total`. This directly breaches the defined acceptable ranges stipulated in the Data Quality Contract, suggesting an underlying problem with data integrity or completeness that needs investigation.
35 / 37
Consider this API response from a data quality monitoring tool:
```json{
"status": "error",
"message": "Data Quality Rule Violation: Column 'product_category' in table 'inventory' contains values not present in the approved list.",
"rule_id": "DQ-INV-001"
}
```
What does this API response primarily communicate?
This API response clearly indicates a data quality violation. The `message` field specifies that the `product_category` column in the `inventory` table contains values not found within the approved list – directly referencing a defined rule (`DQ-INV-001`). This requires immediate attention to correct the inconsistent data.
36 / 37
Review this PR description:
`Subject: Refactor: Address Validation Logic. We've updated the address validation process to use a more robust library and improve data consistency. This ensures all addresses adhere to USPS standards.` What aspect of data quality is primarily addressed by this change?
This PR description focuses on a crucial aspect of data quality: compliance with external standards. By using a robust library and ensuring adherence to USPS standards, the change directly addresses the requirement that all addresses must conform to those specifications – as likely defined within the Data Quality Contract.
37 / 37
"Okay team, I've been working on updating the 'customer_tier' column in the CRM. The contract requires this field to be populated based on a pre-defined scoring system; we're implementing that today. It's important that we maintain accurate customer segmentation for targeted marketing campaigns." – David (Data Analyst).
What is David communicating regarding data quality?
David's update directly addresses data quality. He's stating that the `customer_tier` column must be populated according to a pre-defined scoring system – which aligns with the requirements outlined in the Data Quality Contract. This emphasizes the importance of accurate customer segmentation for business purposes.
What does the "Data Quality Contract Language" exercise practise?
Practice data quality vocabulary: freshness SLA, completeness expectation, accuracy, null rate, and anomaly threshold.
How many questions are in this exercise?
This exercise has 37 questions, each multiple-choice with a full explanation shown after you answer.
What English level is this exercise for?
This exercise is tagged Intermediate. If the vocabulary feels difficult, browse the Data Contracts category page for an easier module to start with.
Is this exercise free to use?
Yes. Every exercise on CoderSlingo, including this one, is free with no account, sign-up, or paywall.
Do I get feedback if I answer incorrectly?
Yes — whichever option you choose, right or wrong, you'll immediately see an explanation clarifying the correct term and why the other options don't fit.
Can I retry this exercise?
Yes — once you finish all the questions, a "Try again" button on the results screen resets the exercise so you can practise as many times as you like.
Do I need an account to track my progress?
No account is required. Your progress bar and score for this session are tracked in the browser as you go, but nothing is saved once you leave the page.
Is "Data Quality Contract Language" part of a larger series?
Yes — it's one exercise in the Data Contracts category on CoderSlingo. See the category page for the full list of related exercises on similar terminology.
Can I link directly to this exercise?
Yes — this exercise has its own permanent URL, so you can bookmark it or share the link directly with a colleague or study partner.
Where can I find more exercises like this one?
See the Data Contracts category page for related exercises, or browse the main Exercises hub for other IT English topics.