COF-C02 practice questions 591–600

1. Question 591 · 1323 in bank

   Which statement MOST accurately describes clustering in Snowflake?

   • AThe database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
   • BClustering is the way data is grouped together and stored within Snowflake micro-partitions.
   • CThe clustering key must be included in the COPY command when loading data into Snowflake.
   • DClustering can be disabled within a Snowflake account.

   Show answer

   Answer: B

   Next question

2. Question 592 · 1323 in bank

   Which of the following roles is recommended to be used to create and manage users and roles?

   • ASYSADMIN
   • BSECURITYADMIN
   • CPUBLIC
   • DACCOUNTADMIN

   Show answer

   Answer: B

   Explanation

   I think the answer to this should be USERADMIN which is not in the options. So the next best answer will be SECURITYADMIN

   Source: Adapted from community discussion — blazingliverbird

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 593 · 1323 in bank

   Select 2

   A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

   • AThe exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
   • BThe same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
   • CThe same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
   • DThe ג€24 hourג€ timer on the precomputed results gets renewed every time the exact query is executed

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

4. Question 594 · 1323 in bank

   Select 2

   Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

   • AConfigure the user to be initially disabled.
   • BForce an immediate password change.
   • CSet a default role for the user.
   • DSet the number of minutes to unlock to 15 minutes.
   • ESet the user's access to expire within a specified timeframe.

   Show answer

   Answer: BC

   References

   • Snowflake documentation

   Next question

5. Question 595 · 1323 in bank

   Select 2

   Network policies can be applied to which of the following Snowflake objects? (Choose two.)

   • ARoles
   • BDatabases
   • CWarehouses
   • DUsers
   • EAccounts

   Show answer

   Answer: DE

   References

   • Snowflake documentation

   Next question

6. Question 596 · 1323 in bank

   Where is Snowflake metadata stored?

   • AWithin the data files
   • BIn the virtual warehouse layer
   • CIn the cloud services layer
   • DIn the remote storage layer

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

7. Question 597 · 1323 in bank

   Select 2

   What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)

   • AKEY
   • BNODE
   • CVALUE
   • DLEVEL
   • EROOT

   Show answer

   Answer: AC

   References

   • Snowflake documentation

   Next question

8. Question 598 · 1323 in bank

   Select 2

   Which of the following Snowflake features provide continuous data protection automatically? (Choose two.)

   • AInternal stages
   • BIncremental backups
   • CTime Travel
   • DZero-copy clones
   • EFail-safe

   Show answer

   Answer: CE

   References

   • Snowflake documentation

   Next question

9. Question 599 · 1323 in bank

   A developer is granted ownership of a table that has a masking policy. The developer’s role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

   • AYes, because a table owner has full control and can unset masking policies.
   • BYes, because masking policies only apply to cloned tables.
   • CNo, because masking policies must always reference specific access roles.
   • DNo, because ownership of a table does not include the ability to change masking policies.

   Show answer

   Answer: D

   Explanation

   Object owners (i.e. the role that has the OWNERSHIP privilege on the object) do not have the privilege to unset masking policies. Object owners cannot view column data in which a masking policy applies. https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies

   Source: Adapted from community discussion — miadiesel

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 600 · 1323 in bank

    How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

    • AConfigure the warehouse to a size larger than generally required
    • BSet the minimum and maximum clusters to autoscale
    • CUse the standard warehouse scaling policy
    • DUse the economy warehouse scaling policy

    Show answer

    Answer: C

    Explanation

    The economy policy doesn't start immediately Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes. https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

    Source: Adapted from community discussion — SV1122

    References

    • Snowflake documentation

    Next question

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

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