March Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! SnowPro-Core SnowPro Core Certification Exam is now Stable and With Pass Result

SnowPro-Core Practice Exam Questions and Answers

SnowPro Core Certification Exam

Last Update 11 hours ago
Total Questions : 427

SnowPro-Core is stable now with all latest exam questions are added 11 hours ago. Just download our Full package and start your journey with Snowflake SnowPro Core Certification Exam certification. All these Snowflake SnowPro-Core practice exam questions are real and verified by our Experts in the related industry fields.

SnowPro-Core PDF

SnowPro-Core PDF (Printable)
$48
$119.99

SnowPro-Core Testing Engine

SnowPro-Core PDF (Printable)
$56
$139.99

SnowPro-Core PDF + Testing Engine

SnowPro-Core PDF (Printable)
$70.8
$176.99
Question # 1

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

Discussion 0
Question # 2

Which statement about billing applies to Snowflake credits?

Options:

A.  

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

B.  

Credits are used to pay for cloud data storage usage

C.  

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

D.  

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

Discussion 0
Question # 3

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

Discussion 0
Question # 4

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

Options:

A.  

ACCOUNTADMIN

B.  

ORGADMIN

C.  

SECURITYADMIN

D.  

SYSADMIN

Discussion 0
Question # 5

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

Options:

A.  

A User Defined Function (UDF)

B.  

A stored procedure

C.  

A single copy_into statement

D.  

A single insert__into statement

Discussion 0
Question # 6

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

Options:

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

Discussion 0
Question # 7

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

Options:

A.  

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

B.  

The replication will not be successful.

C.  

The physical data is replicated

D.  

Additional costs for storage are charged to a secondary account

E.  

Metadata pointers to cloned tables are replicated

Discussion 0
Question # 8

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

COPY INTO my__table FROM @my__stage;

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

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 9

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

Discussion 0
Question # 10

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

Options:

A.  

The load HISTORY view

B.  

The Query history view

C.  

The show warehouses command

D.  

The WAREHOUSE_METERING__HISTORY View

E.  

The billing and usage tab in the Snowflake web Ul

Discussion 0
Question # 11

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

Discussion 0
Question # 12

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

Discussion 0
Question # 13

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 14

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

Discussion 0
Question # 15

What is a best practice after creating a custom role?

Options:

A.  

Create the custom role using the SYSADMIN role.

B.  

Assign the custom role to the SYSADMIN role

C.  

Assign the custom role to the PUBLIC role

D.  

Add__CUSTOM to all custom role names

Discussion 0
Question # 16

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Options:

A.  

Configure the user to be initially disabled.

B.  

Force an immediate password change.

C.  

Set a default role for the user.

D.  

Set the number of minutes to unlock to 15 minutes.

E.  

Set the user's access to expire within a specified timeframe.

Discussion 0
Question # 17

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

Options:

A.  

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

B.  

Yes, because masking policies only apply to cloned tables.

C.  

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

D.  

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

Discussion 0
Question # 18

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

Options:

A.  

Gathering the hourly credit usage for an account

B.  

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

C.  

Summarizing the throughput of Snowpipe costs for an account

D.  

Calculating the funds left on an account's contract

Discussion 0
Question # 19

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

Options:

A.  

Custom Edition

B.  

Virtual Private Snowflake

C.  

Business Critical Edition

D.  

Standard Edition

E.  

Enterprise Edition

Discussion 0
Question # 20

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

Options:

A.  

STRIP_NULL_VALUES

B.  

SKIP_BYTE_ORDER_MARK

C.  

REPLACE_INVALID_CHARACTERS

D.  

VALIDATION_MODE

Discussion 0
Question # 21

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

Options:

A.  

True

B.  

False

Discussion 0
Question # 22

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

Discussion 0
Question # 23

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

Options:

A.  

@

B.  

&

C.  

$

D.  

#

Discussion 0
Question # 24

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.

Discussion 0
Question # 25

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 26

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

Options:

A.  

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 30 days.

Fail Safe retention time is 1 day.

B.  

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 365 days.

Fail Safe retention time is 7 days.

C.  

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

D.  

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

E.  

Default Time Travel Retention is set to 7 days.

Maximum Time Travel Retention is 1 day.

Fail Safe retention time is 90 days.

F.  

Default Time Travel Retention is set to 90 days.

Maximum Time Travel Retention is 7 days.

Fail Safe retention time is 356 days.

Discussion 0
Question # 27

A running virtual warehouse is suspended.

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

Options:

A.  

1 second

B.  

60 seconds

C.  

5 minutes

D.  

60 minutes

Discussion 0
Question # 28

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

Options:

A.  

SELECT SUM (ORDER_AMT) FROM SALES;

B.  

SELECT AVG(ORDER_QTY) FROM SALES;

C.  

SELECT MIN(ORDER_AMT) FROM SALES;

D.  

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Discussion 0
Question # 29

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

A.  

parse_json()

B.  

json_extract_path_text()

C.  

object_construct()

D.  

flatten

Discussion 0
Question # 30

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

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Question # 31

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

