COF-C02 practice questions 881–890

1. Question 881 · 1323 in bank

   Which encryption type will enable client-side encryption for a directory table?

   • AAES
   • BAWS_CSE
   • CSNOWFLAKE_SSE
   • DSNOWFLAKE_FULL

   Show answer

   Answer: D

   Explanation

   SNOWFLAKE_FULL: Client-side encryption. The files are encrypted by a client when it uploads them to the internal stage using PUT. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage

   Source: Adapted from community discussion — miomio123

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 882 · 1323 in bank

   If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

   • ATable definition
   • BStage definition
   • CSession level
   • DCOPY INTO TABLE statement

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

3. Question 883 · 1323 in bank

   A complex SQL query involving eight tables with joins is taking a while to execute. The Query Profile shows that all partitions are being scanned. What is causing the query performance issue?

   • APruning is not being performed efficiently.
   • BA huge volume of data is being fetched, with many joins applied.
   • CIncorrect joins are being used, leading to scanning and pulling too many records.
   • DThe columns in the micro-partitions need granular ordering based on the dataset.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

4. Question 884 · 1323 in bank

   What does Snowflake's search optimization service support?

   • AExternal tables
   • BMaterialized views
   • CTables and views that are not protected by row access policies
   • DCasts on table columns (except for fixed-point numbers cast to strings)

   Show answer

   Answer: C

   Explanation

   Queries Not Supported By the Search Optimization Service¶ The search optimization service does not support the following: External tables. Materialized views. Columns defined with a COLLATE clause. Column concatenation. Analytical expressions. Casts on table columns (except for fixed-point numbers cast to strings). https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-service-supported-data-types

   Source: Adapted from community discussion — ukpino

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 885 · 1323 in bank

   Which table type is no longer available after the close of the session and therefore has no Fail-safe or Time Travel recovery option?

   • AExternal
   • BPermanent
   • CTemporary
   • DTransient

   Show answer

   Answer: C

   Next question

6. Question 886 · 1323 in bank

   How many network policies can be assigned to an account or specific user at a time?

   • AOne
   • BTwo
   • CThree
   • DUnlimited

   Show answer

   Answer: A

   Explanation

   You can create multiple network policies, however only one network policy can be associated with an account at any one time. https://docs.snowflake.com/en/user-guide/network-policies

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation

   Next question

7. Question 887 · 1323 in bank

   True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

   • ATrue
   • BFalse

   Show answer

   Answer: A

   Next question

8. Question 888 · 1323 in bank

   What is a characteristic of a tag associated with a masking policy?

   • AA tag can be dropped after a masking policy is assigned.
   • BA tag can have only one masking policy for each data type.
   • CA tag can have multiple masking policies for each data type.
   • DA tag can have multiple masking policies with varying data types.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

9. Question 889 · 1323 in bank

   Select 2

   Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Choose two.)

   • AGO driver
   • BNode.js driver
   • CODBC driver
   • DPython connector
   • ESpark connector

   Show answer

   Answer: CD

   Explanation

   https://docs.snowflake.com/en/user-guide/security-mfa ODBC driver version 2.23.0 (or later). JDBC driver version 3.12.16 (or later). Python Connector for Snowflake version 2.3.7 (or later).

   Source: Adapted from community discussion — ravuri_rk

   References

   • Snowflake documentation

   Next question

10. Question 890 · 1323 in bank

    What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?

    • A1-16 MB
    • B16-128 MB
    • C100-250 MB
    • D256-512 MB

    Show answer

    Answer: D

    Explanation

    D To optimize the number of parallel scanning operations when querying external tables, we recommend the following file or row group sizes per format: Parquet files 256 - 512 MB

    Source: Adapted from community discussion — 0e504b5

    References

    • Snowflake documentation

    Next question

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

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