Winter Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

SnowPro-Core PDF

$38.5

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

SnowPro-Core PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

  • Exam Name: SnowPro Core Certification Exam
  • Last Update: Feb 14, 2025
  • Questions and Answers: 605
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

SnowPro-Core Engine

$46.2

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

SnowPro-Core Practice Exam Questions with Answers SnowPro Core Certification Exam Certification

Question # 6

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

A.

GRANT

B.

SELECT

C.

MODIFY

D.

OWNERSHIP

E.

CREATE USER

Full Access
Question # 7

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

A.

10

B.

50

C.

64

D.

256

Full Access
Question # 8

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

A.

TABLES

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STORAGE USAGE

Full Access
Question # 9

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

A.

A VARIANT column

B.

A column with very low cardinality

C.

A column with very high cardinality

D.

A column that is most actively used in selective filters

E.

A column that is most actively used in join predicates

Full Access
Question # 10

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

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

Full Access
Question # 11

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

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Full Access
Question # 12

Authorization to execute CREATE statements comes only from which role?

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Full Access
Question # 13

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

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.

Full Access
Question # 14

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

A.

READ

B.

REFERENCES

C.

REFERENCEJJSAGE

D.

USAGE

Full Access
Question # 15

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

A.

Authy

B.

Duo Security

C.

One Login

D.

RSA SecurlD Access

Full Access
Question # 16

Which statement accurately describes a characteristic of a materialized view?

A.

A materialized view can query only a single table.

B.

Data accessed through materialized views can be stale.

C.

Materialized view refreshes need to be maintained by the user.

D.

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

Full Access
Question # 17

Which Snowflake edition enables data sharing only through Snowflake Support?

A.

Virtual Private Snowflake

B.

Business Critical

C.

Enterprise

D.

Standard

Full Access
Question # 18

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

A.

USAGE

B.

OPERATE

C.

MODIFY

D.

MONITOR

Full Access
Question # 19

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

A.

Fail-safe

B.

Network policies

C.

End-to-end encryption

D.

Multi-Factor Authentication (MFA)

Full Access
Question # 20

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?

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.

Full Access
Question # 21

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

A.

Roles

B.

Databases

C.

Warehouses

D.

Users

E.

Accounts

Full Access
Question # 22

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

A.

Create a view.

B.

Cluster a table.

C.

Enable the search optimization service.

D.

Enable Time Travel.

E.

Index a table.

Full Access
Question # 23

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

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

Full Access
Question # 24

What is the difference between a stored procedure and a User-Defined Function (UDF)?

A.

Stored procedures can execute database operations while UDFs cannot.

B.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

C.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

D.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Full Access
Question # 25

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

A.

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

B.

When managing a steady workload

C.

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

D.

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

E.

When the warehouse is shared across different teams

Full Access
Question # 26

Which stream type can be used for tracking the records in external tables?

A.

Append-only

B.

External

C.

Insert-only

D.

Standard

Full Access
Question # 27

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

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

Full Access
Question # 28

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

A.

7 days

B.

14 days

C.

28 days

D.

365 days

Full Access
Question # 29

Which Snowflake URL type is used by directory tables?

A.

File

B.

Pre-signed

C.

Scoped

D.

Virtual-hosted style

Full Access
Question # 30

How would a user run a multi-cluster warehouse in maximized mode?

A.

Configure the maximum clusters setting to "Maximum."

B.

Turn on the additional clusters manually after starting the warehouse.

C.

Set the minimum Clusters and maximum Clusters settings to the same value.

D.

Set the minimum clusters and maximum clusters settings to different values.

Full Access
Question # 31

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

A.

Directory

B.

External

C.

Temporary

D.

Transient

Full Access
Question # 32

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

A.

1 minute

B.

2 minutes

C.

6 minutes

D.

8 minutes

Full Access
Question # 33

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

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

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

Full Access
Question # 34

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

A.

FLATTEN

B.

CHECK_JSON

C.

PARSE_JSON

D.

TO_VARIANT

Full Access
Question # 35

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

A.

SYSTEMADMIN_TAG

B.

SYSTEM$GET_PRIVATELINK

C.

SYSTEMSALLONTLIST

D.

SYSTEMAUTHORIZE

Full Access
Question # 36

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

A.

Range of values

