COF-C02 practice questions 761–770

1. Question 761 · 1323 in bank

   What ensures that a user with the role SECURITYADMIN can activate a network policy for an individual user?

   • AA role that has been granted the EXECUTE TASK privilege
   • BA role that has been granted the global ATTACH POLICY privilege
   • COwnership privilege on only the role that created the network policy
   • DOwnership privilege on both the user and the network policy

   Show answer

   Answer: D

   Explanation

   The correct answer is D. Only the role with the OWNERSHIP privilege on both the user and the network policy, or a higher role, can activate a network policy for an individual user. https://docs.snowflake.com/en/user-guide/network-policies#activating-network-policies-for-individual-users

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

2. Question 762 · 1323 in bank

   Which function can be combined with the copy command to unload a relational table into a JSON file?

   • AFLATTEN
   • BLISTAGG
   • COBJECT_CONSTRUCT
   • DPARSE_JSON

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

3. Question 763 · 1323 in bank

   A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake. What table type should be used?

   • APermanent
   • BTransient
   • CTemporary
   • DExternal

   Show answer

   Answer: B

   Explanation

   transient tables provide a good option for managing the cost of very large tables used to store transitory data; recommend using transient tables only for data that does not need to be protected against failures or data that can be reconstructed outside of Snowflake.

   Source: Adapted from community discussion — ShagunMittal

   References

   • Snowflake documentation

   Next question

4. Question 764 · 1323 in bank

   While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?

   • ASKIP_BYTE_ORDER_MARK
   • BSTRIP_NULL_VALUE
   • CSTRIP_OUTER_ARRAY
   • DSTRIP_OUTER_ELEMENT

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

5. Question 765 · 1323 in bank

   Select 2

   Which functions can be used to share unstructured data through a secure view? (Choose two.)

   • ABUILD_SCOPED_FILE_URL
   • BBUILD_STAGE_FILE_URL
   • CGET_ABSOLUTE_PATH
   • DGET_PRESIGNED_URL
   • EGET_RELATIVE_PATH

   Show answer

   Answer: AD

   References

   • Snowflake documentation

   Next question

6. Question 766 · 1323 in bank

   Which function will return a row for each for each object in a VARIANT, OBJECT, or ARRAY column?

   • ACAST
   • BFLATTEN
   • CGET
   • DPARSE_JSON

   Show answer

   Answer: B

   Explanation

   The function that will return a row for each object in a VARIANT, OBJECT, or ARRAY column is B. FLATTEN. The FLATTEN function is a table function that takes a VARIANT, OBJECT, or ARRAY column and returns a row for each element or attribute within the column. This can be useful for breaking down complex data structures into a more easily queryable form.

   Source: Adapted from community discussion — junpal

   Next question

7. Question 767 · 1323 in bank

   What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?

   • A1 Kilobyte (KB)
   • B1 Megabyte (MB)
   • C1 Gigabyte (GB)
   • D1 Terabyte (TB)

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

8. Question 768 · 1323 in bank

   Select 2

   Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

   • ASnowSQL
   • BODBC
   • CR
   • DHIVE

   Show answer

   Answer: AB

   Explanation

   SnowSQL (CLI Client) SnowSQL Download ODBC Driver ODBC Download Snowpark API Snowpark Client Download Drivers Drivers and Libraries Scala and Java connectors Drivers and Libraries SnowCD Drivers and Libraries Snowpark ML Drivers and Libraries

   Source: Adapted from community discussion — [Removed]

   References

   • Snowflake documentation

   Next question

9. Question 769 · 1323 in bank

   For the ALLOWED_VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

   • A10
   • B50
   • C64
   • D256

   Show answer

   Answer: D

   Explanation

   None of them As of Feb 2024, it's 300 The ALLOWED_VALUES tag property enables specifying the possible string values that can be assigned to the tag when the tag is set on an object. The maximum number of possible string values for a single tag is 300. https://docs.snowflake.com/en/user-guide/object-tagging#label-object-tagging-specify-tag-values

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation

   Next question

10. Question 770 · 1323 in bank

    Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

    • ATemporary
    • BLocal
    • CUser
    • DTransient

    Show answer

    Answer: A

    References

    • Snowflake documentation

    Next question

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

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