Summer Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia
  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02
  5. SnowPro Core Certification Exam Questions and Answers

COF-C02 Sample Questions Answers

Questions 4

What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?

Options:

A.

Scale-up by resizing the warehouse.

B.

Scale-out with a multi-cluster warehouse.

C.

Disable auto-suspend on the warehouse.

D.

Enable auto-resume on the warehouse.

Buy Now
Questions 5

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

Options:

A.

Source_column.element[1]:name

B.

Source_column.element[0]:name

C.

Source_column.element[1].name

D.

Source_column.element[0]:name

Buy Now
Questions 6

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 7

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 8

Which privilege is required for a user to be able to view a resource monitor?

Options:

A.

USAGE

B.

SELECT

C.

MONITOR

D.

OPERATE

Buy Now
Questions 9

The following settings are configured:

THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.

THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.

For how many days will the data be retained at the object level?

Options:

A.

2

B.

3

C.

5

D.

7

Buy Now
Questions 10

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

Options:

A.

The remainder of the session

B.

An unlimited amount of time

C.

The length of time specified in the expiration_time argument

D.

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

Buy Now
Questions 11

When will Snowflake charge credits for the use of the Cloud Services layer?

Options:

A.

Credits will be charged whenever the Cloud Services layer is used.

B.

Credits will be charged only when running a Snowflake-provisioned compute warehouse comfute_wh.

C.

Credits will be charged when the daily consumption of cloud services resources exceeds Wo of the daily warehouse usage.

D.

Credits will be charged only when a virtual warehouse consumes serverless compute services.

Buy Now
Questions 12

Who can access the data published in a Data Exchange?

Options:

A.

Only the data provider who published the data

B.

Any Snowflake user, regardless of their role or permissions

C.

Any user who has been provided with a unique Data Exchange URL

D.

Only the users that the data provider has invited to the Data Exchange

Buy Now
Questions 13

STION NO: 17

How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?

Options:

A.

Log in to the data consumer account and check if the secure view data is appearing as expected.

B.

Create a data share for a test data consumer account and check if the secure view data is appearing as expected.

C.

Query the secure view from a consumer account by setting the share_restrictions parameter.

D.

Simulate querying the secure view by setting the simulated_data_sharing_consumer session parameter.

Buy Now
Questions 14

While unloading data into a stage, how can the user ensure that the output will be a single file?

Options:

A.

Use the copy option files=single.

B.

Use the COPY Option SINGLE=TRUE .

C.

Use the get option SINGLE-TRUE.

D.

Use the GET option FILES-SINGLE.

Buy Now
Questions 15

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 16

What should be considered when deciding to use a secure view? (Select TWO).

Options:

A.

No details of the query execution plan will be available in the query profiler.

B.

Once created there is no way to determine if a view is secure or not.

C.

Secure views do not take advantage of the same internal optimizations as standard views.

D.

It is not possible to create secure materialized views.

E.

The view definition of a secure view is still visible to users by way of the information schema.

Buy Now
Questions 17

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 18

Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO).

Options:

A.

Tables

B.

User-Defined Table Functions (UDTFs)

C.

Secure views

D.

Stored procedures

E.

Worksheets

Buy Now
Questions 19

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

Options:

A.

The file will continue to load until all contents arc loaded.

B.

The tile will slop loading and all data up to that point will be committed.

C.

The file loading could be aborted without any portion of the file being committed.

D.

The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake

Buy Now
Questions 20

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 21

What virtual warehouse configuration should be used when processing a large number of complex queries?

Options:

A.

Use the auto-resume feature.

B.

Run the warehouse in auto-scale mode.

C.

Increase the size of the warehouse.

D.

Increase the number of warehouse clusters.

Buy Now
Questions 22

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

Buy Now
Questions 23

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 24

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 25

What persistent data structures are used by the search optimization service to improve the performance of point lookups?

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Equality searches

D.

Search access paths

Buy Now
Questions 26

Which statement describes Snowflake tables?

Options:

A.

Snowflake tables arc logical representation of underlying physical data.

B.

Snowflake tables are the physical instantiation of data loaded into Snowflake.

C.

Snowflake tables require that clustering keys be defined lo perform optimally.

D.

Snowflake tables are owned by a use.

Buy Now
Questions 27

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 28

Which command will unload data from a table into an external stage?

Options:

A.

PUT

B.

INSERT

C.

COPY INTO

D.

GET

Buy Now
Questions 29

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

Options:

A.

Views

B.

Materialized views

C.

Tables

D.

External tables

E.

Future grants

Buy Now
Questions 30

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.

Buy Now
Questions 31

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.

Buy Now
Questions 32

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 33

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)

Buy Now
Questions 34

Which Snowflake object does not consume any storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Buy Now
Questions 35

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 36

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

Buy Now
Questions 37

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

Options:

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Buy Now
Questions 38

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

Options:

A.

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

B.

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

C.

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

D.

All explicit child object retention periods will remain unchanged.

Buy Now
Questions 39

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 40

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

Options:

A.

Bytes scanned

B.

Partitions scanned

C.

Bytes spilled to local storage

D.

Bytes spilled to remote storage

E.

Percentage scanned from cache

Buy Now
Questions 41

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 42

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 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

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 45

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 46

Which function unloads data from a relational table to JSON?

Options:

A.

TO_OBJECT

B.

TO_JSON

C.

TO_VARIANT

D.

OBJECT CONSTRUCT

Buy Now
Questions 47

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

Options:

A.

File URL

B.

Staged URL

C.

Scoped URL

D.

D. Pre-signed URL

Buy Now
Questions 48

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

Options:

A.

MONITOR

B.

OPERATE

C.

OWNERSHIP

D.

D. ALL

Buy Now
Questions 49

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 50

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.

Buy Now
Questions 51

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 52

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 53

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

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

Options:

A.

Data:employee.name

B.

DATA:employee.name

C.

data:Employee.name

D.

data:employee.name

Buy Now
Questions 54

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 55

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 56

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 57

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

Buy Now
Questions 58

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.

Buy Now
Questions 59

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 60

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

Options:

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Buy Now
Questions 61

What transformations are supported when loading data into a table using the COPY INTO

command? (Select TWO).

Options:

A.

Column reordering

B.

Column omission

C.

JOIN function

D.

FLATTEN function

E.

GROUP BY function

Buy Now
Questions 62

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 63

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Options:

A.

DATA_RETENTION_TIME_IN_DAYS

B.

MAX_DATA_EXTENSION_TIME_IN_DAYS

C.

MIN_DATA_RETENTION_TIME_IN_DAYS

D.

MAX CONCURRENCY LEVEL

Buy Now
Questions 64

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 65

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

Buy Now
Questions 66

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 67

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 68

What type of function returns one value for each Invocation?

Options:

A.

Aggregate

B.

Scalar

C.

Table

D.

Window

Buy Now
Questions 69

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 70

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

Buy Now
Questions 71

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

Options:

A.

Avro

B.

CSV

C.

JSON

D.

Parquet

Buy Now
Questions 72

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.

Buy Now
Questions 73

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 74

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 75

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 76

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 77

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 78

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

Options:

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Buy Now
Questions 79

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 80

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 81

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 82

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 83

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

Options:

A.

1

B.

5

C.

10

D.

100

Buy Now
Questions 84

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

Options:

A.

View

B.

Secure view

C.

Materialized view

D.

External table

Buy Now
Questions 85

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 86

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

Buy Now
Questions 87

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 88

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

What should they do?

Options:

A.

Use the SECURITYADMIN role.

B.

Use the SYSADMIN role.

C.

Use the USERADMIN role.

D.

Contact Snowflake Support.

Buy Now
Questions 89

Why would a Snowflake user decide to use a materialized view instead of a regular view?

Options:

A.

The base tables do not change frequently.

B.

The results of the view change often.

C.

The query is not resource intensive.

D.

The query results are not used frequently.

Buy Now
Questions 90

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

Options:

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

Buy Now
Questions 91

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 92

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 93

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
Questions 94

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 95

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 96

Which Snowflake layer is associated with virtual warehouses?

Options:

A.

Cloud services

B.

Query processing

C.

Elastic memory

D.

Database storage

Buy Now
Questions 97

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

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 98

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

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Buy Now
Questions 99

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 100

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 101

How can staged files be removed during data loading once the files have loaded successfully?

Options:

A.

Use the DROP command

B.

Use the purge copy option.

C.

Use the FORCE = TRUE parameter

D.

Use the LOAD UNCERTAIN FILES copy option.

Buy Now
Questions 102

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

Buy Now
Questions 103

Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

Options:

A.

Secure functions

B.

Secure views

C.

Object tagging

D.

Row-level security

Buy Now
Questions 104

By default, which role can create resource monitors?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

USERADMIN

Buy Now
Questions 105

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

Buy Now
Questions 106

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 107

Which of the following SQL statements will list the version of the drivers currently being used?

Options:

A.

Execute SELECT CURRENT_ODBC_CLlENT(); from the Web Ul

B.

Execute SELECT CURRENT_JDBC_VERSION() ; from SnowSQL

C.

Execute SELECT CURRENT_CLIENT(); from an application

D.

Execute SELECT CURRENT_VERSION (); from the Python Connector

Buy Now
Questions 108

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

Buy Now
Questions 109

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 110

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 111

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 112

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)

Buy Now
Questions 113

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 114

In a Snowflake role hierarchy, what is the top-level role?

Options:

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Buy Now
Questions 115

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 116

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 117

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

Buy Now
Questions 118

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 119

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

Buy Now
Questions 120

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 121

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 122

What affects whether the query results cache can be used?

Options:

A.

If the query contains a deterministic function

B.

If the virtual warehouse has been suspended

C.

If the referenced data in the table has changed

D.

If multiple users are using the same virtual warehouse

Buy Now
Questions 123

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 124

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

Options:

A.

The USERS view in ACCOUNT_USAGE

B.

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.

The SESSIONS view in ACCOUNT_USAGE

Buy Now
Questions 125

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

Options:

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Buy Now
Questions 126

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

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 127

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 128

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 129

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 130

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

Buy Now
Questions 131

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

Buy Now
Questions 132

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 133

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 134

What are supported file formats for unloading data from Snowflake? (Choose three.)

Options:

A.

XML

B.

JSON

C.

Parquet

D.

ORC

E.

AVRO

F.

CSV

Buy Now
Questions 135

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

Options:

A.

True

B.

False

Buy Now
Questions 136

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

Options:

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

Buy Now
Questions 137

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 138

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Buy Now
Questions 139

Which command sets the Virtual Warehouse for a session?

Options:

A.

COPY WAREHOUSE FROM <>;

B.

SET WAREHOUSE = <>;

C.

USE WAREHOUSE <>;

D.

USE VIRTUAL_WAREHOUSE <>;

Buy Now
Questions 140

How many days is load history for Snowpipe retained?

Options:

A.

1 day

B.

7 days

C.

14 days

D.

64 days

Buy Now
Questions 141

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

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Buy Now
Questions 142

Which of the following is a data tokenization integration partner?

Options:

A.

Protegrity

B.

Tableau

C.

DBeaver

D.

SAP

Buy Now
Questions 143

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

Options:

A.

Configure the warehouse to a size larger than generally required

B.

Set the minimum and maximum clusters to autoscale

C.

Use the standard warehouse scaling policy

D.

Use the economy warehouse scaling policy

Buy Now
Questions 144

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 145

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 146

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 147

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 148

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 149

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 150

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 151

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 152

Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).

Options:

A.

GO driver

B.

Node.js driver

C.

ODBC driver

D.

Python connector

E.

Spark connector

Buy Now
Questions 153

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

Options:

A.

NUMBER

B.

OBJECT

C.

STRING

D.

VARCHAR

E.

VARIANT

Buy Now
Questions 154

What column type does a Kafka connector store formatted information in a single column?

Options:

A.

ARRAY

B.

OBJECT

C.

VARCHAR

D.

VARIANT

Buy Now
Questions 155

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

Options:

A.

PARSE_JSON

B.

CHECK_JSON

C.

JSON_EXTRACT_PATH_TEXT

D.

PARSE_XML

Buy Now
Questions 156

Which of the following are characteristics of security in Snowflake?

Options:

A.

Account and user authentication is only available with the Snowflake Business Critical edition.

B.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D.

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Buy Now
Questions 157

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.

Permanent storage of micro-partitions

Buy Now
Questions 158

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 159

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 160

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

Options:

A.

8-16 MB

B.

16-24 MB

C.

10-99 MB

D.

100-250 MB

Buy Now
Questions 161

A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.

Which tasks can this user now perform on the Data Exchange? (Select TWO).

Options:

A.

Rename listings.

B.

Delete provider profiles.

C.

Modify listings properties.

D.

Modify incoming listing access requests.

E.

Submit listings for approval/publishing.

Buy Now
Questions 162

ON NO: 457

What role is required to use Partner Connect?

Options:

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

Buy Now
Questions 163

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

Options:

A.

ALTER FILE FORMAT my_format SET TYPE=JSON;

B.

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

C.

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

D.

REPLACE FILE FORMAT my format TYPE-JSON;

Buy Now
Questions 164

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Buy Now
Questions 165

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 166

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Options:

A.

Gathering the hourly credit usage for an account

B.

Compiling an account's average cloud services cost over the previous month

C.

Summarizing the throughput of Snowpipe costs for an account

D.

Calculating the funds left on an account's contract

Buy Now
Questions 167

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

Options:

A.

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Buy Now
Questions 168

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

Options:

A.

list @bronzestage;

B.

select * from directory(@bronzestage);

C.

select metadata$filename from @bronzestage;

D.

select * from table(information_schema.stage_directory_file_registration_history(

stage name=>'bronzestage1));

Buy Now
Questions 169

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.

Buy Now
Questions 170

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

Options:

A.

Cloud Services

B.

Database Storage

C.

Query Processing

D.

Metadata Management

Buy Now
Questions 171

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.

Buy Now
Questions 172

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

Buy Now
Questions 173

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

Options:

A.

src:salesperson.name

B.

src:sa1esPerson. name

C.

src:salesperson.Name

D.

SRC:salesperson.name

E.

SRC:salesperson.Name

Buy Now
Questions 174

Which Snowflake URL type is used by directory tables?

Options:

A.

File

B.

Pre-signed

C.

Scoped

D.

Virtual-hosted style

Buy Now
Questions 175

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Options:

A.

Duo Security

B.

OAuth

C.

Okta

D.

Single Sign-On (SSO)

Buy Now
Questions 176

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 177

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Options:

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

Buy Now
Questions 178

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

Buy Now
Questions 179

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

Options:

A.

Pre-signed URL

B.

Scoped URL

C.

Signed URL

D.

File URL

Buy Now
Questions 180

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 181

What does Snowflake recommend regarding database object ownership? (Select TWO).

Options:

A.

Create objects with ACCOUNTADMIN and do not reassign ownership.

B.

Create objects with SYSADMIN.

C.

Create objects with SECURITYADMIN to ease granting of privileges later.

D.

Create objects with a custom role and grant this role to SYSADMIN.

E.

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Buy Now
Questions 182

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 183

What is a characteristic of the Snowflake Query Profile?

Options:

A.

It can provide statistics on a maximum number of 100 queries per week.

B.

It provides a graphic representation of the main components of the query processing.

C.

It provides detailed statistics about which queries are using the greatest number of compute resources.

D.

It can be used by third-party software using the Query Profile API.

Buy Now
Questions 184

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 185

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Options:

A.

SHOW GRANTS ON ROLE DATA_SCIENCE

B.

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C.

SHOW GRANTS TO USER INQUISITIVE_PERSON

D.

SHOW GRANTS OF ROLE DATA_SCIENCE

Buy Now
Questions 186

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

Options:

A.

B-tree

B.

Indexing

C.

Map reduce

D.

Pruning

Buy Now
Questions 187

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Options:

A.

Bytes sent over network

B.

Percentage scanned from cache

C.

Partitions total

D.

Bytes spilled to local storage

E.

Partitions scanned

Buy Now
Questions 188

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 189

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

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Buy Now
Questions 190

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

Options:

A.

An FTP server with TLS encryption

B.

An HTTPS server with WebDAV

C.

A Google Cloud storage bucket

D.

A Windows server file share on Azure

Buy Now
Questions 191

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 192

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

Buy Now
Questions 193

A user has unloaded data from Snowflake to a stage

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

Options:

A.

list @file__stage

B.

show @file__stage

C.

view @file__stage

D.

verify @file__stage

Buy Now
Questions 194

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Options:

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Buy Now
Questions 195

What is a best practice after creating a custom role?

Options:

A.

Create the custom role using the SYSADMIN role.

B.

Assign the custom role to the SYSADMIN role

C.

Assign the custom role to the PUBLIC role

D.

Add__CUSTOM to all custom role names

Buy Now
Questions 196

Which data types does Snowflake support when querying semi-structured data? (Select TWO)

Options:

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Buy Now
Questions 197

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

Options:

A.

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

B.

Partitions scanned is equal to partitions total

C.

An AggregateOperacor node is present

D.

The query is spilling to remote storage

Buy Now
Questions 198

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

Buy Now
Questions 199

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 200

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

Buy Now
Questions 201

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 202

Which of the following describes external functions in Snowflake?

Options:

A.

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

B.

They contain their own SQL code.

C.

They call code that is stored inside of Snowflake.

D.

They can return multiple rows for each row received

Buy Now
Questions 203

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 204

ION NO: 229

What happens when a virtual warehouse is resized?

Options:

A.

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B.

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

Buy Now
Questions 205

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 206

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

A.

ROLEADMIN

B.

ACCOUNTADMIN

C.

SYSADMIN

D.

SECURITYADMIN

E.

USERADMIN

Buy Now
Questions 207

Which Snowflake feature is used for both querying and restoring data?

Options:

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Buy Now
Questions 208

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 209

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 210

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 211

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Buy Now
Questions 212

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 213

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Options:

A.

The table contains a column that has very low cardinality

B.

DML statements that are being issued against the table are blocked

C.

The table has a small number of micro-partitions

D.

Queries on the table are running slower than expected

E.

The clustering depth for the table is large

Buy Now
Questions 214

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

Buy Now
Questions 215

What is a key feature of Snowflake architecture?

Options:

A.

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

B.

Software updates are automatically applied on a quarterly basis

C.

Snowflake eliminates resource contention with its virtual warehouse implementation

D.

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

E.

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

Buy Now
Questions 216

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 217

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Options:

A.

Each Snowflake account can be hosted in a different cloud vendor and region.

B.

Each Snowflake account must be hosted in a different cloud vendor and region

C.

All Snowflake accounts must be hosted in the same cloud vendor and region

D.

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Buy Now
Questions 218

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 219

Which command is used to unload data from a Snowflake table into a file in a stage?

Options:

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Buy Now
Questions 220

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 221

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

Buy Now
Questions 222

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 223

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

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Buy Now
Questions 224

TION NO: 230

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Options:

A.

Yes, because a table owner has full control and can unset masking policies.

B.

Yes, because masking policies only apply to cloned tables.

C.

No, because masking policies must always reference specific access roles.

D.

No, because ownership of a table does not include the ability to change masking policies

Buy Now
Questions 225

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

A.

Customer-managed encryption keys through Tri-Secret Secure

B.

Automatic encryption of all data

C.

Up to 90 days of data recovery through Time Travel

D.

Object-level access control

E.

Column-level security to apply data masking policies to tables and views

Buy Now
Questions 226

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)

Buy Now
Exam Code: COF-C02
Exam Name: SnowPro Core Certification Exam
Last Update: Sep 16, 2025
Questions: 941
$66  $164.99
$50  $124.99
$42  $104.99
buy now COF-C02