Latest Snowflake COF-C02 Dumps PDF Questions Answers 2025

Question 15

Which statement will execute a stored procedure?

Options:

CALL proc1(SELECT COUNT(*) FROM

);

CALL proc1(1) + proc1(2);

CALL proc1(1) + IF

CALL proc1(proc2(1));

Question 16

How can a Snowflake user access near real-time metrics that can be used to identify queries affected by disk spilling?

Options:

Use a load monitoring chart.

Review the history section of the Query Profile.

Implement a Snowsight dashboard.

Use a worksheet.

Question 17

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

Options:

READ

REFERENCES

REFERENCEJJSAGE

USAGE

Question 18

Which Snowflake objects are supported by Snowpipe Streaming? (Select TWO)

Options:

Temporary tables

Permanent tables

Tables with a default column that is not NULL

Tables with columns containing the GEOMETRY datatype

Tables using sequences to generate names for columns

Question 19

What can be interpreted based on the number of nodes reported in a Query Profile?

Options:

Query execution time

Network bandwidth during query execution

Data spillage

Compute required for metadata management

Question 20

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

Options:

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

The data retention period is permanently extended for the table.

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

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

Question 21

Masking policies are created at what level in Snowflake?

Options:

Table

Column

Schema

Database

Question 22

A Snowflake user is querying JSON data and all values in the result set are wrapped in quotes. Which step will unwrap the data from all the columns in the query results?

Options:

Use the TRIM function to remove the quotes.

Use the INSTR function to remove the quotes.

Use the SUBSTRING function to select the values that are inside the quotes.

Use the CAST function to convert the columns to the correct data type.

Question 23

Which type of Snowflake security policy requires users to re-authenticate after a given period of inactivity?

Options:

Network policy

Password policy

Authentication policy

Session policy

Question 24

Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

Options:

Directory table

Temporary table

Transient table

A table with a materialized view

Question 25

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

Options:

Repair the failed resources.

Restart failed resources.

Queue the failed resources

Provision the failed resources

Question 26

What action is required to load data from a local file system into a Snowflake table?

Options:

Use the COPY INTO

command directly on the local file system.

Upload data files to a Snowflake external stage using the COPY INTO

and then use the GET command.

Use the PUT command directly on the local file system.

Upload data files to a Snowflake internal stage using the PUT command and then use the COPY INTO

command.

command to load data from the internal stage into the table.

[Reference:, Snowflake Docs: Loading Data from Local Files, ===========]

Question 27

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

Options:

Fail-safe

Network policies

End-to-end encryption

Multi-Factor Authentication (MFA)

Question 28

If a virtual warehouse is suspended, what happens to the warehouse cache?

Options:

The cache is dropped when the warehouse is suspended and is no longer available upon restart.

The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.

The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.

The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Question 29

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

Options:

AVERAGE ROWS)

MEDIAN< RONS)

SAMPLE( ROWS)

RANDOM( ROUS)

Question 30

When using the COPY INTO command to unload table data into a CSV file, which option would compress the file using the default algorithm?

Options:

SNAPPY

DEFLATE

NONE

AUTO

Question 31

What happens when a suspended virtual warehouse is resized in Snowflake?

Options:

It will return an error.

It will return a warning.

The suspended warehouse is resumed and new compute resources are provisioned immediately.

The additional compute resources are provisioned when the warehouse is resumed.

Question 32

Which Snowflake tool or feature enables governed sharing of datasets with a selected group of consumers that are invited, internal or external, to a Snowflake user's company?

Options:

Snowflake Marketplace

Data Exchange

Replication

Snowpipe

Question 33

When do Snowflake object owners lose their ability to make grant decisions?

Options:

When the object owner has been granted a database role

When the object owner has been granted an account role

When the object is part of a managed access schema

When the object is part of a regular schema

Question 34

What are type predicates used for?

Options:

Extracting data from a variant column

Casting a value in a variant column to a particular data type

Determining if a value in a variant column is a particular data type

Manipulating objects and arrays in a VARIANT column

Question 35

What does a Query Profile metric that shows excessive spillage indicate?

Options:

Poor query optimization

Expired temporary tables

Improper virtual warehouse sizing

Improper Common Table Expressions (CTEs)

Question 36

Which action will scale-out a Snowflake virtual warehouse?

Options:

Removing 1 cluster from a multi-cluster warehouse

Adding 2 additional clusters to a multi-cluster warehouse

Resizing a warehouse from size Small to X-Large

Resizing a warehouse from size Large to Medium

Question 37

Which objects will incur storage costs associated with Fail-safe?

Options:

External tables

Permanent tables

Data files available in internal stages

Data files available in external stages

Question 38

What is the purpose of the use of the VALIDATE command?

Options:

To view any queries that encountered an error

To verify that a SELECT query will run without error

To prevent a put statement from running if an error occurs

To see all errors from a previously run COPY INTO

statement

statement. This command helps users identify and resolve data loading issues.

Run the COPY INTO Statement:Execute theCOPY INTO

command to load data from a stage into a table.

COPY INTO my_table

