COF-C02 Online Practice Questions and Answers

What is the recommended method for loading data into Snowflake?

A. Load row by row

B. Load data in batch

C. Load data by writing it In the Snowflake Web Interface (UI)

D. Load data via frequent, angle row DML's

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A. Data can be filtered by an optional where clause

B. Incoming data can be joined with other tables

C. Columns can be reordered

D. Columns can be omitted

E. Row level access can be defined

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

A. parse_json()

B. json_extract_path_text()

C. object_construct()

D. flatten

A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

A. Increase the warehouse size from Medium to 2XL.

B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C. Configure the warehouse to a multi-cluster warehouse.

D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

A Snowflake user wants to share data using my_share with account xy12345.

Which command should be used?

A. grant usage on share my_share to account xy12345;

B. grant select on share my_share to account xy12345;

C. alter share my_share add accounts = xy12345;

D. alter account xy12345 add share my_share;

When unloading data to an external stage, what is the MAXIMUM file size supported?

A. 1 GB

B. 5 GB

C. 10 GB

D. 16 GB

What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?

A. Reorder the rows in a relational table and then unload the rows into a file.

B. Convert the rows in a relational table to a single VARIANT column and then unload the rows into a file.

C. Reorder the data columns according to a target table definition and then unload the rows into the table.

D. Convert the rows in a source file to a single VARIANT column and then load the rows from the file to a variant table.

What are benefits of using Snowpark with Snowflake? (Choose two.)

A. Snowpark uses a Spark engine to generate optimized SQL query plans.

B. Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C. Snowpark does not require that a separate cluster be running outside of Snowflake.

D. Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E. Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology that is not listed in Snowflake's partner ecosystem?

A. Use Snowflake's native API.

B. Use a custom-built connector.

C. Contact Snowflake Support for a new driver.

D. Connect through Snowflake's JDBC or ODBC drivers.

Which command will unload data from a table into an external stage?

A. PUT

B. INSERT

C. COPY INTO

D. GET