MDM, ETL and Data Security - QUIZ 3

What is the primary purpose of the 'Extract' phase in ETL?

• To clean and transform data

• To load data into the target system

• To retrieve data from source systems

• To validate data integrity

Which of the following best describes 'Transform' in ETL?

• Moving data from source to destination

• Converting data into a suitable format for analysis

• Archiving data for backup

• Extracting data from a data warehouse

In ETL, what is 'Load'?

• Sending data to the source system

• Moving data into the target data warehouse or system

• Creating backups of data

• Validating data quality

Which ETL technique minimizes downtime during data processing?

• Batch processing

• Real-time streaming

• Data replication

• Data archiving

Which tool is NOT typically used in ETL processes?

• Apache NiFi

• Talend

• PowerPoint

• Informatica

What is master data management (MDM)?

• Managing transactional data

• Maintaining consistent, accurate core business data across systems

• Managing user credentials

• Backing up data regularly

Which of the following is a common challenge in managing master data?

• Data duplication

• Slow network speeds

• Power outages

• Hardware failures

Which technique helps ensure data consistency across multiple systems?

• Data replication

• Data sharding

• Data encryption

• Data archiving

Which of the following is NOT a typical component of MDM?

• Data governance

• Data quality management

• Data virtualization

• Data encryption

Which approach is used to synchronize master data across different systems?

• Batch updates

• Event-driven updates

• Both A and B

• Neither A nor B