Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free SnowPro Core Certification Exam Practice Questions

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

SnowPro-Core PDF

SnowPro-Core PDF (Printable)
$54.25
$154.99

SnowPro-Core Testing Engine

SnowPro-Core PDF (Printable)
$59.5
$169.99

SnowPro-Core PDF + Testing Engine

SnowPro-Core PDF (Printable)
$74.55
$212.99

Free Exams Sample Questions