Winter Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Snowflake COF-C02 SnowPro Core Certification Exam Exam Practice Test

Page: 1 / 67
Total 671 questions

SnowPro Core Certification Exam Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

Which activities are included in the Cloud Sen/ices layer? (Select TWO).

Options:

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Question 2

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

Question 3

Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

Options:

A.

Directory

B.

File

C.

Pre-signed

D.

Scoped

Question 4

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

Options:

A.

JSON

B.

BINARY

C.

VARCHAR

D.

VARIANT

Question 5

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

Question 6

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

Options:

A.

Resource monitor

B.

Account_usage. query_history

C.

Information_schema.warehouse_load_history

D.

Information schema.warehouse metering history

Question 7

A materialized view should be created when which of the following occurs? (Choose two.)

Options:

A.

There is minimal cost associated with running the query.

B.

The query consumes many compute resources every time it runs.

C.

The base table gets updated frequently.

D.

The query is highly optimized and does not consume many compute resources.

E.

The results of the query do not change often and are used frequently.

Question 8

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

Options:

A.

Cloud services layer

B.

Compute layer

C.

Storage layer

D.

Cloud agnostic layer

Question 9

Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

Options:

A.

Security

B.

Data storage

C.

Data visualization

D.

Query computation

E.

Metadata management

Question 10

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.

Question 11

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.

Question 12

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Options:

A.

Create a view.

B.

Cluster a table.

C.

Enable the search optimization service.

D.

Enable Time Travel.

E.

Index a table.

Question 13

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Options:

A.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Question 14

How many resource monitors can be assigned at the account level?

Options:

A.

1

B.

2

C.

3

D.

4

Question 15

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.

Question 16

What can a Snowflake user do in the Activity section in Snowsight?

Options:

A.

Create dashboards.

B.

Write and run SQL queries.

C.

Explore databases and objects.

D.

Explore executed query performance.

Question 17

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

Options:

A.

Contacts

B.

Sharing settings

C.

Copy History

D.

Query History

E.

Automatic Clustering History

Question 18

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

Options:

A.

CSV

B.

JSON

C.

ORC

D.

Parquet

Question 19

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

Options:

A.

Directory

B.

External

C.

Temporary

D.

Transient

Question 20

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

Question 21

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.

Question 22

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

Options:

A.

When using a paid listing on the Snowflake Marketplace

B.

When using a private listing on the Snowflake Marketplace

C.

When using a personalized listing on the Snowflake Marketplace

D.

When using a Direct Share with another account

Question 23

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

Options:

A.

60

B.

91

C.

120

D.

121

Question 24

Which feature allows a user the ability to control the organization of data in a micro-partition?

Options:

A.

Range Partitioning

B.

Search Optimization Service

C.

Automatic Clustering

D.

Horizontal Partitioning

Question 25

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

Options:

A.

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

Question 26

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

Question 27

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

Options:

A.

SnowCD

B.

Snowpark

C.

Snowsight

D.

SnowSQL

Question 28

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

Options:

A.

Search optimization service

B.

Automatic clustering

C.

Row access policies

D.

Multi-cluster virtual warehouses

E.

Secure views

Question 29

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 30

How often are the Account and Table master keys automatically rotated by Snowflake?

Options:

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days.

Question 31

Which of the following statements describes a schema in Snowflake?

Options:

A.

A logical grouping of objects that belongs to a single database

B.

A logical grouping of objects that belongs to multiple databases

C.

A named Snowflake object that includes all the information required to share a database

D.

A uniquely identified Snowflake account within a business entity

Question 32

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

Options:

A.

READ

B.

OWNERSHIP

C.

USAGK

D.

WRTTF

Question 33

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

Options:

A.

Analyze query performance.

B.

Write queries and execute them.

C.

Provide an overview of the listings in the Snowflake Marketplace.

D.

Connect to Snowflake partners to explore extended functionality.

Question 34

Which Snowflake URL type is used by directory tables?

Options:

A.

File

B.

Pre-signed

C.

Scoped

D.

Virtual-hosted style

Question 35

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.

Question 36

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 37

Snowflake's access control framework combines which models for securing data? (Select TWO).

Options:

A.

Attribute-based Access Control (ABAC 1

B.

Discretionary Access Control (DAC)

C.

Access Control List (ACL)

D.

Role-based Access Control (RBAC)

E.

Rule-based Access Control (RuBAC)

Question 38

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

Options:

A.

Users with ACCOUNTADMIN role

B.

Users with sysadmin role

C.

Users with ORGADMIN role

D.

Users with import share privilege

E.

Users with manage grants privilege

Question 39

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

Options:

A.

1 Kilobyte (KB)

B.

1 Megabyte (MB)

C.

1 Gigabyte (GB)

D.

1 Terabyte (TB)

Question 40

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

Options:

A.

ACCOUNTADMIN

B.

USERADMIN

C.

PUBLIC

D.

SYSADMIN

E.

Any role that has the global ATTACH POLICY privilege

Question 41

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

Question 42

At what level is the MIN_DATA_RETENSION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Question 43

What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?

Options:

A.

Faster query performance and increased storage consumption

B.

Slower query performance and increased storage consumption

C.

Faster query performance and decreased storage consumption

D.

Slower query performance and decreased storage consumption

Question 44

Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake">

Options:

A.

BUILD_SCOPED_FILE_URL

B.

GET_PRESIGNED_URL

C.

BUILD_STAGE_FILE_URL

D.

GET_STAGE_LOCATION

Question 45

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

Options:

A.

PUT

B.

INSERT

C.

COPY INTO

D.

GET

Question 46

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

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSTEMADMIN

D.

ORGADMIN

E.

USERADMIN

Question 47

Which function can be used to convert semi-structured data into rows and columns?

Options:

A.

TABLE

B.

FLATTEN

C.

PARSE_JSON

D.

JSON EXTRACT PATH TEXT

Question 48

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

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 49

Which function can be used with the copy into statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

Options:

A.

FLATTEN

B.

OBJECT_AS

C.

OBJECT_CONSTRUCT

D.

TO VARIANT

Question 50

What can be used to process unstructured data?

Options:

A.

External tables

B.

The copy into

command

C.

External functions

D.

Snowpipe

Question 51

Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?

Options:

A.

Snowsight

B.

SnowCD

C.

Snowpark

D.

SnowSQL

Question 52

What Snowflake recommendation is designed to ensure that staged data is only loaded once"?

Options:

A.

Partitioning staged data files

B.

Loading only the most recently-staged data files

C.

Removing data files after loading

D.

Identifying and removing duplicates after each data load

Question 53

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

Question 54

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

USERADMIN

Question 55

To use the overwrite option on insert, which privilege must be granted to the role?

Options:

A.

truncate

B.

DELETE

C.

UPDATE

D.

SELECT

Question 56

Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

Options:

A.

A VARIANT column is more secure than a string column

B.

A VARIANT column compresses data and a string column does not.

C.

A variant column can be used to create a data hierarchy and a string column cannot

D.

A VARIANT column will have a better query performance than a string column.

Question 57

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

Question 58

Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

Options:

A.

ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

B.

ALTER USER jsmith SET ENCRYPTED_KEY=’MIIBIjANBgkqh...';

C.

ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';

D.

ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';

Question 59

Which governance feature is supported by all Snowflake editions?

Options:

A.

Object tags

B.

Masking policies

C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Question 60

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

Options:

A.

It will return an error.

B.

It will return a warning.

C.

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

D.

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

Question 61

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?

Options:

A.

Create a view on the table.

B.

Add a clustering key to the table

C.

Add a limit clause to the query.

D.

Add a Dynamic Data Masking policy to the table.

Question 62

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 63

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

Options:

A.

Workloads with a predictable data volume for each query

B.

Workloads that include on-demand data analyses

C.

Queries with small scans and non-selective filters

D.

Queries that do not have filters or aggregation

Question 64

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

Options:

A.

The privileges cannot be revoked.

B.

The privileges can be revoked by an ACCOUNTADMIN.

C.

The privileges can be revoked by an orgadmin.

D.

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

Question 65

Which privilege is required on a virtual warehouse to abort any existing executing queries?

Options:

A.

USAGE

B.

OPERATE

C.

MODIFY

D.

MONITOR

Question 66

Which data type can be used for floating-point numbers without losing precision?

Options:

A.

BINARY

B.

VARIANT

C.

INTEGER

D.

DOUBLE

Question 67

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

Options:

A.

Fail-safe

B.

Time Travel

C.

Cloning

D.

Account replication

Question 68

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

Question 69

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

Options:

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Question 70

What is a limitation of a Materialized View?

Options:

A.

A Materialized View cannot support any aggregate functions

B.

A Materialized View can only reference up to two tables

C.

A Materialized View cannot be joined with other tables

D.

A Materialized View cannot be defined with a JOIN

Question 71

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

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Question 72

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 73

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

Options:

A.

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

B.

The replication will not be successful.

C.

The physical data is replicated

D.

Additional costs for storage are charged to a secondary account

E.

Metadata pointers to cloned tables are replicated

Question 74

Which Snowflake partner specializes in data catalog solutions?

Options:

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Question 75

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

Options:

A.

Via the Snowflake Web Interface (Ul)

B.

Via thedata_share=trueparameter

C.

Via SQL commands

D.

Via Virtual Warehouses

Question 76

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

Options:

A.

The primary cluster in the virtual warehouse

B.

The entire virtual warehouse

C.

The database in which the virtual warehouse resides

D.

The Queries currently being run on the virtual warehouse

Question 77

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

Question 78

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

Options:

A.

True

B.

False

Question 79

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

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

Options:

A.

Use multi-clustered warehousing to scale out warehouse capacity.

B.

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

C.

Stop and start the warehouse to clear the queued queries

D.

Migrate some queries to a new warehouse to reduce load

E.

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

Question 80

Which statement about billing applies to Snowflake credits?

Options:

A.

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

B.

Credits are used to pay for cloud data storage usage

C.

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

D.

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

Question 81

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

Options:

A.

True

B.

False

Question 82

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

Question 83

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

Question 84

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

Options:

A.

Load files that are approximately 25 MB or smaller.

B.

Remove all dates and timestamps.

C.

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

D.

Avoid using embedded characters such as commas for numeric data types

E.

Remove semi-structured data types

Question 85

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

Options:

A.

STATEMENT_TIMEOUT__IN__SECONDS

B.

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.

MAX_CONCURRENCY__LEVEL

D.

QUERY_TIMEOUT_IN_SECONDS

Question 86

The fail-safe retention period is how many days?

Options:

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Question 87

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

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Question 88

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Question 89

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

Question 90

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

Question 91

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

Question 92

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

Options:

A.

Clustering

B.

Indexing

C.

Fragmenting

D.

Using INDEX__HINTS

Question 93

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

Question 94

What is a responsibility of Snowflake's virtual warehouses?

Options:

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Management of the storage layer

Question 95

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

Question 96

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

Options:

A.

A User Defined Function (UDF)

B.

A stored procedure

C.

A single copy_into statement

D.

A single insert__into statement

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

Question 97

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

Question 98

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

Question 99

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

Options:

A.

Column-level security

B.

SOC 2 type II certification

C.

Multi-factor Authentication (MFA)

D.

Object-level access control

Question 100

Which copy INTO command outputs the data into one file?

Options:

A.

SINGLE=TRUE

B.

MAX_FILE_NUMBER=1

C.

FILE_NUMBER=1

D.

MULTIPLE=FAISE

Question 101

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

Question 102

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

Options:

A.

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

B.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

C.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Question 103

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

Question 104

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

Question 105

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

Options:

A.

Clustering

B.

Materialized Views

C.

Zero-copy Cloning

D.

Search Optimization Service

Question 106

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Options:

A.

30 days

B.

7 days

C.

48 hours

D.

24 hours

Question 107

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Options:

A.

Data is live, ready-to-query, and can be personalized.

B.

Data needs to be loaded into a cloud provider as a consumer account.

C.

Data is not available for copying or moving to an individual Snowflake account.

D.

Data is available without copying or moving.

E.

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Question 108

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Options:

A.

The explain plan output is available graphically.

B.

An explain plan can be used to conduct performance analysis without executing a query.

C.

An explain plan will handle queries with temporary tables and the query profiler will not.

D.

An explain plan's output will display automatic data skew optimization information.

Question 109

What is the default file size when unloading data from Snowflake using the COPY command?

Options:

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Question 110

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 111

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

How can this be accomplished?

Options:

A.

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

B.

The transient table version cannot be retrieved after 24 hours.

C.

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

D.

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

Question 112

Which statement is true about running tasks in Snowflake?

Options:

A.

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

B.

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

C.

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

D.

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

Question 113

What is the purpose of multi-cluster virtual warehouses?

Options:

A.

To create separate data warehouses to increase query optimization

B.

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

C.

To eliminate or reduce Queuing of concurrent queries

D.

To allow the warehouse to resize automatically

Question 114

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

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Question 115

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

Options:

A.

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 30 days.

Fail Safe retention time is 1 day.

B.

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 365 days.

Fail Safe retention time is 7 days.

C.

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

D.

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

E.

Default Time Travel Retention is set to 7 days.

Maximum Time Travel Retention is 1 day.

Fail Safe retention time is 90 days.

F.

Default Time Travel Retention is set to 90 days.

Maximum Time Travel Retention is 7 days.

Fail Safe retention time is 356 days.

Question 116

A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Options:

A.

view @my_stage

B.

list @my_stage

C.

show @my_stage

D.

display @my_stage

Question 117

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

Options:

A.

Removing a column from the query SELECT list

B.

Stopping the virtual warehouse that the query is running against

C.

Clustering of the data used by the query

D.

Executing the RESULTS_SCAN() table function

E.

Changing a column that is not in the cached query

Question 118

Which of the following describes a Snowflake stored procedure?

Options:

A.

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

B.

They can only access tables from a single database.

C.

They can contain only a single SQL statement.

D.

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

Question 119

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

Options:

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Question 120

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

Question 121

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

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Question 122

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.

Question 123

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

Options:

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Question 124

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

Options:

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Question 125

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

Which SQL command should be used to delete the files?

Options:

A.

PURGE

B.

MODIFY

C.

REMOVE

D.

DELETE

Question 126

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

Options:

A.

Identifying queries that will likely run very slowly before executing them

B.

Locating queries that consume a high amount of credits

C.

Identifying logical issues with the queries

D.

Identifying inefficient micro-partition pruning

E.

Data spilling to a local or remote disk

Question 127

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

Options:

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

Question 128

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Options:

A.

Use the DROP command after the load completes.

B.

Specify the TEMPORARY option when creating the file format.

C.

Specify the PURGE copy option in the COPY INTO

command.

D.

Use the REMOVE command after the load completes.

E.

Use the DELETE LOAD HISTORY command after the load completes.

 command, which will automatically delete the files after they have been successfully loaded. Additionally, you can use the REMOVE command after the load completes to manually delete the files from the stage12.

References = DROP STAGE, REMOVE

Question 129

What type of query benefits the MOST from search optimization?

Options:

A.

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

B.

A query that includes analytical expressions

C.

A query that uses equality predicates or predicates that use IN

D.

A query that filters on semi-structured data types

Question 130

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.

Question 131

Which command sets the Virtual Warehouse for a session?

Options:

A.

COPY WAREHOUSE FROM <>;

B.

SET WAREHOUSE = <>;

C.

USE WAREHOUSE <>;

D.

USE VIRTUAL_WAREHOUSE <>;

Question 132

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Options:

A.

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.

When the data cache is full, the least-recently used data will be cleared to make room.

C.

A user can only access their own queries from the query result cache.

D.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Question 133

Which of the following accurately describes shares?

Options:

A.

Tables, secure views, and secure UDFs can be shared

B.

Shares can be shared

C.

Data consumers can clone a new table from a share

D.

Access to a share cannot be revoked once granted

Question 134

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

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Question 135

What is true about sharing data in Snowflake? (Choose two.)

Options:

A.

The Data Consumer pays for data storage as well as for data computing.

B.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C.

A Snowflake account can both provide and consume shared data.

D.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E.

The Data Consumer pays only for compute resources to query the shared data.

Question 136

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Options:

A.

Compress the file and load the compressed file.

B.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.

Use a larger-sized warehouse.

D.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Question 137

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

Options:

A.

FOR

B.

LOOP

C.

REPEAT

D.

WHILE

Question 138

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

Options:

A.

Tag

B.

Task

C.

Stream

D.

Stored procedure

Question 139

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 140

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

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Question 141

What does a masking policy consist of in Snowflake?

Options:

A.

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

B.

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

C.

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

D.

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

Question 142

How can performance be optimized for a query that returns a small amount of data from a very large base table?

Options:

A.

Use clustering keys

B.

Create materialized views

C.

Use the search optimization service

D.

Use the query acceleration service

Question 143

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

Options:

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Question 144

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

Options:

A.

Queries without filters or aggregation

B.

Queries with large scans and selective filters

C.

Queries where the GROUP BY has high cardinality

D.

Queries of tables that have search optimization service enabled

Question 145

How can a Snowflake user traverse semi-structured data?

Options:

A.

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

B.

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

C.

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

Question 146

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

Options:

A.

It removes null values from all columns in the data.

B.

It converts null values to empty strings during loading.

C.

It skips rows with null values during the loading process.

D.

It removes object or array elements containing null values.

Question 147

What is a characteristic of materialized views in Snowflake?

Options:

A.

Materialized views do not allow joins.

B.

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

C.

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

D.

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

Question 148

A Snowflake account has activated federated authentication.

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

Options:

A.

The user will be unable to enter a password.

B.

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

C.

The user will be able to log into Snowflake successfully.

D.

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

Question 149

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

Options:

A.

ARRAY

B.

BLOB

C.

CLOB

D.

JSON

E.

VARIANT

Question 150

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

Question 151

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

Question 152

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

Options:

A.

Temporary tables

B.

Permanent tables

C.

Transient tables

D.

External tables

E.

User-Defined Table Functions (UDTFs)

Question 153

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

Question 154

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

Options:

A.

TO_CHAR

B.

TO_VARIANT

C.

TO_VARCHAR

D.

STRIP NULL VALUE

Question 155

Which operation can be performed on Snowflake external tables?

Options:

A.

INSERT

B.

JOIN

C.

RENAME

D.

ALTER

Question 156

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

Question 157

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)