Discussion 0
Question # 32

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

Options:

A.  

A directory table is a separate database object.

B.  

Directory tables store data file metadata.

C.  

A directory table will be automatically added to a stage.

D.  

Directory tables do not have their own grantable privileges.

E.  

Directory table data can not be refreshed manually.

Discussion 0
Question # 33

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

Options:

A.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

Discussion 0
Question # 34

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

Discussion 0
Question # 35

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

Options:

A.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

Discussion 0
Question # 36

Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Options:

A.  

COPY INTO

B.  

CREATE PIPE

C.  

INSERT INTO

D.  

TABLE STREAM

Discussion 0
Question # 37

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

Question # 37

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

A.  

select src:dealership from car_sales;

B.  

select src.dealership from car_sales;

C.  

select src:Dealership from car_sales;

D.  

select dealership from car_sales;

Discussion 0
Question # 38

The PUT command: (Choose two.)

Options:

A.  

Automatically creates a File Format object

B.  

Automatically uses the last Stage created

C.  

Automatically compresses files using Gzip

D.  

Automatically encrypts files

Discussion 0
Question # 39

Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Options:

A.  

Database

B.  

Tables

C.  

Warehouses

D.  

Worksheets

Discussion 0
Question # 40

Which of the following objects is not covered by Time Travel?

Options:

A.  

Tables

B.  

Schemas

C.  

Databases

D.  

Stages

Discussion 0
Question # 41

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

Options:

A.  

True

B.  

False

Discussion 0
Question # 42

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

Select one.

Options:

A.  

INITTIALLY_SUSPENDED = TRUE/FALSE

B.  

START_AFTCR_CREATE = TRUE/FALSE

C.  

START_TTIME = 60 // (seconds from now)

D.  

START.TIME = CURRENT.DATE()

Discussion 0
Question # 43

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

Select one.

Options:

A.  

1 Hour

B.  

3 Hours

C.  

12 hours

D.  

24 hours

Discussion 0
Question # 44

Which of the following commands are not blocking operations?

Choose 2 answers

Options:

A.  

UPDATE

B.  

INSERT

C.  

MERGE

D.  

COPY

Discussion 0
Question # 45

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

Options:

A.  

True

B.  

False

Discussion 0
Question # 46

Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:

Choose 2 answers

Options:

A.  

Temporary Tables

B.  

Transient Tables

C.  

Provisional Tables

D.  

Permanent Tables

Discussion 0
Question # 47

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

Options:

A.  

On-premise availability

B.  

Simplicity

C.  

Open source based

D.  

Concurrency

E.  

Performance

Discussion 0
Question # 48

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

Options:

A.  

True

B.  

False

Discussion 0
Question # 49

True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

Options:

A.  

True

B.  

False

Discussion 0
Question # 50

Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

Options:

A.  

Micro-partitions

B.  

Clustering keys

C.  

Key partitions

D.  

Clustered partitions

Discussion 0
Question # 51

True or False: It is possible to load data into Snowflake without creating a named File Format object.

Options:

A.  

True

B.  

False

Discussion 0
Question # 52

Which of the following are common use cases for zero-copy cloning?

Choose 3 answers

Options:

A.  

Quick provisioning of Dev and Test/QA environments

B.  

Data backups

C.  

Point in time snapshots

D.  

Performance optimization

Discussion 0
Question # 53

True or False: During data unloading, only JSON and CSV files can be compressed.

Options:

A.  

True

B.  

False

Discussion 0
Question # 54

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Options:

A.  

True

B.  

False

Discussion 0
Question # 55

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Options:

A.  

Configure the Maximum Clusters setting to “Auto-Scale”

B.  

Set the Warehouse type to “Auto”

C.  

Set the Minimum Clusters and Maximum Clusters settings to the same value

D.  

Set the Minimum Clusters and Maximum Clusters settings to the different values

Discussion 0
Question # 56

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

Options:

A.  

Through the Snowflake web interface (Ul)

B.  

Through the DATA_SHARE=TRUE parameter

C.  

Through SQL commands

D.  

Through the enable__share=true parameter

E.  

Using the CREATE SHARE AS SELECT * TABLE command

Discussion 0
Question # 57

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

Options:

A.  

True

B.  

False

Discussion 0
Question # 58

True or False: Loading data into Snowflake requires that source data files be no larger than 16M

B.  

Options:

A.  

True

B.  

False

Discussion 0
Question # 59

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

Options:

A.  

ROLES

B.  

POLICY_REFERENCES

C.  

QUERY_HISTORY

D.  

RESOURCE_MONIT ORS

E.  

ACCESS_HISTORY

Discussion 0
Question # 60

How long is Snowpipe data load history retained?

Options:

A.  

As configured in the create pipe settings

B.  

Until the pipe is dropped

C.  

64 days

D.  

14 days

Discussion 0
Question # 61

Which of the following objects can be shared through secure data sharing?

Options:

A.  

Masking policy

B.  

Stored procedure

C.  

Task

D.  

External table

Discussion 0
Get SnowPro-Core dumps and pass your exam in 24 hours!

Free Exams Sample Questions