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

Question

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

Options

• AThey will need to alter the Query to return two separate sets of results.
• BThey will need to add two separate visualizations to the dashboard based on the same Query.
• CThey will need to create two separate dashboards.
• DThey will need to decide on a single data visualization to add to the dashboard.
• EThey will need to copy the Query and create one data visualization per query.

Explanation

B is correct because Databricks SQL allows multiple visualizations to be created from a single Query - each visualization (e.g., a bar chart and a pie chart) is built independently on top of the same underlying query result, and both can be added as separate widgets to the same dashboard without any duplication or modification of the query itself.

Why the distractors are wrong:

• A is wrong because the query doesn't need to return two result sets - one result set can power multiple different visualizations.
• C is wrong because both visualizations can coexist on a single dashboard; separate dashboards are unnecessary.
• D is wrong because Databricks SQL explicitly supports adding multiple visualizations to one dashboard - you are not limited to one.
• E is wrong because copying the query is unnecessary overhead; the same query can serve as the data source for many visualizations simultaneously.

Memory tip: Think of a query as a data "tap" - you can attach as many "cups" (visualizations) as you want to a single tap, and pour them all onto the same "tray" (dashboard). No need to duplicate the tap.

No community discussion yet for this question.