Data Profiling — Learn free

Self-check

Questions 1–10 of 10

1. What is the aim of Data Profiling?
Question 1A. To encrypt sensitive columnsB. To find out the data patterns by summarising data for analysisC. To replace real data with synthetic dataD. To move data from silos into a warehouseE. To assign monetary value to datasets
2. Which teams use Data Profiling as part of their daily routine?
Question 2A. Sales and marketing teamsB. Data Modellers, Data Engineers, Data Governance and Data Quality teamsC. Project managers and sponsorsD. Network security teamsE. Customer service agents
3. In the customer-age example, what is the quick way to find out whether any customer is aged over 90?
Question 3A. Read through each line of dataB. Sort the customer list by nameC. Run a DISTINCT command on the age column to see all unique agesD. Ask the customers directlyE. Delete the age column
4. If customers in a database are aged between 21 and 100, what does profiling say about the number of unique age values?
Question 4A. It should not be more than 80B. It should be exactly 100C. It should be at least 121D. It should be oneE. It cannot be determined
5. How do Data Quality teams use Data Profiling to enforce a rule that all dates must be in DD/MM/YYYY format?
Question 5A. By manually reviewing each new fileB. By blocking all incoming dataC. By converting all dates to numbersD. By running automated profiling with DISTINCT commands to detect any other date format arrivingE. By encrypting the date columns
6. What are the three key high-level steps of Data Profiling?
Question 6A. Storing, Sharing, DiscoverableB. Extract, Transform, LoadC. Landing, Staging, TransformedD. Generation, Processing, RemovalE. Collecting Data, Cleansing Data, Run Profiling Tasks
7. Which of the following is NOT listed as a Data Profiling task?
Question 7A. Gathering min, max and sum of the dataB. Gathering datatype and column lengthsC. Finding regular patternsD. Negotiating the purchase price of a data companyE. Classifying candidate columns for primary and foreign keys
8. Which commands are used in Data Profiling to find keywords, descriptions or categories?
Question 8A. DISTINCT and GROUP BYB. INSERT and UPDATEC. JOIN and UNIOND. CREATE and DROPE. GRANT and REVOKE
9. Which artefacts does Data Profiling record, according to its listed tasks?
Question 9A. Project plans and budgetsB. Invoices and receiptsC. Metadata, data dictionary and data catalogueD. Model weights and biasesE. Network diagrams
10. For what kinds of key classification does Data Profiling assess candidate columns?
Question 10A. Encryption keys and API keysB. Keywords for search enginesC. Sort keys and partition keys onlyD. Public and private keysE. Primary keys, foreign keys, uniqueness and composite keys