Labour Day Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02 - SnowPro Core Certification Exam (COF-C02)

Snowflake COF-C02 SnowPro Core Certification Exam (COF-C02) Exam Practice Test

Demo: 181 questions
Total 605 questions
Get COF-C02 Full Access Download COF-C02 PDF

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

Question 1

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 2

What are the main differences between the account usage views and the information schema views? (Select TWO).

Options:

A.

No active warehouse to needed to query account usage views but one is needed to query information schema views.

B.

Account usage views do not contain data about tables but information schema views do.

C.

Account issue views contain dropped objects but information schema views do not.

D.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

E.

Information schema views are read-only but account usage views are not.

Question 3

Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

Options:

A.

TASK_HISTORY

B.

TASK_DEPENDENTS

C.

CURRENT_TASK_GRAPHS

D.

COMPLETE_TASK_GRAPHS

Question 4

How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).

Options:

A.

Shows how the accessed data was moved from the source lo the target objects

B.

Provides a unified picture of what data was accessed and when it was accessed

C.

Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime

D.

Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data

E.

Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

Question 5

Which function returns the URL of a stage using the stage name as the input?

Options:

A.

BUILD_STAGE_FILE_URL

B.

BUILD_SCOPED_FILE_URL

C.

GET_PRESIGNED_URL

D.

GET STAGE LOCATION

Question 6

Authorization to execute CREATE statements comes only from which role?

Options:

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Question 7

Which Snowflake data governance feature can support auditing when a user query reads column data?

Options:

A.

Access History

B.

Data classification

C.

Column-level security

D.

Object dependencies

Question 8

What type of account can be used to share data with a consumer who does have a Snowflake account?

Options:

A.

Data provider

B.

Data consumer

C.

Reader

D.

Organization

Question 9

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 10

Which Snowflake database object can be shared with other accounts?

Options:

A.

Tasks

B.

Pipes

C.

Secure User-Defined Functions (UDFs)

D.

Stored Procedures

Question 11

When should a stored procedure be created with caller's rights?

Options:

A.

When the caller needs to be prevented from viewing the source code of the stored procedure

B.

When the caller needs to run a statement that could not execute outside of the stored procedure

C.

When the stored procedure needs to run with the privileges of the role that called the stored procedure

D.

When the stored procedure needs to operate on objects that the caller does not have privileges on

Question 12

The property mins_to_bypass_network_policy is set at which level?

Options:

A.

User

B.

Role

C.

Account

D.

Organization

Question 13

Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).

Options:

A.

Authorisation

B.

Access delegation

C.

Data pruning

D.

Data compression

E.

Query parsing and optimization

Question 14

Which statements reflect valid commands when using secondary roles? (Select TWO).

Options:

A.

Use SECONDARY ROLES RESUME

B.

USE SECONDARY ROLES SUSPEND

C.

USE SECONDARY RLES ALL

D.

USE SECONDARY ROLES ADD

E.

Use SECONDARY ROLES NONE

Question 15

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 16

Which roles can make grant decisions to objects within a managed access schema? (Select TWO)

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSTEMADMIN

D.

ORGADMIN

E.

USERADMIN

Question 17

Which Snowflake privilege is required on a pipe object to pause or resume pipes?

Options:

A.

OPERATE

B.

READ

C.

SELECT

D.

USAGE

Question 18

Which object type is granted permissions for reading a table?

Options:

A.

User

B.

Role

C.

Attribute

D.

Schema

Question 19

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 20

A stream can be created on which Snowflake objects to record data manipulation language(DML) changes? (Select TWO).

Options:

A.

Database

B.

Standard tables

C.

Standard tables

D.

Standard views

E.

Schemas

F.

Pipes

Question 21

Which key access control concept does Snowflake descibe as a defined level of access to an object?

Options:

A.

Grant

B.

Privilege

C.

Role

D.

Session

Question 22

What does the Activity area of Snowsight allow users to do? (Select TWO).

Options:

A.

Schedule automated data backups.

B.

Explore each step of an executed query.

C.

Monitor queries executed by users in an account.

D.

Create and manage user roles and permissions.

E.

Access Snowflake Marketplace to find and integrate datasets.

Question 23

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

Options:

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Question 24

What happens to the privileges granted to Snowflake system-defined roles?

Options:

A.

The privileges cannot be revoked.

B.

The privileges can be revoked by an ACCOUNTADMIN.

C.

The privileges can be revoked by an orgadmin.

D.

The privileges can be revoked by any user-defined role with appropriate privileges.

Question 25

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

Options:

A.

ACCESS_HISTORY

B.

LOAD_HOSTORY

C.

QUERY_HISTORY

D.

COPY_HISTORY

Question 26

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

Options:

A.

Avro

B.

JSON

C.

TSV

D.

Parquet

Question 27

Which views are included in the data_sharing_usage schema? (Select TWO).

Options:

A.

ACCESS_HISTORY

B.

DATA_TRANSFER_HISTORY

C.

WAREHOUSE_METERING_HISTORY

D.

MONETIZED_USAGE_DAILY

E.

LISTING TELEMETRY DAILY

Question 28

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

Options:

A.

Pruning

B.

Spilling

C.

Initialization

D.

Local Disk I/O

E.

Percentage of data read from cache

Question 29

What causes objects in a data share to become unavailable to a consumer account?

Options:

A.

The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

B.

The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

C.

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

D.

The consumer account acquires the data share through a private data exchange.

Question 30

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

Options:

A.

USAGE on the specific tables in the database.

B.

USAGE on the specific tables in the database.

C.

MODIFY on 1Mb specific tables in the database.

D.

USAGE on the database and the schema containing the tables to share

E.

OPEBATE on the database and the schema containing the tables to share.

Question 31

What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

Options:

A.

1 Kilobyte (KB)

B.

1 Megabyte (MB)

C.

1 Gigabyte (GB)

D.

1 Terabyte (TB)

Question 32

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

Options:

A.

SHOW TABLES command

B.

SHOW EXTERNAL TABLES command

C.

TABLES view

D.

TABLE STORAGE METRICS view

Question 33

Which Snowflake layer is associated with virtual warehouses?

Options:

A.

Cloud services

B.

Query processing

C.

Elastic memory

D.

Database storage

Question 34

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

Options:

A.

Last_QUERY_ID

B.

CURRENT_STATEMENT

C.

UUID_STRING

D.

JOB_ID

Question 35

What does the worksheet and database explorer feature in Snowsight allow users to do?

Options:

A.

Add or remove users from a worksheet.

B.

Move a worksheet to a folder or a dashboard.

C.

Combine multiple worksheets into a single worksheet.

D.

Tag frequently accessed worksheets for ease of access.

Question 36

What does the TableScan operator represent in the Query Profile?

Options:

A.

The access to a single table

B.

The access to data stored in stage objects

C.

The list of values provided with the VALUES clause

D.

The records generated using the TABLE (GENERATOR (...)) construct

Question 37

How are network policies defined in Snowflake?

Options:

A.

They are a set of rules that define the network routes within Snowflake.

B.

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

C.

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

D.

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect

to Snowflake.

Question 38

What is the only supported character set for loading and unloading data from all supported file formats?

Options:

A.

UTF-8

B.

UTF-16

C.

ISO-8859-1

D.

WINDOWS-1253

Question 39

Which function will provide the proxy information needed to protect Snowsight?

Options:

A.

SYSTEMADMIN_TAG

B.

SYSTEM$GET_PRIVATELINK

C.

SYSTEMSALLONTLIST

D.

SYSTEMAUTHORIZE

Question 40

Which URL provides access to files in Snowflake without authorization?

Options:

A.

File URL

B.

Scoped URL

C.

Pre-signed URL

D.

Scoped file URL

Question 41

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

Options:

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Question 42

What are the benefits of the replication feature in Snowflake? (Select TWO).

Options:

A.

Disaster recovery

B.

Time Travel

C.

Fail-safe

D.

Database failover and fallback

E.

Data security

Question 43

What information does the Query Profile provide?

Options:

A.

Graphical representation of the data model

B.

Statistics for each component of the processing plan

C.

Detailed Information about I he database schema

D.

Real-time monitoring of the database operations

Question 44

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

Options:

A.

1 minutes

B.

5 minutes

C.

10 minutes

D.

15 minutes

Question 45

What type of function returns one value for each Invocation?

Options:

A.

Aggregate

B.

Scalar

C.

Table

D.

Window

Question 46

Which activities are included in the Cloud Services layer? {Select TWO).

Options:

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Question 47

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

Options:

A.

Hierarchical key model

B.

Client-side encryption

C.

Tri-secret secure encryption

D.

Key pair authentication

Question 48

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

Options:

