Question 6

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?
  • Question 7

    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 of the following approaches 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?
  • Question 8

    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?
  • Question 9

    A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
    Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?
  • Question 10

    A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.
    Which of the following approaches can be used to identify the owner of new_table?