Question 1

Which Snowflake objects can be defined with future grants? (Select TWO).

Options :

A : Schemas

B : Databases

C : Masking policies

D : External functions

E : Virtual warehouses

Answer: B,C

Question 2

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micropartitions being scanned How should this query be optimized?

Options :

A : Create a view on the table.

B : Add a clustering key to the table

C : Add a limit clause to the query.

D : Add a Dynamic Data Masking policy to the table.

Answer: B

Question 3

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Options :

A : Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 30 days.

Fail Safe retention time is 1 day.

B : Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 365 days.

Fail Safe retention time is 7 days.

C : Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

D : Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

E : Default Time Travel Retention is set to 7 days.

Maximum Time Travel Retention is 1 day.

Fail Safe retention time is 90 days.

F : Default Time Travel Retention is set to 90 days.

Maximum Time Travel Retention is 7 days.

Fail Safe retention time is 356 days.

Answer: D

Question 4

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

Options :

A : The file will continue to load until all contents arc loaded.

B : The tile will slop loading and all data up to that point will be committed.

C : The file loading could be aborted without any portion of the file being committed.

D : The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake

Answer: C

Question 5

Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?

Options :

A : Query Profile

B : Query history

C : Visualization chart

D : Query acceleration service

Answer: A

Confidently Practice Online with Free SnowPro-Core Exam Cram

Buying Options: