CompTIA Data+ (DA0-001) — Question 294

An analyst wants to extract data from a variety of sources and store the data in a cloud-based environment prior to cleaning. Which of the following integration techniques should the analyst use?

Answer options

• A. ETL
• B. API
• C. SQL
• D. ELT

Correct answer: D

Explanation

The correct answer is D, ELT, which allows data to be loaded into a cloud environment first and then transformed, making it ideal for cloud-based workflows. ETL (A) involves transforming data before loading, which is less efficient for cloud environments. API (B) refers to application programming interfaces that don't specifically address data extraction and storage techniques, while SQL (C) is a query language used for managing data, not an integration technique.