A.

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

B.

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

C.

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

D.

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Question 49

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

Options:

A.

Partitions scanned

B.

Partitions total

C.

Bytes scanned

D.

Bytes read from result

E.

Bytes written

Question 50

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 51

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

Options:

A.

Syntax error

B.

Inefficient pruning

C.

Ambiguous column names

D.

Queries too large to fit in memory

E.

Object does not exist or not authorized

Question 52

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

Options:

A.

Caching

B.

Cluster depth

C.

Query pruning

D.

Retrieval optimization

Question 53

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.

What will happen if User2 tries to access the query history?

Options:

A.

If User2 has the sysadmin role they will be able to see the results.

B.

If User2 has the securityadmin role they will be able to see the results.

C.

If User2 has the ACCOUNTADMIN role they will be able to see the results.

D.

User2 will be unable to view the result set of the query executed by User1.

Question 54

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

Options:

A.

Avro

B.

CSV

C.

JSON

D.

Parquet

Question 55

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

Options:

A.

ARRAY

B.

OBJECT

C.

TEXT

D.

VARIANT

Question 56

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

Options:

A.

Reader account users cannot add new data to the account.

B.

Reader account users can share data to other reader accounts.

C.

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

D.

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

E.

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

Question 57

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

Options:

A.

MODIFY

B.

READ

C.

SELECT

D.

USAGE

Question 58

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 59

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

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Question 60

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

Options:

A.

LIST

B.

ALTER FILE FORMAT

C.

DESCRIBE FILE FORMAT

D.

SHOW FILE FORMATS

Question 61

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

Options:

A.

ARRAY

B.

CHARACTER

C.

STRING

D.

VARCHAR

E.

VARIANT

Question 62

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Question 63

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

Options:

A.

When creating a table

B.

When loading data into a table

C.

When unloading data from a table

D.

When executing a show command

E.

When executing a list command

Question 64

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 65

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 66

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

Options:

A.

Queries without filters or aggregation

B.

Queries with large scans and selective filters

C.

Queries where the GROUP BY has high cardinality

D.

Queries of tables that have search optimization service enabled

Question 67

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Question 68

Which type of loop requires a BREAK statement to stop executing?

Options:

A.

FOR

B.

LOOP

C.

REPEAT

D.

WHILE

Question 69

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

Question 70

What is a directory table in Snowflake?

Options:

A.

A separate database object that is used to store file-level metadata

B.

An object layered on a stage that is used to store file-level metadata

C.

A database object with grantable privileges for unstructured data tasks

D.

A Snowflake table specifically designed for storing unstructured files

Question 71

Which data types can be used in Snowflake to store semi-structured data? (Select TWO)

Options:

A.

ARRAY

B.

BLOB

C.

CLOB

D.

JSON

E.

VARIANT

Question 72

Which function unloads data from a relational table to JSON?

Options:

A.

TO_OBJECT

B.

TO_JSON

C.

TO_VARIANT

D.

OBJECT CONSTRUCT

Question 73

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Options:

A.

CREATE STAGE

B.

COPY INTO

C.

COPY INTO

D.

CREATE PIPE

Question 74

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

Options:

A.

A user with an USERADMIN or higher role

B.

A user with a SECURITYADMIN or higher role

C.

A role that has been granted the ATTACH POLICY privilege

D.

A role that has the NETWORK_POLlCY account parameter set

E.

A role that has the ownership of the network policy

Question 75

Which object can be used with Secure Data Sharing?

Options:

A.

View

B.

Materialized view

C.

External table

D.

User-Defined Function (UDF)

Question 76

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 77

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 78

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

Options:

A.

TO_CHAR

B.

TO_VARIANT

C.

TO_VARCHAR

D.

STRIP NULL VALUE

Question 79

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

Options:

A.

Tags

B.

Comments

C.

Internal tokenization

D.

Row access policies

Question 80

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

Options:

A.

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

B.

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

C.

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.

D.

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 81

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Question 82

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 83

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 84

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 85

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 86

A Snowflake account has activated federated authentication.

What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

Options:

A.

The user will be unable to enter a password.

B.

The user will encounter an error, and will not be able to log in.

C.

The user will be able to log into Snowflake successfully.

D.

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Question 87

Which operation can be performed on Snowflake external tables?

Options:

A.

INSERT

B.

JOIN

C.

RENAME

D.

ALTER

Question 88

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 89

