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 346–350 (page: 71)

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

A user is preparing to load data from an external stage.

Which practice will provide the MOST efficient loading performance?

  1. Organize files into logical paths
  2. Store the files on the external stage to ensure caching is maintained
  3. Use pattern matching for regular expression execution
  4. Load the data in one large file

Answer(s): A



What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  1. The warehouse size does not change until all queries currently running in the warehouse have completed.
  2. The warehouse size does not change until all queries currently in the warehouse queue have completed.
  3. The warehouse size does not change until the warehouse is suspended and restarted.
  4. It does not return from the command until the warehouse has finished changing its size.

Answer(s): D



Which of the following can be used when unloading data from Snowflake? (Choose two.)

  1. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
  2. Use the ENCODING file format option to change the encoding from the default UTF-8.
  3. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
  4. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
  5. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Answer(s): C,D



What data is stored in the Snowflake storage layer? (Choose two.)

  1. Snowflake parameters
  2. Micro-partitions
  3. Query history
  4. Persisted query results
  5. Standard and secure view results

Answer(s): B,C



A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

  1. The reader account will automatically use the Standard edition of Snowflake.
  2. The reader account compute will be billed to the provider account.
  3. The reader account can clone data the provider has shared, but cannot re-share it.
  4. The reader account can create a copy of the shared data using CREATE TABLE AS...

Answer(s): B



  PDF
Viewing page 71 of 221
Viewing questions 351 - 355 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!