nerdexam
Snowflake

ARA-C01 · Question #87

A new table and streams are created with the following commands: CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ; CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS; CREATE OR REPLACE STREAM

Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.

Data Engineering

Question

A new table and streams are created with the following commands:

CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ; CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS; CREATE OR REPLACE STREAM STREAM_2 ON TABLE LETTERS APPEND_ONLY = TRUE; The following operations are processed on the newly created table:

INSERT INTO LETTERS VALUES (1, 'A'); INSERT INTO LETTERS VALUES (2, 'B'); INSERT INTO LETTERS VALUES (3, 'C'); TRUNCATE TABLE LETTERS; INSERT INTO LETTERS VALUES (4, 'D'); INSERT INTO LETTERS VALUES (5, 'E'); INSERT INTO LETTERS VALUES (6, 'F'); DELETE FROM LETTERS WHERE ID = 6; What would be the output of the following SQL commands, in order? SELECT COUNT () FROM STREAM_1; SELECT COUNT () FROM STREAM_2;

Options

  • A2 & 6
  • B2 & 3
  • C4 & 3
  • D4 & 6

Unlock ARA-C01 to see the answer

You've previewed enough free ARA-C01 questions. Unlock ARA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowflake Streams#Append-Only Streams#Change Data Capture#TRUNCATE TABLE
Full ARA-C01 Practice