B.

Distinct values

C.

Index values

D.

Sorted values

E.

Null values

Full Access
Question # 37

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

A.

COPY INTO

B.

GET

C.

INSERT INTO

D.

PUT

Full Access
Question # 38

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

A.

SHOW GRANTS ON ROLE

B.

SHOW ROLES

C.

SHOW GRANTS TO ROLE

D.

SHOW GRANTS FOR ROLE

Full Access
Question # 39

What does the LATERAL modifier for the FLATTEN function do?

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

Full Access
Question # 40

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

A.

OAuth

B.

Network policies

C.

Single Sign-On (SSO)

D.

Multi-Factor Authentication (MFA)

Full Access
Question # 41

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

A.

A user with an USERADMIN or higher role

B.

A user with a SECURITYADMIN or higher role

C.

A role that has been granted the ATTACH POLICY privilege

D.

A role that has the NETWORK_POLlCY account parameter set

E.

A role that has the ownership of the network policy

Full Access
Question # 42

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

A.

FLATTEN

B.

GET_PATH

C.

CHECK_JSON

D.

PARSE JSON

Full Access
Question # 43

What is a characteristic of materialized views in Snowflake?

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.

Full Access
Question # 44

What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).

A.

Column reordering

B.

Column omission

C.

JOIN function

D.

FLATTEN function

E.

GROUP BY function

Full Access
Question # 45

What is the purpose of a Query Profile?

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.

Full Access
Question # 46

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

A.

CREATE STAGE

B.

COPY INTO <table>

C.

COPY INTO

D.

CREATE PIPE

Full Access
Question # 47

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?

A.

File URL

B.

Scoped URL

C.

Relative URL

D.

Pre-Signed URL

Full Access
Question # 48

Which function unloads data from a relational table to JSON?

A.

TO_OBJECT

B.

TO_JSON

C.

TO_VARIANT

D.

OBJECT CONSTRUCT

Full Access
Question # 49

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

A.

TO_CHAR

B.

TO_VARIANT

C.

TO_VARCHAR

D.

STRIP NULL VALUE

Full Access
Question # 50

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

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Full Access
Question # 51

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

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Full Access
Question # 52

Which Snowflake object does not consume any storage costs?

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Full Access
Question # 53

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

A.

Network policy

B.

End-to-end encryption

C.

Multi-Factor Authentication (MFA)

D.

Role-Based Access Control (RBAC)

Full Access
Question # 54

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

A.

Temporary table

B.

External table

C.

Secure view

D.

Materialized view

Full Access
Question # 55

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

A.

INTEGER

B.

OBJECT

C.

VARIANT

D.

VARCHAR

E.

LIST

Full Access
Question # 56

Which statement accurately describes Snowflake's architecture?

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.

Full Access
Question # 57

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?

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.

Full Access
Question # 58

Which use case does the search optimization service support?

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

Full Access
Question # 59

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

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.

Full Access
Question # 60

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

A.

(12,2)

B.

(10,4)

C.

(14,8)

D.

(15,9)

Full Access
Question # 61

How are network policies defined in Snowflake?

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.

Full Access
Question # 62

What type of function returns one value for each Invocation?

A.

Aggregate

B.

Scalar

C.

Table

D.

Window

Full Access
Question # 63

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

A.

Disaster recovery

B.

Time Travel

C.

Fail-safe

D.

Database failover and fallback

E.

Data security

Full Access
Question # 64

Which Snowflake layer is associated with virtual warehouses?

A.

Cloud services

B.

Query processing

C.

Elastic memory

D.

Database storage

Full Access
Question # 65

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

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

Full Access
Question # 66

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

A.

View

B.

Secure view

C.

Materialized view

D.

External table

Full Access
Question # 67

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

A.

Last_QUERY_ID

B.

CURRENT_STATEMENT

C.

UUID_STRING

D.

JOB_ID

Full Access
Question # 68

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

How will those object names be resolved during execution?

A.

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.

Snowflake will only check the schema the UDF belongs to.

C.

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

D.

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

Full Access
Question # 69

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

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.

Full Access
Question # 70

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

A.

60 minutes

B.

24 hours

C.

14 days

D.

30 days

Full Access
Question # 71

What does the TableScan operator represent in the Query Profile?

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

