Free Practice Snowflake SnowPro-Advanced-Architect Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced, Architect SnowPro-Advanced-Architect Dumps Practice Questions

Page: 1 / 89

Total 442 Questions | Updated On: Apr 09, 2025

Add To Cart

Question 1

A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses

A : TRUE

B : FALSE

Answer: A

Question 2

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 3

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 4

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 5

For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service. What is this object called?

A : External procedure

B : External function

C : External Script

D : External job

Answer: B

Page: 1 / 89

Total 442 Questions | Updated On: Apr 09, 2025

Add To Cart