CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #34
CERTIFIED-DATA-ANALYST-ASSOCIATE Question #34: Real Exam Question with Answer & Explanation
The correct answer is C: Data engineer. Data engineers primarily work in Databricks Data Science and Engineering (DSE) - building pipelines, transforming data, and orchestrating workflows - but may use Databricks SQL secondarily to query or validate data. Their core work lives in notebooks, jobs, and ETL pipelines, not
Question
Data professionals with varying titles use the Databricks SQL service as the primary touchpoint with the Databricks Lakehouse Platform. However, some users will use other services like Databricks Machine Learning or Databricks Data Science and Engineering. Which of the following roles uses Databricks SQL as a secondary service while primarily using one of the other services?
Options
- ABusiness analyst
- BSQL analyst
- CData engineer
- DBusiness intelligence analyst
- EData analyst
Explanation
Data engineers primarily work in Databricks Data Science and Engineering (DSE) - building pipelines, transforming data, and orchestrating workflows - but may use Databricks SQL secondarily to query or validate data. Their core work lives in notebooks, jobs, and ETL pipelines, not SQL dashboards.
Why the distractors are wrong:
- A (Business analyst), B (SQL analyst), D (BI analyst), and E (Data analyst) all center their daily work around querying, reporting, and visualizing data - making Databricks SQL their primary touchpoint, not a secondary one. These roles live in SQL editors and dashboards, not pipeline code.
Memory tip: Think about where each role spends most of their day. If the title suggests "data movement/building" → SQL is secondary (engineer). If the title suggests "data consumption/reporting" → SQL is primary (analyst). The word "engineer" signals a builder, not a consumer.
Community Discussion
No community discussion yet for this question.