Month End Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Examstrust Logo
examstrust mcafee
  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02 - SnowPro Core Certification Exam

Snowflake COF-C02 SnowPro Core Certification Exam Exam Practice Test

Page: 1 / 89
Total 893 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$52.5  $174.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Add to Cart
Question 1

What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?

Options:

A.

X-Small

B.

Small

C.

Medium

D.

Large

Question 2

Which command can be used to list all network policies available in an account?

Options:

A.

DESCRIBE SESSION POLICY

B.

DESCRIBE NETWORK POLICY

C.

SHOW SESSION POLICIES

D.

SHOW NETWORK POLICIES

Question 3

Which table function will identify data that was loaded using COPY INTO

statements and also identify data loaded using Snowpipe?

Options:

A.

DATA_TRANSFER_HISTORY

B.

PIPE_USAGE_HISTORY

C.

VALIDATE_PIPE_LOAD

D.

COPY_HISTORY

commands and automated data loading through Snowpipe. This function provides visibility into load operations, making it valuable for monitoring data ingestion, ensuring data integrity, and troubleshooting loading processes.

Question 4

How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?

Options:

A.

32

B.

64

C.

128

D.

256

Question 5

What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).

Options:

A.

Compress the files before loading.

B.

Use a semi-structured file format.

C.

Increase the PARALLEL option value.

D.

Load the data into a table stage.

E.

Enable the overwrite option.

Question 6

Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions). and has no Fail-safe period?

Options:

A.

External

B.

Permanent

C.

Temporary

D.

Transient

Question 7

Which types of subqueries does Snowflake support? (Select TWO).

Options:

A.

Uncorrelated scalar subqueries in WHERE clauses

B.

Uncorrelated scalar subqueries in any place that a value expression can be used

C.

EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

D.

EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

E.

EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

Question 8

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

Question 9

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

Options:

A.

Repair the failed resources.

B.

Restart failed resources.

C.

Queue the failed resources

D.

Provision the failed resources

Question 10

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.

Question 11

The customer table in the T1 database is accidentally dropped.

Which privileges are required to restore this table? {Select TWO).

Options:

A.

SELECT privilege on the customer table

B.

ownership privilege on the customer table

C.

All privileges on the customer table

D.

All privileges on the T1 database

E.

CREATE TABIE privilege on the T1 database

Question 12

What is the default access of a securable object until other access is granted?

Options:

A.

No access

B.

Read access

C.

Write access

D.

Full access

Question 13

Which privilege grants the ability to set a column-level security masking policy on a table or view column?

Options:

A.

APPLY

B.

CREATE

C.

SET

D.

MODIFY

Question 14

Which function will convert semi-structured data to a relational data representation?

Options:

A.

PARSE JSON

B.

FLATTEN

C.

OBJECT_CONSTRUCT

D.

OBJECT_AGG

Question 15

Which steps will help optimize query performance? (Select TWO).

Options:

A.

Using the query acceleration service

B.

Clustering a table

C.

Indexing a column

D.

Increasing the size of the micro-partitions

E.

Decreasing the size of the virtual warehouse

Question 16

An external stage many_stage contains many directories including one, app_files that contains CSV files

How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?

Options:

A.

B.

C.

D.

Question 17

What do temporary and transient tables have m common in Snowflake? (Select TWO).

Options:

A.

Both tables have no Fail-safe period.

B.

Both tables have data retention period maximums of one day.

C.

Both tables are visible only to a single user session.

D.

For both tables the retention period ends when the tables are dropped.

E.

For both tables, the retention period does not end when the session ends

Question 18

Which Snowflake table supports unstructured data?

Options:

A.

Directory

B.

Transient

C.

Temporary

D.

Permanent

Question 19

Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).

Options:

A.

B.

C.

D.

E.

Question 20

Which type of role can be granted to a share?

Options:

A.

Account role

B.

Custom role

C.

Database role

D.

Secondary role

Question 21

Which security models are used in Snowflake to manage access control? (Select TWO).

Options:

A.

Discretionary Access Control (DAC)

B.

Identity Access Management (1AM)

C.

Mandatory Access Control (MAC)

D.

Role-Based Access Control (RBAC)

E.

Security Assertion Markup Language (SAML)

Question 22

Which data protection feature should only be used when all other data recovery options have been attempted?

Options:

A.

Time Travel

B.

Cloning

C.

Replication

D.

Fail-safe

Question 23

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.

Which Snowflake do it the user's IP address does not match the user-level network policy rules?

Options:

A.

Log the user out.

B.

Deactivate the network policy.

C.

Prevent the user from executing additional queries.

D.

Allow the user to continue until the session or login token expires.

Question 24

In the Data Exchange, who can get or request data from the listings? (Select TWO).

Options:

A.

Users with ACCOUNTADMIN role

B.

Users with sysadmin role

C.

Users with ORGADMIN role

D.

Users with import share privilege

E.

Users with manage grants privilege

Question 25

How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column ID_NUMER?

Options:

A.

TRUNC (ID_NUMBER, -6)

B.

TRUNC (ID_NUMBER, 5)

C.

ID_NUMBER*100

D.

TO CHAR(ID_NUMBER)

Question 26

When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?

Options:

A.

SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);

B.

SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);

C.

SELECT * FROM MY_TABLE SAMPLE (5 ROWS);

D.

SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);

Question 27

What is the expiration period tor a file URL used to access unstructured data in cloud storage?

Options:

A.

The remainder of the session

B.

An unlimited amount of time

C.

The length of time specified in the expiration_time argument

D.

The same length of time as the expiration period for the query results cache

Question 28

In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).

Options:

A.

Implementation of column-level security will optimize query performance.

B.

Column-level security supports encryption of the entire database.

C.

Column-level security ensures that only the table owner can access the data.

D.

Column-level security limits access to specific columns within a table based on user privileges

E.

Column-level security allows the application of a masking policy to a column within a table or view.

Question 29

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.

Question 30

Which table type is used in the file processing pipeline to process unstructured data in Snowflake?

Options:

A.

Temporary

B.

Directory

C.

Standard

D.

Transient

Question 31

Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

Options:

A.

GET

B.

PUT

C.

CREATE STREAM

D.

COPY INTO

Question 32

Which function, when added to a select statement will return a randomly-selected, specified number of rows from a table?

Options:

A.

AVERAGE ROWS)

B.

MEDIAN< RONS)

C.

SAMPLE( ROWS)

D.

RANDOM( ROUS)

Question 33

Which type of workload traditionally benefits from the use of the query acceleration service?

Options:

A.

Workloads with a predictable data volume for each query

B.

Workloads that include on-demand data analyses

C.

Queries with small scans and non-selective filters

D.

Queries that do not have filters or aggregation

Question 34

What is the MINIMUM Snowflake edition required to use the query acceleration service?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Question 35

Authorization to execute CREATE statements comes only from which role?

Options:

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Question 36

A Snowflake user needs to optimize the definition of a secure view, but the user cannot see the view.

Which of the LEAST-PRIVILEGED access or role that should be granted to the user to complete this task?

Options:

A.

Grant the user the AYSADMIN role.

B.

Grant the user the ownership privilege on the secure view.

C.

Grant the user the imported privileges privilege on the database.

D.

Grant the user the SHOWFLAKE. object viewer database role.

Question 37

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

Question 38

Which semi-structured file format is a compressed, efficient, columnar data representation?

Options:

A.

Avro

B.

JSON

C.

TSV

D.

Parquet

Question 39

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Question 40

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

Options:

A.

To validate external table files in table t1 across all sessions

B.

To validate task SQL statements against table t1 in the last 14 days

C.

To validate a file for errors before it gets executed using a COPY command

D.

To return errors from the last executed COPY command into table t1 in the current session

Question 41

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

Question 42

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Question 43

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Question 44

True or False: Snowpipe via REST API can only reference External Stages as source.

Options:

A.

True

B.

False

Question 45

Which of the following describes a Snowflake stored procedure?

Options:

A.

They can be created as secure and hide the underlying metadata from the user.

B.

They can only access tables from a single database.

C.

They can contain only a single SQL statement.

D.

They can be created to run with a caller's rights or an owner's rights.

Question 46

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

A.

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.

An error will occur, as views with qualified references cannot be cloned.

C.

An error will occur, as stored objects cannot be cloned.

D.

The stored procedures and views will refer to tables in the source database.

Question 47

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Options:

A.

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B.

Allows a user to import the files in a sequential order

C.

Increases the latency staging and accuracy when loading the data

D.

Allows optimization of parallel operations

Question 48

How does Snowflake Fail-safe protect data in a permanent table?

Options:

A.

Fail-safe makes data available up to 1 day, recoverable by user operations.

B.

Fail-safe makes data available for 7 days, recoverable by user operations.

C.

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D.

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Question 49

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options:

A.

The Pipe load history is reset to empty.

B.

The REFRESH command is executed.

C.

The stage will be purged.

D.

The destination table is truncated.

Question 50

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

Question 51

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Options:

A.

VARIANT

B.

VARRAY

C.

STRUCT

D.

ARRAY

E.

QUEUE

Question 52

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 ;

C.

COPY INTO

D.

CREATE PIPE

Question 194

Which privilege must be granted by one role to another role, and cannot be revoked?

Options:

A.

MONITOR

B.

OPERATE

C.

OWNERSHIP

D.

D. ALL

Question 195

How is unstructured data retrieved from data storage?

Options:

A.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Question 196

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

Options:

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.

Question 197

What is the primary purpose of a directory table in Snowflake?

Options:

A.

To store actual data from external stages

B.

