CompTIA Data+ (DA0-001) — Question 349

A company CRM has more than one million email addresses. The company wants to create a new reduced and simplified table that can be exported in a flat file. Which of the following analytics tools is the most appropriate?

Answer options

• A. MS Excel
• B. Power BI
• C. RapidMiner
• D. SQL

Correct answer: D

Explanation

The correct answer is D, SQL, as it is designed for managing and querying large datasets effectively, making it suitable for creating a simplified table from a large CRM database. MS Excel (A) is not ideal for handling such large volumes of data, Power BI (B) is primarily for visualization rather than data extraction, and RapidMiner (C) is more focused on data mining and predictive analytics, which is not necessary for this task.