Question 1

What integration object should be used to place restrictions on where data may be exported?

Options :

A : Stage integration

B : Security integration

C : Storage integration

D : API integration

Answer: C

Question 2

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)

Options :

A : There needs to be fewer objects per tenant.

B : Security and Role-Based Access Control (RBAC) policies must be simple to configure.

C : Compute costs must be optimized.

D : Tenant data shape may be unique per tenant.

E : Storage costs must be optimized.

Answer: B,D

Question 3

Which command can we use to convert JSON NULL values to SQL NULL values?

Options :

A : STRIP_NULL_VALUE

B : STRIP_OUTER_ARRAY

C : TRANSCRIPT_NULL

D : JSON_TO_SQL

Answer: A

Question 4

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

Options :

A : The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.

B : By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

C : Contact Snowflake and they will execute the share request for the healthcare company.

D : Set the share_restriction parameter on the shared object to false.

Answer: D

Question 5

What does a successful response from the insertFiles Snowpipe endpoint mean?

Options :

A : Snowflake has recorded the list of files to add to the table.

B : The files have been ingested.

C : It Retrieves a report of files submitted via the insertFile endpoint.

Answer: A