Question 1

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

Options :

A : Changing the name of the organization

B : Creating an account

C : Viewing a list of organization accounts

D : Changing the name of an account

E : Deleting an account

F : Enabling the replication of a database

Answer: B,C,F

Question 2

A company needs to share a Snowflake data table with data consumers who do not have Snowflake accounts.

What is the recommended way to to this?

Options :

A : Create a share with the table and provide the consumers with the public URL for the share.

B : Unload the table to a read-only cloud storage location and give consumers access to the table.

C : Create users for the consumers that have the built-in role EXTERNAL and grant that role the select privilege on the table.

D : Create a share with the table and create a reader account with access to the share for the consumers.

Answer: D

Question 3

You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve. What may be the most possible cause of this.

Options :

A : There may be a symptom on skew in your data where one of the value of the column is significantly more than rest of the values in the column

B : Your warehouses do not have enough memory

C : Since you have configured an warehouse with a low auto-suspend value, your warehouse is going down frequently

Answer: A

Question 4

For which use cases, will you use cross-cloud and cross-region replication?

Options :

A : Business continuity and disaster recovery

B : Secure data sharing across regions/cloud

C : Data portability and account migrations

D : All of these

Answer: D

Question 5

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availability 3. Database replication in between different regions 4. Native support for JDBC and ODBC 5. Customer-managed encryption keys using Tri-Secret Secure 6. Support for Payment Card Industry Data Security Standards (PCI DSS) In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

Options :

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: C