FROM @my_stage

FILE_FORMAT = (FORMAT_NAME = 'my_format');

Validate the Load:Use theVALIDATEfunction to see if there were any errors during the data load.

SELECT *

FROM TABLE(VALIDATE(my_table, JOB_ID => 'my_copy_job_id'));

Review Errors:TheVALIDATEfunction will return details about any errors that occurred, such as parsing errors or data type mismatches.

[References:, Snowflake Documentation: Validating Data Loads, Snowflake Documentation: COPY INTO

, , , ]

Question 39

How should a data provider securely share Snowflake objects with a data consumer who does not have a Snowflake account?

Options:

Give the consumer owner's rights on the provider's Snowflake account.

Unload the data into the consumer's cloud storage.

Create a reader account for the consumer.

Create and replicate a share, then give the consumer access to the replication.

Question 40

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

Options:

Add more storage

Convert to a multi-cluster warehouse

Increase the size of the warehouse

Run the query during off-peak hours

Question 41

While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).

Options:

GET

CREATE STAGE

PUT

COPY INTO

CREATE PIPE

Question 42

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Options:

MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters

MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters

Question 43

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

Options:

Streams containing the object will become stale.

Time Travel will be deactivated for the object.

Data replication will be disabled for the object.

Data sharing will be disabled for the object.

Answer:

Explanation:

Comprehensive and Detailed Explanation From Exact Extract:

Why B (Time Travel will be deactivated for the object) is correct:In Snowflake, the data retention period determines how long historical data (including deleted or modified data) is retained for Time Travel. When this period is set to 0 days, Time Travel is effectively disabled for that object (such as a table, schema, or database).

From the official Snowflake documentation:

“The DATA_RETENTION_TIME_IN_DAYS parameter specifies the number of days for which historical data is retained for Time Travel. A value of 0 disables Time Travel for the object.”

This means:

When DATA_RETENTION_TIME_IN_DAYS = 0, no historical versions of the object’s data are retained.

As a result, Time Travel queries (using AT or BEFORE clauses) and undrop/recovery operations are not available for that object.

Why A (Streams containing the object will become stale) is incorrect:Streams become stale when the data change tracking window exceeds the retention period of the source table’s Time Travel, but only if the retention period expires after some time. Setting retention to 0 disables Time Travel immediately, but doesn’t by itself make existing streams “stale.” Instead, new streams cannot be used effectively because there is no historical data to track.

Why C (Data replication will be disabled) is incorrect:Data replication is independent of the Time Travel retention period. A retention period of 0 does not affect replication; it only impacts the Time Travel feature.

Why D (Data sharing will be disabled) is incorrect:Data sharing is a separate Snowflake feature (using Secure Data Sharing). It is not impacted by Time Travel retention settings. Shared data can still be accessible regardless of the retention period.

References (Snowflake SnowPro Core / Study Guide / Official Documentation):

Snowflake Documentation — Time Travel:

“Setting DATA_RETENTION_TIME_IN_DAYS = 0 disables Time Travel for the object.”

Snowflake Documentation — Object Parameters:Describes DATA_RETENTION_TIME_IN_DAYS behavior at the database, schema, and table levels.

Snowflake Study Guide — Data Protection and Governance:Clarifies that setting retention to zero disables historical data storage and deactivates Time Travel functionality.

Question 44

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

Options:

Avro

JSON

TSV

Parquet

Question 45

Which command should be used to load data from a local computer into Snowflake?

Options:

CREATE EXTERNAL TABLE

COPY INTO

INSERT

PUT

Question 46

What does Snowflake recommend when planning virtual warehouse usage for a data load?

Options:

Load the fewest possible number of large files.

Dedicate a separate warehouse for loading data.

Increase the size of the warehouse used.

Use several single-duster warehouses.

Question 47

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

Options:

Pruning

Spilling

Initialization

Local Disk I/O

Percentage of data read from cache

Question 48

Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

Options:

Free listing

Paid listing

Direct share

Data Exchange

Question 49

What is the purpose of multi-cluster virtual warehouses?

Options:

To create separate data warehouses to increase query optimization

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

To eliminate or reduce Queuing of concurrent queries

To allow the warehouse to resize automatically

Question 50

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

Options:

Question 51

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

Options:

Shared-disk

Shared-nothing

Multi-cluster shared data

Serverless query engine

Question 52

How many days is load history for Snowpipe retained?

Options:

1 day

7 days

14 days

64 days

Question 53

What affects whether the query results cache can be used?

Options:

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

Question 54

In the Snowflake access control model, which entity owns an object by default?

Options:

The user who created the object

The SYSADMIN role

Ownership depends on the type of object

The role used to create the object

Question 55

What is the minimum Snowflake edition that has column-level security enabled?

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Question 56

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:

Question 57

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Question 58

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Options:

Schema

View

Internal stage

Table

User

Role

Question 59

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options:

Management of metadata

Computing the data

Maintaining Availability Zones

Infrastructure security

Parsing and optimizing queries

Question 60

Which of the following accurately describes shares?

Options:

