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

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.

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.

No community discussion yet for this question.