support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. COF-C02

Free COF-C02 Exam Braindumps
SnowPro Core Questions 236–240 (page: 49)

Updated On: 10-Feb-2026
Page 49 of 221
PDF with 1300 Questions

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

  1. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
  2. The transient table version cannot be retrieved after 24 hours.
  3. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
  4. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Answer(s): B



When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)

  1. Use multi-clustered warehousing to scale out warehouse capacity.
  2. Scale up the warehouse size to allow queries to execute faster.
  3. Stop and start the warehouse to clear the queued queries.
  4. Migrate some queries to a new warehouse to reduce load.
  5. Limit user access to the warehouse so fewer queries are run against it.

Answer(s): A,D



Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

  1. Tri-Secret Secure
  2. Time Travel
  3. Fail-safe
  4. Data encryption
  5. External stages

Answer(s): B,C



Where can a user find and review the failed logins of a specific user for the past 30 days?

  1. The USERS view in ACCOUNT_USAGE
  2. The LOGIN_HISTORY view in ACCOUNT_USAGE
  3. The ACCESS_HISTORY view in ACCOUNT_USAGE
  4. The SESSIONS view in ACCOUNT_USAGE

Answer(s): B



What is the purpose of an External Function?

  1. To call code that executes outside of Snowflake
  2. To run a function in another Snowflake database
  3. To share data in Snowflake with external parties
  4. To ingest data from on-premises data sources

Answer(s): A



  PDF
Viewing page 49 of 221
Viewing questions 241 - 245 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!