COF-C02 practice questions 271–280

1. Question 271 · 1323 in bank

   True or False: All Snowflake table types include fail-safe storage.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Next question

2. Question 272 · 1323 in bank

   What function should be used to convert JSON NULL values to SQL NULL values when loading data into a Snowflake table?

   • ASTRIP_OUTER_ARRAYS
   • BSTRIP_NULL_VALUE
   • CFLATTEN
   • DPARSE_JSON

   Show answer

   Answer: D

   Next question

3. Question 273 · 1323 in bank

   What is the recommended way to insert a VARIANT value into a Snowflake table?

   • AUse a SELECT statement to convert data to a VARIANT data type before inserting it.
   • BUse the TO_VARIANT function in the INSERT statement.
   • CCast the data to a VARIANT data type within the INSERT statement.
   • DUse a subquery to convert the data to a VARIANT data type and then insert it.

   Show answer

   Answer: D

   Explanation

   https://docs.snowflake.com/en/sql-reference/functions/to_variant "The TO_VARIANT function cannot be used directly in an INSERT statement. Instead, use INSERT INTO ... SELECT.... Hence, ANSWER B is not correct. As per the right answer, or A, or D. I am saying D, only because I have to select an answer. Please, see below syntax, for JSON: INSERT INTO to_variant_example (v_varchar, v_number, v_timestamp, v_array, v_object) SELECT TO_VARIANT('Skiing is fun!'), TO_VARIANT(3.14), TO_VARIANT('2024-01-25 01:02:03'), TO_VARIANT(ARRAY_CONSTRUCT('San Mateo', 'Seattle', 'Berlin')), PARSE_JSON(' { "key1": "value1", "key2": "value2" } '); SELECT * FROM to_variant_example; Not very confident that this will help here.

   Source: Adapted from community discussion — 37ceea2

   References

   • Snowflake documentation

   Next question

4. Question 274 · 1323 in bank

   Which process does Snowflake follow when a stored procedure with owner's rights is called within a session?

   • AThe procedure will be run with the privileges of the caller.
   • BThe owner can set the caller's session variables.
   • CThe owner will inherit the caller's current virtual warehouse.
   • DThe owner can view the caller's session variables.

   Show answer

   Answer: C

   Next question

5. Question 275 · 1323 in bank

   Which configuration of the function PARSE_JSON( [expr] ) will retrieve a valid SQL NULL value?

   • ASELECT parse_json(NULL)
   • BSELECT parse_json('null')
   • CSELECT parse_json('[ null ]')
   • DSELECT parse_json('{"a": null}'):a

   Show answer

   Answer: A

   Explanation

   If the input is NULL, the output is also NULL. However, if the input string is 'null', then it is interpreted as a JSON null value so that the result isn’t SQL NULL, but instead a valid VARIANT value containing null https://docs.snowflake.com/en/sql-reference/functions/parse_json

   Source: Adapted from community discussion — Damu123

   References

   • Snowflake documentation

   Next question

6. Question 276 · 1323 in bank

   What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?

   • AStandard
   • BEnterprise
   • CBusiness Critical
   • DVirtual Private Snowflake (VPS)

   Show answer

   Answer: B

   Next question

7. Question 277 · 1323 in bank

   Select 2

   What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

   • AVia the Snowflake Web Interface (UI)
   • BVia the DATA_SHARE=TRUE parameter
   • CVia SQL commands
   • DVia Virtual Warehouses

   Show answer

   Answer: AC

   Next question

8. Question 278 · 1323 in bank

   Select 2

   While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Choose two.)

   • AGET
   • BCREATE STAGE
   • CPUT
   • DCOPY INTO [location]
   • ECREATE PIPE

   Show answer

   Answer: BD

   Next question

9. Question 279 · 1323 in bank

   Which Query Profile operator provides information on pruning efficiency?

   • ATableScan
   • BExternalScan
   • CInternalObject
   • DGenerator

   Show answer

   Answer: B

   Next question

10. Question 280 · 1323 in bank

    What metadata is stored for each micro-partition? (Choose two.)

    • AThe number of distinct values
    • BThe clustering key used in the table
    • CThe average depth of values for each of the columns
    • DThe range of values for each of the columns in the full table
    • EThe minimum and maximum values for each of the columns

    Show answer

    Answer: A

    Explanation

    1. D is not correct, because the question is about metadata stored for each micro-partition. But, in D it is about the full table. 2. Right answer is A and E, because there, it is not mentioned any full table.

    Source: Adapted from community discussion — 37ceea2

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 271. 1323 questions available.