CERTIFIED-DATA-ANALYST-ASSOCIATE Question #69: Real Exam Question with Answer & Explanation

Question

A data analyst has created a Query in Databricks SQL, and now wants to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard. Which step will the data analyst need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

Options

• ACopy the Query and create one data visualization per query.
• BAdd two separate visualizations to the dashboard based on the same Query.
• CDecide on a single data visualization to add to the dashboard.
• DAlter the Query to return two separate sets of results.

Explanation

Databricks SQL allows multiple visualizations to be created from a single Query, and both can be added independently to the same Dashboard - this is option B. Each visualization is its own object (bar chart, line chart, table, etc.) attached to the same underlying query result, so there's no need to duplicate or modify anything.

Why the distractors are wrong:

• A is unnecessary - copying the query is redundant work; one query can power multiple visualizations.
• C contradicts the goal; the analyst specifically wants two visualizations, not one.
• D is incorrect because the query doesn't need to change - visualizations simply present the same result set in different ways.

Memory tip: Think of a Query as a data source and visualizations as "views" into that source. One tap, many glasses - one query, many charts.

No community discussion yet for this question.