What does the LATERAL modifier for the FLATTEN function do?

Options:

A.

Casts the values of the flattened data

B.

Extracts the path of the flattened data

C.

Joins information outside the object with the flattened data

D.

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

Question 90

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 91

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 92

How can a Snowflake user traverse semi-structured data?

Options:

A.

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

B.

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.

C.

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

Question 93

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 94

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Question 95

Which of the following accurately describes shares?

Options:

A.

Tables, secure views, and secure UDFs can be shared

B.

Shares can be shared

C.

Data consumers can clone a new table from a share

D.

Access to a share cannot be revoked once granted

Question 96

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 97

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Options:

A.

VIEWS_HISTORY

B.

OBJECT_HISTORY

C.

ACCESS_HISTORY

D.

LOGIN_HISTORY

Question 98

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

Options:

A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

Question 99

Which of the following describes the Snowflake Cloud Services layer?

Options:

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Question 100

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

Options:

A.

ORGADMIN

B.

SECURITYADMIN

C.

SHAREADMIN

D.

ACCOUNTADMIN

Question 101

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Options:

A.

Reader

B.

Consumer

C.

Vendor

D.

Standard

E.

Personalized

Question 102

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:

A.

Increase the warehouse size from Medium to 2XL.

B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.

Configure the warehouse to a multi-cluster warehouse.

D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Question 103

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Options:

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Question 104

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

Options:

A.

parse_json()

B.

json_extract_path_text()

C.

object_construct()

D.

flatten

Question 105

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options:

A.

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B.

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C.

The ACCOUNTADMIN role must be granted to only one user.

D.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Question 106

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 107

Which of the following objects are contained within a schema? (Choose two.)

Options:

A.

Role

B.

Stream

C.

Warehouse

D.

External table

E.

User

F.

Share

Question 108

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:

A.

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

B.

The transient table version cannot be retrieved after 24 hours.

C.

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

D.

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

Question 109

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

Options:

A.

SHOW GRANTS OF ROLE MY_ROLE

B.

SHOW GRANTS TO ROLE MY_ROLE

C.

SHOW GRANTS FOR ROLE MY_ROLE

D.

SHOW GRANTS ON ROLE MY_ROLE

Question 110

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

How can this worksheet be shared?

Options:

A.

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

B.

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

C.

Share the worksheet with teammates within Snowsight

D.

Create a database and grant all permissions to teammates

Question 111

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Options:

A.

Removing a column from the query SELECT list

B.

Stopping the virtual warehouse that the query is running against

C.

Clustering of the data used by the query

D.

Executing the RESULTS_SCAN() table function

E.

Changing a column that is not in the cached query

Question 112

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 113

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:

A.

select src:dealership from car_sales;

B.

select src.dealership from car_sales;

C.

select src:Dealership from car_sales;

D.

select dealership from car_sales;

Question 114

When should a multi-cluster warehouse be used in auto-scaling mode?

Options:

A.

When it is unknown how much compute power is needed

B.

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.

If the runtime of the executed query is very slow

D.

When a large number of concurrent queries are run on the same warehouse

Question 115

How are serverless features billed?

Options:

A.

Per second multiplied by an automatic sizing for the job

B.

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

C.

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

D.

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

Question 116

When loading data into Snowflake, how should the data be organized?

Options:

A.

Into single files with 100-250 MB of compressed data per file

B.

Into single files with 1-100 MB of compressed data per file

C.

Into files of maximum size of 1 GB of compressed data per file

D.

Into files of maximum size of 4 GB of compressed data per file

Question 117

Network policies can be set at which Snowflake levels? (Choose two.)

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Question 118

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Options:

A.

PURGE

B.

MODIFY

C.

REMOVE

D.

DELETE

Question 119

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

Options:

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Question 120

What are common issues found by using the Query Profile? (Choose two.)

Options:

A.

Identifying queries that will likely run very slowly before executing them

B.

Locating queries that consume a high amount of credits

C.

Identifying logical issues with the queries

D.

Identifying inefficient micro-partition pruning

E.

Data spilling to a local or remote disk

Question 121

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Options:

A.

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

B.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

C.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

D.

A user cannot specify a default warehouse when using the ODBC driver.

E.

The default virtual warehouse size can be changed at any time.

Question 122

What type of query benefits the MOST from search optimization?

Options:

A.

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

B.

A query that includes analytical expressions

C.

