Summer Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: takeit60

Databricks-Certified-Data-Analyst-Associate Databricks Certified Data Analyst Associate Exam Questions and Answers

Questions 4

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?

Options:

A.

Business analyst

B.

SQL analyst

C.

Data engineer

D.

Business intelligence analyst

E.

Data analyst

Buy Now
Questions 5

A data engineer is working with a nested array columnproductsin tabletransactions. They want to expand the table so each unique item inproductsfor each row has its own row where thetransaction_idcolumn is duplicated as necessary.

They are using the following incomplete command:

Which of the following lines of code can they use to fill in the blank in the above code block so that it successfully completes the task?

Options:

A.

array distinct(produces)

B.

explode(produces)

C.

reduce(produces)

D.

array(produces)

E.

flatten(produces)

Buy Now
Questions 6

A data analyst has been asked to use the below tablesales_tableto 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)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Buy Now
Questions 7

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?

Options:

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 drogdown list query parameters, not dates.

Buy Now
Questions 8

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?

Options:

A.

Heatmap

B.

IChoropleth

C.

Word Cloud

D.

Pivot Table

E.

Sankey

Buy Now
Questions 9

Which of the following approaches can be used to ingest data directly from cloud-based object storage?

Options:

A.

Createan external table while specifying the DBFS storage path to FROM

B.

Create anexternal table while specifying the DBFS storage path to PATH

C.

It is not possible to directly ingest data from cloud-based object storage

D.

Create an external table while specifying the object storage path to FROM

E.

Create an external table while specifying the object storage path to LOCATION

Buy Now
Questions 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 of the following terms is used to describe this data augmentation?

Options:

A.

Data testing

B.

Ad-hoc improvements

C.

Last-mile

D.

Last-mile ETL

E.

Data enhancement

Buy Now
Questions 11

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

Now, a data analyst runs the following command:

DROP accounts.customers;

Which of the following describes the result of running this command?

Options:

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.

Buy Now
Questions 12

Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

Options:

A.

Visualization scale can be changed.

B.

Data Labels can be formatted.

C.

Colors can be changed.

D.

Borders can be added.

E.

Tooltips can be formatted.

Buy Now
Questions 13

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?

Options:

A.

SELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary

B.

SELECT price FROM customer_summary

C.

SELECT function(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

D.

SELECT double(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

E.

SELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary

Buy Now
Exam Name: Databricks Certified Data Analyst Associate Exam
Last Update: Apr 21, 2024
Questions: 45
Databricks-Certified-Data-Analyst-Associate pdf

Databricks-Certified-Data-Analyst-Associate PDF

$32  $80
Databricks-Certified-Data-Analyst-Associate Engine

Databricks-Certified-Data-Analyst-Associate Testing Engine

$38  $95
Databricks-Certified-Data-Analyst-Associate PDF + Engine

Databricks-Certified-Data-Analyst-Associate PDF + Testing Engine

$52  $130