← Back to exam page

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

Loading demo links...

Showing 13–15 of 26 questions

Question 13 (Topic 1)

The Databricks CLI is used to trigger a run of an existing job by passing the job_id parameter. The response that the job run request has been submitted successfully includes a field run_id. Which statement describes what the number alongside this field represents?

Select an option, then click Submit answer.

  • ○ The job_id and number of times the job has been run are concatenated and returned.
  • ○ The total number of jobs that have been run in the workspace.
  • ○ The number of times the job definition has been run in this workspace.
  • ○ The job_id is returned in this field.
  • ○ The globally unique ID of the newly triggered run.
Question 14 (Topic 1)

Each configuration below is identical to the extent that each cluster has 400 GB total of RAM 160 total cores and only one Executor per VM. Given an extremely long-running job for which completion must be guaranteed, which cluster configuration will be able to guarantee completion of the job in light of one or more VM failures?

Select an option, then click Submit answer.

  • ○ • Total VMs: 8 • 50 GB per Executor • 20 Cores / Executor
  • ○ • Total VMs: 16 • 25 GB per Executor • 10 Cores / Executor
  • ○ • Total VMs: 1 • 400 GB per Executor • 160 Cores/Executor
  • ○ • Total VMs: 4 • 100 GB per Executor • 40 Cores / Executor
  • ○ • Total VMs: 2 • 200 GB per Executor • 80 Cores / Executor
Question 15 (Topic 1)

The business intelligence team has a dashboard configured to track various summary metrics for retail stores. This includes total sales for the previous day alongside totals and averages for a variety of time periods. The fields required to populate this dashboard have the following schema: For demand forecasting, the Lakehouse contains a validated table of all itemized sales updated incrementally in near real-time. This table, named products_per_order, includes the following fields: Because reporting on long-term sales trends is less volatile, analysts using the new dashboard only require data to be refreshed once daily. Because the dashboard will be queried interactively by many users throughout a normal business day, it should return results quickly and reduce total compute associated with each materialization. Which solution meets the expectations of the end users while controlling and limiting possible costs?

Select an option, then click Submit answer.

  • ○ Populate the dashboard by configuring a nightly batch job to save the required values as a table overwritten with each update.
  • ○ Use Structured Streaming to configure a live dashboard against the products_per_order table within a Databricks notebook.
  • ○ Define a view against the products_per_order table and define the dashboard against this view.
  • ○ Use the Delta Cache to persist the products_per_order table in memory to quickly update the dashboard with each query.