Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Create Streams – Continuation

What is the purpose of executing the command to copy data into the raw JSON table?

• To update the schema

• To delete existing data

• To ingest data from a stage object

• To create a new table

How can you verify that the Change Data Capture (CDC) has been captured in the stream?

• By checking the raw table

• By truncating the line item table

• By executing a merge command

• By selecting data from the stream

What does the task history command help you to check?

• The tasks executed in the last hour

• The number of rows in the raw table

• The schema of the production table

• The current state of the database

What should be done to ensure the line item table is empty?

• Perform a truncate operation

• Create a new table

• Run a merge command

• Execute a select command

What is the next step after ensuring the stream is empty?

• Create a Snowpipe object

• Ingest data into the raw table

• Run a select command

• Delete the raw table