Practice ARA-C01 Exam Online

Question 1

Which command will fail if you have a table created with the following DDL query?

CREATE TABLE MYTABLE

(ID INTEGER, NAME VARCHAR)

A : SELECT * FROM MYTABLE

B : SELECT * FROM “Mytable”

C : SELECT * FROM “MYTABLE”

Answer: B

Question 2

What is the meaning of “Processing” in the query profiler menu when running a query?

A : The time when the processing was waiting for the network data transfer.

B : The time spent on data processing by the CPU.

C : The time when the processing was blocked by local disk access.

Answer: B

Question 3

Which of the below commands will use warehouse credits?

A : SHOW TABLES LIKE 'SNOWFL%';

B : SELECT MAX(TEST_ID) FROM SNOWFLAKE;

C : SELECT COUNT(*) FROM SNOWFLAKE;

D : SELECT COUNT(TEST_ID) FROM SNOWFLAKE GROUP BY TEST_ID;

Answer: D

Question 4

You want to automatically delete the files from stage after a successful load using the COPY INTO command. What will be recommended approach for deletion?

A : Set PURGE=TRUE in the COPY INTO command

B : Set REMOVE=TRUE in the COPY INTO Command

C : No need to do anything, snowflake does it automatically

Answer: A

Question 5

What is the data size limit for loading into a variant column?

A : 16 MB(Compressed)

B : 1 GB(Compressed)

C : 32 GB

D : 10 MB - 100 MB compressed

Answer: A

Name:	SnowPro Advanced Architect Certification
Exam Code:	ARA-C01
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	442
Last Updated:	Apr 24, 2024

Snowflake ARA-C01