SOL-C01 Question #217: Real Exam Question with Answer & Explanation

Question

You are designing a data pipeline in Snowflake that involves frequent updates to a staging table `STG CUSTOMERS before merging the data into a production table `PROD CUSTOMERS. The 'DATA RETENTION_TIME parameter is set to 7 days at the account level. During a particular data load, a bug in the pipeline causes incorrect data to be loaded into `STG CUSTOMERS. You need to revert 'STG CUSTOMERS' to its state before the erroneous load. However, you also need to investigate the cause of the bug using the incorrect data in the current version of 'STG CUSTOMERS. What steps can you take to achieve both data recovery and root cause analysis effectively?

Options

• AImmediately drop and recreate the 'STG CUSTOMERS' table from a backup. Investigate the bug
• BCreate a clone of 'STG_CUSTOMERS' before reverting it to its previous state using Time Travel.
• CRevert 'STG CUSTOMERS to its previous state using Time Travel. The incorrect data is
• DSet the 'DATA RETENTION_TIME IN DAYS parameter to 0 on 'STG_CUSTOMERS and perform

Explanation

Creating a clone of 'STG_CUSTOMERS' before reverting it allows you to preserve the incorrect data for analysis while restoring the original table to its correct state using Time Travel. This allows for both data recovery and root cause analysis. Option A doesn't preserve the incorrect data for analysis. Option C loses the incorrect data, hindering debugging. Option D disables Time Travel and relies on a full refresh, which might be slow and complex.

No community discussion yet for this question.