COF-C02 practice questions 1,131–1,140

1. Question 1131 · 1323 in bank

   Select 2

   In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Choose two.)

   • AAuthorizing users
   • BInitiating user sessions
   • CLogging into Snowflake
   • DLogging out of Snowflake
   • EPerforming role authentication

   Show answer

   Answer: CD

   Explanation

   The correct Answer is C and D. Federated authentication enables the following SSO workflows: Logging into Snowflake. Logging out of Snowflake. System timeout due to inactivity. https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-overview#supported-sso-workflows

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

2. Question 1132 · 1323 in bank

   What does the worksheet and database explorer feature in Snowsight allow users to do?

   • AAdd or remove users from a worksheet.
   • BMove a worksheet to a folder or a dashboard.
   • CCombine multiple worksheets into a single worksheet.
   • DTag frequently accessed worksheets for ease of access.

   Show answer

   Answer: B

   Explanation

   The correct answer is B. Move a worksheet to a folder or a dashboard. The worksheet and database explorer feature in Snowsight, Snowflake's web-based SQL editor and data visualization tool, allows users to organize and manage their worksheets effectively. While the other options mentioned (A, C, and D) are not specific to the worksheet and database explorer feature, moving a worksheet to a folder or a dashboard is a key functionality provided by Snowsight. By using the worksheet and database explorer, users can easily organize their worksheets by creating folders or dashboards and moving worksheets into them. This helps in maintaining a structured and organized workspace, making it easier to locate and access specific worksheets when needed.

   Source: Adapted from community discussion — Pawanpant

   References

   • Snowflake documentation

   Next question

3. Question 1133 · 1323 in bank

   Select 2

   When unloading data from Snowflake to AWS, what permissions are required? (Choose two.)

   • As3:DeleteObject
   • Bs3:CopyObject
   • Cs3:GetBucketAcl
   • Ds3:PutObject
   • Es3:GetBucketLocation

   Show answer

   Answer: AD

   Explanation

   Answer is A & D. Snowflake requires the following permissions on an S3 bucket and folder to create new files in the folder (and any sub-folders): s3:DeleteObject s3:PutObject https://docs.snowflake.com/en/user-guide/data-unload-s3#configuring-an-s3-bucket-for-unloading-data

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation

   Next question

4. Question 1134 · 1323 in bank

   What step can reduce data spilling in Snowflake?

   • AUsing a larger virtual warehouse
   • BIncreasing the virtual warehouse maximum timeout limit
   • CIncreasing the amount of remote storage for the virtual warehouse
   • DUsing a Common Table Expression (CTE) instead of a temporary table

   Show answer

   Answer: A

   Explanation

   Answer A is correct! Adjusting the available memory of a warehouse can improve performance because a query runs substantially slower when a warehouse runs out of memory, which results in bytes “spilling” onto storage. https://docs.snowflake.com/en/user-guide/performance-query-warehouse

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 1135 · 1323 in bank

   Select 2

   Which user preferences can be set for a user profile in Snowsight? (Choose two.)

   • AMulti-Factor Authentication (MFA)
   • BDefault database
   • CDefault schema
   • DNotifications
   • EUsername

   Show answer

   Answer: AD

   Explanation

   The correct Answer is A & D. Setting User Details and Preferences: ------------------------------------------------------------------------------------- Profile photo Username (cannot be changed) First name Last name Password Email Default experience (Snowsight or Classic) Language (English, Japanese) *Notifications (Browser Notification) *Multi-factor authentication Session Timeout https://docs.snowflake.com/en/user-guide/ui-snowsight-gs#setting-user-details-and-preferences

   Source: Adapted from community discussion — BobFar

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 1136 · 1323 in bank

   What Snowflake recommendation is designed to ensure that staged data is only loaded once?

   • APartitioning staged data files
   • BLoading only the most recently-staged data files
   • CRemoving data files after loading
   • DIdentifying and removing duplicates after each data load

   Show answer

   Answer: C

   Next question

7. Question 1137 · 1323 in bank

   What privilege is needed for a Snowflake user to see the definition of a secure view?

   • AOWNERSHIP
   • BMODIFY
   • CCREATE
   • DUSAGE

   Show answer

   Answer: A

   Explanation

   The definition of a secure view is only exposed to authorized users (i.e. users who have been granted the role that owns the view). However, users that have been granted IMPORTED PRIVILEGES privilege on the SNOWFLAKE database or another shared database have access to secure view definitions via the VIEWS Account Usage view. Users granted the ACCOUNTADMIN role or the SNOWFLAKE.OBJECT_VIEWER database role can also see secure view definitions via this view. The preferred, least-privileged means of access is the SNOWFLAKE.OBJECT_VIEWER database role. https://docs.snowflake.com/en/user-guide/views-secure

   Source: Adapted from community discussion — gizzamo

   References

   • Snowflake documentation

   Next question

8. Question 1138 · 1323 in bank

   What general guideline does Snowflake recommend when setting the auto-suspension time limit?

   • ASet tasks for immediate suspension.
   • BSet tasks for suspension after 5 minutes.
   • CSet query warehouses for suspension after 15 minutes.
   • DSet query warehouses for suspension after 30 minutes.

   Show answer

   Answer: B

   Explanation

   If you enable auto-suspend, we recommend setting it to a low value (e.g. 5 or 10 minutes or less) because Snowflake utilizes per-second billing. This will help keep your warehouses from running (and consuming credits) when not in use. https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension

   Source: Adapted from community discussion — gizzamo

   References

   • Snowflake documentation

   Next question

9. Question 1139 · 1323 in bank

   Select 2

   When does Snowflake automatically encrypt data that is loaded into Snowflake? (Choose two.)

   • AAfter the data is micro-partitioned.
   • BAfter loading the data into a table.
   • CAfter loading the data into an internal stage.
   • DAfter loading data into an external stage.
   • EOnly when using an encrypted stage.

   Show answer

   Answer: BC

   Explanation

   https://docs.snowflake.com/en/user-guide/security-encryption-end-to-end 1. A user uploads one or more data files to a stage. If the stage is an internal (i.e. Snowflake) stage (Image B) data files are automatically encrypted by the Snowflake client on the user’s local machine prior to being transmitted to the internal stage, in addition to being encrypted after they are loaded into the stage. 2. The user loads the data from the stage into a table. In Snowflake, all data at rest is always encrypted and encrypted with TLS in transit

   Source: Adapted from community discussion — 0e504b5

   References

   • Snowflake documentation

   Next question

10. Question 1140 · 1323 in bank

    How can the Query Profile be used to troubleshoot a problematic query?

    • AIt will indicate if a virtual warehouse memory is too small to run the query.
    • BIt will indicate if a user lacks the privileges needed to run the query.
    • CIt will indicate if a virtual warehouse is in auto-scale mode.
    • DIt will indicate if the user has enough Snowflake credits to run the query.

    Show answer

    Answer: A

    Next question

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

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