Tables, secure views, and secure UDFs can be shared

Shares can be shared

Data consumers can clone a new table from a share

Access to a share cannot be revoked once granted

Question 61

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Options:

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

Question 62

Which statement is true about running tasks in Snowflake?

Options:

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

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

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

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

Question 63

Which of the following significantly improves the performance of selective point lookup queries on a table?

Options:

Clustering

Materialized Views

Zero-copy Cloning

Search Optimization Service

Question 64

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

Question 65

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options:

INSERT

PUT

GET

COPY

Question 66

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

Options:

True

False

Question 67

How are serverless features billed?

Options:

Per second multiplied by an automatic sizing for the job

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Question 68

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Options:

Snowflake leverages a Role-Based Access Control (RBAC) model.

Snowflake requires a user to configure an IAM user to connect to the database.

All data in Snowflake is encrypted.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

All data in Snowflake is compressed.

Question 69

The is the minimum Fail-safe retention time period for transient tables?

Options:

1 day

7 days

12 hours

0 days

Question 70

What happens to historical data when the retention period for an object ends?

Options:

The data is cloned into a historical object.

The data moves to Fail-safe

Time Travel on the historical data is dropped.

The object containing the historical data is dropped.

Question 71

Which command can be used to load data files into a Snowflake stage?

Options:

JOIN

COPY INTO

PUT

GET

Question 72

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

Options:

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

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

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

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

Question 73

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

Options:

The Pipe load history is reset to empty.

The REFRESH command is executed.

The stage will be purged.

The destination table is truncated.

Question 74

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

Options:

Business Critical Edition

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

Question 75

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Options:

Increase the warehouse size from Medium to 2XL.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Question 76

How long is the Fail-safe period for temporary and transient tables?

Options:

There is no Fail-safe period for these tables.

1 day

7 days

31 days

90 days

Question 77

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Options:

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

The transient table version cannot be retrieved after 24 hours.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Question 78

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

Options:

UPDATE TABLE FROM STREAM

SELECT FROM STREAM

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

BEGIN COMMIT

Question 79

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Options:

4 minutes

10 minutes

14 minutes

24 minutes

Question 80

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Options:

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Question 81

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Options:

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Question 82

Where can a user find and review the failed logins of a specific user for the past 30 days?

Options:

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

Question 83

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

Options:

Database replication and failover

Automated index management

Customer managed keys (Tri-secret secure)

Extended time travel

Native support for geospatial data

Question 84

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

Options:

Create a zero-copy clone of the worksheet and grant permissions to teammates

Create a private Data Exchange so that any teammate can use the worksheet

Share the worksheet with teammates within Snowsight

Create a database and grant all permissions to teammates

Question 85

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

Options:

Row access policies

Data masking policies

Data encryption

Role based access control

Question 86

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

parse_json()

json_extract_path_text()

object_construct()

flatten

Question 87

By default, which Snowflake role is required to create a share?

Options:

ORGADMIN

SECURITYADMIN

SHAREADMIN

ACCOUNTADMIN

Question 88

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

Options:

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

Question 89

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Options:

Row level access policies

Data masking policies

Data encryption

Time Travel

External tokenization

Question 90

Which of the following is a data tokenization integration partner?

Options:

Protegrity

Tableau

DBeaver

SAP

Question 91

What type of query benefits the MOST from search optimization?

Options:

A query that uses only disjunction (i.e., OR) predicates

A query that includes analytical expressions

A query that uses equality predicates or predicates that use IN

A query that filters on semi-structured data types

Question 92

What is the following SQL command used for?

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

Options:

To validate external table files in table t1 across all sessions

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

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

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

Question 93

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Options:

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

Question 94

Which Snowflake architectural layer is responsible for a query execution plan?

Options:

Compute

Data storage

Cloud services

Cloud provider

Question 95

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Options:

Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.

Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.

Question 96

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Options:

SHOW GRANTS OF ROLE MY_ROLE

SHOW GRANTS TO ROLE MY_ROLE

SHOW GRANTS FOR ROLE MY_ROLE

SHOW GRANTS ON ROLE MY_ROLE

Question 97

How is unstructured data retrieved from data storage?

Options:

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

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.

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.

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 98

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

Options:

It removes null values from all columns in the data.

It converts null values to empty strings during loading.

It skips rows with null values during the loading process.

It removes object or array elements containing null values.

Question 99

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Options:

Bytes scanned

Partitions scanned

Bytes spilled to local storage

Bytes spilled to remote storage

Percentage scanned from cache

Question 100

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:

RETURN_-1_R0WS

RETURN_n_ROWS

RETURN_ERRORS

RETURN ALL ERRORS

Question 101

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

Options:

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

Warehouses can be started and stopped at any time.

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

Warehouses are billed on a per-minute usage basis.

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

Question 102

What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

Options:

The objects are dropped.

The objects enter the Fail-safe period.

The objects enter the Time Travel period.

The objects are immediately moved to the provider account.

Question 103

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

Options:

1 hour

2 hours

4 hours

8 hours

Question 104

