Data Provenance — Learn free

Self-check

Questions 1–10 of 10

1. How do Data Provenance and Data Lineage relate to each other?
Question 1A. They are completely unrelated activitiesB. Logically they do the same thing but at different levels of granularityC. Data Provenance is a technical subset of Data LineageD. Data Lineage applies to business data and Data Provenance to technical logsE. Data Provenance is the older name for Data Lineage
2. At what level does Data Provenance describe the data lifecycle?
Question 2A. Individual rows and cell valuesB. Databases, tables and columnsC. Network packets and portsD. Inputs, entities, systems and processesE. File paths and directory names
3. Which of the following details belongs to Data Lineage rather than Data Provenance?
Question 3A. Which database, table and column the data came from and went intoB. Whether real-time or batch processing was usedC. Which entity the data relates toD. Whether analytical modelling was performedE. Which source system supplied the data
4. Which of the following is an example of a question Data Provenance answers?
Question 4A. Which column was renamed during the ETL jobB. Which index is defined on the target tableC. How many bytes the source file occupiedD. Which foreign key links two tablesE. Whether the data was processed in real time, in batches or by events
5. Who mainly uses Data Provenance?
Question 5A. Database administratorsB. ETL developersC. Business users and managementD. Network engineersE. Security testers
6. Who mainly uses Data Lineage?
Question 6A. IT staffB. Board membersC. External auditors onlyD. CustomersE. Marketing managers
7. Which of the following is NOT listed as something Data Provenance captures during the data lifecycle?
Question 7A. Any data cleaning that took placeB. Any data quality rules appliedC. The index defined on a particular table columnD. Any data enrichment that took placeE. Master and reference data management activities
8. Which processing styles does Data Provenance record as part of describing how data was handled?
Question 8A. Compiled, interpreted and scriptedB. Encrypted, hashed and tokenisedC. Primary, secondary and tertiaryD. Local, regional and globalE. Real-time, batch and event-based
9. Which of the following is something Data Provenance records about incoming data?
Question 9A. The width of each column in charactersB. The format it arrives in and the source system it comes fromC. The password of the source systemD. The SQL used to create the target tableE. The number of rows in each partition
10. What does a Data Lineage record capture when data moves from one table to another?
Question 10A. The cost of the storage usedB. The name of the business sponsorC. The reason the project was approvedD. The business rules incorporated during the transformation between source and target database, table and columnE. The regulatory framework governing the data