COF-C02 practice questions 81–90

1. Question 81 · 1323 in bank

   What function, combined with the copy command, should be used to unload data from a relational table into a JSON file?

   • ALATERAL
   • BCAST
   • CFLATTEN
   • DOBJECT_CONSTRUCT

   Show answer

   Answer: D

   Explanation

   D is correct: Unloading a relational table to JSON You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file. https://docs.snowflake.com/en/user-guide/data-unload-considerations

   Source: Adapted from community discussion — 4762448

   References

   • Snowflake documentation

   Next question

2. Question 82 · 1323 in bank

   What is the primary purpose of a directory table in Snowflake?

   • ATo store actual data from external stages
   • BTo automatically expire file URLs for security
   • CTo manage user privileges and access control
   • DTo store file-level metadata about data files in a stage

   Show answer

   Answer: D

   Explanation

   A directory table is an implicit object layered on a stage that stores file-level metadata about the data files in the stage, similar conceptually to an external table You can query a directory table to retrieve a list of all the files on a stage. The query output contains information about each file, including the size, last modified timestamp, and the file URL Directory tables store data file metadata https://docs.snowflake.com/en/user-guide/data-load-dirtablesThe key points are:

   Source: Adapted from community discussion — peter_4321

   References

   • Snowflake documentation

   Next question

3. Question 83 · 1323 in bank

   Select 2

   Which Snowflake table objects can be shared with other accounts? (Choose two.)

   • ATemporary tables
   • BPermanent tables
   • CTransient tables
   • DExternal tables
   • EUser-Defined Table Functions (UDTFs)

   Show answer

   Answer: BD

   Explanation

   "Secure Data Sharing lets you share selected objects in a database in your account with other Snowflake accounts. You can share the following Snowflake objects: Databases Tables Dynamic tables External tables Iceberg tables Secure views Secure materialized views Secure user-defined functions (UDFs)"

   Source: Adapted from community discussion — Jacobr5000

   Next question

4. Question 84 · 1323 in bank

   Which metadata table will store the storage utilization information even for dropped tables?

   • ADATABASE_STORAGE_USAGE_HISTORY
   • BTABLE_STORAGE_METRICS
   • CSTORAGE_DAILY_HISTORY
   • DSTAGE_STORAGE_USAGE_HISTORY

   Show answer

   Answer: B

   Explanation

   TABLE_STORAGE_METRICS View: This view displays table-level storage utilization information, which is used to calculate the storage billing for each table in the account, including tables that have been dropped, but are still incurring storage costs.

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation

   Next question

5. Question 85 · 1323 in bank

   How is role hierarchy established in Snowflake?

   • ABy assigning users to roles
   • BBy default when a role is created
   • CBy granting one role to another role
   • DBy transferring ownership of one role to another role

   Show answer

   Answer: C

   Explanation

   "Granting a role to another role creates a “parent-child” relationship between the roles (also referred to as a role hierarchy)."

   Source: Adapted from community discussion — Jacobr5000

   References

   • Snowflake documentation

   Next question

6. Question 86 · 1323 in bank

   Select 2

   What commands can be used to see what files are stored in a stage? (Choose two.)

   • ALIST
   • BSELECT
   • CLS
   • DGET
   • EDESCRIBE

   Show answer

   Answer: AC

   Explanation

   LIST, LS Returns a list of files that have been staged (i.e. uploaded from a local file system or unloaded from a table) in one of the following Snowflake stages:

   Source: Adapted from community discussion — nexerSnow

   Next question

7. Question 87 · 1323 in bank

   Select 2

   Which stages are created by default, with no need to use the CREATE STAGE command? (Choose two.)

   • AExternal stage
   • BInternal stage
   • CNamed stage
   • DTable stage
   • EUser stage

   Show answer

   Answer: DE

   References

   • Snowflake documentation

   Next question

8. Question 88 · 1323 in bank

   While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

   • ABUILD_STAGE_FILE_URL
   • BGET_ABSOLUTE_PATH
   • CBUILD_SCOPED_FILE_URL
   • DGET_PRESIGNED_URL

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

9. Question 89 · 1323 in bank

   Select 2

   Who can create and manage reader accounts? (Choose two.)

   • AA user with ACCOUNTADMIN role
   • BA user with SECURITYADMIN role
   • CA user with SYSADMIN role
   • DA user with ORGADMIN role
   • EA user with CREATE ACCOUNT privilege

   Show answer

   Answer: AE

   Explanation

   "All tasks described in this topic must be performed using the ACCOUNTADMIN role or a role granted the CREATE ACCOUNT global privilege."

   Source: Adapted from community discussion — Jacobr5000

   References

   • Snowflake documentation

   Next question

10. Question 90 · 1323 in bank

    Which command allows for continuous loading of data files as soon as they are available in a stage?

    • ACOPY INTO [table]
    • BPUT
    • CCREATE PIPE
    • DGET

    Show answer

    Answer: C

    References

    • Snowflake documentation

    Next question

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

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