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

Question

A data analyst has recently joined a new team that uses Databricks SQL, but the analyst has never used Databricks before. The analyst wants to know where in Databricks SQL they can write and execute SQL queries. On which of the following pages can the analyst write and execute SQL queries?

Options

• AData page
• BDashboards page
• CQueries page
• DAlerts page
• ESQL Editor page

Explanation

Option E (SQL Editor page) is correct because the SQL Editor is the dedicated workspace in Databricks SQL where users write, run, and save SQL queries against connected data sources - it functions like a standard SQL IDE within the platform.

The distractors are wrong for these reasons:

• A (Data page): Used for browsing databases, tables, and schemas - a read-only catalog explorer, not a query execution environment.
• B (Dashboards page): Used to build and view visual dashboards from pre-existing query results, not to write new queries.
• C (Queries page): Displays a list of saved queries for management and reuse, but you navigate to the SQL Editor to actually write or edit them.
• D (Alerts page): Used to configure notifications triggered by query result thresholds - it monitors data, not writes queries.

Memory tip: Think of it by analogy - just as a text editor is where you write code, the SQL Editor is where you write SQL. The other pages (Dashboards, Queries, Alerts) all consume the results of queries but none of them is where you author them.

No community discussion yet for this question.