DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE Online Practice Questions and Answers

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

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

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. Option A

B. Option B

C. Option C

D. Option D

E. Option 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:

The result of the query should look like this:

Which of the following queries will accomplish this task?

A. Option A

B. Option B

C. Option C

D. Option D

E. Option 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 priceFROM 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

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

Which of the following statements about a refresh schedule is incorrect?

A. A query can be refreshed anywhere from 1 minute to 2 weeks.

B. Refresh schedules can be configured in the Query Editor.

C. A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).

D. A refresh schedule is not the same as an alert.

E. You must have workspace administrator privileges to configure a refresh schedule.

A data team has been given a series of projects by a consultant that need to be implemented in the Databricks Lakehouse Platform.

Which of the following projects should be completed in Databricks SQL?

A. Testing the quality of data as it is imported from a source

B. Tracking usage of feature variables for machine learning projects

C. Combining two data sources into a single, comprehensive dataset

D. Segmenting customers into like groups using a clustering algorithm

E. Automating complex notebook-based workflows with multiple tasks

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.

Which of the following terms is used to describe this type of work?

A. Data blending

B. Last-mile dashboarding

C. Data testing

D. Last-mile ETL

E. Data enhancement

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