COF-C02 practice questions 1,161–1,170

1. Question 1161 · 1323 in bank

   Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

   • APersisted query results
   • BQUERY_HISTORY view
   • CQuery acceleration service
   • DQuery Profile

   Show answer

   Answer: D

   Explanation

   Analyze and optimize SQL queries by examining execution plans and identifying potential bottlenecks. Use Snowflake's query profiling tools to understand query performance characteristics and optimize accordingly. Consider breaking down complex queries into smaller, more manageable steps to improve performance. https://www.linkedin.com/advice/1/how-can-you-optimize-performance-snowflake-data-5jhec

   Source: Adapted from community discussion — nexerSnow

   Next question

2. Question 1162 · 1323 in bank

   What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

   • AFail-safe
   • BTime Travel
   • CCloning
   • DAccount replication

   Show answer

   Answer: A

   Next question

3. Question 1163 · 1323 in bank

   Which function should be used to authorize users to access rows in a base table when using secure views with Secure Data Sharing?

   • ACURRENT_ACCOUNT()
   • BCURRENT_ROLE()
   • CCURRENT_SESSION()
   • DCURRENT_USER()

   Show answer

   Answer: A

   Explanation

   The correct answer is A. CURRENT_ACCOUNT() Secure Views and Data Sharing When using secure views with Secure Data Sharing, use the CURRENT_ACCOUNT function to authorize users from a specific account to access rows in a base table. ------------------------------------------------------------------------------------------------------------------------------- Note: When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions. The reason is that the owner of the data being shared does not typically control the users or roles in the account with which the view is being shared. https://docs.snowflake.com/en/user-guide/views-secure#secure-views-and-data-sharing

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

4. Question 1164 · 1323 in bank

   What is the purpose of collecting statistics on data in Snowflake?

   • ATo identify data storage order correlations
   • BTo enable efficient pruning based on query filters
   • CTo reduce the total number of micro-partitions in a table
   • DTo optimize query performance by reading all data in a table

   Show answer

   Answer: B

   Next question

5. Question 1165 · 1323 in bank

   What type of function returns one value for each invocation?

   • AAggregate
   • BScalar
   • CTable
   • DWindow

   Show answer

   Answer: B

   Explanation

   A scalar function is a function that returns one value per invocation; in most cases, you can think of this as returning one value per row. This contrasts with Aggregate Functions, which return one value per group of rows.

   Source: Adapted from community discussion — gizzamo

   References

   • Snowflake documentation

   Next question

6. Question 1166 · 1323 in bank

   Select 2

   Which file formats support unloading semi-structured data? (Choose two.)

   • AAvro
   • BJSON
   • CORC
   • DParquet
   • EXML

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

7. Question 1167 · 1323 in bank

   Which system-defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?

   • AACCOUNTADMIN
   • BSECURITYADMIN
   • CSYSADMIN
   • DORGADMIN

   Show answer

   Answer: D

   Explanation

   https://docs.snowflake.com/en/sql-reference/sql/alter-account Organization administrators (i.e. users with the ORGADMIN role) to: Rename an account and specify whether the original URL can be used to access the account.

   Source: Adapted from community discussion — 6c79d6f

   References

   • Snowflake documentation

   Next question

8. Question 1168 · 1323 in bank

   How can a user get the MOST detailed information about individual table storage details in Snowflake?

   • ASHOW TABLES command
   • BSHOW EXTERNAL TABLES command
   • CTABLES view
   • DTABLE_STORAGE_METRICS view

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

9. Question 1169 · 1323 in bank

   A Snowflake user wants to design a series of transformations that need to be executed in a specific order, on a given schedule. What Snowflake objects should be used?

   • APipes
   • BTasks
   • CStreams
   • DSequences

   Show answer

   Answer: B

   Next question

10. Question 1170 · 1323 in bank

    True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

    • ATrue
    • BFalse

    Show answer

    Answer: A

    Explanation

    "Snowflake stores metadata about all rows stored in a micro-partition, including: - The range of values for each of the columns in the micro-partition. - The number of distinct values. - Additional properties used for both optimization and efficient query processing." Seems to me that this is done by the Cloud Services layer, and this "Global Services layer" looks like another term for it: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions

    Source: Adapted from community discussion — oscarglob

    References

    • Snowflake documentation
    • Snowflake documentation

    Next question

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

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