COF-C02 practice questions 41–50

1. Question 41 · 1323 in bank

   Select 2

   Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)

   • AINTEGER
   • BOBJECT
   • CVARIANT
   • DVARCHAR
   • ELIST

   Show answer

   Answer: BC

   References

   • Snowflake documentation

   Next question

2. Question 42 · 1323 in bank

   Select 2

   Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)

   • ABytes scanned
   • BBytes written to result
   • CPartitions scanned
   • DPartitions total
   • EPercentage scanned from cache

   Show answer

   Answer: CD

   References

   • Snowflake documentation

   Next question

3. Question 43 · 1323 in bank

   Which element in the Query Profile interface shows the relationship between the nodes in the execution of a query?

   • ANode List
   • BSteps
   • COverview
   • DOperator Tree

   Show answer

   Answer: D

   Explanation

   https://docs.snowflake.com/en/user-guide/ui-query-profile Operator tree The middle pane displays a graphical representation of all the operator nodes for the selected step, including the relationships between each operator node.

   Source: Adapted from community discussion — SSahar

   References

   • Snowflake documentation

   Next question

4. Question 44 · 1323 in bank

   What will happen if a Snowflake user suspends the updates to a materialized view?

   • AThe queries on that view will generate an error message.
   • BThe queries on that view will return the last stored data.
   • CThe queries on that view will return the data using Time Travel.
   • DThe queries on that view will return the data with a warning message.

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

5. Question 45 · 1323 in bank

   Which Snowflake function will parse a JSON-null into a SQL-null?

   • ATO_CHAR
   • BTO_VARIANT
   • CTO_VARCHAR
   • DSTRIP_NULL_VALUE

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

6. Question 46 · 1323 in bank

   Which Snowflake command can be used to unload the result of a query to a single file?

   • AUse COPY INTO [external stage] followed by a GET command to download the file.
   • BUse COPY INTO [internal stage] followed by a PUT command to download the file.
   • CUse COPY INTO [internal stage] with SINGLE = TRUE followed by a GET command to download the file.
   • DUse COPY INTO [external stage] with SINGLE = TRUE followed by a PUT command to download the file.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

7. Question 47 · 1323 in bank

   As a best practice, clustering keys should only be defined on tables of which minimum size?

   • AMulti-Kilobyte (KB) Range
   • BMulti-Megabyte (MB) Range
   • CMulti-Gigabyte (GB) Range
   • DMulti-Terabyte (TB) Range

   Show answer

   Answer: D

   Explanation

   D is correct Considerations for Choosing Clustering for a Table Whether you want faster response times or lower overall costs, clustering is best for a table that meets all of the following criteria: The table contains a large number of micro-partitions. Typically, this means that the table contains multiple terabytes (TB) of data.

   Source: Adapted from community discussion — datamech001

   References

   • Snowflake documentation

   Next question

8. Question 48 · 1323 in bank

   How are micro-partitions enabled on Snowflake tables?

   • AMicro-partitioning requires a cluster key on a table.
   • BMicro-partitioning is automatically performed on a table.
   • CMicro-partitioning requires the use of the search optimization service.
   • DMicro-partitioning is defined by the user when a table is created.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

9. Question 49 · 1323 in bank

   What persistent data structures are used by the search optimization service to improve the performance of point lookups?

   • AMicro-partitions
   • BClustering keys
   • CEquality searches
   • DSearch access paths

   Show answer

   Answer: D

   Explanation

   To improve performance of search queries, the search optimization service creates and maintains a persistent data structure called a search access path. The search access path keeps track of which values of the table’s columns might be found in each of its micro-partitions, allowing some micro-partitions to be skipped when scanning the table.

   Source: Adapted from community discussion — nexerSnow

   References

   • Snowflake documentation

   Next question

10. Question 50 · 1323 in bank

    Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

    • AOAuth
    • BNetwork policies
    • CSingle Sign-On (SSO)
    • DMulti-Factor Authentication (MFA)

    Show answer

    Answer: D

    Explanation

    Snowflake supports multi-factor authentication (i.e. MFA) to provide increased login security for users connecting to Snowflake. MFA support is provided as an integrated Snowflake feature, powered by the Duo Security service, which is managed completely by Snowflake.

    Source: Adapted from community discussion — nexerSnow

    References

    • Snowflake documentation

    Next question

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

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