All COF-C02 Test Inside Snowflake Questions

SnowPro Core Certification Exam Questions and Answers

Question 85

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 86

What is a directory table in Snowflake?

A separate database object that is used to store file-level metadata

An object layered on a stage that is used to store file-level metadata

A database object with grantable privileges for unstructured data tasks

A Snowflake table specifically designed for storing unstructured files

Question 87

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Access history

Data classification

Dynamic Data Masking

Object tagging

Question 88

What happens when a Snowflake user changes the data retention period at the schema level?

All child objects will retain data for the new retention period.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

All child objects with an explicit retention period will be overridden with the new retention period.

All explicit child object retention periods will remain unchanged.