Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

COF-C02 SnowPro Core Certification Exam Questions and Answers

Questions 4

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

Options:

A.

Auto-scale mode

B.

Maximized mode

C.

Economy scaling policy

D.

Standard scaling policy

Buy Now
Questions 5

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options:

A.

USAGE

B.

OPERATE

C.

MONITOR

D.

MODIFY

Buy Now
Questions 6

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.

Buy Now
Questions 7

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

Options:

A.

7 days

B.

14 days

C.

28 days

D.

365 days

Buy Now
Questions 8

What is the name of the SnowSQLfile that can store connection information?

Options:

A.

history

B.

config

C.

snowsqLcnf

D.

snowsql.pubkey

Buy Now
Questions 9

Which statement MOST accurately describes clustering in Snowflake?

Options:

A.

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

B.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

C.

The clustering key must be included in the COPY command when loading data into Snowflake.

D.

Clustering can be disabled within a Snowflake account.

Buy Now
Questions 10

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

Options:

A.

Bytes spilled to local cache.

B.

Bytes spilled to local storage.

C.

Bytes spilled to remote cache.

D.

Bytes spilled to remote storage.

E.

Bytes spilled to remote metastore.

Buy Now
Questions 11

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

Buy Now
Questions 12

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.

Buy Now
Questions 13

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

Options:

A.

Roles

B.

Databases

C.

Warehouses

D.

Users

E.

Accounts

Buy Now
Questions 14

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

Options:

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

Buy Now
Questions 15

Using variables in Snowflake is denoted by using which SQL character?

Options:

A.

@

B.

&

C.

$

D.

#

Buy Now
Questions 16

How can a data provider ensure that a data consumer is going to have access to the required objects?

Options:

A.

Enable the data sharing feature in the account and validate the view.

B.

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

C.

Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

D.

Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Buy Now
Questions 17

Which Snowflake tool would be BEST to troubleshoot network connectivity?

Options:

A.

SnowCLI

B.

SnowUI

C.

SnowSQL

D.

SnowCD

Buy Now
Questions 18

How can a user change which columns are referenced in a view?

Options:

A.

Modify the columns in the underlying table

B.

Use the ALTER VIEW command to update the view

C.

Recreate the view with the required changes

D.

Materialize the view to perform the changes

Buy Now
Questions 19

Which REST API can be used with unstructured data?

Options:

A.

inscrtFilcs

B.

insertReport

C.

GET /api/tiles/

D.

loadHistoryScan

Buy Now
Questions 20

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

Options:

A.

STRIP_NULL_VALUES

B.

SKIP_BYTE_ORDER_MARK

C.

REPLACE_INVALID_CHARACTERS

D.

VALIDATION_MODE

Buy Now
Questions 21

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

Buy Now
Questions 22

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

Options:

A.

CSV

B.

JSON

C.

ORC

D.

Parquet

Buy Now
Questions 23

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

Options:

A.

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

B.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C.

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

D.

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

E.

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

Buy Now
Questions 24

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 25

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

Options:

A.

When users will be using compute at different times throughout a 24/7 period

B.

When managing a steady workload

C.

When the compute must be available with no delay or lag time

D.

When the user does not want to have to manually turn on the warehouse each time it is needed

E.

When the warehouse is shared across different teams

Buy Now
Questions 26

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

Options:

A.

A directory table is a separate database object.

B.

Directory tables store data file metadata.

C.

A directory table will be automatically added to a stage.

D.

Directory tables do not have their own grantable privileges.

E.

Directory table data can not be refreshed manually.

Buy Now
Questions 27

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Options:

A.

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.

The warehouse size does not change until the warehouse is suspended and restarted.

D.

It does not return from the command until the warehouse has finished changing its size.

Buy Now
Questions 28

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Options:

A.

Scale up the existing warehouse.

B.

Create separate warehouses for each user.

C.

Create separate warehouses for each workload.

D.

Stop loading and querying data at the same time.

Buy Now
Questions 29

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

Options:

A.

Files

B.

External tables

C.

Secure User-Defined Functions (UDFs)

D.

Sequences

E.

Streams

Buy Now
Questions 30

What is used to diagnose and troubleshoot network connections to Snowflake?

Options:

A.

SnowCD

B.

Snowpark

C.

Snowsight

D.

SnowSQL

Buy Now
Questions 31

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

Options:

A.

Schema Stage

B.

User Stage

C.

Database Stage

D.

Table Stage

E.

External Named Stage

F.

Internal Named Stage

Buy Now
Questions 32

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

Options:

A.

1 GB

B.

5 GB

C.

10 GB

D.

16 GB

Buy Now
Questions 33

Where is Snowflake metadata stored?

Options:

A.

Within the data files

B.

In the virtual warehouse layer

C.

In the cloud services layer

D.

In the remote storage layer

Buy Now
Questions 34

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

Options:

A.

8MB

B.

16MB

C.

32MB

D.

128MB

Buy Now
Questions 35

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

Buy Now
Questions 36

Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

Options:

A.

A User-Defined Table Function (UDTF)

B.

A Scalar User Function (UDF)

C.

A stored procedure

D.

A task

Buy Now
Questions 37

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Options:

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

Buy Now
Questions 38

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.

Buy Now
Questions 39

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

Options:

A.

GRANT

B.

SELECT

C.

MODIFY

D.

OWNERSHIP

E.

CREATE USER

Buy Now
Questions 40

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

Options:

A.

FOR

B.

LOOP

C.

REPEAT

D.

WHILE

Buy Now
Questions 41

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

Buy Now
Questions 42

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

Options:

A.

Review the granted privileges to the database object.

B.

Review the row access policy for the database object.

C.

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

D.

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

Buy Now
Questions 43

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

Options:

A.

Manually re-cluster the table regularly.

B.

Choose one high cardinality column as the clustering key.

C.

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

D.

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

Buy Now
Questions 44

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

Options:

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Buy Now
Questions 45

Which operation can be performed on Snowflake external tables?

Options:

A.

INSERT

B.

JOIN

C.

RENAME

D.

ALTER

Buy Now
Questions 46

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

Buy Now
Questions 47

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

Options:

A.

INTEGER

B.

OBJECT

C.

VARIANT

D.

VARCHAR

E.

LIST

Buy Now
Questions 48

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.

Buy Now
Questions 49

What does SnowCD help Snowflake users to do?

Options:

A.

Copy data into files.

B.

Manage different databases and schemas.

C.

Troubleshoot network connections to Snowflake.

D.

Write SELECT queries to retrieve data from external tables.

Buy Now
Questions 50

Which object can be used with Secure Data Sharing?

Options:

A.

View

B.

Materialized view

C.

External table

D.

User-Defined Function (UDF)

Buy Now
Questions 51

NO: 504

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

Options:

A.

File URL

B.

Scoped URL

C.

Relative URL

D.

Pre-Signed URL

Buy Now
Questions 52

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

Options:

A.

It removes null values from all columns in the data.

B.

It converts null values to empty strings during loading.

C.

It skips rows with null values during the loading process.

D.

It removes object or array elements containing null values.

Buy Now
Questions 53

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:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 54

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Buy Now
Questions 55

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.

Buy Now
Questions 56

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

Buy Now
Questions 57

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

Options:

A.

RETURN_-1_R0WS

B.

RETURN_n_ROWS

C.

RETURN_ERRORS

D.

RETURN ALL ERRORS

Buy Now
Questions 58

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

Options:

A.

The separation allows independent scaling of computing resources.

B.

The separation ensures consistent data encryption across all virtual data warehouses.

C.

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D.

Storage volume growth and compute usage growth can be tightly coupled.

E.

Compute can be scaled up or down without the requirement to add more storage.

Buy Now
Questions 59

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

Buy Now
Questions 60

What will prevent unauthorized access to a Snowflake account from an unknown source?

Options:

A.

Network policy

B.

End-to-end encryption

C.

Multi-Factor Authentication (MFA)

D.

Role-Based Access Control (RBAC)

Buy Now
Questions 61

What step can reduce data spilling in Snowflake?

Options:

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

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

Buy Now
Questions 62

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

Buy Now
Questions 63

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)

Buy Now
Questions 64

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

Options:

A.

Access history

B.

Data classification

C.

Dynamic Data Masking

D.

Object tagging

Buy Now
Questions 65

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

Buy Now
Questions 66

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

Buy Now
Questions 67

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

Options:

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Buy Now
Questions 68

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

Options:

A.

DATABASE_STORAGE_USAGE_HISTORY

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STAGE STORAGE USAGE HISTORY

Buy Now
Questions 69

TION NO: 521

Who can grant object privileges in a regular schema?

Options:

A.

Object owner

B.

Schema owner

C.

Database owner

D.

SYSADMIN

Buy Now
Questions 70

What are the least privileges needed to view and modify resource monitors? (Select TWO).

Options:

A.

SELECT

B.

OWNERSHIP

C.

MONITOR

D.

MODIFY

E.

USAGE

Buy Now
Questions 71

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

Options:

A.

GET_PRESIGNED_URL

B.

GET_ABSOLUTE_PATH

C.

BUILD_STAGE_FILE_URL

D.

BUILD SCOPED FILE URL

Buy Now
Questions 72

Which Snowflake view is used to support compliance auditing?

Options:

A.

ACCESS_HISTORY

B.

COPY_HISTORY

C.

QUERY_HISTORY

D.

ROW ACCESS POLICIES

Buy Now
Questions 73

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

Options:

A.

The database owner

B.

The object owner

C.

The schema owner

D.

The Snowflake user's role

Buy Now
Questions 74

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

Options:

A.

The objects are dropped.

B.

The objects enter the Fail-safe period.

C.

The objects enter the Time Travel period.

D.

The objects are immediately moved to the provider account.

Buy Now
Questions 75

What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

Options:

A.

Data Replication

B.

Secure Data Sharing

C.

Data Exchange

D.

Snowflake Marketplace

Buy Now
Questions 76

How can a Snowflake user validate data that is unloaded using the COPY INTO command?

Options:

A.

Load the data into a CSV file.

B.

Load the data into a relational table.

C.

Use the VALlDATlON_MODE - SQL statement.

D.

Use the validation mode = return rows statement.

Buy Now
Questions 77

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

Options:

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Buy Now
Questions 78

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

Buy Now
Questions 79

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

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Buy Now
Questions 80

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

Options:

A.

SnowSQL

B.

Snowflake classic web interface (Ul)

C.

Snowsight

D.

.NET driver

Buy Now
Questions 81

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 82

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Options:

A.

True

B.

False

Buy Now
Questions 83

Which of the following describes how clustering keys work in Snowflake?

Options:

A.

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.

Clustering keys sort the designated columns over time, without blocking DML operations

C.

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D.

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Buy Now
Questions 84

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

Buy Now
Questions 85

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

Buy Now
Questions 86

How long is Snowpipe data load history retained?

Options:

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Buy Now
Questions 87

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

Options:

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Buy Now
Questions 88

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

Buy Now
Questions 89

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

Options:

A.

Through the Snowflake web interface (Ul)

B.

Through the DATA_SHARE=TRUE parameter

C.

Through SQL commands

D.

Through the enable__share=true parameter

E.

Using the CREATE SHARE AS SELECT * TABLE command

Buy Now
Questions 90

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

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Buy Now
Questions 91

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Options:

A.

Pipes

B.

Streams

C.

Tasks

D.

D. Procedures

Buy Now
Questions 92

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

Which statements will provide this access?

Options:

A.

GRANT ROLE MYROLE TO USER USER1;

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

B.

GRANT ROLE MYROLE TO USER USER1;

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

C.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Buy Now
Questions 93

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Options:

A.

The user has the appropriate privileges on the objects associated with the query

B.

Micro-partitions have been reclustered since the query was last run

C.

The new query is run using the same virtual warehouse as the previous query

D.

The query includes a User Defined Function (UDF)

E.

The query has been run within 24 hours of the previously-run query

Buy Now
Questions 94

Which cache type is used to cache data output from SQL queries?

Options:

A.

Metadata cache

B.

Result cache

C.

Remote cache

D.

Local file cache

Buy Now
Questions 95

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

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Buy Now
Questions 96

What can be used to view warehouse usage over time? (Select Two).

Options:

A.

The load HISTORY view

B.

The Query history view

C.

The show warehouses command

D.

The WAREHOUSE_METERING__HISTORY View

E.

The billing and usage tab in the Snowflake web Ul

Buy Now
Questions 97

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:

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Buy Now
Questions 98

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

Buy Now
Questions 99

What is the MOST performant file format for loading data in Snowflake?

Options:

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Buy Now
Questions 100

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

What does the STRIP_OUTER_ARRAY file format do?

Options:

A.

It removes the last element of the outer array.

B.

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

C.

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

D.

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

Buy Now
Questions 101

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Options:

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Buy Now
Questions 102

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

Options:

A.

All data from all of the files on the stage will be appended to the table

B.

Only data about new customers from the new files will be appended to the table

C.

The operation will fail with the error uncertain files in stage.

D.

All data from only the newly-added files will be appended to the table.

Buy Now
Questions 103

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

Options:

A.

Via the Snowflake Web Interface (Ul)

B.

Via the data_share=true parameter

C.

Via SQL commands

D.

Via Virtual Warehouses

Buy Now
Questions 104

What features does Snowflake Time Travel enable?

Options:

A.

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

B.

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

C.

Conducting point-in-time analysis for Bl reporting

D.

Analyzing data usage/manipulation over all periods of time

Buy Now
Questions 105

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

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Buy Now
Questions 106

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

Options:

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

Buy Now
Questions 107

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

Options:

A.

True

B.

False

Buy Now
Questions 108

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

Options:

A.

Columns can be aggregated

B.

Columns can be joined with an existing table

C.

Columns can be reordered

D.

Columns can be omitted

E.

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

Buy Now
Questions 109

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

Buy Now
Questions 110

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Buy Now
Questions 111

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:

A.

Standard

B.

Premium

C.

Enterprise

D.

Business Critical

Questions 112

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

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 113

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.

Buy Now
Questions 114

Which type of URL gives permanent access to files in cloud storage?

Options:

A.

Pre-signed URL

B.

Account URL

C.

Scoped URL

D.

File URL

Buy Now
Questions 115

A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).

Options:

A.

RECORD_TIMESTAMP

B.

RECORD_CONTENT

C.

RECORDKEY

D.

RECORD_SESSION

E.

RECORD_METADATA

Buy Now
Questions 116

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Options:

A.

Set the WAREHOUSES_SIZE to 6XL.

B.

Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.

C.

Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.

D.

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Buy Now
Questions 117

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 118

How can the outer array structure of a semi-structured file be removed?

Options:

A.

Use the parameter strip_outer_array = true in a COPY INTO

command.

B.

Set the file format to eliminate any outer array structure before initiating the COPY INTO

command.

C.

Filter the outer array structure using a PUT command with the include_outer_array = false parameter.

D.

Use the FLATTEN command with the outer_array = false parameter.

Buy Now
command to remove the outer array structure from a semi-structured file. This parameter is useful for JSON files or similar data formats where an array might wrap the data, allowing Snowflake to directly load the inner elements as table rows.

Questions 119

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

Buy Now
Questions 120

What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).

Options:

A.

Auto-suspend

B.

Cache size

C.

Default role

D.

Resource monitor

E.

Storage size

Buy Now
Questions 121

Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?

Options:

A.

An economy scaling policy

B.

A standard scaling policy

C.

Maximized mode

D.

Auto-scale mode

Buy Now
Questions 122

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

Options:

A.

B.

C.

D.

E.

Buy Now
Questions 123

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

Options:

A.

ACCESS_HISTORY

B.

LOAD_HISTORY

C.

QUERY_HISTORY

D.

REST EVENT HISTORY

Buy Now
Questions 124

The Snowflake VARIANT data type imposes a 16 MB size limit on what?

Options:

A.

An individual row

B.

An individual column

C.

A view

D.

A file in a stage

Buy Now
Questions 125

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

Options:

A.

TRUNC (ID_NUMBER, -6)

B.

TRUNC (ID_NUMBER, 5)

C.

ID_NUMBER*100

D.

TO CHAR(ID_NUMBER)

Buy Now
Questions 126

Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

Options:

A.

Alerts

B.

External tables

C.

Secure views

D.

Materialized views

Buy Now
Questions 127

What is the MINIMUM Snowftake edition that supports database replication?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Buy Now
Questions 128

Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

Options:

A.

Only while in the ACCOUNTADMIH role

B.

Only while in the securityadmin role

C.

Only the role with the ownership privilege on the network policy

D.

Only Snowflake Support can set the value for this object property

Buy Now
Questions 129

Which features can be used with the Snowflake Standard edition? (Select TWO).

Options:

A.

Materialized views

B.

External functions

C.

Multi-cluster virtual warehouses

D.

Fail-safe

E.

Row-level security

Buy Now
Questions 130

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

Buy Now
Questions 131

Which transformation techniques are supported for bulk loading data into Snowflake using the copy into

command? (Select TWO)

Options:

A.

Column grouping

B.

Column omission

C.

Column reordering

D.

Column aggregation

E.

Selection of a limited number of rows

Buy Now
Questions 132

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

Options:

A.

Users with ACCOUNTADMIN role

B.

Users with sysadmin role

C.

Users with ORGADMIN role

D.

Users with import share privilege

E.

Users with manage grants privilege

Buy Now
Questions 133

Which task is supported by the use of Access History in Snowflake?

Options:

A.

Data backups

B.

Cost monitoring

C.

Compliance auditing

D.

Performance optimization

Buy Now
Questions 134

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

Buy Now
Questions 135

When used with the UNLOAD command, which parameter specifies the destination of unloaded data?

Options:

A.

COPY INTO

B.

COPY INTO

C.

GET

D.

PUT

Buy Now
Questions 136

Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

Options:

A.

GET_RELATIVE_PATH

B.

GET_PRESIGNED_URL

C.

BUILD_STAGE_FILE_URL

D.

BUILD_SCOPED_FILE_URL

Buy Now
Questions 137

Authorization to execute CREATE statements comes only from which role?

Options:

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Buy Now
Questions 138

Which typos of charts does Snowsight support? (Select TWO).

Options:

A.

Area charts

B.

Bar charts

C.

Column charts

D.

Radar charts

E.

Scorecards

Buy Now
Questions 139

What is the primary purpose of using a masking policy in Snowflake?

Options:

A.

To protect sensitive data from unauthorized access when queries are run.

B.

To automatically encrypt sensitive data when data is stored in Snowflake.

C.

To protect multiple columns that have different data types in a given table.

D.

To protect both column-level and row-level data.

Buy Now
Questions 140

When does a materialized view get suspended in Snowflake?

Options:

A.

When a column is added to the base table

B.

When a column is dropped from the base table

C.

When a DML operation is run on the base table

D.

When the base table is reclustered

Buy Now
Questions 141

Which privilege is needed for a SnowFlake user to see the definition of a secure view?

Options:

A.

OWNERSHIP

B.

MODIFY

C.

CREATE

D.

USAGE

Buy Now
Questions 142

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

Options:

A.

Directory table

B.

Temporary table

C.

Transient table

D.

A table with a materialized view

Buy Now
Questions 143

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.

Buy Now
Questions 144

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

Buy Now
Questions 145

A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

Options:

A.

ALTER TABLE

PURGE CLUSTERING KEY

B.

ALTER TABLE

DELETE CLUSTERING KEY

C.

ALTER TABLE

DROP CLUSTERING KEY

D.

ALTER TABLE

REMOVE CLUSTERING KEY

Buy Now
Questions 146

In which hierarchy is tag inheritance possible?

Options:

A.

Organization » Account» Role

B.

Account » User » Schema

C.

Database » View » Column

D.

Schema » Table » Column

Buy Now
Questions 147

Which Snowflake object is supported by both database replication and replication groups?

Options:

A.

Pipes

B.

Users

C.

Stages

D.

Materialized views

Buy Now
Questions 148

Who can create network policies within Snowflake? (Select TWO).

Options:

A.

SYSADMIN only

B.

ORCADMIN only

C.

SECURITYADMIN or higher roles

D.

A role with the CREATE NETWORK POLICY privilege

E.

A role with the CREATE SECURITY INTEGRATION privilege

Buy Now
Questions 149

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

Options:

A.

A defined level of access to an object

B.

An entity in which access can be granted

C.

Each object has an owner, who can in turn grail access to that object.

D.

Access privileges are assigned to roles. which are in turn assigned to use's

Buy Now
Questions 150

The property mins_to_bypass_network_policy is set at which level?

Options:

A.

User

B.

Role

C.

Account

D.

Organization

Buy Now
Questions 151

What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the copy into command used during data unloading? (Select TWO).

Options:

A.

Single quote character (')

B.

NULL

C.

'NULL'

D.

NONE

E.

'NONE'

Buy Now
Questions 152

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Options:

A.

1 second

B.

60 seconds

C.

5 minutes

D.

60 minutes

Buy Now
Questions 153

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

Buy Now
Questions 154

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

Options:

A.

The data is cloned into a historical object.

B.

The data moves to Fail-safe

C.

Time Travel on the historical data is dropped.

D.

The object containing the historical data is dropped.

Buy Now
Questions 155

A user is preparing to load data from an external stage

Which practice will provide the MOST efficient loading performance?

Options:

A.

Organize files into logical paths

B.

Store the files on the external stage to ensure caching is maintained

C.

Use pattern matching for regular expression execution

D.

Load the data in one large file

Buy Now
Questions 156

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:

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Buy Now
Questions 157

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

Buy Now
Questions 158

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

Options:

A.

The Pipe load history is reset to empty.

B.

The REFRESH command is executed.

C.

The stage will be purged.

D.

The destination table is truncated.

Buy Now
Questions 159

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

Options:

A.

Row level access policies

B.

Data masking policies

C.

Data encryption

D.

Time Travel

E.

External tokenization

Buy Now
Questions 160

When cloning a database, what is cloned with the database? (Choose two.)

Options:

A.

Privileges on the database

B.

Existing child objects within the database

C.

Future child objects within the database

D.

Privileges on the schemas within the database

E.

Only schemas and tables within the database

Buy Now
Questions 161

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:

A.

4 minutes

B.

10 minutes

C.

14 minutes

D.

24 minutes

Buy Now
Questions 162

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

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Buy Now
Questions 163

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Options:

A.

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B.

Scaling out adds clusters of varying sizes to a virtual warehouse.

C.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Buy Now
Questions 164

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

Options:

A.

The user who created the object

B.

The SYSADMIN role

C.

Ownership depends on the type of object

D.

The role used to create the object

Buy Now
Questions 165

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Options:

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Buy Now
Questions 166

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 167

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

Options:

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Buy Now
Questions 168

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

Options:

A.

True

B.

False

Buy Now
Questions 169

What COPY INTO SQL command should be used to unload data into multiple files?

Options:

A.

SINGLE=TRUE

B.

MULTIPLE=TRUE

C.

MULTIPLE=FALSE

D.

SINGLE=FALSE

Buy Now
Questions 170

Which command removes a role from another role or a user in Snowflak?

Options:

A.

ALTER ROLE

B.

REVOKE ROLE

C.

USE ROLE

D.

USE SECONDARY ROLES

Buy Now
Questions 171

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

Buy Now
Questions 172

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

Options:

A.

When the system has enough load for 2 minutes

B.

When the system has enough load for 6 minutes

C.

When the system has enough load for 8 minutes

D.

When the system has enough load for 10 minutes

Buy Now
Questions 173

Which statement accurately describes Snowflake's architecture?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 174

Which Snowflow object does not consume and storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Buy Now
Questions 175

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

Buy Now
Questions 176

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.

Buy Now
Questions 177

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

Options:

A.

There is no Fail-safe period for these tables.

B.

1 day

C.

7 days

D.

31 days

E.

90 days

Buy Now
Questions 178

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

Options:

A.

Authentication

B.

Resource management

C.

Virtual warehouse caching

D.

Query parsing and optimization

E.

Query execution

F.

Physical storage of micro-partitions

Buy Now
Questions 179

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

Options:

A.

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

B.

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

C.

All data in Snowflake is encrypted.

D.

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

E.

All data in Snowflake is compressed.

Buy Now
Questions 180

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Options:

A.

Queries against large tables where frequent DML occurs

B.

Queries against tables larger than 1 TB

C.

Selective point lookup queries

D.

Queries against a subset of columns in a table

Buy Now
Questions 181

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

Buy Now
Questions 182

How does Snowflake describe its unique architecture?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 183

Which view can be used to determine if a table has frequent row updates or deletes?

Options:

A.

TABLES

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STORAGE USAGE

Buy Now
Questions 184

What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

Options:

A.

Temporary table

B.

External table

C.

Secure view

D.

Materialized view

Buy Now
Questions 185

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

Buy Now
Questions 186

Which command should be used to unload all the rows from a table into one or more files in a named stage?

Options:

A.

COPY INTO

B.

GET

C.

INSERT INTO

D.

PUT

Buy Now
Questions 187

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

Options:

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Buy Now
Questions 188

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

Options:

A.

GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE

B.

GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE

C.

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE

D.

GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE

Buy Now
Questions 189

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:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 190

Which Snowflake layer is associated with virtual warehouses?

Options:

A.

Cloud services

B.

Query processing

C.

Elastic memory

D.

Database storage

Buy Now
Questions 191

Which use case does the search optimization service support?

Options:

A.

Disjuncts (OR) in join predicates

B.

LIKE/ILIKE/RLIKE join predicates

C.

Join predicates on VARIANT columns

D.

Conjunctions (AND) of multiple equality predicates

Buy Now
Questions 192

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

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Buy Now
Questions 193

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

Options:

A.

BINARY_FORMAT

B.

ESCAPE_UNENCLOSED_FIELD

C.

FIELD_OPTIONALLY_ENCLOSED_BY

D.

SKIP BYTE ORDER MARK

Buy Now
Questions 194

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

Options:

A.

The column name and element names are both case-sensitive.

B.

The column name and element names are both case-insensitive.

C.

The column name is case-sensitive but element names are case-insensitive.

D.

The column name is case-insensitive but element names are case-sensitive.

Buy Now
Questions 195

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

Options:

A.

BINARY

B.

GEOGRAPHY

C.

GEOMETRY

D.

OBJECT

E.

VARIANT

Buy Now
Questions 196

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.

Buy Now
Questions 197

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

Options:

A.

1 day

B.

7 days

C.

12 hours

D.

0 days

Buy Now
Questions 198

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

Options:

A.

Local disk caching

B.

Authentication and access control

C.

Metadata management

D.

Query processing

E.

Database storage

Buy Now
Questions 199

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

Buy Now
Questions 200

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

Buy Now
Questions 201

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Options:

A.

Custom Edition

B.

Virtual Private Snowflake

C.

Business Critical Edition

D.

Standard Edition

E.

Enterprise Edition

Buy Now
Questions 202

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.

Buy Now
Questions 203

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

Options:

A.

4

B.

8

C.

16

D.

32

Buy Now
Questions 204

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

Options:

A.

Database replication and failover

B.

Automated index management

C.

Customer managed keys (Tri-secret secure)

D.

Extended time travel

E.

Native support for geospatial data

Buy Now
Questions 205

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

Buy Now
Questions 206

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

Options:

A.

SELECT SUM (ORDER_AMT) FROM SALES;

B.

SELECT AVG(ORDER_QTY) FROM SALES;

C.

SELECT MIN(ORDER_AMT) FROM SALES;

D.

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Buy Now
Questions 207

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

Buy Now
Questions 208

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

Options:

A.

0 days

B.

1 day

C.

7 days

D.

90 days

Buy Now
Questions 209

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.

Buy Now
Questions 210

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:

A.

Data classification

B.

Query acceleration service

C.

Search optimization service

D.

Tagging

Buy Now
Questions 211

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

Options:

A.

ARRAY_AGG

B.

OBJECT_AGG

C.

ARRAY_CONSTRUCT

D.

OBJECT_CONSTRUCT

Buy Now
Questions 212

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:

A.

60

B.

91

C.

120

D.

121

Buy Now
Questions 213

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.

Buy Now
Questions 214

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

Options:

A.

Grant the additional privileges to a custom role.

B.

Grant the additional privileges to the ACCOUNTADMIN role.

C.

Grant the additional privileges to the SYSADMIN role.

D.

Grant the additional privileges to the ORGADMIN role.

Buy Now
Questions 215

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

Options:

A.

GROUP BY

B.

LIMIT

C.

ORDER BY

D.

PARTITION BY

E.

UNION ALL

Buy Now
Questions 216

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

Buy Now
Questions 217

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:

A.

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.

Snowflake will only check the schema the UDF belongs to.

C.

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

D.

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

Buy Now
Questions 218

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

Buy Now
Questions 219

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.

Buy Now
Questions 220

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

Buy Now
Questions 221

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

Buy Now
Questions 222

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

Options:

A.

FLATTEN

B.

CHECK_JSON

C.

PARSE_JSON

D.

TO_VARIANT

Buy Now
Questions 223

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

Options:

A.

Use the SHOW STAGES command.

B.

Use the DESCRIBE STAGE command.

C.

Use the GET_ABSOLUTE_PATH function.

D.

Use the GET_STAGE_LOCATION function.

Buy Now
Questions 224

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

Options:

A.

User stage

B.

Table stage

C.

Named internal stage

D.

Named external stage

Buy Now
Questions 225

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

Buy Now
Questions 226

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

Buy Now
Exam Code: COF-C02
Exam Name: SnowPro Core Certification Exam
Last Update: Mar 29, 2025
Questions: 751

PDF + Testing Engine

$134.99

Testing Engine

$99.99

PDF (Q&A)

$84.99