DAC Data Tools and Visualization 4

Question 1

Which chart type is best for displaying the distribution of a single continuous variable?

Accepted Answer

Histogram

Answer

A histogram bins a continuous variable to show its frequency distribution.

Question 2

In Tableau, what is the difference between a live connection and an extract?

Accepted Answer

Live queries the source directly; extract is a static in-memory snapshot

Answer

A live connection queries the source in real time, while an extract is a saved snapshot.

Question 3

What is the recommended maximum number of slices before a pie chart becomes hard to read?

Accepted Answer

Around 5-6 slices

Answer

Pie charts become unreadable beyond roughly five or six slices.

Question 4

In SQL for reporting, which clause groups rows so aggregate functions apply per category?

Accepted Answer

GROUP BY

Answer

GROUP BY groups rows by column values so aggregates compute per group.

Question 5

Which principle suggests placing the most important dashboard metric in the top-left area?

Accepted Answer

Z-pattern / F-pattern reading flow

Answer

Western readers scan in Z/F patterns, so key metrics belong top-left.

Data Analytics Certifications (DAC) Practice Test