Special Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 201

How can a user improve the performance of a single large complex query in Snowflake?

A.

Scale up the virtual warehouse.

B.

Scale out the virtual warehouse.

C.

Enable standard warehouse scaling.

D.

Enable economy warehouse scaling.

Full Access
Question # 202

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

A.

ROW_NUMBER

B.

TABLE

C.

TABULAR

D.

VALUES

Full Access
Question # 203

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

A.

Cloud Services

B.

Database Storage

C.

Query Processing

D.

Metadata Management

Full Access
Question # 204

What can a Snowflake user do with the information included in the details section of a Query Profile?

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

Determine if the query was on structured or semi-structured data.

Full Access
Question # 205

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

A.

SHOW GRANTS ON ROLE DATA_SCIENCE

B.

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C.

SHOW GRANTS TO USER INQUISITIVE_PERSON

D.

SHOW GRANTS OF ROLE DATA_SCIENCE

Full Access
Question # 206

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

A.

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Full Access
Question # 207

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

A.

True

B.

False

Full Access
Question # 208

Which of the following are benefits of micro-partitioning? (Select TWO)

A.

Micro-partitions cannot overlap in their range of values

B.

Micro-partitions are immutable objects that support the use of Time Travel.

C.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D.

Rows are automatically stored in sorted order within micro-partitions

E.

Micro-partitions can be defined on a schema-by-schema basis

Full Access
Go to page: