Question 1

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 2

When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Options :

A : 8 hours

B : 4 hours

C : 2 hours

D : 1 hour

Answer: B

Question 3

Which pipes are cloned when cloning a database or schema?

Options :

A : Pipes that reference external stages

B : Both

C : Pipes that reference internal stages

Answer: A

Question 4

In this scenarios, files are constantly getting ingested in an external stage, the files are between 1 and 4 MB. You want to load the data immediately into a table without any human intervention. What will you use?

Options :

A : Create a materialize view on the external stage

B : Use Snowpipe rest APIs

C : Use Snowpipe with auto ingest

Answer: C

Question 5

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