Question 1

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options :

A : True

B : False

Answer: A

Question 2

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Options :

A : SHOW

B : MERGE

C : INSERT

D : DELETE

E : DESCRIBE

Answer: A,E

Question 3

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

Options :

A : Clone the table schema as it existed before the table was dropped.

B : Clone the database as it existed before the table was dropped.

C : Recreate the table and reload the data.

D : Run the UNDROP command against the table.

Answer: D

Question 4

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Options :

A : Each Snowflake account can be hosted in a different cloud vendor and region.

B : Each Snowflake account must be hosted in a different cloud vendor and region

C : All Snowflake accounts must be hosted in the same cloud vendor and region

D : Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Answer: A

Question 5

Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually 24 hours a day, 7 days a week? (Select TWO).

Options :

A : -1

B : 0

C : 86400

D : 172800

E : NULL

Answer: C,D

Higher Test Marks with Free Online SnowPro-Core Exam Practice

Buying Options: