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

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?

A. Separate endpoints for each section

B. Separate queries for each section

C. Markdown-based text boxes

D. Direct text written into the dashboard in editing mode

E. Separate color palettes for each section

After running DESCRIBE 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?

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.

Delta Lake stores table data as a series of data files, but it also stores a lot of other information. Which of the following is stored alongside data files when using Delta Lake?

A. None of these

B. Table metadata, data summary visualizations, and owner account information

C. Table metadata

D. Data summary visualizations

E. Owner account information

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 created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.

Which of the following approaches can the analyst use to complete the task?

A. Edit the Owner field in the table page by removing their own account

B. Edit the Owner field in the table page by selecting All Users

C. Edit the Owner field in the table page by selecting the new owner's account

D. Edit the Owner field in the table page by selecting the Admins group

E. Edit the Owner field in the table page by removing all access

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

A data analyst has been asked to provide a list of options on how to share a dashboard with a client. It is a security requirement that the client does not gain access to any other information, resources, or artifacts in the database. Which of the following approaches cannot be used to share the dashboard and meet the security requirement?

A. Download the Dashboard as a PDF and share it with the client.

B. Set a refresh schedule for the dashboard and enter the client's email address in the "Subscribers" box.

C. Take a screenshot of the dashboard and share it with the client.

D. Generate a Personal Access Token that is good for 1 day and share it with the client.

E. Download a PNG file of the visualizations in the dashboard and share them with the client.

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.

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

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.