Certified Data Engineer Associate Exam - Free Exam Q&As, Page 5

Question #41

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?

A
They can set up an Alert with a custom template.
B
They can set up an Alert with a new email alert destination.
C
They can set up an Alert with a new webhook alert destination.
Most Voted
D
They can set up an Alert with one-time notifications.
E
They can set up an Alert without notifications.

Correct Answer:
C

Show Answer

send

light_mode delete

Question #42

A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job’s current run. The data engineer asks a tech lead for help in identifying why this might be the case.
Which of the following approaches can the tech lead use to identify why the notebook is running slowly as part of the Job?

A
They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook.
B
They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook.
C
They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.
Most Voted
D
There is no way to determine why a Job task is running slowly.
E
They can navigate to the Tasks tab in the Jobs UI to immediately review the processing notebook.

Correct Answer:
C

Show Answer

send

light_mode delete

Question #43

A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.
Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?

A
They can use endpoints available in Databricks SQL
B
They can use jobs clusters instead of all-purpose clusters
C
They can configure the clusters to be single-node
D
They can use clusters that are from a cluster pool
Most Voted
E
They can configure the clusters to autoscale for larger data sizes

Correct Answer:
D

Show Answer

send

light_mode delete

Question #44

A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

A
GRANT USAGE ON DATABASE customers TO team;
B
GRANT ALL PRIVILEGES ON DATABASE team TO customers;
C
GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
D
GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
E
GRANT ALL PRIVILEGES ON DATABASE customers TO team;
Most Voted

Correct Answer:
E

Show Answer

send

light_mode delete