Which commands can only be executed using SnowSQL? (Select TWO).

Options:

COPY INTO

GET

LIST

PUT

REMOVE

Question 105

How can a dropped internal stage be restored?

Options:

Enable Time Travel.

Clone the dropped stage.

Execute the UNDROP command.

Recreate the dropped stage.

Question 106

Which object can be used with Secure Data Sharing?

Options:

View

Materialized view

External table

User-Defined Function (UDF)

Question 107

What is the relationship between a Query Profile and a virtual warehouse?

Options:

A Query Profile can help users right-size virtual warehouses.

A Query Profile defines the hardware specifications of the virtual warehouse.

A Query Profile can help determine the number of virtual warehouses available.

A Query Profile automatically scales the virtual warehouse based on the query complexity.

Question 108

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

Options:

Automatic clustering

Materialized views

Query acceleration service

Search optimization service

Question 109

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

Options:

When creating a table

When loading data into a table

When unloading data from a table

When executing a show command

When executing a list command

Question 110

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

Options:

ACCESS_HISTORY

DATA_TRANSFER_HISTORY

WAREHOUSE_METERING_HISTORY

MONETIZED_USAGE_DAILY

LISTING TELEMETRY DAILY

Question 111

What step can reduce data spilling in Snowflake?

Options:

Using a larger virtual warehouse

Increasing the virtual warehouse maximum timeout limit

Increasing the amount of remote storage for the virtual warehouse

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

Question 112

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

Options:

Data:employee.name

DATA:employee.name

data:Employee.name

data:employee.name

Question 113

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

Options:

SHOW

MERGE

INSERT

DELETE

DESCRIBE

Question 114

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

Options:

The account type

The storage file format

The cloud region used by the account

The type of data being stored

The cloud platform being used

Question 115

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

Options:

MONITOR

OPERATE

OWNERSHIP

ALL

Question 116

What does a masking policy consist of in Snowflake?

Options:

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

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

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

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

Question 117

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Options:

Access history

Data classification

Dynamic Data Masking

Object tagging

Question 118

What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

Options:

Views

Materialized views

Tables

External tables

Future grants

Question 119

Who can grant object privileges in a regular schema?

Options:

Object owner

Schema owner

Database owner

SYSADMIN

Question 120

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

Options:

Temporary tables

Permanent tables

Transient tables

External tables

User-Defined Table Functions (UDTFs)

Question 121

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

Options:

GRANT

SELECT

MODIFY

OWNERSHIP

CREATE USER

Question 122

What does the LATERAL modifier for the FLATTEN function do?

Options:

Casts the values of the flattened data

Extracts the path of the flattened data

Joins information outside the object with the flattened data

Retrieves a single instance of a repeating element in the flattened data

Question 123

What type of query will benefit from the query acceleration service?

Options:

Queries without filters or aggregation

Queries with large scans and selective filters

Queries where the GROUP BY has high cardinality

Queries of tables that have search optimization service enabled

Question 124

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

Options:

File URL

Staged URL

Scoped URL

Pre-signed URL

Question 125

Which Snowflake view is used to support compliance auditing?

Options:

ACCESS_HISTORY

COPY_HISTORY

QUERY_HISTORY

ROW ACCESS POLICIES

Question 126

What is the purpose of the Snowflake SPLIT TO_TABLE function?

Options:

To count the number of characters in a string

To split a string into an array of sub-strings

To split a string and flatten the results into rows

To split a string and flatten the results into columns

Question 127

What is the purpose of a Query Profile?

Options:

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

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

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

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

Question 128

What does a Notify & Suspend action for a resource monitor do?

Options:

Send an alert notification to all account users who have notifications enabled.

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

Question 129

When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

Options:

The database owner

The object owner

The schema owner

The Snowflake user's role

Question 130

How should clustering be used to optimize the performance of queries that run on a very large table?

Options:

Manually re-cluster the table regularly.

Choose one high cardinality column as the clustering key.

Use the column that is most-frequently used in query select clauses as the clustering key.

Assess the average table depth to identify how clustering is impacting the query.

Question 131

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:

CREATE TABLE LIKE TABLE_A;

CREATE VIEW AS SELECT * FROM TABLE_A;

CREATE TABLE AS SELECT * FROM TABLE_A;

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

Question 132

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

Options:

DATABASE_STORAGE_USAGE_HISTORY

TABLE_STORAGE_METRICS

STORAGE_DAILY_HISTORY

STAGE STORAGE USAGE HISTORY

Question 133

How can a Snowflake user traverse semi-structured data?

Options:

Insert a colon (:) between the VARIANT column name and any first-level element.

Insert a colon (:) between the VARIANT column name and any second-level element. C. Insert a double colon (: :) between the VARIANT column name and any first-level element.

Insert a double colon (: :) between the VARIANT column name and any second-level element.

Question 134

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Options:

USERADMIN

ORGADMIN

SYSADMIN

SECURITYADMIN

Question 135

Which Snowflake object does not consume any storage costs?

Options:

Secure view

Materialized view

Temporary table

Transient table

Question 136

