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

Question

Which of the following benefits of using Databricks SQL is provided by Data Explorer?

Options

• AIt can be used to run UPDATE queries to update any tables in a database.
• BIt can be used to view metadata and data, as well as view/change permissions.
• CIt can be used to produce dashboards that allow data exploration.
• DIt can be used to make visualizations that can be shared with stakeholders.
• EIt can be used to connect to third party Bl cools.

Explanation

Data Explorer in Databricks SQL is specifically designed as a metadata and permissions management tool - it lets you browse databases, tables, and columns, preview sample data, and manage access controls (view/change permissions), making B the correct answer.

Why the distractors are wrong:

• A is incorrect because Data Explorer is read-oriented for browsing metadata; running DML queries like UPDATE is done in the SQL Editor, not Data Explorer.
• C is incorrect because dashboards are a feature of Databricks SQL's Dashboard section, not Data Explorer.
• D is incorrect because visualizations are created in the Query Editor or Dashboard tools, not Data Explorer.
• E is incorrect because connecting to third-party BI tools (like Tableau or Power BI) is done via SQL Warehouses (connection endpoints), not Data Explorer.

Memory tip: Think of Data Explorer as a catalog browser - it's for exploring what exists and who can see it, not for running queries, building dashboards, or connecting external tools. If the answer involves browsing structure or managing permissions, it's Data Explorer.

No community discussion yet for this question.