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 # 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

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