Databricks-Certified-Data-Analyst-Associate Databricks Certified Data Analyst Associate Exam - Practice Questions

Question 7

A data analyst has been asked to count the number of customers in each region and has written the following query:

If there is a mistake in the query, which of the following describes the mistake?

Select an option, then click Submit answer.

○
The query is using count('). which will count all the customers in the customers table, no matter the region.
○
The query is missing a GROUP BY region clause.
○
The query is using ORDER BY. which is not allowed in an aggregation.
○
There are no mistakes in the query.
○
The query is selecting region but region should only occur in the ORDER BY clause.

Reference / correct answer:

The query is missing a GROUP BY region clause.

In the provided SQL query, the data analyst is trying to count the number of customers in each region. However, they made a mistake by not including the œGROUP BY clause to group the results by region. Without this clause, the query will not return counts for each distinct region but rather an error or incorrect result. Reference: The need for a GROUP BY clause in such queries can be understood from Databricks SQL documentation: Databricks SQL.

I also noticed that you uploaded an image with your question. The image shows a snippet of an SQL query written in plain text on a white background. The query is attempting to select regions and count customers from a œcustomers table and order the results by region. There-s no visible syntax highlighting or any other color - it-s monochromatic. The query is the same as the one in your question. I-m not sure why you included the image, but maybe you wanted to show me the exact format of your query. If so, you can also use code blocks to display formatted content such as SQL queries. For example, you can write:

SELECT region, count(*) AS number_of_customers

FROM customers

ORDER BY region;

This way, you can avoid uploading images and make your questions more clear and concise. I hope this helps.

Question 8

Where in the Databricks SQL workspace can a data analyst configure a refresh schedule for a query when the query is not attached to a dashboard or alert?

Select an option, then click Submit answer.

○
Data bxplorer
○
The Visualization editor
○
The Query Editor
○
The Dashboard Editor

Question 9

A data analyst runs the following command:

INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers; What is the result of running this command?

Select an option, then click Submit answer.

○
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.
○
The command fails because it is written incorrectly.
○
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.
○
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.
○
The suppliers table now contains only the data from the new suppliers table.

Databricks-Certified-Data-Analyst-Associate – Databricks Certified Data Analyst Associate Exam