Free Snowflake ARA-C01 Exam Questions

Become Snowflake Certified with updated ARA-C01 exam questions and correct answers

Page: 1 / 90

Total 449 Questions | Updated On: Oct 24, 2026

Add To Cart

Question 1

A large join query takes around 3 hours to complete in an L warehouse. After increasing the warehouse size to XL one, the query's performance didn't improve. What can be the cause of it?

A : The query was still running before the new size of the warehouse was applied

B : The warehouse doesn't have enough power still

C : The warehouse had auto-suspended before the query finished, and it had to re-start again

D : One of the column's values is significantly more than the rest of the values in the column; that's why it produces a skew in your data.

Answer: D

Question 2

Which are the two VARIANT columns each schema has in every Snowflake table loaded by the Kafka connector? (Choose two.)

A : RECORD_ISCORRECT

B : RECORD_SUMMARY

C : RECORD_PRIVILEGES

D : RECORD_METADATA

E : RECORD_CONTENT

Answer: D,E

Question 3

Which pipes are cloned when cloning a database or schema?

A : Pipes that reference external stages

B : Both

C : Pipes that reference internal stages

Answer: A

Question 4

You have create a task as below

CREATE TASK mytask1

WAREHOUSE = mywh

SCHEDULE = '5 minute'

WHEN

SYSTEM$STREAM_HAS_DATA('MYSTREAM')

INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT';

Which statement is true below?

A : If SYSTEM$STREAM_HAS_DATA returns false, the task will be skipped

B : If SYSTEM$STREAM_HAS_DATA returns false, the task will still run

C : If SYSTEM$STREAM_HAS_DATA returns false, the task will go to suspended mode

Answer: A

Question 5

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;

A : 2 & 6

B : 2 & 3

C : 4 & 3

D : 4 & 6

Answer: C

Page: 1 / 90

Total 449 Questions | Updated On: Oct 24, 2026

Add To Cart