Weekend Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

COF-C02 Exam Dumps - Snowflake SnowPro Core Certification Questions and Answers

Question # 109

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

Options:

A.

60

B.

91

C.

120

D.

121

Buy Now
Question # 110

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Options:

A.

Clone the data from the production account to the non-production account.

B.

Create a data share from the production account to the non-production account.

C.

Create a subscription in the production account and have it publish to the non-production account.

D.

Create a reader account using the production account and link the reader account to the non-production account.

Buy Now
Question # 111

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

Options:

A.

User level

B.

Pipe level

C.

Account level

D.

Cloud services level

E.

Virtual warehouse level

Buy Now
Question # 112

Which strategy for optimizing virtual warehouse performance should be used to speed the execution of a very large query?

Options:

A.

Use the query acceleration service.

B.

Enable the search optimization service.

C.

Convert to a multi-cluster warehouse.

D.

Increase the size of the warehouse.

Buy Now
Question # 113

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

Options:

A.

Area chart

B.

Box plot

C.

Heat grid

D.

Pie chart

Buy Now
Question # 114

Which virtual warehouse auto-suspend configurations will result in a warehouse that runs continually 24 hours a day, 7 days a week? (Select TWO).

Options:

A.

-1

B.

0

C.

86400

D.

172800

E.

NULL

Buy Now
Question # 115

Authorization to execute CREATE statements comes only from which role?

Options:

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Buy Now
Question # 116

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

Options:

A.

Use Snowflake's native API.

B.

Use a custom-built connector.

C.

Contact Snowflake Support for a new driver.

D.

Connect through Snowflake’s JDBC or ODBC drivers

Buy Now
Question # 117

What happens when a table or schema with a standard retention period is dropped?

Options:

A.

The object is immediately removed from the system.

B.

The object is instantaneously moved to Fail-safe.

C.

The object is retained but all associated data is immediately purged.

D.

The object is retained for the data retention period.

Buy Now
Question # 118

Which features are included in Snowsight? (Select TWO)

Options:

A.

Worksheet sharing

B.

Referencing SnowSQL

C.

Exploring the Snowflake Marketplace

D.

Changing the Snowflake account cloud provider

E.

Downloading query result data larger than 100 MB

Buy Now
Question # 119

Which features can be used with the Snowflake Standard edition? (Select TWO).

Options:

A.

Materialized views

B.

External functions

C.

Multi-cluster virtual warehouses

D.

Fail-safe

E.

Row-level security

Buy Now
Question # 120

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Options:

A.

Persisted query results

B.

QUERY_HISTORY View

C.

Query acceleration service

D.

Query Profile

Buy Now
Question # 121

Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

Options:

A.

Secure functions

B.

Secure views

C.

Object tagging

D.

Row-level security

Buy Now
Question # 122

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

Options:

A.

ACCESS_HOSTORY

B.

LOGIN_HISTORY

C.

SESSIONS

D.

QUERY HISTORY

Buy Now
Question # 123

Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a stage?

Options:

A.

COPY_INTO command

B.

Data replication

C.

Snowpipe

D.

Direct share

Buy Now
Exam Code: COF-C02
Exam Name: SnowPro Core Certification Exam
Last Update: Feb 23, 2025
Questions: 751
COF-C02 pdf

COF-C02 PDF

$25.5  $84.99
COF-C02 Engine

COF-C02 Testing Engine

$28.5  $94.99
COF-C02 PDF + Engine

COF-C02 PDF + Testing Engine

$40.5  $134.99