Changed COF-C03 Exam Questions

A directory table in Snowflake is an implicit object layered on a stage, whether internal or external. It allows users to query the contents of a stage as if it were a table, providing metadata about the files stored in the stage, such as filenames, file sizes, and last modified timestamps.

Snowflake Documentation: Directory Tables

The correct answer is B. Assigns a value to a variable .

Corrected wording:

The original command was written as idefine < variable > = < value > . In SnowSQL, the correct command is:

!define < variable > = < value >

SnowSQL supports variables that can be defined and reused in SQL scripts or interactive sessions. The !define command assigns a value to a variable.

Why B is correct:

!define < variable > = < value > creates or sets a SnowSQL variable to the specified value.

Example:

!define table_name=my_table

SELECT *

FROM & table_name;

In this example, table_name is assigned the value my_table, and the variable can then be referenced later in the script.

Why the other options are incorrect:

A. The variable name is part of the command syntax, but the purpose of the command is to assign a value to that variable.

C. Context is usually set with commands such as USE DATABASE, USE SCHEMA, USE WAREHOUSE, or SnowSQL connection options.

D. The command does not establish metrics.

Official Snowflake documentation reference:

Snowflake documentation for SnowSQL explains that !define is used to define variables for use in SnowSQL sessions or scripts.

Resource monitors in Snowflake can perform actions such as suspending a virtual warehouse when its credit usage reaches a defined limit and triggering a notification to account administrators when credit usage reaches a specified threshold. These actions help manage and control resource usage and costs within Snowflake.

Snowflake Documentation: Resource Monitors