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: Dec 16, 2025

Add To Cart

Question 1

A Snowflake Architect is writing a User-Defined Function (UDF) with some unqualified object names.

How will those object names be resolved during execution?

A : Snowflake will resolve them according to the SEARCH_PATH parameter.

B : Snowflake will first check the current schema, and then the PUBLIC schema of the current database.

C : Snowflake will first check the current schema, and then the schema the previous query used.

D : Snowflake will only check the schema the UDF belongs to.

Answer: D

Question 2

What are the limitations about external functions? (Choose two.)

A : We can only write functions, not stored procedures.

B : The maximum response size per batch is 16MB.

C : External functions must be scalar, so it returns a single value for each input row.

D : Future grants of privileges on external functions are supported.

Answer: A,C

Question 3

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data. How should these requirements be met?

A : Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

B : Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

C : Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.

D : Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

Answer: A

Question 4

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

A : TRUE

B : FALSE

Answer: B

Question 5

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

Page: 1 / 90

Total 449 Questions | Updated On: Dec 16, 2025

Add To Cart