Question 1

What feature can be used to reorganize a very large table on one or more columns?

Options :

A : Micro-partitions

B : Clustering keys

C : Key partitions

D : Clustered partitions

Answer: B

Question 2

What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?

Options :

A : Standard

B : Enterprise

C : Business Critical

D : Virtual Private Snowflake (VPS)

Answer: B

Question 3

When a schema is cloned what happens to the tags that reside in that schema or database?

Options :

A : The tags are deleted and must be redefined in the target schema.

B : The tags remain in the source schema unchanged.

C : The tags become temporarily inactive until they are manually reactivated.

D : The tags are automatically cloned with the schema, maintaining all associations.

Answer: D

Question 4

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 5

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Options :

A : Compute Credits = 50 Credits Cloud Services = 10

B : Compute Credits = 80 Credits Cloud Services = 5

C : Compute Credits = 10 Credits Cloud Services = 9

D : Compute Credits = 120 Credits Cloud Services = 10

E : Compute Credits = 200 Credits Cloud Services = 26

Answer: A,E

Higher Test Marks with Free Online SnowPro-Core Exam Practice