Which Snowflake function will parse a JSON-null into a SQL-null?

Options:

TO_CHAR

TO_VARIANT

TO_VARCHAR

STRIP NULL VALUE

Question 137

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

Options:

Column compression

Data clustering

Micro-partitioning

Metadata management

Question 138

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

Options:

Access control

Fail-safe

Network policies

Time Travel

Question 139

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

How can this be achieved?

Options:

Flatten the data and store it in structured data types in a flattened table. Query the table.

Store the data in a table with a variant data type. Query the table.

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

Store the data in an external stage and create views on top of it. Query the views.

Question 140

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:

FLATTEN

GET_PATH

CHECK_JSON

PARSE JSON

Question 141

What does SnowCD help Snowflake users to do?

Options:

Copy data into files.

Manage different databases and schemas.

Troubleshoot network connections to Snowflake.

Write SELECT queries to retrieve data from external tables.

Question 142

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

Options:

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

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

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

All explicit child object retention periods will remain unchanged.

Question 143

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?

Options:

DATA_RETENTION_TIME_IN_DAYS

MAX_DATA_EXTENSION_TIME_IN_DAYS

MIN_DATA_RETENTION_TIME_IN_DAYS

MAX CONCURRENCY LEVEL

Question 144

Which Snowflake command can be used to unload the result of a query to a single file?

Options:

Use COPY INTO followed by a GET command to download the file.

Use COPY INTO followed by a put command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

Question 145

What is a best practice after creating a custom role?

Options:

Create the custom role using the SYSADMIN role.

Assign the custom role to the SYSADMIN role

Assign the custom role to the PUBLIC role

Add__CUSTOM to all custom role names

Question 146

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Options:

Compute layer

Storage layer

Cloud infrastructure layer

Cloud services layer

Question 147

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

Options:

Variant

Object

Geometry

Geography

Question 148

What is a key feature of Snowflake architecture?

Options:

Zero-copy cloning creates a mirror copy of a database that updates with the original

Software updates are automatically applied on a quarterly basis

Snowflake eliminates resource contention with its virtual warehouse implementation

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Question 149

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

Options:

SCIM

Federated authentication

TLS 1.2

Key-pair authentication

OAuth

OCSP authentication

Question 150

Which of the following objects can be shared through secure data sharing?

Options:

Masking policy

Stored procedure

Task

External table

Question 151

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

Options:

CREATE SHARE

ALTER WAREHOUSE

DROP ROLE

SHOW SCHEMAS

DESCRBE TABLE

Question 152

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

Question 153

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Options:

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Question 154

Which statement about billing applies to Snowflake credits?

Options:

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

Question 155

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Options:

The ability to scale up warehouses

The use of warehouse auto scaling

The ability to resize warehouses

Use of multi-clustered warehouses

The use of warehouse indexing

Question 156

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:

list @mytable;

list @%raytable;

list @ %m.ystage;

list @mystage;

Question 157

Will data cached in a warehouse be lost when the warehouse is resized?

Options:

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

Question 158

The fail-safe retention period is how many days?

Options:

1 day

7 days

45 days

90 days

Question 159

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options:

True

False

Question 160

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Options:

Okta Verify

Duo Mobile

Microsoft Authenticator

Google Authenticator

Question 161

True or False: A Virtual Warehouse can be resized while suspended.

Options:

True

False

Question 162

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Options:

The primary cluster in the virtual warehouse

The entire virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

Question 163

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:

list @file__stage

show @file__stage

view @file__stage

verify @file__stage

Question 164

When is the result set cache no longer available? (Select TWO)

Options:

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

Question 165

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Options:

Informatica

Power Bl

Adobe

Data Robot

Question 166

What is the default character set used when loading CSV files into Snowflake?

Options:

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

Question 167

Which of the following can be executed/called with Snowpipe?

Options:

A User Defined Function (UDF)

A stored procedure

A single copy_into statement

A single insert__into statement

statement within a pipe object to load data from files as soon as they are available in a stage. Snowpipe does not execute UDFs, stored procedures, or insert statements. References: Snowpipe | Snowflake Documentation

Question 168

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

Options:

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

Question 169

What is the default File Format used in the COPY command if one is not specified?

Options:

CSV

JSON

Parquet

XML

Question 170

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Options:

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

Question 171

How would you determine the size of the virtual warehouse used for a task?

Options:

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Querying(select)the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Question 172

What happens when an external or an internal stage is dropped? (Select TWO).

Options:

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an external stage, both the stage and the files within the stage are removed

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Question 173

Which Snowflake technique can be used to improve the performance of a query?

Options:

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

Question 174

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Options:

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

Question 175

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

Options:

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

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

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

Question 176

How long is Snowpipe data load history retained?

Options:

As configured in the create pipe settings

Until the pipe is dropped

64 days

14 days

Question 177

Which of the following are benefits of micro-partitioning? (Select TWO)

Options:

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

Question 178

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Options:

True

False

Question 179

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

Time Travel - 1 day. Fail-safe - 1 day

Time Travel - 0 days. Fail-safe - 1 day

