CertsTopics Logo

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

SnowPro Core Certification Changed COF-C02 Questions

Page: 30 / 45
Total 605 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam (COF-C02) Questions and Answers

Question 117

How long does Snowflake retain information in the ACCESS HISTORY view?

Options:

A.

7 days

B.

14 days

C.

28 days

D.

365 days

Question 118

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Options:

A.

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

B.

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C.

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

D.

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

E.

grant SELECT on all tables in database DB1 to role MYROLE;

F.

grant SELECT on future tables in database DB1 to role MYROLE;

Question 119

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

Options:

A.

1 minute

B.

2 minutes

C.

6 minutes

D.

8 minutes

Question 120

Which transformation is supported by a COPY INTO

command?

Options:

A.

Filter using a where clause

B.

Filter using a limit keyword

C.

Cast using a SELECT statement

D.

Order using an ORDER BY clause

command in Snowflake supports transformations such as casting using a SELECT statement. This allows for the transformation of data types as the data is being loaded into the table, which can be particularly useful when the data types in the source files do not match the data types in the target table

Page: 30 / 45
Total 605 questions
Get COF-C02 Full Access Download COF-C02 PDF