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

Examstrust Logo
examstrust mcafee
  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. SnowPro-Core - SnowPro Core Certification Exam

Snowflake SnowPro-Core SnowPro Core Certification Exam Exam Practice Test

Page: 1 / 43
Total 427 questions
Get SnowPro-Core Full Access Download SnowPro-Core PDF

SnowPro Core Certification Exam Questions and Answers

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$59.5  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$42  $119.99
Add to Cart

PDF Study Guide

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

Which statement describes how Snowflake supports reader accounts?

Options:

A.

A reader account can consume data from the provider account that created it and combine it with its own data.

B.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Question 2

What role is required to use Partner Connect?

Options:

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

Question 3

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 4

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

Options:

A.

@

B.

&

C.

$

D.

#

Question 5

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Question 6

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

Options:

A.

Modify the columns in the underlying table

B.

Use the ALTER VIEW command to update the view

C.

Recreate the view with the required changes

D.

Materialize the view to perform the changes

Question 7

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 8

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

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

Options:

A.

Rename listings.

B.

Delete provider profiles.

C.

Modify listings properties.

D.

Modify incoming listing access requests.

E.

Submit listings for approval/publishing.

Question 9

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 10

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

Options:

A.

In the metadata of the target table for 14 days

B.

In the metadata of the pipe for 14 days

C.

In the metadata of the target table for 64 days

D.

In the metadata of the pipe for 64 days

Question 11

How can a user improve the performance of a single large complex query in Snowflake?

Options:

A.

Scale up the virtual warehouse.

B.

Scale out the virtual warehouse.

C.

Enable standard warehouse scaling.

D.

Enable economy warehouse scaling.

Question 12

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Options:

A.

Grant the OWNERSHIP privilege on the schema.

B.

Grant the OWNERSHIP privilege on the database.

C.

Grant the MANAGE GRANTS global privilege.

D.

Grant ALL privileges on the schema.

Question 13

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Options:

A.

The clone always stays in sync with the original table.

B.

The clone has better query performance.

C.

The clone is created almost instantly.

D.

The clone will have time travel history from the original table.

E.

The clone saves space by not duplicating storage.

Question 14

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Options:

A.

CHECK_OPTION

B.

IS_SECURE

C.

IS_UPDATEABLE

D.

TABLE_NAME

Question 15

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

Options:

A.

Authy

B.

Duo Security

C.

One Login

D.

RSA SecurlD Access

Question 16

Which statement MOST accurately describes clustering in Snowflake?

Options:

A.

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

B.

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

C.

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

D.

Clustering can be disabled within a Snowflake account.

Question 17

What is the MAXIMUM Time Travel retention period for a transient table?

Options:

A.

O days

B.

1 day

C.

7 days

D.

90 days

Question 18

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 19

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 20

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

Options:

A.

Create objects with ACCOUNTADMIN and do not reassign ownership.

B.

Create objects with SYSADMIN.

C.

Create objects with SECURITYADMIN to ease granting of privileges later.

D.

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

E.

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Question 21

Which statement accurately describes a characteristic of a materialized view?

Options:

A.

A materialized view can query only a single table.

B.

Data accessed through materialized views can be stale.

C.

Materialized view refreshes need to be maintained by the user.

D.

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

Question 22

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 23

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

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Question 24

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

Options:

A.

USAGE

B.

OPERATE

C.

MONITOR

D.

OWNERSHIP

Question 25

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

Options:

A.

External tables

B.

Secure views

C.

Materialized views

D.

User-Defined Functions (UDFs)

Question 26

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

Options:

A.

GRANT ROLE MYROLE TO USER USER1;

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

B.

GRANT ROLE MYROLE TO USER USER1;

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

C.

GRANT ROLE MYROLE TO USER USER1;

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

D.

GRANT ROLE MYROLE TO USER USER1;

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

Question 27

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 28

Which parameter prevents streams on tables from becoming stale?

Options:

A.

MAXDATAEXTENSIONTIMEINDAYS

B.

MTN_DATA_RETENTION_TTME_TN_DAYS

C.

LOCK_TIMEOUT

D.

STALE_AFTER

Question 29

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

Options:

A.

ROW_NUMBER

B.

TABLE

C.

TABULAR

D.

VALUES

Question 30

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

Options:

A.

Determine the total duration of the query.

B.

Determine the role of the user who ran the query.

C.

Determine the source system that the queried table is from.

D.

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

Question 31

Which role has the ability to create and manage users and roles?

Options:

A.

ORGADMIN

B.

USERADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Question 32

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 33

What happens when a virtual warehouse is resized?

Options:

A.

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

B.

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

C.

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

D.

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

Question 34

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

Options:

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Question 35

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Question 36

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 37

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 38

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

Options:

A.

True

B.

False

Question 39

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 40

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

Options:

A.

Users

B.

Tables

C.

Databases

D.

Internal Stages

Question 41

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

Options:

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Question 42

What is a key feature of Snowflake architecture?

Options:

A.

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

B.

Software updates are automatically applied on a quarterly basis

C.

Snowflake eliminates resource contention with its virtual warehouse implementation

D.

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

E.

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

Question 43

What data is stored in the Snowflake storage layer? (Select TWO).

Options:

A.

Snowflake parameters

B.

Micro-partitions

C.

Query history

D.

Persisted query results

E.

Standard and secure view results

Question 44

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

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Question 45

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Question 46

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Options:

A.

Data can be filtered by an optional where clause

B.

Incoming data can be joined with other tables

C.

Columns can be reordered

D.

Columns can be omitted

E.

Row level access can be defined

Question 47

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 48

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

Options:

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

Question 49

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 50

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 51

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 52

What features does Snowflake Time Travel enable?

Options:

A.

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

B.

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

C.

Conducting point-in-time analysis for Bl reporting

D.

Analyzing data usage/manipulation over all periods of time

Question 53

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 54

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 55

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

Options:

A.

Micro-partitions cannot overlap in their range of values

B.

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

C.

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

D.

Rows are automatically stored in sorted order within micro-partitions

E.

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

Question 56

Which Snowflake partner specializes in data catalog solutions?

Options:

A.

Alation

B.

DataRobot

C.

dbt

D.

Tableau

Question 57

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 58

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 59

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

Options:

A.

True

B.

False

Question 60

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

Options:

A.

True

B.

False

Question 61

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 62

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

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Question 63

Which object type is granted permissions for reading a table?

Options:

A.

User

B.

Role

C.

Attribute

D.

Schema

Question 64

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

Options:

A.

Schedule automated data backups.

B.

Explore each step of an executed query.

C.

Monitor queries executed by users in an account.

D.

Create and manage user roles and permissions.

E.

Access Snowflake Marketplace to find and integrate datasets.

Question 65

The following settings are configured:

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

Options:

A.

2

B.

3

C.

5

D.

7

Question 66

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

Options:

A.

Set the WAREHOUSES_SIZE to 6XL.

B.

Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.

C.

Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.

D.

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Question 67

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

Options:

A.

Permanent

B.

Transient

C.

Temporary

D.

Externa

Question 68

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 69

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

Options:

A.

The type of SQL statements executed

B.

The number of tables or databases queried

C.

The amount of data stored in the warehouse

D.

The length of time the compute resources in each cluster run

Question 70

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

GRANT ON To SHARE ;

Options:

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Question 71

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

Options:

A.

Access History

B.

Data classification

C.

Column-level security

D.

Object dependencies

Question 72

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 73

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 74

Which command can be used to list all network policies available in an account?

Options:

A.

DESCRIBE SESSION POLICY

B.

DESCRIBE NETWORK POLICY

C.

SHOW SESSION POLICIES

D.

SHOW NETWORK POLICIES

Question 75

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Question 76

The property mins_to_bypass_network_policy is set at which level?

Options:

A.

User

B.

Role

C.

Account

D.

Organization

Question 77

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Options:

A.

The data retention period is reduced to a minimum of 14 days.

B.

The data retention period is permanently extended for the table.

C.

The data retention period is temporarily extended to the stream's offset.

D.

The data retention period is not affected by the stream consumption.

Question 78

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

Options:

A.

Source_column.element[1]:name

B.

Source_column.element[0]:name

C.

Source_column.element[1].name

D.

Source_column.element[0]:name

Question 79

By default, which role can create resource monitors?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

USERADMIN

Question 80

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

Options:

A.

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

B.

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

C.

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

D.

It is not possible to create secure materialized views.

E.

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

Question 81

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

Options:

A.

SYSADMIN only

B.

ORCADMIN only

C.

SECURITYADMIN or higher roles

D.

A role with the CREATE NETWORK POLICY privilege

E.

A role with the CREATE SECURITY INTEGRATION privilege

Question 82

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 83

Which user preferences can be set for a user profile in Snowsight? (Select TWO).

Options:

A.

Multi-Factor Authentication (MFA)

B.

Default database

C.

Default schema

D.

Notification

E.

Username

Question 84

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

Options:

A.

TASK_HISTORY

B.

TASK_DEPENDENTS

C.

CURRENT_TASK_GRAPHS

D.

COMPLETE_TASK_GRAPHS

Question 85

When unloading data with the COPY into command, what is the purpose of the PARTITION BY parameter option?

Options:

A.

To sort the contents of the output file by the specified expression.

B.

To delimit the records in the output file using the specified expression.

C.

To include a new column in the output using the specified window function expression.

D.

To split the output into multiple files, one for each distinct value of the specified expression.

Question 86

Which Snowflake objects can be restored using Time Travel? (Select VNO).

Options:

A.

Roles

B.

Users

C.

Databases

D.

Schemas

E.

Virtual warehouses

Question 87

Which virtual warehouse consideration can help lower compute resource credit consumption?

Options:

A.

Setting up a multi-cluster virtual warehouse

B.

Resizing the virtual warehouse to a larger size

C.

Automating the virtual warehouse suspension and resumption settings

D.

Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse

Question 88

Which Snowflake table supports unstructured data?

Options:

A.

Directory

B.

Transient

C.

Temporary

D.

Permanent

Question 89

Which system_defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Question 90

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

Options:

A.

PUT @mystage

B.

GET @mystage

C.

COPY INTO @mystage

D.

INSERT @mystage

Question 91

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 92

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

Options:

A.

Repair the failed resources.

B.

Restart failed resources.

C.

Queue the failed resources

D.

Provision the failed resources

Question 93

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 94

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Question 95

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

Options:

A.

When it is unknown how much compute power is needed

B.

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

C.

If the runtime of the executed query is very slow

D.

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

Question 96

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 97

Users are responsible for data storage costs until what occurs?

Options:

A.

Data expires from Time Travel

B.

Data expires from Fail-safe

C.

Data is deleted from a table

D.

Data is truncated from a table

Question 98

How many days is load history for Snowpipe retained?

Options:

A.

1 day

B.

7 days

C.

14 days

D.

64 days

Question 99

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Question 100

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 101

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

Options:

A.

B.

C.

D.

Question 102

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 103

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 104

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

Options:

A.

Reader

B.

Consumer

C.

Vendor

D.

Standard

E.

Personalized

Question 105

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 106

What is the maximum Time Travel retention period for a temporary Snowflake table?

Options:

A.

90 days

B.

1 day

C.

7 days

D.

45 days

Question 107

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

Options:

A.

Row level access policies

B.

Data masking policies

C.

Data encryption

D.

Time Travel

E.

External tokenization

Question 108

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 109

Which of the following describes the Snowflake Cloud Services layer?

Options:

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Question 110

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 111

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

Options:

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Question 112

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

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

What action should be taken to address this situation?

Options:

A.

Increase the warehouse size from Medium to 2XL.

B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.

Configure the warehouse to a multi-cluster warehouse.

D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Question 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 of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 115

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

Options:

A.

The Pipe load history is reset to empty.

B.

The REFRESH command is executed.

C.

The stage will be purged.

D.

The destination table is truncated.

Question 116

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Options:

A.

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B.

Allows a user to import the files in a sequential order

C.

Increases the latency staging and accuracy when loading the data

D.

Allows optimization of parallel operations

Question 117

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

Options:

A.

The USERS view in ACCOUNT_USAGE

B.

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.

The SESSIONS view in ACCOUNT_USAGE

Question 118

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

Options:

A.

Amazon Web Services

B.

Docker

C.

IBM Cloud

D.

Microsoft Azure Cloud

E.

Google Cloud Platform

F.

Oracle Cloud

Question 119

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 120

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

Options:

A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

Question 121

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

Options:

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Question 122

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

Options:

A.

Database replication and failover

B.

Automated index management

C.

Customer managed keys (Tri-secret secure)

D.

Extended time travel

E.

Native support for geospatial data

Question 123

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

Options:

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Question 124

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Question 125

Which operation can be performed on Snowflake external tables?

Options:

A.

INSERT

B.

JOIN

C.

RENAME

D.

ALTER

Question 126

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 127

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

Options:

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Question 128

Which Snowflake view is used to support compliance auditing?

Options:

A.

ACCESS_HISTORY

B.

COPY_HISTORY

C.

QUERY_HISTORY

D.

ROW ACCESS POLICIES

Question 129

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

Options:

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Question 130

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 131

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 132

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

Options:

A.

Tags

B.

Comments

C.

Internal tokenization

D.

Row access policies

Question 133

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 134

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

Options:

A.

File URL

B.

Staged URL

C.

Scoped URL

D.

Pre-signed URL

Question 135

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 136

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 137

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 138

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 139

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Options:

A.

Access control

B.

Fail-safe

C.

Network policies

D.

Time Travel

Question 140

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

Options:

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Question 141

What does the LATERAL modifier for the FLATTEN function do?

Options:

A.

Casts the values of the flattened data

B.

Extracts the path of the flattened data

C.

Joins information outside the object with the flattened data

D.

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

Question 142

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 143

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 144

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 145

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

Options:

A.

INTEGER

B.

OBJECT

C.

VARIANT

D.

VARCHAR

E.

LIST

Question 146

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

Options:

A.

Operator tree

B.

Table pruning

C.

Most expensive nodes

D.

Nodes by execution time

Question 147

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

Options:

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Question 148

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 149

What is a directory table in Snowflake?

Options:

A.

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

B.

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

C.

A database object with grantable privileges for unstructured data tasks

D.

A Snowflake table specifically designed for storing unstructured files

Question 150

What factors impact storage costs in Snowflake? (Select TWO).

Options:

A.

The account type

B.

The storage file format

C.

The cloud region used by the account

D.

The type of data being stored

E.

The cloud platform being used

Question 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

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 154

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 155

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

Options:

A.

Bytes scanned

B.

Partitions scanned

C.

Bytes spilled to local storage

D.

Bytes spilled to remote storage

E.

Percentage scanned from cache

Question 156

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 157

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

Options:

A.

ARRAY

B.

CHARACTER

C.

STRING

D.

VARCHAR

E.

VARIANT

Question 158

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 159

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

Options:

A.

LIST

B.

ALTER FILE FORMAT

C.

DESCRIBE FILE FORMAT

D.

SHOW FILE FORMATS

Question 160

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

Options:

A.

0 days

B.

1 day

C.

7 days

D.

90 days

Question 161

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

Options:

A.

1 minutes

B.

5 minutes

C.

10 minutes

D.

15 minutes

Question 162

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 163

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 164

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

Options:

A.

UTF-8

B.

UTF-16

C.

ISO-8859-1

D.

WINDOWS-1253

Question 165

Which Snowflow object does not consume and storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Question 166

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 167

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 168

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

Options:

A.

Avro

B.

CSV

C.

JSON

D.

Parquet

Question 169

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 170

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

Options:

A.

Use the SHOW STAGES command.

B.

Use the DESCRIBE STAGE command.

C.

Use the GET_ABSOLUTE_PATH function.

D.

Use the GET_STAGE_LOCATION function.

Question 171

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

Options:

A.

Add or remove users from a worksheet.

B.

Move a worksheet to a folder or a dashboard.

C.

Combine multiple worksheets into a single worksheet.

D.

Tag frequently accessed worksheets for ease of access.

Question 172

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

Question 173

What are characteristics of transient tables in Snowflake? (Select TWO).

Options:

A.

Transient tables have a Fail-safe period of 7 days.

B.

Transient tables can be cloned to permanent tables.

C.

Transient tables persist until they are explicitly dropped.

D.

Transient tables can be altered to make them permanent tables.

E.

Transient tables have Time Travel retention periods of 0 or 1 day.

Question 174

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

Options:

A.

BINARY

B.

GEOGRAPHY

C.

GEOMETRY

D.

OBJECT

E.

VARIANT

Question 175

How does Snowflake describe its unique architecture?

Options:

A.

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

B.

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

C.

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

D.

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

Question 176

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Options:

A.

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B.

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C.

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Question 177

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 178

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 179

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 180

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 181

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

Options:

A.

Hierarchical key model

B.

Client-side encryption

C.

Tri-secret secure encryption

D.

Key pair authentication

Load More SnowPro-Core Questions
Page: 1 / 43
Total 427 questions
Get SnowPro-Core Full Access Download SnowPro-Core PDF