Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Snowflake SnowPro Core Certification COF-C02 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam COF-C02 Premium Access

View all detail and faqs for the COF-C02 exam

Go to Exam

701 Students Passed

86% Average Score

91% Same Questions
Viewing page 12 out of 14 pages
Viewing questions 221-240 out of questions
Questions # 221:

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

Options:

A.

GET_PRESIGNED_URL

B.

GET_ABSOLUTE_PATH

C.

BUILD_STAGE_FILE_URL

D.

BUILD SCOPED FILE URL

Questions # 222:

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 # 223:

Which function unloads data from a relational table to JSON?

Options:

A.

TO_OBJECT

B.

TO_JSON

C.

TO_VARIANT

D.

OBJECT CONSTRUCT

Questions # 224:

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Options:

A.

Review the granted privileges to the database object.

B.

Review the row access policy for the database object.

C.

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

D.

Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

Questions # 225:

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

Options:

A.

OAuth

B.

Network policies

C.

Single Sign-On (SSO)

D.

Multi-Factor Authentication (MFA)

Questions # 226:

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Options:

A.

Local disk caching

B.

Authentication and access control

C.

Metadata management

D.

Query processing

E.

Database storage

Questions # 227:

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Options:

A.

4

B.

8

C.

16

D.

32

Questions # 228:

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Options:

A.

When the system has enough load for 2 minutes

B.

When the system has enough load for 6 minutes

C.

When the system has enough load for 8 minutes

D.

When the system has enough load for 10 minutes

Questions # 229:

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Options:

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Questions # 230:

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Options:

A.

Avro

B.

JSON

C.

ORC

D.

XML

E.

Delimited (CSV, TSV, etc.)

Questions # 231:

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Options:

A.

UPDATE TABLE FROM STREAM

B.

SELECT FROM STREAM

C.

INSERT INTO TABLE SELECT FROM STREAM

D.

ALTER TABLE AS SELECT FROM STREAM

E.

BEGIN COMMIT

Questions # 232:

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

Options:

A.

B.

C.

D.

Questions # 233:

Which statement is true about running tasks in Snowflake?

Options:

A.

A task can be called using a CALL statement to run a set of predefined SQL commands.

B.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

C.

A task allows a user to execute a set of SQL commands on a predefined schedule.

D.

A task can be executed using a SELECT statement to run a predefined SQL command.

Questions # 234:

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Options:

A.

Database replication and failover

B.

Automated index management

C.

Customer managed keys (Tri-secret secure)

D.

Extended time travel

E.

Native support for geospatial data

Questions # 235:

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Questions # 236:

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Options:

A.

Use the DROP command after the load completes.

B.

Specify the TEMPORARY option when creating the file format.

C.

Specify the PURGE copy option in the COPY INTO <title> command.

D.

Use the REMOVE command after the load completes.

E.

Use the DELETE LOAD HISTORY command after the load completes.

Questions # 237:

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Options:

A.

SELECT SUM (ORDER_AMT) FROM SALES;

B.

SELECT AVG(ORDER_QTY) FROM SALES;

C.

SELECT MIN(ORDER_AMT) FROM SALES;

D.

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Questions # 238:

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

Options:

A.

There is no need to have a Snowflake account in the target region, a share will be created for each user.

B.

The listing is replicated into all selected regions automatically, the data is not.

C.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

D.

Shares attached to listings in remote regions can be viewed from any account in an organization.

E.

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Questions # 239:

How can a row access policy be applied to a table or a view? (Choose two.)

Options:

A.

Within the policy DDL

B.

Within the create table or create view DDL

C.

By future APPLY for all objects in a schema

D.

Within a control table

E.

Using the command ALTER ADD ROW ACCESS POLICY ;