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 426–430 (page: 87)

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

Which Snowflake objects can be used to reduce data storage costs for short-lived tables? (Choose two.)

  1. Provisional tables
  2. Temporary tables
  3. Transient tables
  4. Permanent tables
  5. Lookup tables

Answer(s): B,C



A user has unloaded data from Snowflake to a stage.

Which SQL command should be used to validate which data was loaded into the stage?

  1. list @file_stage
  2. show @file_stage
  3. view @file_stage
  4. verify @file_stage

Answer(s): A



What are benefits of using the ACCESS_HISTORY view in the SNOWFLAKE database? (Choose two.)

  1. Identification of unused data
  2. Identification of which roles have been used
  3. Tracking of network policy usage
  4. Highlighting of row access policy usage
  5. Identification of who has read data

Answer(s): A,B



Which of the following view types are available in Snowflake? (Choose two.)

  1. Layered view
  2. Secure view
  3. External view
  4. Embedded view
  5. Materialized view

Answer(s): B,E



Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose two.)

  1. Growth of storage and compute are tightly coupled.
  2. Storage expands without the requirement to add more compute.
  3. Compute can be scaled up or down without the requirement to add more storage.
  4. Compute and storage can be scaled together.
  5. Use of storage avoids disk spilling.

Answer(s): B,C



  PDF
Viewing page 87 of 221
Viewing questions 431 - 435 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!