Snowflake SnowPro Core COF-C03 - SnowPro Core COF-C03 Exam
Page: 1 / 20
Total 100 questions
Question #1 (Topic: Exam A)
What is a key difference between the Snowflake CLI and SnowSQL?
A. SnowSQL is used for managing workloads and applications, while Snowflake CLI executes queries.
B. Snowflake CLI is primarily used for managing workloads and applications, while SnowSQL is used for executing operations.
C. SnowSQL supports only Data Definition Language (DDL) operations, while Snowflake CLI supports only Data Manipulation Language (DML) operations.
D. Snowflake CLI only supports query execution, while SnowSQL manages Python packages.
Answer: B
Question #2 (Topic: Exam A)
Which services are handled within the Cloud Services layer? (Choose two.)
A. Authentication
B. Query processing
C. Secure socket
D. Virtual warehouse hosting
E. Metadata management
Answer: AE
Question #3 (Topic: Exam A)
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.)
Which variable templating syntaxes should be used? (Choose two.)
A. STANDARD
B. LEGACY
C. JINJA
D. NONE
E. ALL
Answer: BC
Question #4 (Topic: Exam A)
What is the MINIMUM Snowflake edition needed to apply 90 days of Time Travel to an object?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake (VPS)
Answer: B
Question #5 (Topic: Exam A)
Which objects can be recovered after being dropped? (Choose two.)
A. View
B. Transient table
C. Temporary table
D. Permanent table
E. Materialized view
Answer: DE
