Free Snowflake SnowPro-Advanced-Architect Exam Questions

Become Snowflake Certified with updated SnowPro-Advanced-Architect exam questions and correct answers

Page: 1 / 89

Total 442 Questions | Updated On: Apr 09, 2021

Add To Cart

Question 1

Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.

A : PARSE_JSON

B : PARSE_XML

C : STRIP_JSON

D : Try a hands-on exercise to understand this

Answer: A

Question 2

What is the best option to clone a table called MYTABLE?

A : CREATE TABLE MYTABLE_2 AS SELECT * FROM MYTABLE;

B : CREATE TABLE MYTABLE_2 CLONE MYTABLE;

C : CREATE TABLE MYTABLE_2 AS INSERT INTO MYTABLE VALUES (SELECT * FROM MYTABLE);

Answer: B

Question 3

You can define a clustering key directly on top of VARIANT columns

A : TRUE

B : FALSE

Answer: B

Question 4

The kafka connector creates one pipe for each partition in a Kafka topic.

A : TRUE

B : FALSE

Answer: A

Question 5

What does a successful response from the insertFiles Snowpipe endpoint mean?

A : Snowflake has recorded the list of files to add to the table.

B : The files have been ingested.

C : It Retrieves a report of files submitted via the insertFile endpoint.

Answer: A

Page: 1 / 89

Total 442 Questions | Updated On: Apr 09, 2021

Add To Cart