Databricks Databricks-Certified-Professional-Data-Engineer Databricks Certified Data Engineer Professional Exam Exam Practice Test Questions

• Question 1

  A developer has successfully configured credential for Databricks Repos and cloned a remote Git repository. Hey don not have privileges to make changes to the main branch, which is the only branch currently visible in their workspace.Use Response to pull changes from the remote Git repository commit and push changes to a branch that appeared as a changes were pulled.

  • Use Repos to merge all differences and make a pull request back to the remote repository.
  • Use repos to merge all difference and make a pull request back to the remote repository.
  • Use Repos to create a new branch commit all changes and push changes to the remote Git repertory.
  • Use repos to create a fork of the remote repository commit all changes and make a pull request on the source repository

  Show Answer Answer: C Next

• Question 2

  Which statement describes Delta Lake Auto Compaction?

  • An asynchronous job runs after the write completes to detect if files could be further compacted;if yes, an optimize job is executed toward a default of 1 GB.
  • Before a Jobs cluster terminates, optimize is executed on all tables modified during the most recent job.
  • Optimized writes use logical partitions instead of directory partitions; because partition boundaries are only represented in metadata, fewer small files are written.
  • Data is queued in a messaging bus instead of committing data directly to memory; all data is committed from the messaging bus in one batch once the job is complete.
  • An asynchronous job runs after the write completes to detect if files could be further compacted; if yes, an optimize job is executed toward a default of 128 MB.

  Show Answer Answer: E Next

• Question 3

  The data architect has mandated that all tables in the Lakehouse should be configured as external (also known as "unmanaged") Delta Lake tables.Which approach will ensure that this requirement is met?

  • When a database is being created, make sure that the LOCATION keyword is used.
  • When configuring an external data warehouse for all table storage, leverage Databricks for all ELT.
  • When data is saved to a table, make sure that a full file path is specified alongside the Delta format.
  • When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.
  • When the workspace is being configured, make sure that external cloud object storage has been mounted.

  Show Answer Answer: D Next

• Question 4

  In order to facilitate near real-time workloads, a data engineer is creating a helper function to leverage the schema detection and evolution functionality of Databricks Auto Loader. The desired function will automatically detect the schema of the source directly, incrementally process JSON files as they arrive in a source directory, and automatically evolve the schema of the table when new fields are detected.The function is displayed below with a blank:Which response correctly fills in the blank to meet the specified requirements?

  • Option A
  • Option B
  • Option C
  • Option D
  • Option E

  Show Answer Answer: B Next

• Question 5

  Spill occurs as a result of executing various wide transformations. However, diagnosing spill requires one to proactively look for key indicators.Where in the Spark UI are two of the primary indicators that a partition is spilling to disk?

  • Stage’s detail screen and Executor’s files
  • Stage’s detail screen and Query’s detail screen
  • Driver’s and Executor’s log files
  • Executor’s detail screen and Executor’s log files

  Show Answer Answer: B Next