Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1581:

  Which statement will execute a stored procedure?

  A. CALL proc1(SELECT COUNT(*) FROM );
  B. CALL proc1(1) + proc1(2);
  C. CALL proc1(1) + IF
  D. CALL proc1(proc2(1));
  D. CALL proc1(proc2(1));

  ---

  Explanation

  You execute a stored procedure using the CALL command. Nested procedure calls are allowed where the result of one procedure is passed as an argument to another.

  Correct syntax:

  CALL proc1(proc2(1));

  Snowflake Docs: CALL Statement

• Question 1582:

  When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

  A. (12,2)
  B. (10,4)
  C. (14,8)
  D. (15,9)
  D. (15,9)

  ---

  Explanation

• Question 1583:

  Which type of URL gives permanent access to files in cloud storage?

  A. Pre-signed URL
  B. Account URL
  C. Scoped URL
  D. File URL
  A. Pre-signed URL

  ---

  Explanation

• Question 1584:

  How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

  A. Use Snowpipe.
  B. Use the INSERT command.
  C. Use an external table.
  D. Use the COPY command.
  D. Use the COPY command.

  ---

  Explanation

• Question 1585:

  Which schema has the RESOURCE_MONITORS view?

  A. ACCOUNT_USAGE
  B. READER_ACCOUNT_USAGE
  C. INFORMATION_SCHEMA
  D. WAREHOUSE_USAGE_SCHEMA
  B. READER_ACCOUNT_USAGE

  ---

  Explanation

• Question 1586:

  What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).

  A. Compress the files before loading.
  B. Use a semi-structured file format.
  C. Increase the PARALLEL option value.
  D. Load the data into a table stage.
  E. Enable the overwrite option.
  A. Compress the files before loading.
  C. Increase the PARALLEL option value.

  ---

  Explanation

  To avoid timeouts during large data uploads with the PUT command in Snowflake, it is recommended to:

  Compress files before loading: Compressed files are smaller and upload faster, reducing the risk of timeouts.

  Increase the PARALLEL option value: This option allows more simultaneous upload threads, improving upload speed and efficiency for large datasets. Semi-structured file formats and table staging do not directly impact timeouts, while

  enabling overwrite does not prevent timeouts but rather controls overwriting of existing files.

• Question 1587:

  How can unstructured data be processed in a Snowflake stage? (Select TWO).

  A. Use a SQL procedure.
  B. Use external functions.
  C. Use a C# procedure.
  D. Implement a Golang (Go) User-Defined Function (UDF).
  E. Implement a Python User-Defined Function (UDF).
  B. Use external functions.

  ---

  Explanation

• Question 1588:

  What is the minimum Snowflake edition required for row level security?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake
  B. Enterprise

  ---

  Explanation

• Question 1589:

  What is the purpose of collecting statistics on data in Snowflake?

  A. To identify data storage order correlations
  B. To enable efficient pruning based on query filters
  C. To reduce the total number of micro-partitions in a table
  D. To optimize query performance by reading all data in a table
  B. To enable efficient pruning based on query filters

  ---

  Explanation

• Question 1590:

  Secured Data Sharing is allowed for which Snowflake database objects? (Choose two.)

  A. Tables
  B. User-Defined Table Functions (UDTFs)
  C. Secure views
  D. Stored procedures
  E. Worksheets
  A. Tables
  C. Secure views

  ---

  Explanation