SnowPro Core COF-C03

Review 116 SNOWPRO-CORE-COF-C03 practice questions with answer explanations and community insights.

Question 1

What is a key difference between the Snowflake CLI and SnowSQL?

  1. SnowSQL is used for managing workloads and applications, while Snowflake CLI executes queries.
  2. Snowflake CLI is primarily used for managing workloads and applications, while SnowSQL is used for executing operations.
  3. SnowSQL supports only Data Definition Language (DDL) operations, while Snowflake CLI supports only Data Manipulation Language (DML) operations.
  4. Snowflake CLI only supports query execution, while SnowSQL manages Python packages.

Question 2

Which services are handled within the Cloud Services layer? (Choose two.)

  1. Authentication
  2. Query processing
  3. Secure socket
  4. Virtual warehouse hosting
  5. Metadata management

Question 3

A user is automating a data pipeline using the Snowflake CLI and needs to pass variables into SQL scripts.Which variable templating syntaxes should be used? (Choose two.)

  1. STANDARD
  2. LEGACY
  3. JINJA
  4. NONE
  5. ALL

Question 4

What is the MINIMUM Snowflake edition needed to apply 90 days of Time Travel to an object?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake (VPS)

Question 5

Which objects can be recovered after being dropped? (Choose two.)

  1. View
  2. Transient table
  3. Temporary table
  4. Permanent table
  5. Materialized view
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.