Databricks Data Analyst Associate Certification Sample Questions

01. A data analyst has been asked to count the number of customers in each region and has written the following query:
- SELECT region, count(*) AS number_of_customers
- FROM customers
- ORDER BY region;
What is the mistake in the query?
a) The query is selecting region, but region should only occur in the ORDER BY clause
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) The query is using count(*), which will count all the customers in the customers table, no matter the region.

02. What are the benefits of using Databricks SQL for in-Lakehouse platform data processing?
(Select two)
a) Reduced need for data movement
b) Limited scalability
c) Enhanced data security
d) Integration with legacy systems

03. Why might a user be unable to refresh a dashboard?
a) If they are using a mobile device
b) Lack of permissions to the underlying data
c) The dashboard is older than six months
d) They are not in the same timezone as the dashboard's owner

04. 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 code block 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 function(price(customer_spend, customer_units)) AS
customer_price
FROM customer_summary
b) SELECT double(price(customer_spend, customer_units)) AS
customer_price
FROM customer_summary
c) SELECT price
FROM customer_summary
d) SELECT PRICE customer_spend, customer_units AS customer_price
FROM customer_summary
e) SELECT price(customer_spend, customer_units) AS customer_price
FROM customer_summary

05. How can Databricks SQL dashboards be configured to refresh?
(Select two)
a) Manually by the viewer
b) At scheduled intervals
c) Automatically upon data updates
d) Using external triggers

06. Which of the following are essential practices for effective data management?
(Select two)
a) Regularly deleting unused data
b) Ensuring data quality and consistency
c) Restricting data access to as few users as possible
d) Automating data integration processes

07. A data analyst is trying to determine whether to develop their dashboard in Databricks SQL or a partner business intelligence (BI) tool like Tableau, Power BI, or Looker. When is it advantageous to use Databricks SQL instead of using third-party BI tools to develop the dashboard?
a) When the data being transformed as part of the visualizations is very large
b) When the visualizations require custom formatting
c) When the visualizations require production-grade, customizable branding
d) When the data being transformed is in table format

08. Which tools or features are commonly used for data visualization and dashboarding within analytics applications?
(Select three)
a) Apache Kafka
b) Databricks notebooks
c) Tableau
d) Microsoft Power BI
e) Docker containers

09. Where in the Databricks SQL workspace can a data analyst configure a refresh schedule for a query when the query is not attached to a dashboard or alert?
a) The Dashboard Editor
b) The Visualization Editor
c) The Query Editor
d) SQL Warehouse
e) Data Explorer

10. 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 term is used to describe this data augmentation?
a) Data testing
b) Last-mile ETL
c) Ad-hoc improvements
d) Data enhancement
e) Last-mile dashboarding