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

Which of the following layers of the medallion architecture is most commonly used by data analysts?

A. None of these layers are used by data analysts

B. Gold

C. All of these layers are used equally by data analysts

D. Silver

E. Bronze

Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

A. As an exact substitute with the same level of functionality

B. As a substitute with less functionality

C. As a complete replacement with additional functionality

D. As a complementary tool for professional-grade presentations

E. As a complementary tool for quick in-platform BI work

A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.

Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

A. Reduce the SQL endpoint cluster size

B. Increase the SQL endpoint cluster size

C. Turn off the Auto stop feature

D. Increase the minimum scaling value

E. Use a Serverless SQL endpoint

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

Which of the following commands can the analyst use to complete the task without producing an error?

A. DROP DATABASE database_name;

B. DROP TABLE database_name.table_name;

C. DELETE TABLE database_name.table_name;

D. DELETE TABLE table_name FROM database_name;

E. DROP TABLE table_name FROM database_name;

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?

A. array distinct(products)

B. explode(products)

C. reduce(products)

D. array(products)

E. flatten(products)

A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person.

Which of the following code blocks will accomplish this task?

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

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