Online Access Free Databricks-Certified-Data-Analyst-Associate Practice Test

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)

B)

C)

D)

• A.Option D
• B.Option C
• C.Option A
• D.Option B

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.
• B.
• C.

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.Data summary visualizations
• C.Table metadata, data summary visualizations, and owner account information
• D.Owner account information
• E.Table metadata

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.
Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

• A.They will need to copy the Query and create one data visualization per query.
• B.They will need to create two separate dashboards.
• C.They will need to decide on a single data visualization to add to the dashboard.
• D.They will need to add two separate visualizations to the dashboard based on the same Query.
• E.They will need to alter the Query to return two separate sets of results.

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.Download a PNG file of the visualizations in the dashboard and share them with the client.
• D.Generate a Personal Access Token that is good for 1 day and share it with the client.
• E.Take a screenshot of the dashboard and share it with the client.