Databricks Machine Learning Professional exam dumps

Databricks Machine Learning Professional practice question 13 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 13

Select 2

You are working on a machine learning project using a Delta table to store training data. A recent update to the Delta table introduced an error in the data. You want to view the table's history to identify the correct version and then load the previous version of the table for your analysis. Which of the following steps should you take?

  1. A

    Use the DESCRIBE HISTORY command to inspect the table's version history.

  2. B

    Use the RESTORE command to revert the Delta table to a previous version.

  3. C

    Use the VERSION AS OF option in your query to load the desired previous version of the Delta table.

  4. D

    Manually modify the Delta table's _delta_log files to roll back to a previous version.

  5. E

    View the Delta table's history with the SHOW VERSIONS command.

Show answer and explanation

Correct answers: A, C

Explanation

To address the issue, you should first use the DESCRIBE HISTORY command to inspect the Delta table's version history and identify the correct version. Once the desired version is identified, you can use the VERSION AS OF option in your query to load that specific version of the Delta table. This approach allows you to analyze the previous data without modifying the Delta table itself.

  • A. Correct.

    The DESCRIBE HISTORY command is the correct way to inspect the table's version history in Delta Lake. It provides details about previous versions, including operation type, user, and timestamp.

  • B. Incorrect.

    The RESTORE command is used to revert a Delta table to a previous state, but it permanently alters the table. This is not the correct step for simply loading a previous version of the table.

  • C. Correct.

    The VERSION AS OF option is the correct way to query and load a specific version of the Delta table without modifying the table itself.

  • D. Incorrect.

    Manually modifying the _delta_log files is not a supported or recommended approach for managing Delta table versions. This could lead to corruption and is not a valid solution.

  • E. Incorrect.

    The SHOW VERSIONS command is not a valid Delta Lake command. There is no such command in Delta Lake for viewing table history.

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