Free Snowflake SnowPro-Advanced-Architect Exam Questions

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

Page: 1 / 90

Total 449 Questions | Updated On: Jul 28, 2025

Add To Cart

Question 1

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

Question 2

Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice

A : TRUE

B : FALSE

Answer: B

Question 3

An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running. Why is this occurring?

A : Tasks cannot be cloned.

B : The objects that the tasks reference are not fully qualified.

C : Cloned tasks are suspended by default and must be manually resumed.

D : The Architect has insufficient privileges to alter tasks on the cloned database.

Answer: C

Question 4

Who can view account-level Credit and Storage Usage?

A : ACCOUNTADMIN

B : A role which has been granted the MONITOR USAGE global privilege

C : STORAGEADMIN

D : STORAGEMONITOR

Answer: A,B

Question 5

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization’s system. What is the BEST way to find recent and ongoing login attempts to Snowflake?

A : Call the LOGIN_HISTORY Information Schema table function.

B : Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.

C : View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text "LOGIN".

D : View the Users section in the Account tab in the Snowflake UI and review the last login column.

Answer: A

Page: 1 / 90

Total 449 Questions | Updated On: Jul 28, 2025

Add To Cart