Time Travel - 1 day. Fail-safe - 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

Question 180

How often are encryption keys automatically rotated by Snowflake?

Options:

30 Days

60 Days

90 Days

365 Days

Question 181

What Snowflake role must be granted for a user to create and manage accounts?

Options:

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

Question 182

Which command can be used to stage local files from which Snowflake interface?

Options:

SnowSQL

Snowflake classic web interface (Ul)

Snowsight

.NET driver

Question 183

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Options:

Via the Snowflake Web Interface (Ul)

Via thedata_share=trueparameter

Via SQL commands

Via Virtual Warehouses

Question 184

In which use cases does Snowflake apply egress charges?

Options:

Data sharing within a specific region

Query result retrieval

Database replication

Loading data into Snowflake

Question 185

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Options:

Compute resources

Query execution

Authentication

Data storage

Metadata

Question 186

What features does Snowflake Time Travel enable?

Options:

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

Question 187

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Options:

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

Question 188

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

Options:

An FTP server with TLS encryption

An HTTPS server with WebDAV

A Google Cloud storage bucket

A Windows server file share on Azure

Question 189

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

Options:

Pipe

External stage

Task

Stream

Question 190

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Options:

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Question 191

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Options:

Standard

Premium

Enterprise

Business Critical

Question 192

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

Options:

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;

Question 193

When unloading data to an external stage, what is the MAXIMUM file size supported?

Options:

1 GB

5 GB

10 GB

16 GB

Question 194

How many network policies can be assigned to an account or specific user at a time?

Options:

One

Two

Three

Unlimited

Question 195

What happens when a database is cloned?

Options:

It does not retain any privileges granted on the source object.

It replicates all granted privileges on the corresponding source objects.

It replicates all granted privileges on the corresponding child objects.

It replicates all granted privileges on the corresponding child schema objects.

Question 196

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Options:

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user's access to expire within a specified timeframe.

Question 197

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

Options:

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

Question 198

What role is required to use Partner Connect?

Options:

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

Question 199

What are benefits of using Snowpark with Snowflake? (Select TWO).

Options:

Snowpark uses a Spark engine to generate optimized SQL query plans.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

Snowpark does not require that a separate cluster be running outside of Snowflake.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Question 200

What is the MAXIMUM size limit for a record of a VARIANT data type?

Options:

8MB

16MB

32MB

128MB

Question 201

By definition, a secure view is exposed only to users with what privilege?

Options:

IMPORT SHARE

OWNERSHIP

REFERENCES

USAGE

Question 202

Which data type can store more than one type of data structure?

Options:

JSON

BINARY

VARCHAR

VARIANT

Question 203

How can a Snowflake user access a JSON object, given the following table? (Select TWO).

Options:

src:salesperson.name

src:sa1esPerson. name

src:salesperson.Name

SRC:salesperson.name

SRC:salesperson.Name

Question 204

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

Options:

STRIP_NULL_VALUES

SKIP_BYTE_ORDER_MARK

REPLACE_INVALID_CHARACTERS

VALIDATION_MODE

Question 205

Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

Options:

Cross join

Inner join

Natural join

Outer join

Question 206

How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Options:

Use Snowpipe.

Use the INSERT command.

Use an external table.

Use the COPY command.

Question 207

Which role has the ability to create and manage users and roles?

Options:

ORGADMIN

USERADMIN

SYSADMIN

SECURITYADMIN

Question 208

Which SQL command can be used to see the CREATE definition of a masking policy?

Options:

SHOW MASKING POLICIES

DESCRIBE MASKING POLICY

GET_DDL

LIST MASKING POLICIES

Question 209

Snowflake's hierarchical key mode includes which keys? (Select TWO).

Options:

Account master keys

Database master keys

File keys

Secure view keys

Schema master keys

Question 210

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

Options:

TSV

JSON

PDF

Avro

Parquet

JPEG

Question 211

Which pages are included in the Activity area of Snowsight? (Select TWO).

Options:

Contacts

Sharing settings

Copy History

Query History

Automatic Clustering History

Question 212

Which task privilege does a Snowflake role need in order to suspend or resume a task?

Options:

USAGE

OPERATE

MONITOR

OWNERSHIP

Question 213

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Options:

CHECK_OPTION

IS_SECURE

IS_UPDATEABLE

TABLE_NAME

Question 214

How would a user execute a series of SQL statements using a task?

Options:

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1WHERE ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the taskdefinition CREATE TASK mytask .... AScall stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

Question 215

Which kind of Snowflake table stores file-level metadata for each file in a stage?

Options:

ARRAY

OBJECT

VARCHAR

VARIANT

Question 217

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Options:

Bytes spilled to local cache.

Bytes spilled to local storage.

Bytes spilled to remote cache.

Bytes spilled to remote storage.

Bytes spilled to remote metastore.

Question 218

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

Options:

Table definition

Stage definition

Session level

COPY INTO TABLE statement

Question 219

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Options:

The clone always stays in sync with the original table.

The clone has better query performance.

The clone is created almost instantly.

The clone will have time travel history from the original table.

The clone saves space by not duplicating storage.

Question 220

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Options:

Caching query results

Running EXPLAIN and SHOW commands

Cloning a database

Running a custom query

Running COPY commands

Question 221

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Options:

The reader account will automatically use the Standard edition of Snowflake.

The reader account compute will be billed to the provider account.

The reader account can clone data the provider has shared, but cannot re-share it.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Question 222

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Options:

Use auto-ingest Snowpipes to load large files in a serverless model.

Produce the largest files possible, reducing the overall number of files to process.

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Question 223

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Options:

256

Question 224

How long does Snowflake retain information in the ACCESS HISTORY view?

Options:

7 days

14 days

28 days

365 days

Question 225

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

Options:

CHECK_JSON

TO_JSON

FLATTEN

PARSE_JSON

Question 226

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

Options:

NUMBER

OBJECT

STRING

VARCHAR

VARIANT

Question 227

How can a user improve the performance of a single large complex query in Snowflake?

Options:

Scale up the virtual warehouse.

Scale out the virtual warehouse.

Enable standard warehouse scaling.

Enable economy warehouse scaling.

Question 228

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

Options:

The number of queries executed

The number of active users assigned to the warehouse

The size of the virtual warehouse

The length of time the warehouse is running

The duration of the queries that are executed

Question 229

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Options:

Indefinitely

Until the result_cache expires

Until the retention_time is met

Until the expiration time is exceeded

Question 230

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

Options:

1 minute

2 minutes

6 minutes

8 minutes

Question 231

Which file format will keep floating-point numbers from being truncated when data is unloaded?

Options:

CSV

JSON

ORC

Parquet

Question 232

Which of the following describes the Snowflake Cloud Services layer?

Options:

Coordinates activities in the Snowflake account

Executes queries submitted by the Snowflake account users

Manages quotas on the Snowflake account storage

Manages the virtual warehouse cache to speed up queries

Question 233

What is the recommended way to change the existing file format type in my format from CSV to JSON?

Options:

ALTER FILE FORMAT my_format SET TYPE=JSON;

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

REPLACE FILE FORMAT my format TYPE-JSON;

Question 234

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Options:

Schemas

Roles

Secure Views

Stored Procedures

Tables

Secure User-Defined Functions (UDFs)

Question 235

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Options:

Roles

Databases

Warehouses

Users

Accounts

Question 236

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

Options:

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

A Data Exchange allows groups of accounts to share data privately among the accounts.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

Question 237

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Options:

Query execution

Data loading

Time Travel data

Security

Authentication and access control

Question 238

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Options:

Resource monitor

Account_usage. query_history

Information_schema.warehouse_load_history

Information schema.warehouse metering history

Question 239

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

Options:

GeoJSON

Array

XML

Object

BLOB

Question 240

Which Snowflake URL type is used by directory tables?

Options:

File

Pre-signed

Scoped

Virtual-hosted style

Question 241

A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.

What should they do?

Options:

Use the SECURITYADMIN role.

Use the SYSADMIN role.

Use the USERADMIN role.

Contact Snowflake Support.

Question 242

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

Options:

Grant the additional privileges to a custom role.

Grant the additional privileges to the ACCOUNTADMIN role.

Grant the additional privileges to the SYSADMIN role.

Grant the additional privileges to the ORGADMIN role.

Question 243

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

Options:

BINARY_FORMAT

ESCAPE_UNENCLOSED_FIELD

FIELD_OPTIONALLY_ENCLOSED_BY

SKIP BYTE ORDER MARK

Question 244

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

Options:

0 days

1 day

7 days

14 days

Question 245

What happens when a network policy includes values that appear in both the allowed and blocked IP address list?

Options:

Those IP addresses are allowed access to the Snowflake account as Snowflake applies the allowed IP address list first.

Those IP addresses are denied access lei the Snowflake account as Snowflake applies the blocked IP address list first.

Snowflake issues an alert message and adds the duplicate IP address values lo both 'he allowed and blocked IP address lists.

Snowflake issues an error message and adds the duplicate IP address values to both the allowed and blocked IP address list

Question 246

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

Options:

60 minutes

24 hours

14 days

30 days

Question 247

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

Options:

View

Secure view

Materialized view

External table

Question 248

Which command can be used to list all the file formats for which a user has access privileges?

Options:

LIST

ALTER FILE FORMAT

DESCRIBE FILE FORMAT

SHOW FILE FORMATS

Question 249

What is the Fail-safe retention period for transient and temporary tables?

Options:

0 days

1 day

7 days

90 days

Question 250

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.

How will those object names be resolved during execution?

Options:

Snowflake will resolve them according to the SEARCH_PATH parameter.

Snowflake will only check the schema the UDF belongs to.

Snowflake will first check the current schema, and then the schema the previous query used

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Question 251

Which Snowflow object does not consume and storage costs?

Options:

Secure view

Materialized view

Temporary table

Transient table

Question 252

What type of function returns one value for each Invocation?

Options:

Aggregate

Scalar

Table

Window

Question 253

