CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #64
A data analyst wants to create a Databricks SQL dashboard with multiple data visualizations and multiple counters. What must be completed before adding the data visualizations and counters to the…
The correct answer is A. All data visualizations and counters must be created using Queries. In Databricks SQL, all data visualizations and counters are built on top of Queries - you must first write and save a SQL query, then create visualizations or counters from that query's results before they can be added to a dashboard. Option B is a distractor because while a…
Question
A data analyst wants to create a Databricks SQL dashboard with multiple data visualizations and multiple counters. What must be completed before adding the data visualizations and counters to the dashboard?
Options
- AAll data visualizations and counters must be created using Queries.
- BA SQL warehouse (formerly known as SQL endpoint) must be turned on and selected.
- CA markdown-based tile must be added to the top of the dashboard displaying the dashboard's
- DThe dashboard owner must also be the owner of the queries, data visualizations, and counters.
How the community answered
(36 responses)- A78% (28)
- B14% (5)
- C3% (1)
- D6% (2)
Explanation
In Databricks SQL, all data visualizations and counters are built on top of Queries - you must first write and save a SQL query, then create visualizations or counters from that query's results before they can be added to a dashboard. Option B is a distractor because while a SQL warehouse must be running to execute queries, it does not need to be selected as a prerequisite to building the dashboard itself. Option C is incorrect because a markdown tile is entirely optional and has no bearing on adding visualizations. Option D is wrong because dashboard ownership is independent of query ownership - you can add visualizations from queries owned by other users.
Memory tip: Think of it as a build order - Query → Visualization/Counter → Dashboard. You can't skip steps; the dashboard is just a container for things you've already built from queries.
Community Discussion
No community discussion yet for this question.