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 291–295 (page: 60)

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

Which of the following roles are recommended to create and manage users and roles? (Choose two.)

  1. SYSADMIN
  2. SECURITYADMIN
  3. PUBLIC
  4. ACCOUNTADMIN
  5. USERADMIN

Answer(s): B,E



When can a newly configured virtual warehouse start running SQL queries?

  1. After 50% of the warehouse provisioning has completed
  2. During the time slots defined by the ACCOUNTADMIN
  3. When the warehouse provisioning is completed
  4. After the warehouse replication is completed

Answer(s): C



What actions will prevent leveraging of the ResultSet cache?

  1. Removing a column from the query SELECT list
  2. Stopping the virtual warehouse that the query is running against
  3. If the result has not been reused within the last 12 hours
  4. Executing the RESULTS_SCAN() table function

Answer(s): A



Which of the following are benefits of micro-partitioning? (Choose two.)

  1. Micro-partitions cannot overlap in their range of values.
  2. Micro-partitions are immutable objects that support the use of Time Travel.
  3. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses.
  4. Rows are automatically stored in sorted order within micro-partitions.
  5. Micro-partitions can be defined on a schema-by-schema basis.

Answer(s): B,C



Which data type can be used to store geospatial data in Snowflake?

  1. Variant
  2. Object
  3. Geometry
  4. Geography

Answer(s): C



  PDF
Viewing page 60 of 221
Viewing questions 296 - 300 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!