COF-C02 practice questions 381–390

1. Question 381 · 1323 in bank

   What is the maximum Time Travel retention period for a temporary Snowflake table?

   • A90 days
   • B1 day
   • C7 days
   • D45 days

   Show answer

   Answer: B

   Next question

2. Question 382 · 1323 in bank

   When should a multi-cluster warehouse be used in auto-scaling mode?

   • AWhen it is unknown how much compute power is needed
   • BIf the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
   • CIf the runtime of the executed query is very slow
   • DWhen a large number of concurrent queries are run on the same warehouse

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

3. Question 383 · 1323 in bank

   Select 3

   Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

   • AGrowth of storage and compute are tightly coupled together
   • BStorage expands without the requirement to add more compute
   • CCompute can be scaled up or down without the requirement to add more storage
   • DMultiple compute clusters can access stored data without contention

   Show answer

   Answer: BCD

   Next question

4. Question 384 · 1323 in bank

   Select 2

   What happens when a cloned table is replicated to a secondary database? (Choose two.)

   • AA read-only copy of the cloned tables is stored.
   • BThe replication will not be successful.
   • CThe physical data is replicated.
   • DAdditional costs for storage are charged to a secondary account.
   • EMetadata pointers to cloned tables are replicated.

   Show answer

   Answer: CD

   Explanation

   Answers C&D are correct. For C read this: Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni For D , read this : Charges based on replication are divided into two categories: data transfer and compute resources. Both categories are billed on the target account (i.e. the account that stores the secondary database or secondary replication/failover group that is refreshed). https://docs.snowflake.com/en/user-guide/account-replication-cost

   Source: Adapted from community discussion — Vinit_Agarwal

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 385 · 1323 in bank

   Select 3

   Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

   • AAmazon Web Services
   • BDocker
   • CIBM Cloud
   • DMicrosoft Azure Cloud
   • EGoogle Cloud Platform
   • FOracle Cloud

   Show answer

   Answer: ADE

   Next question

6. Question 386 · 1323 in bank

   What is a limitation of a Materialized View?

   • AA Materialized View cannot support any aggregate functions
   • BA Materialized View can only reference up to two tables
   • CA Materialized View cannot be joined with other tables
   • DA Materialized View cannot be defined with a JOIN

   Show answer

   Answer: D

   Explanation

   Answer C does not make any sense at all. There is no concept of joining materialized views by another tables. Tables, per se, can join. So answer is D

   Source: Adapted from community discussion — lol632

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 387 · 1323 in bank

   In the Snowflake access control model, which entity owns an object by default?

   • AThe user who created the object
   • BThe SYSADMIN role
   • COwnership depends on the type of object
   • DThe role used to create the object

   Show answer

   Answer: D

   Next question

8. Question 388 · 1323 in bank

   What is the minimum Snowflake edition required to use Dynamic Data Masking?

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

   Show answer

   Answer: B

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 389 · 1323 in bank

   Select 2

   Which services does the Snowflake Cloud Services layer manage? (Choose two.)

   • ACompute resources
   • BQuery execution
   • CAuthentication
   • DData storage
   • EMetadata

   Show answer

   Answer: CE

   References

   • Snowflake documentation

   Next question

10. Question 390 · 1323 in bank

    A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII. Which Snowflake feature will support this?

    • ARow access policies
    • BData masking policies
    • CData encryption
    • DRole based access control

    Show answer

    Answer: B

    Explanation

    If you have a table with a column including PII, masking rows will not solve the issue. What we need is to make the data in this column visible to some, and masked to some. Thus we need to use dynamic data masking.

    Source: Adapted from community discussion — YokoSumiGaeshi

    Next question

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

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