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

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 approaches can be used to ingest data directly from cloud-based object storage?

A. Create an external table while specifying the DBFS storage path to FROM

B. Create an external 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

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 is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?

A. ACID transactions

B. Flexible schemas

C. Data deletion

D. Scalable storage

E. Open-source formats

The stakeholders.customers table has 15 columns and 3,000 rows of data. The following command is run:

After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks. After logging back in two days later, what is the status of the stakeholders.eur_customers view?

A. The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.

B. The view has been dropped.

C. The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.

D. The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.

E. The view has been converted into a table.

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.

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

How can a data analyst determine if query results were pulled from the cache?

A. Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.

B. Go to the Alerts tab and check the Cache Status alert.

C. Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.

D. Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.

E. Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.

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.