Data Deduplication — Learn free

Self-check

Questions 1–10 of 10

1. What is Data Deduplication about?
Question 1A. Compressing data to save disk spaceB. Removing duplication in the dataC. Copying data to a backup siteD. Encrypting duplicate recordsE. Splitting a table into partitions
2. In which process is Data Deduplication mostly involved?
Question 2A. User authenticationB. Network routingC. ETL or ELTD. Report formattingE. Server provisioning
3. What are the two kinds of data that can be duplicated?
Question 3A. Structured and unstructured dataB. Raw or Processed Data, and Absence of Golden RecordC. Hot and cold dataD. OLTP and OLAP dataE. Internal and external data
4. Which is given as an example of duplicate data entered from a badly designed front-end application?
Question 4A. A customer wrongly created twice, or a product sold once but entered more than onceB. A policy with three different codes across systemsC. A missing primary keyD. A report run twiceE. A backup restored twice
5. Which process must remove duplicates created during ETL/ELT transformation into a Data Warehouse or Data Mart?
Question 5A. The Security processB. The Licensing processC. The Backup processD. The Network processE. The Data Quality process
6. What does 'Absence of Golden Record' mean?
Question 6A. A table has no primary keyB. A backup copy is missingC. There is more than one code for a single entity across systemsD. An audit log has been deletedE. A report has no owner
7. In the insurance example from I Am Datapedia!, what happens when the marketing department plans campaigns without a Golden Record?
Question 7A. One campaign is sent for the one policy typeB. Campaigns are sent only to new customersC. No campaigns can be sentD. Three campaigns are designed for the same single type of policyE. The campaign budget is halved
8. Which application helps create a de-duplicated Golden Record?
Question 8A. A Master Data Management (MDM) applicationB. A firewallC. A load balancerD. A container orchestratorE. A web browser
9. Which of the following is NOT one of the named reasons for duplicated Raw or Processed data?
Question 9A. Data entered from front-end applications that allow duplicate entryB. Data transformed during ETL/ELT from source systems to the warehouseC. A system so badly designed that it allows a customer to be created twiceD. Human error such as entering a sale twiceE. Data stored on encrypted disks
10. Where does data from the three insurance systems flow to in the Golden Record example?
Question 10A. Back to the front-end applicationsB. An external regulatorC. A printed archiveD. A centralised location such as a Data Warehouse or Data MartE. A customer's email inbox