COF-C02 practice questions 161–170

1. Question 161 · 1323 in bank

   Select 2

   What are the possible values within a METADATA$ACTION column in a Snowflake stream? (Choose two.)

   • AINSERT
   • BUPDATE
   • CDELETE
   • DTRUNCATE
   • EUPSERT

   Show answer

   Answer: AC

   Next question

2. Question 162 · 1323 in bank

   The fail-safe retention period is how many days?

   • A1 day
   • B7 days
   • C45 days
   • D90 days

   Show answer

   Answer: B

   Next question

3. Question 163 · 1323 in bank

   What is the MINIMUM Snowflake edition that offers data protection for extremely sensitive data, such as Protected Health Information (PHI)?

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

   Show answer

   Answer: C

   Next question

4. Question 164 · 1323 in bank

   What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

   • AThe stage definition
   • BThe table definition
   • CThe use of a COPY INTO [table] statement
   • DThe use of a COPY INTO [location] statement

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

5. Question 165 · 1323 in bank

   Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?

   • ASnowsight
   • BSnowCD
   • CSnowpark
   • DSnowSQL

   Show answer

   Answer: D

   Next question

6. Question 166 · 1323 in bank

   What Snowflake objects can contain custom application logic written in JavaScript? (Choose two.)

   • AStored procedures
   • BStages
   • CTasks
   • DViews
   • EUser-Defined Functions (UDFs)

   Show answer

   Answer: E

   Next question

7. Question 167 · 1323 in bank

   What is the MINIMUM Snowflake edition required to use the column-level security feature?

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

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

8. Question 168 · 1323 in bank

   Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

   • AALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
   • BALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
   • CALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
   • DALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

9. Question 169 · 1323 in bank

   What is the purpose of the use of the VALIDATE command?

   • ATo view any queries that encountered an error
   • BTo verify that a SELECT query will run without error
   • CTo prevent a PUT statement from running if an error occurs
   • DTo see all errors from a previously run COPY INTO [table] statement

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

10. Question 170 · 1323 in bank

    Which function is used to unload a relational table into a JSON file?

    • APARSE_JSON
    • BJSON_EXTRACT_PATH_TEXT
    • COBJECT_CONSTRUCT
    • DTO_JSON

    Show answer

    Answer: D

    Explanation

    D. TO_JSON Explanation: TO_JSON is used to convert relational data into JSON format, which is ideal when unloading a relational table into a JSON file. Why the others are wrong: A. PARSE_JSON: This function is used to parse a JSON string into a Snowflake-compatible format, not for converting relational data into JSON. B. JSON_EXTRACT_PATH_TEXT: This function extracts specific values from JSON data, but it doesn't convert relational data into JSON. C. OBJECT_CONSTRUCT: This creates a JSON object from key-value pairs, but it doesn't convert the entire relational data into JSON format. Example of using TO_JSON: SELECT TO_JSON(OBJECT_CONSTRUCT(*)) FROM my_table;

    Source: Adapted from community discussion — md_2000

    Next question

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

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