Courseiva
← Back to Databricks Certified Data Analyst Associate questions

Scenario-based practice

Select Two (Multi-Select) Questions

Practise Databricks Certified Data Analyst Associate practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

20
scenario questions
Databricks-DA-Assoc
exam code
Databricks
vendor

Scenario guide

How to approach select two (multi-select) questions

Multi-select questions tell you to 'Choose TWO' or 'Choose THREE'. Getting partial credit is not a thing — you must select all correct answers with no incorrect ones. The stem always states how many to choose, so trust it. These questions require precision, not best-guess elimination.

Quick answer

Select Two (Multi-Select) Questions questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Related practice questions

Related Databricks-DA-Assoc topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Practice set

Practice scenarios

Question 1hardmulti select
Full question →

An analyst is preparing a Genie Space and wants to ensure users get the most accurate answers while maintaining security. Which TWO actions should the analyst take? (Choose two)

Question 2mediummulti select
Full question →

A Databricks workspace administrator wants to optimize costs and manage resources effectively. Which TWO of the following capabilities allow for automatic cluster termination and scaling?

Question 3hardmulti select
Full question →

Which TWO of the following are benefits of using Unity Catalog with Databricks SQL?

Question 4hardmulti select
Full question →

A data analyst is using the Databricks Add Data UI to import a CSV file from cloud storage into a Delta table. The analyst wants to ensure the import process handles the data correctly. Which two actions can the analyst perform directly in the Add Data UI? (Choose two.)

Question 5hardmulti select
Full question →

Which THREE actions occur when using Auto Loader with schema evolution enabled? (Choose three)

Question 6hardmulti select
Full question →

An analyst is reviewing a slow-running query and wants to identify potential bottlenecks. Which TWO of the following metrics in the Databricks SQL query profile are most indicative of inefficient data distribution?

Question 7mediummulti select
Full question →

Which TWO of the following are true regarding Databricks SQL Warehouses?

Question 8hardmulti select
Full question →

A user wants to import a local 50MB CSV file into a Databricks workspace for a quick ad-hoc analysis. Which TWO methods are available within the Databricks UI to accomplish this task directly?

Question 9mediummulti select
Full question →

An analyst needs to manage data lifecycle and performance in Databricks SQL. Which TWO of the following tasks are best achieved using the Liquid Clustering feature?

Question 10mediummulti select
Full question →

Which THREE of the following are benefits of using Liquid Clustering instead of traditional partitioning in Databricks SQL?

Question 11mediummulti select
Full question →

A data platform administrator needs to configure secure data access policies in Unity Catalog. Which TWO actions can the administrator perform to restrict access to sensitive columns within a Delta table? (Choose TWO)

Question 12hardmulti select
Full question →

Which TWO of the following are true about Databricks SQL Alerts? (Choose two)

Question 13hardmulti select
Full question →

Which THREE of the following are benefits of using Delta Lake over standard Parquet files in Databricks?

Question 14mediummulti select
Full question →

A data analyst is working in a Databricks workspace and needs to ensure that their notebook code is version-controlled and collaborative. Which TWO actions should they take?

Question 15hardmulti select
Full question →

Which THREE of the following are essential components of a well-architected AI/BI Genie Space setup?

Question 16mediummulti select
Full question →

Which THREE features are provided by AI/BI Genie spaces to help business users analyze data independently?

Question 17mediummulti select
Full question →

Which THREE of the following are valid sources for importing data into a Databricks Delta table? (Choose three)

Question 18hardmulti select
Full question →

Which THREE of the following are benefits of using the Delta Lake format in Databricks SQL?

Question 19hardmulti select
Full question →

An analyst is preparing a dashboard and needs to ensure that the queries powering it are as performant as possible. Which THREE techniques should the analyst use to optimize these SQL queries in Databricks?

Question 20mediummulti select
Full question →

Which THREE of the following are valid methods to optimize the performance of a slow-running SQL query in Databricks?

These Databricks-DA-Assoc practice questions are part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style Databricks-DA-Assoc questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.