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 396–400 (page: 81)

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

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

  1. The clone always stays in sync with the original table.
  2. The clone has better query performance.
  3. The clone is created almost instantly.
  4. The clone will have time travel history from the original table.
  5. The clone saves space by not duplicating storage.

Answer(s): C,E



How often are the Account and Table master keys automatically rotated by Snowflake?

  1. 30 Days
  2. 60 Days
  3. 90 Days
  4. 365 Days

Answer(s): A



Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

  1. USAGE
  2. OPERATE
  3. MONITOR
  4. MODIFY

Answer(s): B


Reference:

https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege



Which statement MOST accurately describes clustering in Snowflake?

  1. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
  2. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
  3. The clustering key must be included in the COPY command when loading data into Snowflake.
  4. Clustering can be disabled within a Snowflake account.

Answer(s): B



Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

  1. Configure the user to be initially disabled.
  2. Force an immediate password change.
  3. Set a default role for the user.
  4. Set the number of minutes to unlock to 15 minutes.
  5. Set the user's access to expire within a specified timeframe.

Answer(s): B,C



  PDF
Viewing page 81 of 221
Viewing questions 401 - 405 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!