CertsTopics Logo

Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SnowPro Core Certification COF-C02 Full Course Free

Page: 41 / 52
Total 693 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 161

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Options:

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Question 162

What is the relationship between a Query Profile and a virtual warehouse?

Options:

A.

A Query Profile can help users right-size virtual warehouses.

B.

A Query Profile defines the hardware specifications of the virtual warehouse.

C.

A Query Profile can help determine the number of virtual warehouses available.

D.

A Query Profile automatically scales the virtual warehouse based on the query complexity.

Question 163

For which use cases is running a virtual warehouse required? (Select TWO).

Options:

A.

When creating a table

B.

When loading data into a table

C.

When unloading data from a table

D.

When executing a show command

E.

When executing a list command

Question 164

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Options:

A.

DATA_RETENTION_TIME_IN_DAYS

B.

MAX_DATA_EXTENSION_TIME_IN_DAYS

C.

MIN_DATA_RETENTION_TIME_IN_DAYS

D.

MAX CONCURRENCY LEVEL

Page: 41 / 52
Total 693 questions
Get COF-C02 Full Access Download COF-C02 PDF