Full Access
Question # 72

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

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.

Full Access
Question # 73

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

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.

Full Access
Question # 74

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

A.

Caching

B.

Cluster depth

C.

Query pruning

D.

Retrieval optimization

Full Access
Question # 75

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

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Full Access
Question # 76

What information does the Query Profile provide?

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

Full Access
Question # 77

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?

A.

60

B.

91

C.

120

D.

121

Full Access
Question # 78

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

A.

Hierarchical key model

B.

Client-side encryption

C.

Tri-secret secure encryption

D.

Key pair authentication

Full Access
Question # 79

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

A.

LIST

B.

ALTER FILE FORMAT

C.

DESCRIBE FILE FORMAT

D.

SHOW FILE FORMATS

Full Access
Question # 80

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

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Full Access
Question # 81

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?

A.

60

B.

91

C.

120

D.

121

Full Access
Question # 82

How do Snowflake data providers share data that resides in different databases?

A.

External tables

B.

Secure views

C.

Materialized views

D.

User-Defined Functions (UDFs)

Full Access
Question # 83

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

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.

Full Access
Question # 84

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

A.

ROW_NUMBER

B.

TABLE

C.

TABULAR

D.

VALUES

Full Access
Question # 85

What are characteristics of Snowflake network policies? (Select TWO).

A.

They can be set for any Snowflake Edition.

B.

They can be applied to roles.

C.

They restrict or enable access to specific IP addresses.

D.

They are activated using ALTER DATABASE SQL commands.

E.

They can only be managed using the ORGADMIN role.

Full Access
Question # 86

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?

A.

Source_column.element[1]:name

B.

Source_column.element[0]:name

C.

Source_column.element[1].name

D.

Source_column.element[0]:name

Full Access
Question # 87

Which types of subqueries does Snowflake support? (Select TWO).

A.

Uncorrelated scalar subqueries in WHERE clauses

B.

Uncorrelated scalar subqueries in any place that a value expression can be used

C.

EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

D.

EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

E.

EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

Full Access
Question # 88

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

A.

Access History

B.

Data classification

C.

Column-level security

D.

Object dependencies

Full Access
Question # 89

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

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.

Full Access
Question # 90

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

A.

USAGE on the specific tables in the database.

B.

USAGE on the specific tables in the database.

C.

MODIFY on 1Mb specific tables in the database.

D.

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

E.

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

Full Access
Question # 91

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

A.

Avro

B.

JSON

C.

TSV

D.

Parquet

Full Access
Question # 92

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

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.

Full Access
Question # 93

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

A.

Area chart

B.

Box plot

C.

Heat grid

D.

Pie chart

Full Access
Question # 94

What is the default access of a securable object until other access is granted?

A.

No access

B.

Read access

C.

Write access

D.

Full access

Full Access
Question # 95

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

A.

1 Kilobyte (KB)

B.

1 Megabyte (MB)

C.

1 Gigabyte (GB)

D.

1 Terabyte (TB)

Full Access
Question # 96

The following settings are configured:

SnowPro-Core question answer

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

A.

2

B.

3

C.

5

D.

7

Full Access
Question # 97

Which Snowflake table supports unstructured data?

A.

Directory

B.

Transient

C.

Temporary

D.

Permanent

Full Access
Question # 98

Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

A.

DELETE

B.

DROP

C.

REMOVE

D.

TRUNCATE

Full Access
Question # 99

Which governance feature is supported by all Snowflake editions?

A.

Object tags

B.

Masking policies

C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Full Access
Question # 100

A user wants to access stored in a stage without authenticating into Snowflake.

Which type of URL should be used?

A.

File URL

B.

Staged URL

C.

Scoped URL

D.

Pre-signed URL

Full Access
Question # 101

Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

A.

APPROXIMATE_SIMILARITY

B.

JAROWINKLER_SIMILARITY

C.

APPROXIMATE_JACCARD_INDEX

D.

MINHASH COMBINE

Full Access
Question # 102

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

A.

TASK_HISTORY

B.

TASK_DEPENDENTS

C.

CURRENT_TASK_GRAPHS

D.

COMPLETE_TASK_GRAPHS

Full Access
Question # 103

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

A.

Area charts

B.

Bar charts

C.

Column charts

D.

Radar charts

E.

Scorecards

