How accurate are the Certified Data Analyst Associate practice questions?

All Certified Data Analyst Associate questions are community-created and reviewed by moderators to align with Databricks's published exam objectives. The community continuously reports and fixes issues to keep content accurate and up to date.

How should I study for the Certified Data Analyst Associate exam?

Start by browsing practice questions to identify weak areas. Use spaced repetition (Learn Mode) to focus study time on topics you struggle with. Combine practice questions with official Databricks documentation and hands-on experience for best results.

Certified Data Analyst Associate Practice Exam — Free 140+ Questions

140Practice Questions

3Study Modes

FreeTo Get Started

Topic:Sort:

Question 1

Managing Data

Question 2

Importing Data

Question 3

Working with Dashboards and Visualizations in Databricks

Question 4

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 5

Working with Dashboards and Visualizations in Databricks

Question 6

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 7

Securing Data

Question 8

Managing Data

Question 9

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 10

Managing Data

Question 11

Managing Data

Question 12

Analyzing Queries

Question 13

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 14

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 15

Analyzing Queries

Question 16

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 17

Data Modeling with Databricks SQL

Question 18

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 19

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 20

Working with Dashboards and Visualizations in Databricks

Question 21

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 22

Managing Data

Question 23

Executing queries using Databricks SQL and Databricks SQL Warehouses

Question 24

Understanding of Databricks Data Intelligence Platform

Question 25

Managing Data

Page 1 of 6 • Questions 1-25 of 140

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

Which of the following layers of the medallion architecture is most commonly used by data analysts?

A None of these layers are used by data analysts
B Gold
C All of these layers are used equally by data analysts
D Silver
E Bronze

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

A Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
B Use Delta Live Tables to establish a cluster for Fivetran to interact with
C Use Partner Connect's automated workflow to establish a cluster for Fivetran to interact with
D Use Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
E Use Workflows to establish a cluster for Fivetran to interact with

Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

A As an exact substitute with the same level of functionality
B As a substitute with less functionality
C As a complete replacement with additional functionality
D As a complementary tool for professional-grade presentations
E As a complementary tool for quick in-platform BI work

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?

A Data page
B Dashboards page
C Queries page
D Alerts page
E SQL Editor page

A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard.
Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

A Separate endpoints for each section
B Separate queries for each section
C Markdown-based text boxes
D Direct text written into the dashboard in editing mode
E Separate color palettes for each section

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?

A Delta Lake
B Databricks Notebooks
C Tableau
D Databricks Machine Learning
E Databricks SQL

Which of the following should data analysts consider when working with personally identifiable information (PII) data?

A Organization-specific best practices for PII data
B Legal requirements for the area in which the data was collected
C None of these considerations
D Legal requirements for the area in which the analysis is being performed
E All of these considerations

Delta Lake stores table data as a series of data files, but it also stores a lot of other information.
Which of the following is stored alongside data files when using Delta Lake?

A None of these
B Table metadata, data summary visualizations, and owner account information
C Table metadata
D Data summary visualizations
E Owner account information

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

A It can be used to run UPDATE queries to update any tables in a database.
B It can be used to view metadata and data, as well as view/change permissions.
C It can be used to produce dashboards that allow data exploration.
D It can be used to make visualizations that can be shared with stakeholders.
E It can be used to connect to third party BI cools.

A data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.
Which of the following approaches can the analyst use to complete the task?

A Edit the Owner field in the table page by removing their own account
B Edit the Owner field in the table page by selecting All Users
C Edit the Owner field in the table page by selecting the new owner's account
D Edit the Owner field in the table page by selecting the Admins group
E Edit the Owner field in the table page by removing all access

A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?

A DROP DATABASE database_name;
B DROP TABLE database_name.table_name;
C DELETE TABLE database_name.table_name;
D DELETE TABLE table_name FROM database_name;
E DROP TABLE table_name FROM database_name;

A data analyst runs the following command:

SELECT age, country -

FROM my_table -
WHERE age >= 75 AND country = 'canada';
Which of the following tables represents the output of the above command?

A
B
C
D
E

A data analyst has created a user-defined function using the following line of code:
CREATE FUNCTION price(spend DOUBLE, units DOUBLE)