Question 158

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

Options:

A.

ACCESS_HISTORY

B.

DATA_TRANSFER_HISTORY

C.

WAREHOUSE_METERING_HISTORY

D.

MONETIZED_USAGE_DAILY

E.

LISTING TELEMETRY DAILY

Question 159

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

Options:

A.

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

B.

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

C.

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

D.

All explicit child object retention periods will remain unchanged.

Question 160

Which Snowflake object does not consume any storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Question 161

How is unstructured data retrieved from data storage?

Options:

A.

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

B.

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

C.

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

D.

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

Question 162

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Options:

A.

Account

B.

Database

C.

Schema

D.

Table

Question 163

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

Options:

A.

OAuth

B.

Network policies

C.

Single Sign-On (SSO)

D.

Multi-Factor Authentication (MFA)

Question 164

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

Options:

A.

Bytes scanned

B.

Bytes written to result

C.

Partitions scanned

D.

Partitions total

E.

Percentage scanned from cache

Question 165

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

Options:

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Question 166

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.

Question 167

What step can reduce data spilling in Snowflake?

Options:

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

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

Question 168

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

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

Options:

A.

CREATE TABLE LIKE TABLE_A;

B.

CREATE VIEW AS SELECT * FROM TABLE_A;

C.

CREATE TABLE AS SELECT * FROM TABLE_A;

