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: Jan 08, 2025

Add To Cart

Question 1

Which SQL alter command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

A :

B :

C :

D :

Answer: A

Question 2

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

Question 3

You have a multi-cluster warehouse running with the standard scaling policy. The maximum number of clusters is set to 8. If a lot of queries are queried, and the warehouse is constantly starting new clusters, what is the maximum time the warehouse will start all the clusters?

A : 8 minutes.

B : They all start at the same time.

C : 80 seconds.

D : 160 seconds.

Answer: D

Question 4

What step will improve the performance of queries executed against an external table?

A : Partition the external table.

B : Shorten the names of the source files.

C : Convert the source files' character encoding to UTF-8.

D : Use an internal stage instead of an external stage to store the source files.

Answer: A

Question 5

An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics. What should the Architect do to enable the Snowflake search optimization service on this table?

A : Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.

B : Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.

C : Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.

D : Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.

Answer: C

Page: 1 / 89

Total 442 Questions | Updated On: Jan 08, 2025

Add To Cart