Question 1

The data engineering team is using a SQL query to review data completeness every day to monitor the ETL job, and query output is being used in multiple dashboards which of the following approaches can be used to set up a schedule and automate this process?

Options :

A : They can schedule the query to run every day from the Jobs UI.

B : They can schedule the query to refresh every day from the query’s page in Databricks SQL

C : They can schedule the query to run every 12 hours from the Jobs UI.

D : They can schedule the query to refresh every day from the SQL endpoint’s page in Databricks SQL.

E : They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL

Answer: B

Question 2

You were asked to identify number of times a temperature sensor exceed threshold temperature (100.00) by each device, each row contains 5 readings collected every 5 minutes, fill in the blank with the appropriate functions

Schema: deviceId INT, deviceTemp ARRAY< double >, dateTimeCollected TIMESTAMP

2022-07-10-07-48-44-ce161b7b323528430beda1ec35cfd36e

SELECT deviceId, __ (__ (__(deviceTemp], i -> i > 100.00)))

FROM devices

GROUP BY deviceId

Options :

A : SUM, COUNT, SIZE

B : SUM, SIZE, SLICE

C : SUM, SIZE, ARRAY_CONTAINS

D : SUM, SIZE, ARRAY_FILTER

E : SUM, SIZE, FILTER

Answer: A

Question 3

A data engineer has left the organization. The data team needs to transfer ownership of the data engineer’s Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team. Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

Options :

A : Databricks account representative

B : This transfer is not possible

C : Workspace administrator

D : New lead data engineer

E : Original data engineer

Answer: D

Question 4

Data science team members are using a single cluster to perform data analysis, although cluster size was chosen to handle multiple users and auto-scaling was enabled, the team realized queries are still running slow, what would be the suggested fix for this?

Options :

A : Setup multiple clusters so each team member has their own cluster

B : Disable the auto-scaling feature

C : Use High concurrency mode instead of the standard mode

D : Increase the size of the driver node

Answer: C

Question 5

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

Options :

A : None of these changes will need to be made

B : The pipeline will need to stop using the medallion-based multi-hop architecture

C : The pipeline will need to be written entirely in SQL

D : The pipeline will need to use a batch source in place of a streaming source

E : The pipeline will need to be written entirely in Python

Answer: B

Free Databricks-Certified-Associate-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: