COF-C02 practice questions 1,191–1,200

1. Question 1191 · 1323 in bank

   Select 2

   Snowflake users can create a resource monitor at which levels? (Choose two.)

   • AUser level
   • BPipe level
   • CAccount level
   • DCloud services level
   • EVirtual warehouse level

   Show answer

   Answer: CE

   Next question

2. Question 1192 · 1323 in bank

   Select 2

   Any user with the appropriate privileges can view data storage for individual tables by using which queries? (Choose two.)

   • AMETERING_HISTORY view in the ACCOUNT_USAGE schema
   • BTABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
   • CSTORAGE_USAGE view in the ACCOUNT_USAGE schema
   • DTABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema
   • EMETERING_DAILY_HISTORY view in the ORGANIZATION_USAGE schema

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

3. Question 1193 · 1323 in bank

   Select 2

   Which Snowflake objects can be secured to protect data privacy? (Choose two.)

   • ASchemas
   • BStages
   • CViews
   • DMaterialized views
   • ETags

   Show answer

   Answer: CD

   Next question

4. Question 1194 · 1323 in bank

   A user created a database and set the DATA_RETENTION_TIME_IN_DAYS to 30, but did not set the DATA_RETENTION_TIME_IN_DAYS in table T1. After 5 days, the user accidentally drops table T1. What are the considerations for recovering table T1?

   • AThe user can recover the table T1 after 30 days.
   • BThe table can be recovered because the table retention period default is at the database level.
   • CThe table can only be recovered by contacting Snowflake Support to recover the table from Fail-safe.
   • DThe table cannot be recovered because the DATA_RETENTION_TIME_IN_DAYS was not set for table T1.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

5. Question 1195 · 1323 in bank

   Select 2

   What table functions in the Snowflake Information Schema can be queried to retrieve information about directory tables? (Choose two.)

   • AAUTO_REFRESH_REGISTRATION_HISTORY
   • BEXTERNAL_TABLE_FILE_REGISTRATION_HISTORY
   • CEXTERNAL_TABLE_FILES
   • DMATERIALIZED_VIEW_REFRESH_HISTORY
   • ESTAGE_DIRECTORY_FILE_REGISTRATION_HISTORY

   Show answer

   Answer: AE

   Explanation

   AUTO_REFRESH_REGISTRATION_HISTORY: Retrieve the history of data files registered in the metadata of specified objects and the credits billed for these operations. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY: Retrieve information about the metadata history for a directory table, including any errors found when refreshing the metadata.

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation

   Next question

6. Question 1196 · 1323 in bank

   Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

   • ANOTIFY
   • BNOTIFY_USERS
   • CSUSPEND
   • DSUSPEND_IMMEDIATE

   Show answer

   Answer: D

   Next question

7. Question 1197 · 1323 in bank

   Which Snowflake table type persists until it is explicitly dropped, is available for all users with relevant privileges (across sessions), and has no Fail-safe period?

   • AExternal
   • BPermanent
   • CTemporary
   • DTransient

   Show answer

   Answer: D

   Next question

8. Question 1198 · 1323 in bank

   Select 2

   Snowflake’s access control framework combines which models for securing data? (Choose two.)

   • AAttribute-based Access Control (ABAC)
   • BDiscretionary Access Control (DAC)
   • CAccess Control List (ACL)
   • DRole-based Access Control (RBAC)
   • ERule-based Access Control (RuBAC)

   Show answer

   Answer: BD

   Next question

9. Question 1199 · 1323 in bank

   Which semi-structured file format is a compressed, efficient, columnar data representation?

   • AAvro
   • BJSON
   • CTSV
   • DParquet

   Show answer

   Answer: D

   Next question

10. Question 1200 · 1323 in bank

    How does Snowflake describe its unique architecture?

    • AA single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)
    • BA multi-cluster shared data architecture using a central data repository and massively parallel processing (MPP)
    • CA single-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)
    • DA multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

    Show answer

    Answer: B

    References

    • Snowflake documentation

    Next question

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

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