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 301–305 (page: 62)

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

What happens when an external or an internal stage is dropped? (Choose two.)

  1. When dropping an external stage, the files are not removed and only the stage is dropped.
  2. When dropping an external stage, both the stage and the files within the stage are removed.
  3. When dropping an internal stage, the files are deleted with the stage and the files are recoverable.
  4. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable.
  5. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable.

Answer(s): A,D



A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my_table FROM @my_stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same COPY INTO command what will happen?

  1. All data from all of the files on the stage will be appended to the table.
  2. Only data about new customers from the new files will be appended to the table.
  3. The operation will fail with the error UNCERTAIN FILES IN STAGE.
  4. All data from only the newly-added files will be appended to the table.

Answer(s): D



Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  1. STRIP_NULL_VALUES
  2. SKIP_BYTE_ORDER_MARK
  3. REPLACE_INVALID_CHARACTERS
  4. VALIDATION_MODE

Answer(s): D



Which of the following SQL statements will list the version of the drivers currently being used?

  1. Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
  2. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
  3. Execute SELECT CURRENT_CLIENT(); from an application
  4. Execute SELECT CURRENT_VERSION(); from the Python Connector

Answer(s): C



Which Snowflake technique can be used to improve the performance of a query?

  1. Clustering
  2. Indexing
  3. Fragmenting
  4. Using INDEX_HINTS

Answer(s): A



  PDF
Viewing page 62 of 221
Viewing questions 306 - 310 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!