COF-C02 practice questions 1,301–1,310

1. Question 1301 · 1323 in bank

   Which query metric can be used to monitor the health of a large table?

   • AClustering depth
   • BClustering key
   • CTotal partition count
   • DTotal number of rows

   Show answer

   Answer: A

   Next question

2. Question 1302 · 1323 in bank

   Which view can be used to track the read and write operations that have been performed on a table?

   • ACOPY_HISTORY
   • BACCESS_HISTORY
   • CQUERY_HISTORY
   • DTASK_HISTORY

   Show answer

   Answer: B

   Next question

3. Question 1303 · 1323 in bank

   What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

   • AStream
   • BTask
   • CStorage integration
   • DNamed file format

   Show answer

   Answer: D

   Next question

4. Question 1304 · 1323 in bank

   How should the SPLIT_TO_TABLE([string], [delimiter]) function be called?

   • ASELECT SPLIT_TO_TABLE(COL1, '.') FROM DUAL;
   • BSELECT SPLIT_TO_TABLE('a.b.c', '.');
   • CSELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.'));
   • DSELECT * FROM SPLIT_TO_TABLE('a.b.c', '.');

   Show answer

   Answer: C

   Next question

5. Question 1305 · 1323 in bank

   Which role has the HIGHEST precedence among roles that will serve as the owners of securable objects?

   • AUSERADMIN
   • BSYSADMIN
   • CSECURITYADMIN
   • DACCOUNTADMIN

   Show answer

   Answer: D

   Next question

6. Question 1306 · 1323 in bank

   Select 2

   How is data protected in Snowflake throughout its lifecycle? (Choose two.)

   • AUsers are responsible for encrypting data before uploading to Snowflake.
   • BSnowflake automatically tags and masks Personal Identifiable Information (PII).
   • CSnowflake automatically encrypts data locally before copying the data to the cloud over an encrypted connection.
   • DSnowflake automatically rotates keys pairs regularly, using a hierarchical key model stored in a hardware security module.
   • EUsers are responsible for uploading and configuring key pair rotation schedules and key sizes to encrypt stored data.

   Show answer

   Answer: CD

   Next question

7. Question 1307 · 1323 in bank

   Which object consumes Snowflake credits for its maintenance?

   • AMaterialized view
   • BView
   • CExternal table
   • DTable

   Show answer

   Answer: A

   Next question

8. Question 1308 · 1323 in bank

   Select 2

   When connecting to Snowflake using SnowSQL, what are ways to explicitly specify the password? (Choose two.)

   • AUse public and private key pair authentication
   • BRun a web-based authorization flow
   • CUse an OAuth token
   • DEnter through an interactive prompt
   • ESpecify using SNOWSQL_PWD environment variables

   Show answer

   Answer: DE

   Next question

9. Question 1309 · 1323 in bank

   Which object can be shared using Secure Data Sharing?

   • ASecure view
   • BMaterialized view
   • CExternal function
   • DUser-Defined Function (UDF)

   Show answer

   Answer: A

   Next question

10. Question 1310 · 1323 in bank

    Which clause is used to define a function that may return different values for different rows?

    • AIMMUTABLE
    • BRETURNS
    • CCOMMENT
    • DVOLATILE

    Show answer

    Answer: D

    Next question

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

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