D.

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

Question 169

What is the purpose of the Snowflake SPLIT TO_TABLE function?

Options:

A.

To count the number of characters in a string

B.

To split a string into an array of sub-strings

C.

To split a string and flatten the results into rows

D.

To split a string and flatten the results into columns

Question 170

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

Options:

A.

Add and remove members.

B.

Delete data categories.

C.

Approve and deny listing approval requests.

D.

Transfer listing ownership.

E.

Transfer ownership of a provider profile.

Question 171

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

Options:

A.

SHOW GRANTS ON ROLE

B.

SHOW ROLES

C.

SHOW GRANTS TO ROLE

D.

SHOW GRANTS FOR ROLE

Question 172

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

Question 173

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

Question 174

What information does the Query Profile provide?

Options:

A.

Graphical representation of the data model

B.

Statistics for each component of the processing plan

C.

Detailed Information about I he database schema

D.

Real-time monitoring of the database operations

Question 175

Which URL provides access to files in Snowflake without authorization?

Options:

A.

File URL

B.

Scoped URL

C.

Pre-signed URL

D.

Scoped file URL

Question 176

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

Options:

A.

Binary file in Avro

B.

Binary file in Parquet

C.

Comma-separated JSON

D.

Newline Delimited JSON

E.

Plain text file containing XML elements

Question 177

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.

Question 178

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.

Question 179

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.

Question 180

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

Options:

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Question 181

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

Question 182

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.

Question 183

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

Question 184

Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

Options:

A.

GET_STATE_LOCATION

B.

GET_PRESENT_URL

C.

BUILD_SCOPED_FILE_URL

D.

BUILD_STAGE_FILE_URL

Question 185

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

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Question 186

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

Options:

A.

ARRAY

B.

CHARACTER

C.

STRING

D.

VARCHAR

E.

VARIANT

Question 187

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

Options:

A.

Create an account for an organization.

B.

Edit the account data for an organization.

C.

Delete the account data for an organization.

D.

View usage information for all accounts in an organization.

E.

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

Question 188

What does the TableScan operator represent in the Query Profile?

Options:

A.

The access to a single table

B.

The access to data stored in stage objects

C.

The list of values provided with the VALUES clause

D.

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

Question 189

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

Question 190

Which Snowflow object does not consume and storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Question 191

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

Question 192

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

Options:

A.

SYSTEMADMIN_TAG

B.

SYSTEM$GET_PRIVATELINK

C.

SYSTEMSALLONTLIST

D.

SYSTEMAUTHORIZE

Question 193

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

Question 194

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

Options:

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Question 195

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

Options:

A.

(12,2)

B.

(10,4)

C.

(14,8)

D.

(15,9)

Question 196

How are network policies defined in Snowflake?

Options:

A.

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

B.

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

C.

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

D.

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

to Snowflake.

Question 197

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

Options:

A.

MODIFY

B.

READ

C.

SELECT

D.

USAGE

Question 198

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.

Question 199

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

Question 200

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

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 201

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

Page: 1 / 67
Total 671 questions