Databricks Machine Learning Professional exam dumps

Databricks Machine Learning Professional practice question 12 of 280

Databricks Certified Machine Learning Professional. Professional level, Databricks. Free question with the correct answer and a full explanation.

Databricks Machine Learning Professional Question 12

Select 3

You are working on a machine learning project where your team has accidentally overwritten a Delta table containing training data. You need to load a previous version of the Delta table to recover the original data for training. Which of the following steps should you take to view the Delta table's history and load a specific version of the table?

  1. A

    Use the DESCRIBE HISTORY command to view the Delta table's history and identify the version to restore.

  2. B

    Use the RESTORE TABLE command to specify the exact version of the Delta table to load.

  3. C

    Use the VERSION AS OF option in a query to reference the specific version of the Delta table.

  4. D

    Use the DESCRIBE TABLE command to view the Delta table's schema and determine its version history.

  5. E

    Use the TIMESTAMP AS OF option in a query to load the Delta table from a specific timestamp.

Show answer and explanation

Correct answers: A, C, E

Explanation

To recover a previous version of a Delta table, you first use the DESCRIBE HISTORY command to view the table's history and identify the version or timestamp you want to restore. Then, you can either use the VERSION AS OF option to query the table at a specific version or the TIMESTAMP AS OF option to query the table as it was at a specific time. These steps allow you to recover and load the original data without overwriting or duplicating the Delta table.

  • A. Correct.

    Correct. The DESCRIBE HISTORY command provides the history of the Delta table, allowing you to identify the version number or timestamp needed to restore the desired state.

  • B. Incorrect.

    Incorrect. There is no RESTORE TABLE command in Delta Lake. Instead, you can query the Delta table using version or timestamp options.

  • C. Correct.

    Correct. The VERSION AS OF option enables you to query the Delta table at a specific version, effectively loading that version.

  • D. Incorrect.

    Incorrect. The DESCRIBE TABLE command only provides schema information and does not show the version history of the Delta table.

  • E. Correct.

    Correct. The TIMESTAMP AS OF option allows you to query the Delta table as it existed at a specific timestamp, which is another way to load a previous version.

Timed practice exam

Take a Databricks Machine Learning Professional practice test under exam conditions

60 questions in 120 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam

More Databricks Machine Learning Professional practice questions

  1. 13.You are working on a machine learning project using a Delta table to store training data. A recent...
  2. 14.A data science team is using a Delta table to store their machine learning dataset. They recently...
  3. 15.A data science team maintains a Delta table named 'salesdata' to track transaction records. The...
  4. 16.You are working on a machine learning project where you need to store and manage features for a...
  5. 17.A data scientist is working on a machine learning project using Databricks Feature Store. They need...
Back to the Databricks Machine Learning Professional exam dumps