Question 1

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

Options :

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,D

Question 2

You have a query that will take 20 minutes to be executed in a data warehouse. This warehouse auto-suspends after 15 minutes. What will happen with the query?

Options :

A : The query will be canceled after 15 minutes

B : The query will stop until the warehouse resumes again

C : The query will finish as expected

Answer: C

Question 3

A Data Architect has set up continuous data ingestion using Snowpipe. After a few days of successful data ingestion, the Architect must modify the pipe definition of the referenced external stage.

What are the recommended steps the Architect should take?

Options :

A : • Pause the pipe using an ALTER_PIPE statement, confirm the pending file count is 0

• Recreate the pipe to change the COPY statement and pause the pipe

• Review the configuration steps for the cloud message service to ensure settings are accurate

• Resume the pipe and verify the pipe execution status is running

B : • Pause the pipe using an ALTER_PIPE statement, confirm the pending file count is 0

• Recreate the pipe to change the COPY statement

• Review the configuration steps for the cloud message service to ensure settings are accurate

• Resume the pipe and verify pipe execution status is running

C : • Create the pipe using the CREATE_PIPE statement, confirm the pending file count is 1

• Recreate the pipe to change the COPY statement and pause the pipe

• Review configuration steps for the cloud message service to ensure settings are accurate

• Resume the pipe using the SET_PIPE statement and verty pipe execution status is running

D : • Pause the pipe using the SET_PIPE statement and make sure the pending file count is 1

• Recreate the pipe to change the COPY statement

• Review the configuration steps for the cloud message service to ensure settings are accurate

• Resume the pipe using the START_PIPE statement and verify pipe execution status is running

Answer: A

Question 4

Below are the rest APIs provided by Snowpipe

Options :

A : insertFiles

B :

insertReport

C : loadData

Answer: A,B

Question 5

Choose the different ways that you have to optimize query performance

Options :

A : Clustering a table

B : Creating one or more materialized views

C : Search Optimization

D : Vacuuming

Answer: A,B,C