Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 161:

  Using variables in Snowflake is denoted by using which SQL character?

  A. @

  B. and

  C. $

  D. #

  Correct Answer: C

• Question 162:

  Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

  A. Schema

  B. View

  C. Internal stage

  D. Table

  E. User

  F. Role

  Correct Answer: AD

• Question 163:

  Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

  A. SHOW GRANTS OF ROLE MY_ROLE

  B. SHOW GRANTS TO ROLE MY_ROLE

  C. SHOW GRANTS FOR ROLE MY_ROLE

  D. SHOW GRANTS ON ROLE MY_ROLE

  Correct Answer: B

• Question 164:

  A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

  Which application will the Snowflake users need to install on their devices in order to connect with MFA?

  A. Okta Verify

  B. Duo Mobile

  C. Microsoft Authenticator

  D. Google Authenticator

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 165:

  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

  Correct Answer: B

• Question 166:

  During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

  A. STATEMENT_TIMEOUT__IN__SECONDS

  B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

  C. MAX_CONCURRENCY__LEVEL

  D. QUERY_TIMEOUT_IN_SECONDS

  Correct Answer: B

  The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter% 20STATEMENT_QUEUED_TIMEOUT_IN_SECO NDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.

• Question 167:

  What tasks can be completed using the copy command? (Select TWO)

  A. Columns can be aggregated

  B. Columns can be joined with an existing table

  C. Columns can be reordered

  D. Columns can be omitted

  E. Data can be loaded without the need to spin up a virtual warehouse

  Correct Answer: CD

• Question 168:

  What is the default character set used when loading CSV files into Snowflake?

  A. UTF-8

  B. UTF-16

  C. ISO S859-1

  D. ANSI_X3.A

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF

  8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).

• Question 169:

  Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

  A. Materialized views

  B. Sequences

  C. Procedures

  D. Tables

  E. Secure User Defined Functions (UDFs)

  Correct Answer: DE

  Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared: Tables External tables Secure views Secure materialized views Secure UDFs

  https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

• Question 170:

  Which of the following compute resources or features are managed by Snowflake? (Select TWO).

  A. Execute a COPY command

  B. Updating data

  C. Snowpipe

  D. AUTOMATIC__CLUSTERING

  E. Scaling up a warehouse

  Correct Answer: AD