Databricks Certified Data Analyst Associate — Question 39

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?

Answer options

• A. They will need to alter the Query to return two separate sets of results.
• B. They will need to add two separate visualizations to the dashboard based on the same Query.
• C. They will need to create two separate dashboards.
• D. They will need to decide on a single data visualization to add to the dashboard.
• E. They will need to copy the Query and create one data visualization per query.

Correct answer: B

Explanation

The correct answer is B because a single Query can yield multiple visualizations based on the same result set, allowing both to be added to the same dashboard. Option A is incorrect as altering the Query is unnecessary for creating multiple visualizations. Options C and D are not valid because they suggest creating additional dashboards or limiting to one visualization, which is not required. Option E is also wrong because copying the Query is not needed when both visualizations can derive from the same Query.