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: Aug 20, 2026

Add To Cart

Question 1

A Snowflake Architect is designing a multiple-account design strategy. This strategy will be MOST cost-effective with which scenarios? (Select TWO).

A : The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

B : The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

C : The company needs to support different role-based access control features for the development, test, and production environments.

D : The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

E : The company must use a specific network policy for certain users to allow and block given IP addresses.

Answer: B,C

Question 2

A table, EMP_ TBL has three records as shown:

The following variables are set for the session:

Which SELECT statements will retrieve all three records? (Select TWO).

A : Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');

B : SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');

C : SELECT * FROM identifier WHERE NAME IN ($var1, $var2, $var3);

D : SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');

E : SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);

Answer: B,E

Question 3

It is recommended to assign ACCOUNTADMIN role to atleast two user

A : TRUE

B : FALSE

Answer: A

Question 4

You have written a procedure and a function in snowflake. How do you find your procedures and functions in snowflake?

A : SHOW PROCEDURES;SHOW FUNCTIONS;

B : SHOW ALL PROCEDURES AND FUNCTIONS

C : SHOW PROCEDURES, FUNCTIONS

Answer: A

Question 5

create or replace table result_scan_table_1 like result_scan_table;

Will the above query cost compute credits?

A : No, since it is a metadata operation only

B : Yes, it will need compute as the table structure is also getting created

C : It is hard to say without looking at query profile

Answer: A

Page: 1 / 90

Total 449 Questions | Updated On: Aug 20, 2026

Add To Cart