Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SnowPro-Core Questions Bank

Page: 36 / 45
Total 605 questions

SnowPro Core Certification Exam Questions and Answers

Question 141

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Question 142

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Options:

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Question 143

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Question 144

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Options:

A.

SHOW GRANTS OF ROLE MY_ROLE

B.

SHOW GRANTS TO ROLE MY_ROLE

C.

SHOW GRANTS FOR ROLE MY_ROLE

D.

SHOW GRANTS ON ROLE MY_ROLE

Page: 36 / 45
Total 605 questions