Databricks-Certified-Data-Analyst-Associate Exam Training Practice Tests (Databricks Certified Data Analyst Associate)]

Question 1

A Data Analyst is working on sensor_df; this DataFrame contains two columns: record_datetime timestamp and record array.
Which code fragment returns a DataFrame that splits the record column into separate columns and has one array item per row?

A. exploded_df = exploded_df.select( " record_datetime " , " record_exploded " ) B. Uses withColumn, but selects sensor_id, status, and health as if they are already top-level columns. C. Selects nested fields before correctly creating the exploded column. D. exploded_df = sensor_df.withColumn( " record_exploded " , explode( " record " ))exploded_df = exploded_df.select( " record_datetime " , " record_exploded.sensor_id " , " record_exploded.status " , " record_exploded.health " )

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

A. Data Explorer B. Auto Loader C. Delta Lake D. Delta Live Tables E. Unity Catalog

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

What describes the variance of a set of values?

A. Variance is a measure of how far a set of values is spread out from the sets central value. B. Variance is a measure of central tendency of a set of values. C. Variance is a measure of how far a single observed value is from a set ot va IN D. Variance is a measure of how far an observed value is from the variable ' s maximum or minimum value.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every 10 minutes.
A data analyst has created a dashboard based on this gold level data. The project stakeholders want to see the results in the dashboard updated within 10 minutes or less of new data becoming available within the gold- level tables.
What is the ability to ensure the streamed data is included in the dashboard at the standard requested by the project stakeholders?

A. A refresh schedule with an interval of 10 minutes or less B. A refresh schedule with stakeholders included as subscribers C. A refresh schedule with an always-on SQL Warehouse (formerly known as SQL Endpoint D. A refresh schedule with a Structured Streaming cluster

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

Consider the following two statements:
Statement 1:

Statement 2:
Which of the following describes how the result sets will differ for each statement when they are run in Databricks SQL?

A. There is no difference between the result sets for both statements. B. When the first statement is run, all rows from the customers table will be returned and only the customer_id from the orders table will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned. C. When the first statement is run, only rows from the customers table that have at least one match with the orders table on customer_id will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned. D. The first statement will return all data from the customers table and matching data from the orders table. The second statement will return all data from the orders table and matching data from the customers table. Any missing data will be filled in with NULL. E. Both statements will fail because Databricks SQL does not support those join types.

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed.
Which approach can the data analyst use to accomplish this task with minimal effort/

A. By adding the stakeholders ' email addresses to the refresh schedule subscribers list B. By granting the stakeholders ' email addresses to the SQL Warehouse (formerly known as endpoint) subscribers list C. By downloading the dashboard as a PDF and emailing it to the stakeholders each time it is refreshed D. By granting the stakeholders ' email addresses permissions to the dashboard

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

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 a complete replacement with additional functionality B. As a complementary tool for quick in-platform Bl work C. As an exact substitute with the same level of functionality D. As a complementary tool for professional-grade presentations E. As a substitute with less functionality

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

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