Match each data analysis tool to its primary function.
Drag a concept onto its matching description — or click a concept then click the description.
Query and manipulate structured data in databases
General-purpose language for data analysis and modeling
Statistical computing and graphics
Interactive data visualization and dashboards
Spreadsheet for data manipulation and basic analysis
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Excel: Spreadsheet analysis and data manipulation
Excel is for spreadsheets, SQL for databases, Python for programming/ML, and Tableau for visualization. Common confusions include assigning predictive modeling to Excel or dashboard creation to SQL.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Excel: Spreadsheet analysis and data manipulation
Why this is correct
Excel is primarily used for spreadsheet calculations, data organization, and basic analysis.
SQL: Querying and managing relational databases
Why this is correct
SQL is designed for retrieving, updating, and managing data in relational databases.
Python: General-purpose programming for data analysis and machine learning
Why this is correct
Python is a versatile language used for data manipulation, statistical analysis, and machine learning.
Tableau: Data visualization and business intelligence
Why this is correct
Tableau specializes in creating interactive dashboards and visual analytics.
Excel: Predictive modeling and statistical analysis
Why it's wrong here
Incorrect — predictive modeling is more commonly done with Python or R, not Excel.
SQL: Creating interactive dashboards
Why it's wrong here
Incorrect — interactive dashboards are typically built with Tableau or Power BI, not SQL.
Go deeper
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.