10 free Databricks Data Analyst Associate practice questions with the correct answer and a full explanation for each, taken from the CertStash pack of 140 questions. Work through them, then open each answer to check your reasoning.
Get all 140 questions (US$39) · Download these 10 as a PDF
Question 1
Which of the following layers of the medallion architecture is most commonly used by data analysts?
Show answer and explanation
Correct answer: B. Gold
Data analysts most commonly work with the Gold layer of the medallion architecture. The Gold layer contains clean, aggregated, business-ready data that is optimized for analytics and reporting. While data engineers may work across all layers, analysts typically focus on the Gold layer for their analysis and dashboard creation.
Why the other options are wrong
- A. Data analysts do use medallion architecture layers, specifically the Gold layer
- C. Data analysts do not use all layers equally; they primarily use the Gold layer
- D. While the Silver layer contains cleansed data, analysts focus on the Gold layer for business reporting
- E. The Bronze layer contains raw data and is not commonly used by analysts
Question 2
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?
Show answer and explanation
Correct answer: E. SQL Editor page
The SQL Editor page is where data analysts can write and execute SQL queries in Databricks SQL. This is the primary interface designed for query development and execution within the Databricks SQL service.
Why the other options are wrong
- A. The Data page is for browsing and exploring tables and data assets, not for writing queries
- B. The Dashboards page is for viewing and managing dashboards, not for writing SQL queries
- C. The Queries page is for managing and organizing saved queries, not the primary place to write new queries
- D. The Alerts page is for setting up and managing alerts, not for writing SQL queries
Question 3
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?
Show answer and explanation
Correct answer: E. As a complementary tool for quick in-platform BI work
Databricks SQL should be used as a complementary tool for quick in-platform BI work alongside dedicated BI tools like Tableau, Power BI, and Looker. While Databricks SQL provides visualization and dashboard capabilities, it is not intended to replace professional-grade BI tools. It excels at enabling analysts to quickly explore data and create simple visualizations without leaving the Databricks platform.
Why the other options are wrong
- A. Databricks SQL does not have the same level of functionality as dedicated BI tools
- B. This framing is unnecessarily negative; it is complementary rather than a lesser substitute
- C. Databricks SQL is not a complete replacement for BI tools; dedicated tools offer more advanced features
- D. While professional-grade presentations are relevant, the focus is on quick in-platform work
Question 4
Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?
Show answer and explanation
Correct answer: D. Use Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with Partner Connect's automated workflow is used to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with. This streamlined approach automates the connection setup and provisioning of the necessary compute resources without requiring manual configuration.
Why the other options are wrong
- A. Workflows are for orchestrating tasks, not for establishing connections with Partner Connect
- B. Delta Live Tables are for building data pipelines, and clusters are not the appropriate compute for Fivetran integration
- C. Partner Connect is correct, but clusters are not the appropriate compute resource; SQL warehouses are used
- E. Workflows are not the mechanism for Partner Connect integration; Partner Connect provides the automated workflow
Question 5
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?
Show answer and explanation
Correct answer: C. Data engineer
Data engineers use Databricks SQL as a secondary service while primarily using Databricks Data Science and Engineering. Data engineers focus on building and maintaining data pipelines, transformations, and infrastructure using notebooks and Workflows, with SQL as a supporting tool for validation and querying.
Why the other options are wrong
- A. Business analysts primarily use Databricks SQL as their main touchpoint
- B. SQL analysts use Databricks SQL as their primary service
- D. Business intelligence analysts use Databricks SQL as their primary service
- E. Data analysts use Databricks SQL as their primary service
Question 6
A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.
Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?
Show answer and explanation
Correct answer: E. Use a Serverless SQL endpoint
Using a Serverless SQL endpoint is the optimal solution to reduce startup time while managing costs. Serverless endpoints automatically handle scaling and startup without requiring manual cluster management, eliminating cold-start delays while providing cost efficiency through on-demand resource provisioning.
Why the other options are wrong
- A. Reducing cluster size would worsen performance and startup issues, not improve them
- B. Increasing cluster size would increase costs without addressing the startup delay problem
- C. Turning off Auto stop would keep the endpoint running constantly, increasing costs significantly
- D. Increasing the minimum scaling value would keep more resources running, increasing costs without solving cold-start issues
Question 7
A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The micro-batches are triggered every minute.
A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables.
Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?
Show answer and explanation
Correct answer: A. The required compute resources could be costly
The data analyst should caution that the required compute resources could be costly when attempting to refresh a dashboard within one minute or less. Achieving such frequent refresh rates requires significant compute resources to continuously query the gold-level tables, which translates to substantial infrastructure costs that stakeholders need to understand and approve.
Why the other options are wrong
- B. Gold-level tables are specifically designed to be clean and appropriate for business reporting
- C. Streaming data sources are appropriate for dashboards; the concern is about refresh frequency and cost
- D. Databricks streaming clusters are fault tolerant and suitable for production pipelines
- E. Dashboards can be refreshed at sub-minute intervals if the underlying compute is provisioned
Question 8
Which of the following approaches can be used to ingest data directly from cloud-based object storage?
Show answer and explanation
Correct answer: E. Create an external table while specifying the object storage path to LOCATION
storage path to LOCATION To ingest data directly from cloud-based object storage, create an external table while specifying the object storage path to the LOCATION keyword. The LOCATION clause tells Spark where the data files are stored in cloud storage (S3, ADLS, GCS, etc.), allowing the table to reference data without copying it into Databricks' managed storage.
Why the other options are wrong
- A. DBFS storage paths are not appropriate for cloud-based object storage; LOCATION is the correct keyword
- B. DBFS paths and the PATH keyword are not used for external table creation from cloud storage
- C. It is entirely possible to directly ingest data from cloud-based object storage using external tables
- D. While the object storage path is correct, FROM is not the appropriate keyword; LOCATION is used
Question 9
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?
Show answer and explanation
Correct answer: C. Markdown-based text boxes
Markdown-based text boxes are the standard tool in Databricks dashboards for adding descriptive text labels and section headers. They allow data analysts to clearly designate different sections of a dashboard using formatted text without affecting the data visualizations themselves. This is a native dashboard feature that maintains clarity and organization.
Why the other options are wrong
- A. Separate endpoints are backend infrastructure concepts unrelated to dashboard text labeling.
- B. Separate queries create different data sources but do not provide text designation on the dashboard itself.
- D. Direct text editing in dashboard mode is not a supported method for adding persistent text labels in Databricks dashboards.
- E. Color palettes distinguish sections visually but do not provide explicit text designation as required.
Question 10
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?
Show answer and explanation
Correct answer: E. Databricks SQL
Databricks SQL is the dedicated service within the Lakehouse Platform that meets all three requirements: it enables quick creation of SQL queries, supports serverless compute resources (SQL Warehouses can be configured as serverless), and allows data visualizations to be created and organized within dashboards. The other options lack one or more of these capabilities.
Why the other options are wrong
- A. Delta Lake is a storage format and engine, not a service for creating queries, visualizations, or dashboards.
- B. Notebooks support SQL queries but do not have native serverless compute options or built-in dashboard capabilities.
- C. Tableau is an external third-party tool, not a native Databricks service, and has licensing and integration considerations.
- D. Machine Learning is specialized for model training and inference, not for general SQL queries and business dashboards.
That was 10 of 140.
The full Databricks Data Analyst Associate pack has all 140 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free monthly updates and a pass-or-your-money-back guarantee.