To automatically expire file URLs for security

C.

To manage user privileges and access control

D.

To store file-level metadata about data files in a stage

Question 198

Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

Options:

A.

CREATE SESSION POLICY

B.

CREATE NETWORK RULE

C.

CREATE SECURITY INTEGRATION

D.

CREATE PASSWORD POLICY

Question 199

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.

Question 200

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Question 201

Which Snowflake database object can be used to track data changes made to table data?

Options:

A.

Tag

B.

Task

C.

Stream

D.

Stored procedure

Question 202

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Options:

A.

Access control

B.

Fail-safe

C.

Network policies

D.

Time Travel

Question 203

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Options:

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Question 204

A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?

Options:

A.

File URL

B.

Staged URL

C.

Scoped URL

D.

D. Pre-signed URL

Question 205

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

Options:

A.

It removes null values from all columns in the data.

B.

It converts null values to empty strings during loading.

C.

It skips rows with null values during the loading process.

D.

It removes object or array elements containing null values.

Question 206

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

Options:

A.

FLATTEN

B.

GET_PATH

C.

CHECK_JSON

D.

PARSE JSON

Question 207

Which metadata table will store the storage utilization information even for dropped tables?

Options:

A.

DATABASE_STORAGE_USAGE_HISTORY

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STAGE STORAGE USAGE HISTORY

Question 208

What is a characteristic of materialized views in Snowflake?

Options:

A.

Materialized views do not allow joins.

B.

Clones of materialized views can be created directly by the user.

C.

Multiple tables can be joined in the underlying query of a materialized view.

D.

Aggregate functions can be used as window functions in materialized views.

Question 209

What factors impact storage costs in Snowflake? (Select TWO).

Options:

A.

The account type

B.

The storage file format

C.

The cloud region used by the account

D.

The type of data being stored

E.

The cloud platform being used

Question 210

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Options:

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Question 211

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)

Question 212

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

Question 213

What step can reduce data spilling in Snowflake?

Options:

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

Using a common table expression (CTE) instead of a temporary table

Question 214

Which Snowflake table objects can be shared with other accounts? (Select TWO).

Options:

A.

Temporary tables

B.

Permanent tables

C.

Transient tables

D.

External tables

E.

User-Defined Table Functions (UDTFs)

Question 215

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Options:

A.

Warehouses that are multi-cluster can have nodes of different sizes.

B.

Warehouses can be started and stopped at any time.

C.

Warehouses can be resized at any time, even while running.

D.

Warehouses are billed on a per-minute usage basis.

E.

Warehouses can only be used for querying and cannot be used for data loading.

Question 216

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

Options:

A.

CREATE TABLE LIKE TABLE_A;

B.

CREATE VIEW AS SELECT * FROM TABLE_A;

C.

CREATE TABLE AS SELECT * FROM TABLE_A;

D.

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

Question 217

What does a masking policy consist of in Snowflake?

Options:

A.

A single data type, with one or more conditions, and one or more masking functions

B.

A single data type, with only one condition, and only one masking function

C.

Multiple data types, with only one condition, and one or more masking functions

D.

Multiple data types, with one or more conditions, and one or more masking functions

Question 218

Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

Options:

A.

RETURN_-1_R0WS

B.

RETURN_n_ROWS

C.

RETURN_ERRORS

D.

RETURN ALL ERRORS

Question 219

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

Options:

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Question 220

How can a dropped internal stage be restored?

Options:

A.

Enable Time Travel.

B.

Clone the dropped stage.

C.

Execute the UNDROP command.

D.

Recreate the dropped stage.

Question 221

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Options:

A.

Add and remove members.

B.

Delete data categories.

C.

Approve and deny listing approval requests.

D.

Transfer listing ownership.

E.

Transfer ownership of a provider profile.

Question 222

What does SnowCD help Snowflake users to do?

Options:

A.

Copy data into files.

B.

Manage different databases and schemas.

C.

Troubleshoot network connections to Snowflake.

D.

Write SELECT queries to retrieve data from external tables.

Question 223

What is the purpose of a Query Profile?

Options:

A.

To profile how many times a particular query was executed and analyze its u^age statistics over time.

B.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Question 224

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

Options:

A.

USAGE_VIEWER

B.

GOVERNANCE_VIEWER

C.

OBJECT_VIEWER

D.

SECURITY_VIEWER

Question 225

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

Options:

A.

The temporary table will take precedence over the permanent table.

B.

The permanent table will take precedence over the temporary table.

C.

An error will say there cannot be two tables with the same name in a schema.

D.

The table that was created most recently will take precedence over the older table.

Question 226

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

Options:

A.

Column compression

B.

Data clustering

C.

Micro-partitioning

D.

Metadata management

Load More COF-C02 Questions
Page: 1 / 89
Total 893 questions
Get COF-C02 Full Access Download COF-C02 PDF