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 176–180 (page: 37)

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

What is the minimum Snowflake edition required to create a materialized view?

  1. Standard Edition
  2. Enterprise Edition
  3. Business Critical Edition
  4. Virtual Private Snowflake Edition

Answer(s): B



Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

  1. parse_json()
  2. json_extract_path_text()
  3. object_construct()
  4. flatten

Answer(s): A



How are serverless features billed?

  1. Per second multiplied by an automatic sizing for the job
  2. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
  3. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
  4. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Answer(s): A



Which Snowflake architectural layer is responsible for a query execution plan?

  1. Compute
  2. Data storage
  3. Cloud services
  4. Cloud provider

Answer(s): C



When unloading to a stage, which of the following is a recommended practice or approach?

  1. Set SINGLE = TRUE for larger files.
  2. Use OBJECT_CONSTRUCT(*) when using Parquet.
  3. Avoid the use of the CAST function.
  4. Define an individual file format.

Answer(s): C



  PDF
Viewing page 37 of 221
Viewing questions 181 - 185 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!