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

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. SnowPro-Core - SnowPro Core Certification Exam

SnowPro-Core Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 105

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

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 107

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

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

GRANT ON To SHARE ;

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Full Access
Question # 109

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

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.

Full Access
Question # 110

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

What do temporary and transient tables have m common in Snowflake? (Select TWO).

A.

Both tables have no Fail-safe period.

B.

Both tables have data retention period maximums of one day.

C.

Both tables are visible only to a single user session.

D.

For both tables the retention period ends when the tables are dropped.

E.

For both tables, the retention period does not end when the session ends

Full Access
Question # 112

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

A.

Fail-safe

B.

Time Travel

C.

Cloning

D.

Account replication

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps