Question 1

What does a response error code of 429 from the insertFiles, insertReport, or loadHistoryScan API of Snowpipe mean?

Options :

A : Failure. Request rate limit exceeded

B : Failure. Invalid request due to an invalid format or limit exceeded

C : Failure. PipeName not recognized

Answer: A

Question 2

Removing files from a stage after you are done loading the files improves performance when subsequently loading data

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

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 4

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00

AM, to recover some objects.

The STAGING schema has 50 days of retention.

The Architect runs the following statement:

CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00');

The Architect receives the following error: Time travel data is not available for schema STAGING. The

requested time is either beyond the allowed time travel period or before the object creation time.

The Architect then checks the schema history and sees the following:

CREATED_ON|NAME|DROPPED_ON

2021-06-02 23:00:00 | STAGING | NULL

2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00

How can cloning the STAGING schema be achieved?

Options :

A : Undrop the STAGING schema and then rerun the CLONE statement.

B :

Modify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-05-01 10:00:00');

C :

Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.

D :

Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.

Answer: D

Question 5

With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?

Options :

A : Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute

B : Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes.

C : Only if the system estimates there’s enough query load to keep the cluster busy for at least 4 minutes.

Answer: A