RETURNS DOUBLE -
RETURN spend / units;
Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?

A SELECT PRICE customer_spend, customer_units AS customer_priceFROM customer_summary
B SELECT price -FROM customer_summary
C SELECT function(price(customer_spend, customer_units)) AS customer_priceFROM customer_summary
D SELECT double(price(customer_spend, customer_units)) AS customer_priceFROM customer_summary
E SELECT price(customer_spend, customer_units) AS customer_priceFROM customer_summary

Consider the following two statements:
Statement 1:

Question Image

Statement 2:

Question Image

Which of the following describes how the result sets will differ for each statement when they are run in Databricks SQL?

A The first statement will return all data from the customers table and matching data from the orders table. The second statement will return all data from the orders table and matching data from the customers table. Any missing data will be filled in with NULL.
B When the first statement is run, only rows from the customers table that have at least one match with the orders table on customer_id will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.
C There is no difference between the result sets for both statements.
D Both statements will fail because Databricks SQL does not support those join types.
E When the first statement is run, all rows from the customers table will be returned and only the customer_id from the orders table will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.

A data analyst has been asked to count the number of customers in each region and has written the following query:

Question Image

If there is a mistake in the query, which of the following describes the mistake?

A The query is using count(*), which will count all the customers in the customers table, no matter the region.
B The query is missing a GROUP BY region clause.
C The query is using ORDER BY, which is not allowed in an aggregation.
D There are no mistakes in the query.
E The query is selecting region, but region should only occur in the ORDER BY clause.

Which of the following is a benefit of Databricks SQL using ANSI SQL as its standard SQL dialect?

A It has increased customization capabilities
B It is easy to migrate existing SQL queries to Databricks SQL
C It allows for the use of Photon's computation optimizations
D It is more performant than other SQL dialects
E It is more compatible with Spark's interpreters

A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person.
Which of the following code blocks will accomplish this task?

A
B
C
D
E

A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales:

Question Image

The result of the query should look like this:

Question Image

Which of the following queries will accomplish this task?

A
B
C
D
E

A data analyst is processing a complex aggregation on a table with zero null values and their query returns the following result:

Question Image

Which of the following queries did the analyst run to obtain the above result?

A
B
C
D
E

A data analyst has been asked to produce a visualization that shows the flow of users through a website.
Which of the following is used for visualizing this type of flow?

A Heatmap
B Choropleth
C Word Cloud
D Pivot Table
E Sankey

A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.
The Alert does not work.
Which of the following describes why the Alert does not work?

A Alerts don't work with queries that access tables.
B Queries that return results based on dates cannot be used with Alerts.
C The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
D Queries that use query parameters cannot be used with Alerts.
E The wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.

A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.
Which of the following terms is used to describe this data augmentation?

A Data testing
B Ad-hoc improvements
C Last-mile dashboarding
D Last-mile ETL
E Data enhancement

A data analyst runs the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of running this command?

A The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, and any duplicate data is deleted.
B The command fails because it is written incorrectly.
C The suppliers table now contains both the data it had before the command was run and the data from the new_suppliers table, including any duplicate data.
D The suppliers table now contains the data from the new_suppliers table, and the new_suppliers table now contains the data from the suppliers table.
E The suppliers table now contains only the data from the new_suppliers table.

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?

A Business analyst
B SQL analyst
C Data engineer
D Business intelligence analyst
E Data analyst

After running DESCRIBE EXTENDED accounts.customers;, the following was returned:

Question Image

Now, a data analyst runs the following command:
DROP accounts.customers;
Which of the following describes the result of running this command?

A Running SELECT * FROM delta. dbfs:/stakeholders/customers results in an error.
B Running SELECT * FROM accounts.customers will return all rows in the table.
C All files with the .customers extension are deleted.
D The accounts.customers table is removed from the metastore, and the underlying data files are deleted.
E The accounts.customers table is removed from the metastore, but the underlying data files are untouched.

Certified Data Analyst AssociatePreview

About the Certified Data Analyst Associate Exam

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Certified Data Analyst AssociatePreview

About the Certified Data Analyst Associate Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25