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

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02 - SnowPro Core Certification Exam

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 201

How can performance be optimized for a query that returns a small amount of data from a very large base table?

A.

Use clustering keys

B.

Create materialized views

C.

Use the search optimization service

D.

Use the query acceleration service

Full Access
Question # 202

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

A.

DATA_RETENTION_TIME_IN_DAYS

B.

MAX_DATA_EXTENSION_TIME_IN_DAYS

C.

MIN_DATA_RETENTION_TIME_IN_DAYS

D.

MAX CONCURRENCY LEVEL

Full Access
Question # 203

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

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
Question # 205

A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).

A.

GRANT

B.

SELECT

C.

MODIFY

D.

OWNERSHIP

E.

CREATE USER

Full Access
Question # 206

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

A.

File URL

B.

Scoped URL

C.

Relative URL

D.

Pre-Signed URL

Full Access
Question # 207

For which use cases is running a virtual warehouse required? (Select TWO).

A.

When creating a table

B.

When loading data into a table

C.

When unloading data from a table

D.

When executing a show command

E.

When executing a list command

Full Access
Question # 208

What happens when a Snowflake user changes the data retention period at the schema level?

A.

All child objects will retain data for the new retention period.

B.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

C.

All child objects with an explicit retention period will be overridden with the new retention period.

D.

All explicit child object retention periods will remain unchanged.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps