COF-C02 practice questions 1,021–1,030

1. Question 1021 · 1323 in bank

   Select 2

   What are the recommended steps to address poor SQL query performance due to data spilling? (Choose two.)

   • AClone the base table.
   • BFetch required attributes only.
   • CUse a larger virtual warehouse.
   • DProcess the data in smaller batches.
   • EAdd another cluster in the virtual warehouse.

   Show answer

   Answer: CD

   Explanation

   Answer is C and D https://docs.snowflake.com/en/user-guide/ui-query-profile For some operations (e.g. duplicate elimination for a huge data set), the amount of memory available for the compute resources used to execute the operation might not be sufficient to hold intermediate results. As a result, the query processing engine will start spilling the data to local disk. If the local disk space is not sufficient, the spilled data is then saved to remote disks. This spilling can have a profound effect on query performance (especially if remote disk is used for spilling). To alleviate this, we recommend: Using a larger warehouse (effectively increasing the available memory/local disk space for the operation), and/or Processing data in smaller batches.

   Source: Adapted from community discussion — ahadh7621

   References

   • Snowflake documentation

   Next question

2. Question 1022 · 1323 in bank

   Select 2

   A Snowflake user wants to share unstructured data through the use of secure views. Which URL types can be used? (Choose two.)

   • AScoped URL
   • BHTTPS URL
   • CCloud storage URL
   • DFile URL
   • EPre-signed URL

   Show answer

   Answer: AE

   References

   • Snowflake documentation

   Next question

3. Question 1023 · 1323 in bank

   Select 2

   What are characteristics of reader accounts in Snowflake? (Choose two.)

   • AReader account users cannot add new data to the account.
   • BReader account users can share data to other reader accounts.
   • CA single reader account can consume data from multiple provider accounts.
   • DData consumers are responsible for reader account setup and data usage costs.
   • EReader accounts enable data consumers to access and query data shared by the provider.

   Show answer

   Answer: AE

   References

   • Snowflake documentation

   Next question

4. Question 1024 · 1323 in bank

   Select 2

   Why should a Snowflake user configure a secure view? (Choose two.)

   • ATo encrypt the data in transit
   • BTo execute faster than a standard view
   • CTo protect hidden data from other users
   • DTo improve the performance of a query
   • ETo hide the view definition from other users

   Show answer

   Answer: CE

   Explanation

   CE Some of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow data that is hidden from users of the view to be exposed through user code, such as user-defined functions, or other programmatic methods. Secure views do not utilize these optimizations, ensuring that users have no access to the underlying data. For security or privacy reasons, you might not wish to expose the underlying tables or internal structural details for a view. With secure views, the view definition and details are visible only to authorized users (i.e. users who are granted the role that owns the view).

   Source: Adapted from community discussion — Pawanpant

   Next question

5. Question 1025 · 1323 in bank

   Select 2

   Which activities are managed by Snowflake’s Cloud Services layer? (Choose two.)

   • AAuthentication
   • BAccess delegation
   • CData pruning
   • DData compression
   • EQuery parsing and optimization

   Show answer

   Answer: AE

   Next question

6. Question 1026 · 1323 in bank

   Account-level storage usage can be monitored via:

   • AThe Snowflake Web Interface (UI) in the Databases section
   • BThe Snowflake Web Interface (UI) in the Account -> Billing & Usage section
   • CThe Information Schema -> ACCOUNT_USAGE_HISTORY View
   • DThe Account Usage Schema -> ACCOUNT_USAGE_METRICS View

   Show answer

   Answer: B

   Explanation

   B is correct. for D it should be TABLE_STORAGE_METRICS not ACCOUNT_USAGE_METRICS. there is no view with account_usage_metrics name. if D has said view name is TABLE_STORAGE_METRICS then its correct

   Source: Adapted from community discussion — bharathmv

   References

   • Snowflake documentation

   Next question

7. Question 1027 · 1323 in bank

   Select 2

   The number of queries that a Virtual Warehouse can concurrently process is determined by (Choose two.):

   • AThe complexity of each query
   • BThe CONCURRENT_QUERY_LIMIT parameter set on the Snowflake account
   • CThe size of the data required for each query
   • DThe tool that is executing the query

   Show answer

   Answer: AC

   Explanation

   Answer: AC MAX_CONCURRENCY_LEVEL is set to 8 by default at account level and can be changed. In reality, we can have more than 8 concurrent queries as well. But it depends on the factors such as the complexity of the queries, their resource consumptions etc.

   Source: Adapted from community discussion — vivek_nitd

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 1028 · 1323 in bank

   Select 2

   The COPY INTO [location] command can unload data from a table directly into which locations? (Choose two.)

   • AA named internal stage
   • BA Snowpipe REST endpoint
   • CA network share on a client machine
   • DA local directory or folder on a client machine
   • EA named external stage that references an external cloud location

   Show answer

   Answer: AE

   Explanation

   AE is correct Copy into is possible for 1) Named internal stage (or table/user stage). 2) Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure). 3) External location https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

9. Question 1029 · 1323 in bank

   Select 2

   What does the Activity area of Snowsight allow users to do? (Choose two.)

   • ASchedule automated data backups.
   • BExplore each step of an executed query.
   • CMonitor queries executed by users in an account.
   • DCreate and manage user roles and permissions.
   • EAccess Snowflake Marketplace to find and integrate datasets.

   Show answer

   Answer: BC

   Explanation

   BC is correct. The keyword is activity area! The Activity area of Snowsight, the Snowflake web interface, lets you: 1)Monitor queries executed by users in your account. 2)View details about queries. 3)View performance data. 4)Explore each step of an executed query. 5)Monitor the status of data loading using COPY INTO (bulk loading) and pipes (continuous loading). 6)View details about instances of bulk and continuous data loading. 7)Navigate to the copy history for individual tables. https://docs.snowflake.com/en/user-guide/ui-snowsight-activity

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 1030 · 1323 in bank

    In which Snowsight section can a user switch roles, modify their profile, and access documentation?

    • AThe user menu
    • BThe activity page
    • CThe content pane
    • DThe worksheets page

    Show answer

    Answer: A

    References

    • Snowflake documentation

    Next question

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

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