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

Question

A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard. Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

Options

• ADelta Lake
• BDatabricks Notebooks
• CTableau
• DDatabricks Machine Learning
• EDatabricks SQL

Explanation

Databricks SQL is the purpose-built service for running SQL queries, creating visualizations, and organizing those visualizations into dashboards - with native support for serverless compute, checking every box in the requirement.

Why the others fail:

• A. Delta Lake - a storage format/table protocol, not a query/visualization service.
• B. Databricks Notebooks - supports SQL and some visualizations, but dashboards are limited and it is not the primary serverless SQL/BI tool.
• C. Tableau - a third-party BI tool that can connect to Databricks but is not a Databricks platform service and has no serverless compute of its own within Databricks.
• D. Databricks Machine Learning - focused on ML experimentation, model training, and MLflow tracking, not SQL analytics or BI dashboards.

Memory tip: Think "SQL → Serverless → Dashboards" and the service name literally contains "SQL" - Databricks SQL is the lakehouse's dedicated BI layer, analogous to a cloud data warehouse experience sitting on top of the open lakehouse.

No community discussion yet for this question.