Which SQL command can be used to verify the privileges that are granted to a role?

Options:

SHOW GRANTS ON ROLE

SHOW ROLES

SHOW GRANTS TO ROLE

SHOW GRANTS FOR ROLE

Question 254

Which privilege is required to use the search optimization service in Snowflake?

Options:

GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE

GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE

GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE

Question 255

What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

Options:

100

Question 256

What activities can a user with the ORGADMIN role perform? (Select TWO).

Options:

Create an account for an organization.

Edit the account data for an organization.

Delete the account data for an organization.

View usage information for all accounts in an organization.

Select all the data in tables for all accounts in an organization.

Question 257

Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

Options:

Data classification

Query acceleration service

Search optimization service

Tagging

Question 258

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Options:

Clone the data from the production account to the non-production account.

Create a data share from the production account to the non-production account.

Create a subscription in the production account and have it publish to the non-production account.

Create a reader account using the production account and link the reader account to the non-production account.

Question 259

Which function should be used to insert JSON format string data inot a VARIANT field?

Options:

FLATTEN

CHECK_JSON

PARSE_JSON

TO_VARIANT

Question 260

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

Options:

There are multiple SOL UDFs with the same names and the same number of arguments.

There are multiple SQL UDFs with the same names and the same number of argument types.

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Question 261

What is the MINIMUM permission needed to access a file URL from an external stage?

Options:

MODIFY

READ

SELECT

USAGE

Question 262

How does Snowflake reorganize data when it is loaded? (Select TWO).

Options:

Binary format

Columnar format

Compressed format

Raw format

Zipped format

Question 263

What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

Options:

The provisioning of new compute resources for the warehouse will begin immediately.

The warehouse will remain suspended but new resources will be added to the query acceleration service.

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

Question 264

For Directory tables, what stage allows for automatic refreshing of metadata?

Options:

User stage

Table stage

Named internal stage

Named external stage

Question 265

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

Options:

0 days

1 day

7 days

14 days

Question 266

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

Options:

GROUP BY

LIMIT

ORDER BY

PARTITION BY

UNION ALL

Question 267

Which function is used to convert rows in a relational table to a single VARIANT column?

Options:

ARRAY_AGG

OBJECT_AGG

ARRAY_CONSTRUCT

OBJECT_CONSTRUCT

Question 268

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

Options:

120

121

Question 269

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

Options:

Avro

CSV

JSON

Parquet

Question 270

Which statement accurately describes Snowflake's architecture?

Options:

It uses a local data repository for all compute nodes in the platform.

It is a blend of shared-disk and shared-everything database architectures.

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

It reorganizes loaded data into internal optimized, compressed, and row-based format.

Question 271

The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

Options:

Partitions scanned

Partitions total

Bytes scanned

Bytes read from result

Bytes written

Question 272

Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake (VPS)

Question 273

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

Options:

1 minutes

5 minutes

10 minutes

15 minutes

Question 274

How can a user get the MOST detailed information about individual table storage details in Snowflake?

Options:

SHOW TABLES command

SHOW EXTERNAL TABLES command

TABLES view

TABLE STORAGE METRICS view

Question 275

Which URL provides access to files in Snowflake without authorization?

Options:

File URL

Scoped URL

Pre-signed URL

Scoped file URL

Question 276

Which common query problems are identified by the Query Profile? (Select TWO.)

Options:

Syntax error

Inefficient pruning

Ambiguous column names

Queries too large to fit in memory

Object does not exist or not authorized

Question 277

How does Snowflake describe its unique architecture?

Options:

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

Question 278

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

Options:

(12,2)

(10,4)

(14,8)

(15,9)

Question 279

While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

Options:

BINARY

GEOGRAPHY

GEOMETRY

OBJECT

VARIANT

Question 280

What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

Options:

Hierarchical key model

Client-side encryption

Tri-secret secure encryption

Key pair authentication

Question 281

Which data types optimally store semi-structured data? (Select TWO).

Options:

ARRAY

CHARACTER

STRING

VARCHAR

VARIANT

Question 282

What are characteristics of reader accounts in Snowflake? (Select TWO).

Options:

Reader account users cannot add new data to the account.

Reader account users can share data to other reader accounts.

A single reader account can consume data from multiple provider accounts.

Data consumers are responsible for reader account setup and data usage costs.

Reader accounts enable data consumers to access and query data shared by the provider.

Question 283

Which role has the ability to create a share from a shared database by default?

Options:

ACCOUNTADMIN

SECURITYADMIN

SYSADMIN

ORGADMIN

Question 284

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

Options:

1 hour

2 hours

4 hours

8 hours

Exam Detail

Vendor: Snowflake

Certification: SnowPro Core Certification

Exam Code: COF-C02

Exam Name: SnowPro Core Certification Exam

Last Update: Oct 29, 2025

COF-C02 Question Answers

Page: 1 / 71
Total 948 questions

Get COF-C02 Full Access Download COF-C02 PDF

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

Free and Premium Snowflake COF-C02 Dumps Questions Answers

SnowPro Core Certification Exam Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options: