Big Halloween Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Snowflake COF-C02 Practice Exam with Questions & Answers

Questions 1

What are characteristics of Snowflake network policies? (Select TWO).

Options:
A.

They can be set for any Snowflake Edition.

B.

They can be applied to roles.

C.

They restrict or enable access to specific IP addresses.

D.

They are activated using ALTER DATABASE SQL commands.

E.

They can only be managed using the ORGADMIN role.

Snowflake COF-C02 Premium Access
Questions 2

Which table function will return the output of a previously-run command?

Options:
A.

FLATTEN

B.

QUERY_HISTORY

C.

TASK_HISTORY

D.

RESULT_SCAN

Questions 3

How can a 5 GB table be downloaded into a single file MOST efficiently?

Options:
A.

Keep the default MAX_FILE_SIZE to 16 MB

B.

Set the default MAX_FILE_SI2E to 5 GB.

C.

Set the SINGLE parameter to TRUE.

D.

Use a regular expression in the stage specifications of the COPY command.

Questions 4

Which COPY INTO

options can be used to load data from a staged file when the metadata in the file has expired? (Select TWO)

Options:
A.

LOAD_UNCERTAIN_FILES

B.

LOAD_EXPIRED_FILES

C.

FORCE

D.

ENFORCE_LENGTH

E.

PURGE

Questions 5

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

Options:
A.

GRANT

B.

SELECT

C.

MODIFY

D.

OWNERSHIP

E.

CREATE USER

Questions 6

When unloading data, which file format preserves the data values for floating-point number columns?

Options:
A.

Avro

B.

CSV

C.

JSON

D.

Parquet

Questions 7

How should a Snowflake user access a third-party SaaS service to process unstructured data?

Options:
A.

Use internal functions.

B.

Use external functions.

C.

Use process functions.

D.

Use an API gateway.

Questions 8

What can a directory table be used for? (Select TWO)

Options:
A.

Retrieve a list of all unstructured files on a stage.

B.

Set an automatic refresh of the metadata for a directory table on internal and external stages.

C.

Remove files from a directory table using the GET command.

D.

Create a view for unstructured data.

E.

Process unstructured data using Snowflake system-defined functions.

Questions 9

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

Options:
A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

Questions 10

What will happen when the data retention period for an object is set to 0 days?

Options:
A.

Streams containing the object will become stale.

B.

Time Travel will be deactivated for the object.

C.

Data replication will be disabled for the object.

D.

Data sharing will be disabled for the object.

Questions 11

How can storage costs be MINIMIZED while maintaining the history and integrity of a large, permanent table that is updated frequently?

Options:
A.

Decrease the Time Travel retention period

B.

Convert the table type to transient.

C.

Use zero-copy clones of the table.

D.

Enable automatic clustering

Questions 12

Which strategy is recommended to improve the performance of a large, complex query?

Options:
A.

Add more storage

B.

Convert to a multi-cluster warehouse

C.

Increase the size of the warehouse

D.

Run the query during off-peak hours

Questions 13

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.

Questions 14

Which access control entity in Snowflake can be created as part of a hierarchy within an account?

Options:
A.

Securable object

B.

Role

C.

Privilege

D.

User

Questions 15

What is a Snowflake recommendation for the use of key pair authentication?

Options:
A.

Keys should be stored in a secure location on the ACCOUNTADMIN file system.

B.

Operator access should be limited to read-only access.

C.

Key pair rotation should be automated.

D.

Role access should be designed to cover the operations that the user account anticipates needing.

Questions 16

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Options:
A.

The data retention period is reduced to a minimum of 14 days.

B.

The data retention period is permanently extended for the table.

C.

The data retention period is temporarily extended to the stream's offset.

D.

The data retention period is not affected by the stream consumption.

Questions 17

How does the search optimization service help Snowflake users improve query performance?

Options:
A.

It scans the micro-partitions based on the joins used in the queries and scans only join columns.

B.

II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

C.

It scans the local disk cache to avoid scans on the tables used in the Query.

D.

It keeps track of running queries and their results and saves those extra scans on the table.

Questions 18

Which Snowflake table stores file-level metadata about unstructured data files in a stage, including size, last-modified timestamp, and Snowflake file URL?

Options:
A.

Directory table

B.

External table

C.

Dynamic table

D.

Iceberg table

Questions 19

What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Select TWO).

Options:
A.

VARIANT

B.

ARRAY

C.

BINARY

D.

OBJECT

E.

VARCHAR

Questions 20

How does the search optimization service improve query performance?

Options:
A.

By clustering the tables

B.

By creating a persistent data structure

C.

By using caching

D.

By optimizing the use of micro-partitions

PDF + Testing Engine
$164.99
$57.75
Testing Engine
$124.99
$43.75
PDF (Q&A)
$104.99
$36.75