Full Access
Question # 104

What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

A.

The ACCCUKTMKIN role should be set as tie user's default role.

B.

The user should use federated authentication instead of a password

C.

The user should be required to use Multi-Factor Authentication (MFA).

D.

There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

Full Access
Question # 105

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

A.

Data provider

B.

Data consumer

C.

Reader

D.

Organization

Full Access
Question # 106

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

A.

Grant

B.

Privilege

C.

Role

D.

Session

Full Access
Question # 107

What command is used to export or unload data from Snowflake?

A.

PUT @mystage

B.

GET @mystage

C.

COPY INTO @mystage

D.

INSERT @mystage

Full Access
Question # 108

In which hierarchy is tag inheritance possible?

A.

Organization » Account» Role

B.

Account » User » Schema

C.

Database » View » Column

D.

Schema » Table » Column

Full Access
Question # 109

The property mins_to_bypass_network_policy is set at which level?

A.

User

B.

Role

C.

Account

D.

Organization

Full Access
Question # 110

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

A.

Data backups

B.

Cost monitoring

C.

Compliance auditing

D.

Performance optimization

Full Access
Question # 111

When does a materialized view get suspended in Snowflake?

A.

When a column is added to the base table

B.

When a column is dropped from the base table

C.

When a DML operation is run on the base table

D.

When the base table is reclustered

Full Access
Question # 112

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

How can this be achieved?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 113

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

A.

SELECT

B.

OWNERSHIP

C.

MONITOR

D.

MODIFY

E.

USAGE

Full Access
Question # 114

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

A.

DATABASE_STORAGE_USAGE_HISTORY

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STAGE STORAGE USAGE HISTORY

Full Access
Question # 115

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

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.

Full Access
Question # 116

What does a masking policy consist of in Snowflake?

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

Full Access
Question # 117

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

A.

Bytes scanned

B.

Bytes written to result

C.

Partitions scanned

D.

Partitions total

E.

Percentage scanned from cache

Full Access
Question # 118

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 119

Which operation can be performed on Snowflake external tables?

A.

INSERT

B.

JOIN

C.

RENAME

D.

ALTER

Full Access
Question # 120

What information is found within the Statistic output in the Query Profile Overview?

A.

Operator tree

B.

Table pruning

C.

Most expensive nodes

D.

Nodes by execution time

Full Access
Question # 121

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

A.

Load the data into a CSV file.

B.

Load the data into a relational table.

C.

Use the VALlDATlON_MODE - SQL statement.

D.

Use the validation mode = return rows statement.

Full Access
Question # 122

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

A.

Access history

B.

Data classification

C.

Dynamic Data Masking

D.

Object tagging

Full Access
Question # 123

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

A.

MONITOR

B.

OPERATE

C.

OWNERSHIP

D.

ALL

Full Access
Question # 124

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

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.

Full Access
Question # 125

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?

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;

Full Access
Question # 126

When unloading to a stage, which of the following is a recommended practice or approach?

A.

Set SINGLE: = true for larger files

B.

Use OBJECT_CONSTRUCT ( * ) when using Parquet

C.

Avoid the use of the CAST function

D.

Define an individual file format

Full Access
Question # 127

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

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Full Access
Question # 128

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

A.

Standard

B.

Premium

C.

Enterprise

D.

Business Critical

Full Access
Question # 129

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

A.

True

B.

False

Full Access
Question # 130

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

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Full Access
Question # 131

Which of the following describes external functions in Snowflake?

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

Full Access
Question # 132

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

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.

Full Access
Question # 133

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

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.

Full Access
Question # 134

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 135

What is a responsibility of Snowflake's virtual warehouses?

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Management of the storage layer

Full Access
Question # 136

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

A.

VARIANT

B.

ARRAY

C.

VARCHAR

D.

XML

E.

BLOB

Full Access
Question # 137

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

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Full Access
Question # 138

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

A.

SCIM

B.

Federated authentication

C.

TLS 1.2

D.

Key-pair authentication

E.

OAuth

F.

OCSP authentication

Full Access
Question # 139

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

A.

Bytes scanned

B.

Bytes sent over the network

C.

Number of partitions scanned

D.

Percentage scanned from cache

E.

External bytes scanned

Full Access
Question # 140

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

A.

Metadata cache

