CertsTopics Logo

Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Snowflake COF-C02 Questions Answers

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

SnowPro Core Certification Exam Questions and Answers

Question 65

Which statement MOST accurately describes clustering in Snowflake?

Options:

A.

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

B.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

C.

The clustering key must be included in the COPY command when loading data into Snowflake.

D.

Clustering can be disabled within a Snowflake account.

Question 66

What does Snowflake recommend regarding database object ownership? (Select TWO).

Options:

A.

Create objects with ACCOUNTADMIN and do not reassign ownership.

B.

Create objects with SYSADMIN.

C.

Create objects with SECURITYADMIN to ease granting of privileges later.

D.

Create objects with a custom role and grant this role to SYSADMIN.

E.

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Question 67

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Options:

A.

SHOW STORAGE BY TABLE;

B.

SHOW TABLES;

C.

Information Schema -> TABLE_HISTORY

D.

Information Schema -> TABLE_FUNCTION

E.

Information Schema -> TABLE_STORAGE_METRICS

Question 68

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: 17 / 52
Total 693 questions
Get COF-C02 Full Access Download COF-C02 PDF