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 246–250 (page: 51)

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

Which data types does Snowflake support when querying semi-structured data? (Choose two.)

  1. VARIANT
  2. VARCHAR
  3. XML
  4. ARRAY
  5. BLOB

Answer(s): A,D



In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

  1. When the system has enough load for 2 minutes
  2. When the system has enough load for 6 minutes
  3. When the system has enough load for 8 minutes
  4. When the system has enough load for 10 minutes

Answer(s): B



What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

  1. To validate external table files in table t1 across all sessions
  2. To validate task SQL statements against table t1 in the last 14 days
  3. To validate a file for errors before it gets executed using a COPY command
  4. To return errors from the last executed COPY command into table t1 in the current session

Answer(s): D



A sales table FCT_SALES has 100 million records.

The following query was executed:
SELECT COUNT (1) FROM FCT_SALES;

How did Snowflake fulfill this query?

  1. Query against the result set cache
  2. Query against a virtual warehouse cache
  3. Query against the most-recently created micro-partition
  4. Query against the metadata cache

Answer(s): D



What happens when a virtual warehouse is resized?

  1. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected.
  2. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
  3. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
  4. Users who are trying to use the warehouse will receive an error message until the resizing is complete.

Answer(s): B



  PDF
Viewing page 51 of 221
Viewing questions 251 - 255 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!