Databricks-Certified-Data-Engineer-Associate Exam Question 41

Which of the following describes the relationship between Gold tables and Silver tables?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 42

    Identify the impact of ON VIOLATION DROP ROW and ON VIOLATION FAIL UPDATE for a constraint violation.
    A data engineer has created an ETL pipeline using Delta Live table to manage their company travel reimbursement detail, they want to ensure that the if the location details has not been provided by the employee, the pipeline needs to be terminated.
    How can the scenario be implemented?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 43

    A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
    The cade block used by the data engineer is below:

    If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 44

    Which of the following describes the storage organization of a Delta table?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 45

    A Delta Live Table pipeline includes two datasets defined using STREAMING LIVE TABLE. Three datasets are defined against Delta Lake table sources using LIVE TABLE.
    The table is configured to run in Development mode using the Continuous Pipeline Mode.
    Assuming previously unprocessed data exists and all definitions are valid, what is the expected outcome after clicking Start to update the pipeline?