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

Question

Consider the following scenario: A Snowflake database `SALES DB contains a table 'CUSTOMER DATA' that is actively being updated. You need to create a historical snapshot of 'CUSTOMER DATA for auditing purposes, ensuring that the snapshot is consistent and reflects the data at a specific point in time. You need to create a second table, `AUDIT CUSTOMER DATA, to hold the historical information. Which of the following methods can accurately capture the data in 'CUSTOMER DATA at a specific point in time?

Options

• AUsing `CREATE TABLE AUDIT CUSTOMER DATAAS SELECT FROM CUSTOMER DATA;'
• Bcreate a clone of the 'CUSTOMER_DATX table using 'CREATE TABLE CLONE
• CUsing `CREATE OR REPLACE VIEW AUDIT_CUSTOMER DATAAS SELECT FROM
• Dcreate a task to periodically copy data from 'CUSTOMER_DATX to
• EUsing 'INSERT INTO AUDIT CUSTOMER DATA SELECT FROM CUSTOMER DATA'

Explanation

Cloning with the BEFORE (TIMESTAMP => clause allows you to create a snapshot of the table at a specific point in time. This ensures that the data in is consistent and reflects the state of 'CUSTOMER_DATX at that specific moment. A simple 'SELECT FROM' statement or INSERT operation will not guarantee consistency if the table is being updated concurrently. a view always reflects the current values. A periodic task also will not give you a point in time accuracy.

No community discussion yet for this question.