Databricks-Certified-Professional-Data-Engineer Exam: Absolutely Free Online Practice

Question 1
- Which of the following commands allows data engineers to perform an insert-only merge?
  A : MERGE INTO orders
  USING new_orders
  ON orders.orders_id = new_orders.orders_id
  WHEN MATCHED
  INSERT *
  
  B : MERGE INTO orders
  USING new_orders
  ON orders.orders_id = new_orders.orders_id
  WHEN NOT MATCHED
  INSERT *
  
  C : MERGE INTO orders
  USING new_orders
  ON orders.orders_id = new_orders.orders_id
  WHEN MATCHED
  INSERT *
  WHEN NOT MATCHED
  IGNORE *
  
  D : MERGE INTO orders
  USING new_orders
  ON orders.orders_id = new_orders.orders_id
  WHEN NOT MATCHED
  INSERT *
  WHEN MATCHED
  IGNORE *
  
  E : MERGE INTO orders
  USING new_orders
  ON orders.orders_id = new_orders.orders_id
  WHEN NOT MATCHED
  INSERT *
  ELSE IGNORE *
  
  Answer: B
Question 2
- Which of the following statements best describes Delta Lake Auto Compaction?
  A : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job with Z-Ordering toward a file size of 128 MB
  
  B : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job without Z-Ordering toward a file size of 128 MB
  
  C : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job with Z-Ordering toward a file size of 1 GB.
  
  D : Auto Compaction occurs after a write to a table has succeeded to check if files can further be compacted; if yes, it runs an OPTIMIZE job without Z-Ordering toward a file size of 1 GB.
  
  E : None of the above statements correctly describe Delta Lake Auto Compaction.
  
  Answer: B
Question 3
- A DLT pipeline includes the following streaming tables:
  • raw_iot ingests raw device measurement data from a heart rate tracking device.
  • bpm_stats incrementally computes user statistics based on BPM measurements from raw_iot.
  How can the data engineer configure this pipeline to be able to retain manually deleted or updated records in the raw_iot table, while recomputing the downstream table bpm_stats table when a pipeline update is run?
  
  A : Set the pipelines.reset.allowed property to false on raw_iot
  
  B : Set the skipChangeCommits flag to true on raw_iot
  
  C : Set the pipelines.reset.allowed property to false on bpm_stats
  
  D : Set the skipChangeCommits flag to true on bpm_stats
  
  Answer: B
Question 4
- Incorporating unit tests into a PySpark application requires upfront attention to the design of your jobs, or a potentially significant refactoring of existing code.
  Which benefit offsets this additional effort?
  
  A : Improves the quality of your data
  
  B : Validates a complete use case of your application
  
  C : Troubleshooting is easier since all steps are isolated and tested individually
  
  D : Yields faster deployment and execution times
  
  E : Ensures that all steps interact correctly to achieve the desired end result
  
  Answer: C
Question 5
- The data engineering team maintains the following code:
  
  Assuming that this code produces logically correct results and the data in the source tables has been de-duplicated and validated, which statement describes what will occur when this code is executed?
  
  A :
  A batch job will update the enriched_itemized_orders_by_account table, replacing only those rows that have different values than the current version of the table, using accountID as the primary key.
  
  B :
  The enriched_itemized_orders_by_account table will be overwritten using the current valid version of data in each of the three tables referenced in the join logic.
  
  C :
  An incremental job will leverage information in the state store to identify unjoined rows in the source tables and write these rows to the enriched_iteinized_orders_by_account table.
  
  D :
  An incremental job will detect if new rows have been written to any of the source tables; if new rows are detected, all results will be recalculated and used to overwrite the enriched_itemized_orders_by_account table
  
  E :
  No computation will occur until enriched_itemized_orders_by_account is queried; upon query materialization, results will be calculated using the current valid version of data in each of the three tables referenced in the join logic.
  
  Answer: B

Free Databricks Databricks-Certified-Professional-Data-Engineer Exam Questions

Absolute Free Databricks-Certified-Professional-Data-Engineer Exam Practice for Comprehensive Preparation