SnowPro-Core Exam Questions Tutorials

SnowPro Core Certification Exam Questions and Answers

Question 65

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Question 66

Which metadata table will store the storage utilization information even for dropped tables?

DATABASE_STORAGE_USAGE_HISTORY

TABLE_STORAGE_METRICS

STORAGE_DAILY_HISTORY

STAGE STORAGE USAGE HISTORY

Question 67

Which Snowflake command can be used to unload the result of a query to a single file?

Use COPY INTO followed by a GET command to download the file.

Use COPY INTO followed by a put command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

Question 68

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Add and remove members.

Delete data categories.

Approve and deny listing approval requests.

Transfer listing ownership.

Transfer ownership of a provider profile.