Question 1

How can unstructured data be processed in a Snowflake stage? (Select TWO).

Options :

A : Use a SQL procedure.

B : Use external functions.

C : Use a C# procedure.

D : Implement a Golang (Go) User-Defined Function (UDF).

E : Implement a Python User-Defined Function (UDF).

Answer: B

Question 2

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options :

A : Management of metadata

B : Computing the data

C : Maintaining Availability Zones

D : Infrastructure security

E : Parsing and optimizing queries

Answer: A,E

Question 3

What Snowflake role must be granted for a user to create and manage accounts?

Options :

A : ACCOUNTADMIN

B : ORGADMIN

C : SECURITYADMIN

D : SYSADMIN

Answer: A

Question 4

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options :

A : Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B : All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C : The ACCOUNTADMIN role must be granted to only one user.

D : Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E : All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Answer: A,D

Question 5

What is the purpose of an External Function?

Options :

A : To call code that executes outside of Snowflake

B : To run a function in another Snowflake database

C : To share data in Snowflake with external parties

D : To ingest data from on-premises data sources

Answer: A