Databricks Databricks-Certified-Data-Analyst-Associate Actual Free Exam Questions & Community Discussion

Which of the following SQL keywords can be used to convert a table from a long format to a wide format?

A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions.
In which of the following locations can the data engineer review their permissions on the table?

A data analyst wants the following output:

Which statement will produce this output?

A data analyst runs the following command:
INSERT INTO stakeholders.suppliers TABLE stakeholders.new_suppliers;
What is the result of running this command?

Which location can be used to determine the owner of a managed table?

A data analyst has developed a query that runs against a Delta table. They want help from the data engineering team to implement a series of tests to ensure the data returned by the query is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following operations could the data engineering team use to run the query and operate with the results in PySpark?

A data analyst is working with the following table my_table:
customer_name dollars_spent
Hex Sprockets [125.34, 100.15, 9003.99]
Dented Fenders [16.99, 200.85, 33.49, 88.17]
The analyst wants to divide each value in the dollars_spent array by 100 to get the spend in terms of hundreds of dollars using the following code block:
SELECT
customer_name,
_______
FROM my_table;
Which line of code can be used to fill in the blank so that the above code block successfully completes the task?

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?

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?