SnowPro Advanced: Data Engineer — Question 109

A Data Engineer is investigating a data quality issue that led to a system failure. Because there is no data from the time of the incident, the Engineer needs replicate the issue, without causing any disruptions to the current operations.

How can a safe environment for testing be established without incurring additional costs?

Answer options

• A. Use Time Travel to restore the data back to the way it was just before the incident occurred.
• B. Create an empty table using a CREATE TABLE LIKE command and insert the historic data into this table using data from Time Travel. Use this table for testing.
• C. Create a view using the historic Time Travel data and use this view to test the data.
• D. Create a clone of the data using the historic Time Travel data and use the clone to test the data.

Correct answer: D

Explanation

The correct answer, D, allows for a separate clone to be created from the historical data, ensuring that testing can occur without impacting current operations. Options A, B, and C either alter the existing data or do not provide a fully isolated environment, which could lead to disruptions during testing.