Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 661:

  Which command should a Snowflake user execute to load data into a table?

  A. copy into mytable purge_mode = TRUE;

  B. copy into mytable from @my_int_stage;

  C. copy into mytable file_format = (format_name);

  D. copy into mytable validation = `RETURN_ERRORS';

  Correct Answer: B

• Question 662:

  What actions does the use of the PUT command do automatically? (Choose two.)

  A. It creates a file format object.

  B. It uses the last stage created.

  C. It compresses all files using GZIP.

  D. It encrypts the file data in transit.

  E. It creates an empty target table.

  Correct Answer: CD

• Question 663:

  Which data governance control has Snowflake embedded in the application?

  A. Network policies

  B. Credit computation

  C. Data storage

  D. Attribute-based access control

  Correct Answer: D

• Question 664:

  A Query Profile shows a UnionAll operator with an extra Aggregate operator on top.

  What does this signify?

  A. Exploding joins

  B. Inefficient pruning

  C. UNION without ALL

  D. Queries that are too large to fit in memory

  Correct Answer: C

• Question 665:

  What Snowflake objects can be added to a share? (Choose two.)

  A. Views

  B. Tables

  C. Stored procedures

  D. Streams

  E. Secure views

  Correct Answer: BE

• Question 666:

  Which Data Definition Language (DDL) commands are supported by Snowflake to manage tags? (Choose two.)

  A. ALTER TAG

  B. DESCRIBE TAG

  C. DROP TAG

  D. GRANT ... TO TAG

  E. GRANT TAG

  Correct Answer: AC

• Question 667:

  What type of function can be used to estimate the approximate number of distinct values from a table that has trillions of rows?

  A. MD5

  B. Window

  C. External

  D. HyperLogLog (HLL)

  Correct Answer: D

• Question 668:

  What JavaScript delimiters are available in Snowflake stored procedures? (Choose two.)

  A. Double quotes (")

  B. Single quote (')

  C. Double forward slash (//)

  D. Double backslash (\\)

  E. Double dollar sign ($$)

  Correct Answer: BE

• Question 669:

  When should a stored procedure be created with caller's rights?

  A. When the caller needs to be prevented from viewing the source code of the stored procedure

  B. When the caller needs to run a statement that could not execute outside of the stored procedure

  C. When the stored procedure needs to run with the privileges of the role that called the stored procedure

  D. When the stored procedure needs to operate on objects that the caller does not have privileges on

  Correct Answer: C

• Question 670:

  What common query issues can be identified using the Query Profile? (Choose two.)

  A. Data classification

  B. Exploding joins

  C. Unions

  D. Inefficient pruning

  E. Data masking

  Correct Answer: BD