Build and Automate Pipelines CERTIFIED-DATA-SCIENCE-PRACTITIONER Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   What is data virtualization?

   • AA method of storing data in a virtual machine
   • BA technique that provides real-time access to data from multiple sources without physical data movement
   • CA process of copying data to a data warehouse
   • DA way to encrypt data in transit
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the primary purpose of the 'load' step in a data warehouse ETL process?

   • ATo delete old data from the warehouse
   • BTo extract data from source systems
   • CTo clean and format the data
   • DTo write the transformed data into the warehouse tables
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A data engineering team wants to streamline the process of transforming raw data inside a cloud data warehouse into analytics-ready tables, with version-controlled SQL transformations. Which tool is specifically designed for this purpose?

   • AApache Kafka
   • BApache Airflow
   • CFivetran
   • Ddbt
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   How does the ETL process for a data lake typically differ from that of a data warehouse?

   • AData lakes only support structured data
   • BData lakes require all data to be transformed before loading
   • CData lakes often store raw, unstructured data without heavy transformation upfront
   • DData lakes do not use ETL at all
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which benefit does data virtualization provide compared to traditional ETL?

   • AReal-time access to source data without creating physical copies
   • BIt eliminates the need for data governance
   • CIt requires all data to be stored in a single database
   • DIt always improves query performance
   Reveal Solution Discussion Select an answer first