Data Validation — Learn free

Self-check

Questions 1–10 of 10

1. What is Data Validation?
Question 1A. Summarising data for management reportsB. Verifying the correctness and quality of data against its sourceC. Generating fake data for testingD. Reducing the number of rows pulled from a tableE. Assigning monetary value to data assets
2. By when must Data Validation be completed at the latest?
Question 2A. Before data is pulled from the sourceB. Before the database is backed upC. Before data is passed to end usersD. Before the annual auditE. Before data is archived
3. When data changes its shape during transformation from source to target, what is Data Validation conducted against?
Question 3A. The original source data onlyB. The business rules implemented during transformationC. The target table's index definitionsD. A synthetic copy of the dataE. The user's dashboard filters
4. What does Constraints Validation check?
Question 4A. The structure of tables and columnsB. The syntax quality of codeC. The allowable date rangeD. Primary keys, foreign keys, unique, not null, value checks and query performance constraintsE. Whether column data types match their contents
5. Which type of Data Validation checks the structure of tables and columns?
Question 5A. Structured ValidationB. Constraints ValidationC. Code ValidationD. Data Range ValidationE. Data Type Validation
6. Which example illustrates Data Range Validation?
Question 6A. Ensuring a Date column only accepts date-formatted valuesB. Checking that foreign keys resolve to a parent rowC. Ensuring that only the latest data is processed when only latest data is allowedD. Checking that code follows optimised patternsE. Confirming a table has the expected columns
7. What does Code Validation assess?
Question 7A. The primary key of every tableB. The data types of columnsC. The number of rows in each tableD. Whether values fall within a date rangeE. The quality of the syntax and whether code is written in an optimised way
8. If a column's data type is Date, which validation ensures only date-formatted values are processed?
Question 8A. Constraints ValidationB. Structured ValidationC. Code ValidationD. Data Range ValidationE. Data Type Validation
9. Which of the following is NOT one of the listed types of Data Validation?
Question 9A. Encryption ValidationB. Structured ValidationC. Constraints ValidationD. Code ValidationE. Data Type Validation
10. Data Validation can be described as reconciliation between which two things?
Question 10A. Development and production environmentsB. The data catalogue and the data inventoryC. Two different dashboardsD. Imported and processed data, and its source dataE. Structured and unstructured datasets