← Back to exam page

Free CERTIFIED-DATA-ENGINEER-ASSOCIATE – Databricks CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice Test Question

Loading demo links...

Showing 10–12 of 17 questions

Question 10 (Topic 1)

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 action can the data engineer perform to improve the start up time for the clusters used for the Job?

Select an option, then click Submit answer.

  • ○ They can use endpoints available in Databricks SQL
  • ○ They can use jobs clusters instead of all-purpose clusters
  • ○ They can configure the clusters to autoscale for larger data sizes
  • ○ They can use clusters that are from a cluster pool
Question 11 (Topic 1)

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release. Which approach can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?

Select an option, then click Submit answer.

  • ○ They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
  • ○ They can set the query’s refresh schedule to end after a certain number of refreshes.
  • ○ They can set the query’s refresh schedule to end on a certain date in the query scheduler.
  • ○ They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.
Question 12 (Topic 1)

Which Databricks asset bundle format is valid?

Select an option, then click Submit answer.

  • ○ resources: jobs: hello-job: name: hello-job tasks: - task_key: hello-task existing_cluster_id: 1234-567890-abcde123 notebook_task: notebook_path: ./hello.py
  • ○ "resources":{ "jobs":{ "name":"hello-job", "tasks":{ "task_key:"hello-task", "existing_cluster_id":"1234-567890-abcde123", "notebook_task":{ "notebook_path": ".hello.py" } } }
  • ○ configuration = { "resources":{ "jobs":{ "name":"hello-job", "tasks":{ "task_key:"hello-task", "existing_cluster_id":"1234-567890-abcde123", "notebook_task":{ "notebook_path": ".hello.py" } } } }
  • ○ resources { jobs { name = "hello-job" tasks{ task_key = "hello-task" existing_cluster_id = "1234-567890-abcde123" notebook_task{ notebook_path = ".hello.py" } } } }