Pass COF-C02 Exam Guide

SnowPro Core Certification Exam Questions and Answers

Question 141

What does SnowCD help Snowflake users to do?

Copy data into files.

Manage different databases and schemas.

Troubleshoot network connections to Snowflake.

Write SELECT queries to retrieve data from external tables.

Question 142

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.

Question 143

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

DATA_RETENTION_TIME_IN_DAYS

MAX_DATA_EXTENSION_TIME_IN_DAYS

MIN_DATA_RETENTION_TIME_IN_DAYS

MAX CONCURRENCY LEVEL

Question 144

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.