Certified Data Engineer Associate Practice Test

Certified Data Engineer Associate Practice Test practice questions, page 9 of 12, with answer review and explanations.

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?

  1. They can set up an Alert with a custom template.
  2. They can set up an Alert with a new email alert destination.
  3. They can set up an Alert with a new webhook alert destination.
  4. They can set up an Alert with one-time notifications.
  5. They can set up an Alert without notifications.

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?

  1. They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook.
  2. They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook.
  3. They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.
  4. There is no way to determine why a Job task is running slowly.
  5. They can navigate to the Tasks tab in the Jobs UI to immediately review the processing notebook.

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?

  1. They can use endpoints available in Databricks SQL
  2. They can use jobs clusters instead of all-purpose clusters
  3. They can configure the clusters to be single-node
  4. They can use clusters that are from a cluster pool
  5. They can configure the clusters to autoscale for larger data sizes

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?

  1. GRANT USAGE ON DATABASE customers TO team;
  2. GRANT ALL PRIVILEGES ON DATABASE team TO customers;
  3. GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
  4. GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
  5. GRANT ALL PRIVILEGES ON DATABASE customers TO team;

Question 45

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team. Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

  1. GRANT VIEW ON CATALOG customers TO team;
  2. GRANT CREATE ON DATABASE customers TO team;
  3. GRANT USAGE ON CATALOG team TO customers;
  4. GRANT CREATE ON DATABASE team TO customers;
  5. GRANT USAGE ON DATABASE customers TO team;