March Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: geek65

COF-C02 SnowPro Core Certification Exam (COF-C02) Questions and Answers

Questions 4

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Buy Now
Questions 5

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

command.

D.

Use the REMOVE command after the load completes.

E.

Use the DELETE LOAD HISTORY command after the load completes.

Buy Now
Questions 6

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

Buy Now
Questions 7

What is the recommended compressed file size range for continuous data loads using Snowpipe?

Options:

A.

8-16 MB

B.

16-24 MB

C.

10-99 MB

D.

100-250 MB

Buy Now
Questions 8

Which formats does Snowflake store unstructured data in? (Choose two.)

Options:

A.

GeoJSON

B.

Array

C.

XML

D.

Object

E.

BLOB

Buy Now
Questions 9

The Snowflake Cloud Data Platform is described as having which of the following architectures?

Options:

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Buy Now
Questions 10

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Options:

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Buy Now
Questions 11

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.

Buy Now
Questions 12

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Options:

A.

The columns that are queried in the select clause.

B.

The columns with very high cardinality.

C.

The columns with many different values.

D.

The columns most actively used in the select filters.

Buy Now
Questions 13

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Options:

A.

Files

B.

External tables

C.

Secure User-Defined Functions (UDFs)

D.

Sequences

E.

Streams

Buy Now
Questions 14

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Options:

A.

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

B.

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C.

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

D.

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

E.

grant SELECT on all tables in database DB1 to role MYROLE;

F.

grant SELECT on future tables in database DB1 to role MYROLE;

Buy Now
Questions 15

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Options:

A.

Use data encryption.

B.

Use dynamic data masking.

C.

Use secure materialized views.

D.

Revoke all roles for functional managers and end users.

Buy Now
Questions 16

What is cached during a query on a virtual warehouse?

Options:

A.

All columns in a micro-partition

B.

Any columns accessed during the query

C.

The columns in the result set of the query

D.

All rows accessed during the query

Buy Now
Questions 17

A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Options:

A.

view @my_stage

B.

list @my_stage

C.

show @my_stage

D.

display @my_stage

Buy Now
Questions 18

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

Options:

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

Buy Now
Questions 19

Which of the following accurately describes shares?

Options:

A.

Tables, secure views, and secure UDFs can be shared

B.

Shares can be shared

C.

Data consumers can clone a new table from a share

D.

Access to a share cannot be revoked once granted

Buy Now
Questions 20

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Options:

A.

Authentication

B.

Resource management

C.

Virtual warehouse caching

D.

Query parsing and optimization

E.

Query execution

F.

Physical storage of micro-partitions

Buy Now
Questions 21

Which of the following describes external functions in Snowflake?

Options:

A.

They are a type of User-defined Function (UDF).

B.

They contain their own SQL code.

C.

They call code that is stored inside of Snowflake.

D.

They can return multiple rows for each row received

Buy Now
Questions 22

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

A.

A read-only copy of the cloned tables is stored.

B.

The replication will not be successful.

C.

The physical data is replicated

D.

Additional costs for storage are charged to a secondary account

E.

Metadata pointers to cloned tables are replicated

Buy Now
Questions 23

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Options:

A.

Load files that are approximately 25 MB or smaller.

B.

Remove all dates and timestamps.

C.

Load files that are approximately 100-250 MB (or larger)

D.

Avoid using embedded characters such as commas for numeric data types

E.

Remove semi-structured data types

Buy Now
Questions 24

Which data type can be used to store geospatial data in Snowflake?

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Buy Now
Questions 25

What tasks can be completed using the copy command? (Select TWO)

Options:

A.

Columns can be aggregated

B.

Columns can be joined with an existing table

C.

Columns can be reordered

D.

Columns can be omitted

E.

Data can be loaded without the need to spin up a virtual warehouse

Buy Now
Questions 26

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

Options:

A.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Buy Now
Questions 27

Which of the following commands cannot be used within a reader account?

Options:

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Buy Now
Questions 28

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Buy Now
Questions 29

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Buy Now
Questions 30

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

Options:

A.

list @mytable;

B.

list @%raytable;

C.

list @ %m.ystage;

D.

list @mystage;

Buy Now
Questions 31

What feature can be used to reorganize a very large table on one or more columns?

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Buy Now
Questions 32

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Options:

A.

Data can be filtered by an optional where clause

B.

Incoming data can be joined with other tables

C.

Columns can be reordered

D.

Columns can be omitted

E.

Row level access can be defined

Buy Now
Questions 33

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Options:

A.

An FTP server with TLS encryption

B.

An HTTPS server with WebDAV

C.

A Google Cloud storage bucket

D.

A Windows server file share on Azure

Buy Now
Questions 34

How long is Snowpipe data load history retained?

Options:

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Buy Now
Questions 35

What SQL command would be used to view all roles that were granted to user.1?

Options:

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Buy Now
Questions 36

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

Options:

A.

It removes the last element of the outer array.

B.

It removes the outer array structure and loads the records into separate table rows,

C.

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D.

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Buy Now
 command to remove the outer array structure and load the records into separate table rows:

copy into

from @~/.json

file_format = (type = 'JSON' strip_outer_array = true);

https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

Questions 37

A user has unloaded data from Snowflake to a stage

Which SQL command should be used to validate which data was loaded into the stage?

Options:

A.

list @file__stage

B.

show @file__stage

C.

view @file__stage

D.

verify @file__stage

Buy Now
Questions 38

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

Options:

A.

SCIM

B.

Federated authentication

C.

TLS 1.2

D.

Key-pair authentication

E.

OAuth

F.

OCSP authentication

Buy Now
Questions 39

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Options:

A.

Create a task that runs a copy into operation from an external stage every 5 minutes

B.

Create a task that puts the files in an internal stage and automate the data loading wizard

C.

Create a task that runs a GET operation to intermittently check for new files

D.

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Buy Now
Exam Code: COF-C02
Exam Name: SnowPro Core Certification Exam (COF-C02)
Last Update: Mar 28, 2024
Questions: 501
COF-C02 pdf

COF-C02 PDF

$28  $80
COF-C02 Engine

COF-C02 Testing Engine

$33.25  $95
COF-C02 PDF + Engine

COF-C02 PDF + Testing Engine

$45.5  $130