B.

Result cache

C.

Remote cache

D.

Local file cache

Full Access
Question # 141

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?

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Full Access
Question # 142

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

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

Full Access
Question # 143

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

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

Full Access
Question # 144

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

A.

STATEMENT_TIMEOUT__IN__SECONDS

B.

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.

MAX_CONCURRENCY__LEVEL

D.

QUERY_TIMEOUT_IN_SECONDS

Full Access
Question # 145

Which Snowflake partner specializes in data catalog solutions?

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Full Access
Question # 146

How long is Snowpipe data load history retained?

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Full Access
Question # 147

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

A.

True

B.

False

Full Access
Question # 148

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

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Full Access
Question # 149

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

A.

list @mytable;

B.

list @%raytable;

C.

list @ %m.ystage;

D.

list @mystage;

Full Access
Question # 150

What happens when a virtual warehouse is resized?

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

Full Access
Question # 151

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

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

Full Access
Question # 152

How often are encryption keys automatically rotated by Snowflake?

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

Full Access
Question # 153

What is a best practice after creating a custom role?

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

Full Access
Question # 154

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

A.

CSV (Unzipped)

B.

Parquet

C.

CSV (Gzipped)

D.

ORC

Full Access
Question # 155

Where would a Snowflake user find information about query activity from 90 days ago?

A.

account__usage . query history view

B.

account__usage.query__history__archive View

C.

information__schema . cruery_history view

D.

information__schema - query history_by_ses s i on view

Full Access
Question # 156

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?

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.

Full Access
Question # 157

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

A.

XML

B.

JSON

C.

Parquet

D.

ORC

E.

AVRO

F.

CSV

Full Access
Question # 158

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

A.

Amazon Web Services

B.

Docker

C.

IBM Cloud

D.

Microsoft Azure Cloud

E.

Google Cloud Platform

F.

Oracle Cloud

Full Access
Question # 159

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

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.

Full Access
Question # 160

What is the following SQL command used for?

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

A.

To validate external table files in table t1 across all sessions

B.

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

C.

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

D.

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

Full Access
Question # 161

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

A.

When it is unknown how much compute power is needed

B.

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

C.

If the runtime of the executed query is very slow

D.

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

Full Access
Question # 162

How many days is load history for Snowpipe retained?

A.

1 day

B.

7 days

C.

14 days

D.

64 days

Full Access
Question # 163

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

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Full Access
Question # 164

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

A.

10-50 MB

B.

100-250 MB

C.

300-500 MB

D.

1000-1500 MB

Full Access
Question # 165

A user is preparing to load data from an external stage

Which practice will provide the MOST efficient loading performance?

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

Full Access
Question # 166

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

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

Full Access
Question # 167

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

A.

1 day

B.

7 days

C.

12 hours

D.

0 days

Full Access
Question # 168

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

A.

JOIN

B.

COPY INTO

C.

PUT

D.

GET

Full Access
Question # 169

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

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

Full Access
Question # 170

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

A.

ORGADMIN

B.

SECURITYADMIN

C.

SHAREADMIN

D.

ACCOUNTADMIN

Full Access
Question # 171

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

A.

Clustering

B.

Materialized Views

C.

Zero-copy Cloning

D.

Search Optimization Service

Full Access
Question # 172

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

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Full Access
Question # 173

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?

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Full Access
Question # 174

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

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.

Full Access
Question # 175

Which of the following accurately describes shares?

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

Full Access
Question # 176

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

A.

Authentication

B.

Resource management

C.

Virtual warehouse caching

D.

Query parsing and optimization

E.

Query execution

F.

Physical storage of micro-partitions

Full Access
Question # 177

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

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

SnowPro-Core question answer

What action should be taken to address this situation?

A.

Increase the warehouse size from Medium to 2XL.

B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.

Configure the warehouse to a multi-cluster warehouse.

D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Full Access
Question # 178

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

A.

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

B.

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

C.

The ACCOUNTADMIN role must be granted to only one user.

D.

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

E.

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

Full Access
Question # 179

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

A.

SINGLE=TRUE

B.

MULTIPLE=TRUE

C.

MULTIPLE=FALSE

D.

SINGLE=FALSE

Full Access
Question # 180

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

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Full Access
Question # 181

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

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

Full Access