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 # 97

Which steps will help optimize query performance? (Select TWO).

A.

Using the query acceleration service

B.

Clustering a table

C.

Indexing a column

D.

Increasing the size of the micro-partitions

E.

Decreasing the size of the virtual warehouse

Full Access
Question # 98

Snowflake users can create a resource monitor at which levels? (Select TWO).

A.

User level

B.

Pipe level

C.

Account level

D.

Cloud services level

E.

Virtual warehouse level

Full Access
Question # 99

What happens to the privileges granted to Snowflake system-defined roles?

A.

The privileges cannot be revoked.

B.

The privileges can be revoked by an ACCOUNTADMIN.

C.

The privileges can be revoked by an orgadmin.

D.

The privileges can be revoked by any user-defined role with appropriate privileges.

Full Access
Question # 100

Which command can be used to unload data into an external named stage in Snowflake?

A.

PUT

B.

CREATE

C.

COPY INTO

D.

COPY INTO

Full Access
Question # 101

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

A.

The separation allows independent scaling of computing resources.

B.

The separation ensures consistent data encryption across all virtual data warehouses.

C.

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D.

Storage volume growth and compute usage growth can be tightly coupled.

E.

Compute can be scaled up or down without the requirement to add more storage.

Full Access
Question # 102

Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

A.

RETURN_-1_R0WS

B.

RETURN_n_ROWS

C.

RETURN_ERRORS

D.

RETURN ALL ERRORS

Full Access
Question # 103

What is a characteristic of materialized views in Snowflake?

A.

Materialized views do not allow joins.

B.

Clones of materialized views can be created directly by the user.

C.

Multiple tables can be joined in the underlying query of a materialized view.

D.

Aggregate functions can be used as window functions in materialized views.

Full Access
Question # 104

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

A.

CREATE STAGE

B.

COPY INTO

C.

COPY INTO

D.

CREATE PIPE

Full Access
Go to page: