Databricks Databricks-Certified-Data-Analyst-Associate Exam With Confidence Using Practice Dumps

Option B is correct. The problem is many users running small queries simultaneously, which is a concurrency issue. Increasing the maximum number of clusters lets the SQL warehouse scale out to serve more concurrent queries. Increasing cluster size is more useful for complex or resource-heavy queries, not necessarily many small simultaneous queries. Auto Stop reduces cost but does not improve active-query latency. Official Databricks extract: “You can increase the maximum clusters if you want to handle more concurrent users,” and Databricks recommends monitoring queued queries and adjusting maximum clusters.

Markdown-based text boxes are useful as labels on a dashboard. They allow the data analyst to add text to a dashboard using the %md magic command in a notebook cell and then select the dashboard icon in the cell actions menu. The text can be formatted using markdown syntax and can include headings, lists, links, images, and more. The text boxes can be resized and moved around on the dashboard using the float layout option. References: Dashboards in notebooks, How to add text to a dashboard in Databricks

Option C is correct. DESCRIBE DATABASE customer360 returns metadata for the database/schema, including its filesystem location. DESCRIBE LOCATION is for external locations, not databases. DROP DATABASE deletes a database, ALTER DATABASE changes metadata/properties, and USE DATABASE changes the current database context. Official Databricks extract: DESCRIBE DATABASE is an alias for DESCRIBE SCHEMA, and DESCRIBE SCHEMA returns metadata including the schema’s “location on the filesystem.”