Databricks Sample Paper 2

Online Certification Questions

Question 1

Which of the following Git operations must be performed outside of Databricks Repos?

  • A. Commit
  • B. Pull
  • C. Push
  • D. Clone
  • E. Merge

Answer:

Merge

The Clone operation must be performed outside of Databricks Repos. Cloning a repository involves creating a copy of an existing remote repository to a local machine. In the context of Databricks, you would typically clone the repository to your local development environment first and then connect it to the Databricks repos

Question 2

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?

  • A. The VACUUM command was run on the table
  • B. The TIME TRAVEL command was run on the table
  • C. The DELETE HISTORY command was run on the table
  • D. The OPTIMIZE command was nun on the table
  • E. The HISTORY command was run on the table

Answer:

The VACUUM command was run on the table

There is no DELETE HISTORY command in Databricks VACCUM command can remove history and we can also specify the retention period with VACCUM Command. Default Retention period is 7 days. To allow changing the default retention period you can rum the following command ALTER TABLE your_table SET TBLPROPERTIES ('delta.retentionDurationCheck.enabled' = 'true');