DAC Data Tools and Visualization

Question 1

What is SQL and why is it essential for data analysts?

Accepted Answer

Structured Query Language — the standard language for querying, manipulating, and managing relational databases

Answer

SQL is the universal language for interacting with relational databases, enabling analysts to retrieve specific data (SELECT), filter (WHERE), join tables, aggregate (GROUP BY), and perform complex data manipulation.

Question 2

When should you use a bar chart versus a line chart?

Accepted Answer

Bar charts for comparing categories; line charts for showing trends over time

Answer

Bar charts effectively compare discrete categories or groups, while line charts show continuous data trends over time. Choosing the wrong chart type can misrepresent the data and mislead the audience.

Question 3

What is a dashboard in data analytics?

Accepted Answer

An interactive visual display of key metrics and KPIs, providing at-a-glance monitoring of business performance

Answer

Analytics dashboards consolidate key metrics, KPIs, and visualizations into a single interactive interface, enabling stakeholders to monitor performance, identify trends, and make data-driven decisions quickly.

Question 4

What is Python's role in data analytics?

Accepted Answer

A versatile programming language with libraries (pandas, NumPy, matplotlib) for data manipulation, analysis, and visualization

Answer

Python is widely used for data analytics through libraries like pandas (data manipulation), NumPy (numerical computing), matplotlib/seaborn (visualization), and scikit-learn (machine learning), offering flexibility beyond spreadsheet tools.

Question 5

What is A/B testing in data-driven decision making?

Accepted Answer

Comparing two versions of something (webpage, email, feature) by randomly assigning users to each version and measuring outcomes

Answer

A/B testing randomly divides users into control (A) and treatment (B) groups, each seeing a different version, to statistically determine which performs better on defined metrics, enabling evidence-based decisions.

Data Analytics Certifications (DAC) Practice Test

Data Analytics Certifications (DAC) Practice Test

DAC Data Tools and Visualization