Data Profiling
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is the aim of Data Profiling?
2. Which teams use Data Profiling as part of their daily routine?
3. In the customer-age example, what is the quick way to find out whether any customer is aged over 90?
4. If customers in a database are aged between 21 and 100, what does profiling say about the number of unique age values?
5. How do Data Quality teams use Data Profiling to enforce a rule that all dates must be in DD/MM/YYYY format?
6. What are the three key high-level steps of Data Profiling?
7. Which of the following is NOT listed as a Data Profiling task?
8. Which commands are used in Data Profiling to find keywords, descriptions or categories?
9. Which artefacts does Data Profiling record, according to its listed tasks?
10. For what kinds of key classification does Data Profiling assess candidate columns?