New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Snowflake SnowPro-Core - SnowPro Core Certification Exam

Snowflake SnowPro-Core Premium Access     Download Demo    
Page: 7 / 13
Total 605 questions

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

A.

Avro

B.

CSV

C.

JSON

D.

Parquet

How can a user get the MOST detailed information about individual table storage details in Snowflake?

A.

SHOW TABLES command

B.

SHOW EXTERNAL TABLES command

C.

TABLES view

D.

TABLE STORAGE METRICS view

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?

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

A.

ALTER TABLE

PURGE CLUSTERING KEY

B.

ALTER TABLE

DELETE CLUSTERING KEY

C.

ALTER TABLE

DROP CLUSTERING KEY

D.

ALTER TABLE

REMOVE CLUSTERING KEY

What does a table with a clustering depth of 1 mean in Snowflake?

A.

The table has only 1 micro-partition.

B.

The table has 1 overlapping micro-partition.

C.

The table has no overlapping micro-partitions.

D.

The table has no micro-partitions.

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.

What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

A.

1 Kilobyte (KB)

B.

1 Megabyte (MB)

C.

1 Gigabyte (GB)

D.

1 Terabyte (TB)

Authorization to execute CREATE statements comes only from which role?

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Snowflake users can create a resource monitor at which levels? (Select TWO).

A.

User level

B.

Pipe level

C.

Account level

D.

Cloud services level

E.

Virtual warehouse level

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

Which command will unload data from a table into an external stage?

A.

PUT

B.

INSERT

C.

COPY INTO

D.

GET

Which Snowflake database object can be shared with other accounts?

A.

Tasks

B.

Pipes

C.

Secure User-Defined Functions (UDFs)

D.

Stored Procedures

What causes objects in a data share to become unavailable to a consumer account?

A.

The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

B.

The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

C.

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

D.

The consumer account acquires the data share through a private data exchange.

The property mins_to_bypass_network_policy is set at which level?

A.

User

B.

Role

C.

Account

D.

Organization

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

A.

Area chart

B.

Box plot

C.

Heat grid

D.

Pie chart