A query that uses equality predicates or predicates that use IN

D.

A query that filters on semi-structured data types

Question 123

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 124

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

Options:

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Question 125

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Options:

A.

Users

B.

Tables

C.

Databases

D.

Internal Stages

Question 126

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

Options:

A.

STATEMENT_TIMEOUT__IN__SECONDS

B.

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.

MAX_CONCURRENCY__LEVEL

D.

QUERY_TIMEOUT_IN_SECONDS

Question 127

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

Options:

A.

Clustering

B.

Indexing

C.

Fragmenting

D.

Using INDEX__HINTS

Question 128

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

Options:

A.

A User Defined Function (UDF)

B.

A stored procedure

C.

A single copy_into statement

D.

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 129

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

Options:

A.

Compute layer

B.

Storage layer

C.

Cloud infrastructure layer

D.

Cloud services layer

Question 130

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Question 131

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 132

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

Options:

A.

Bytes scanned

B.

Bytes sent over the network

C.

Number of partitions scanned

D.

Percentage scanned from cache

E.

External bytes scanned

Question 133

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

Options:

A.

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

B.

The replication will not be successful.

C.

The physical data is replicated

D.

Additional costs for storage are charged to a secondary account

E.

Metadata pointers to cloned tables are replicated

Question 134

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Options:

A.

Materialized views

B.

Sequences

C.

Procedures

D.

Tables

E.

Secure User Defined Functions (UDFs)

Question 135

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

Options:

A.

The primary cluster in the virtual warehouse

B.

The entire virtual warehouse

C.

The database in which the virtual warehouse resides

D.

The Queries currently being run on the virtual warehouse

Question 136

How long is Snowpipe data load history retained?

Options:

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Question 137

What is a responsibility of Snowflake's virtual warehouses?

Options:

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Management of the storage layer

Question 138

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

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Question 139

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

Options:

A.

Micro-partitions cannot overlap in their range of values

B.

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

C.

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

D.

Rows are automatically stored in sorted order within micro-partitions

E.

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

Question 140

Which of the following describes external functions in Snowflake?

Options:

A.

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

B.

They contain their own SQL code.

C.

They call code that is stored inside of Snowflake.

D.

They can return multiple rows for each row received

Question 141

True or False: Fail-safe can be disabled within a Snowflake account.

Options:

A.

True

B.

False

Question 142

Which statement about billing applies to Snowflake credits?

Options:

A.

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

B.

Credits are used to pay for cloud data storage usage

C.

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

D.

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

Question 143

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

Options:

A.

SCIM

B.

Federated authentication

C.

TLS 1.2

D.

Key-pair authentication

E.

OAuth

F.

OCSP authentication

Question 144

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

Options:

A.

Load files that are approximately 25 MB or smaller.

B.

Remove all dates and timestamps.

C.

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

D.

Avoid using embedded characters such as commas for numeric data types

E.

Remove semi-structured data types

Question 145

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Options:

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Question 146

Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Options:

A.

Execute a COPY command

B.

Updating data

C.

Snowpipe

D.

AUTOMATIC__CLUSTERING

E.

Scaling up a warehouse

Question 147

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 148

What is a limitation of a Materialized View?

Options:

A.

A Materialized View cannot support any aggregate functions

B.

A Materialized View can only reference up to two tables

C.

A Materialized View cannot be joined with other tables

D.

A Materialized View cannot be defined with a JOIN

Question 149

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

Options:

A.

UTF-8

B.

UTF-16

C.

ISO S859-1

D.

ANSI_X3.A

Question 150

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:

A.

Use multi-clustered warehousing to scale out warehouse capacity.

B.

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

C.

Stop and start the warehouse to clear the queued queries

D.

Migrate some queries to a new warehouse to reduce load

E.

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

Question 151

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

Options:

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Question 152

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Options:

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

Question 153

Which feature is only available in the Enterprise or higher editions of Snowflake?

Options:

A.

Column-level security

B.

SOC 2 type II certification

C.

Multi-factor Authentication (MFA)

D.

Object-level access control

Question 154

Which Snowflake partner specializes in data catalog solutions?

Options:

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Question 155

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

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Question 156

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Options:

A.

The shared objects are transferred.

B.

The shared objects are copied.

C.

The shared objects become accessible.

D.

The shared objects can be re-shared.

Question 157

Which command is used to unload files from an internal or external stage to a local file system?

Options:

A.

COPY INTO

B.

GET

C.

PUT

D.

TRANSFER

Question 158

What can a Snowflake user do in the Admin area of Snowsight?

Options:

A.

Analyze query performance.

B.

Write queries and execute them.

C.

Provide an overview of the listings in the Snowflake Marketplace.

D.

Connect to Snowflake partners to explore extended functionality.

Question 159

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

Options:

A.

Caching query results

B.

Running EXPLAIN and SHOW commands

C.

Cloning a database

D.

Running a custom query

E.

Running COPY commands

Question 160

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:

A.

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

B.

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

C.

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

D.

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

Question 161

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

Options:

A.

Schemas

B.

Roles

C.

Secure Views

D.

Stored Procedures

E.

Tables

F.

Secure User-Defined Functions (UDFs)

Question 162

Which objects together comprise a namespace in Snowflake? (Select TWO).

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

E.

Virtual warehouse

Question 163

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

Options:

A.

CHECK_JSON

B.

TO_JSON

C.

FLATTEN

D.

PARSE_JSON

Question 164

What action can a user take to address query concurrency issues?

Options:

A.

Enable the query acceleration service.

B.

Enable the search optimization service.

C.

Add additional clusters to the virtual warehouse

D.

Resize the virtual warehouse to a larger instance size.

Question 165

What internal stages are available in Snowflake? (Choose three.)

Options:

A.

Schema stage

B.

Named stage

C.

User stage

D.

Stream stage

E.

Table stage

F.

Database stage

Question 166

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

Options:

A.

GRANT ROLE MYROLE TO USER USER1;

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

B.

GRANT ROLE MYROLE TO USER USER1;

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

C.

GRANT ROLE MYROLE TO USER USER1;

GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

D.

GRANT ROLE MYROLE TO USER USER1;

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

Question 167

Which items are considered schema objects in Snowflake? (Select TWO).

Options:

A.

Pipe

B.

File format

C.

Resource monitor

D.

Storage integration

E.

Virtual warehouse

Question 168

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:

A.

Cross join

B.

Inner join

C.

Natural join

D.

Outer join

Question 169

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

Options:

A.

USAGE

B.

OPERATE

C.

MONITOR

D.

OWNERSHIP

Question 170

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Options:

A.

CREATE_SHARE on the account

B.

SHARE on databases and schemas

C.

SELECT on tables used by the secure view

D.

REFERENCE_USAGE on databases

Question 171

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

Options:

A.

The data from the permanent table.

B.

The data from the temporary table.

C.

An error stating that the view could not be compiled.

D.

An error stating that the referenced object could not be uniquely identified.

Question 172

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

Options:

A.

Contacts

B.

Sharing settings

C.

Copy History

D.

Query History

E.

Automatic Clustering History

Question 173

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

Options:

A.

ROW_NUMBER

B.

TABLE

C.

TABULAR

D.

VALUES

Question 174

What can a Snowflake user do with the information included in the details section of a Query Profile?

Options:

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

Determine if the query was on structured or semi-structured data.

Question 175

Which statement accurately describes a characteristic of a materialized view?

Options:

A.

A materialized view can query only a single table.

B.

Data accessed through materialized views can be stale.

C.

Materialized view refreshes need to be maintained by the user.

D.

Querying a materialized view is slower than executing a query against the base table of the view.

Question 176

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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 177

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

Options:

A.

Account master keys

B.

Database master keys

C.

File keys

D.

Secure view keys

E.

Schema master keys

Question 178

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

Options:

A.

A VARIANT column

B.

A column with very low cardinality

C.

A column with very high cardinality

D.

A column that is most actively used in selective filters

E.

A column that is most actively used in join predicates

Question 179

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?

Options:

A.

INTERSECT

B.

MFRCK

C.

MINUS

D.

UNION

Question 180

What happens when a database is cloned?

Options:

A.

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

B.

It replicates all granted privileges on the corresponding source objects.

C.

It replicates all granted privileges on the corresponding child objects.

D.

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

Question 181

Which parameter prevents streams on tables from becoming stale?

Options:

A.

MAXDATAEXTENSIONTIMEINDAYS

B.

MTN_DATA_RETENTION_TTME_TN_DAYS

C.

LOCK_TIMEOUT

D.

STALE_AFTER

Load More COF-C02 Questions
Demo: 181 questions
Total 605 questions
Get COF-C02 Full Access Download COF-C02 PDF