COF-C02 practice questions 651–660

1. Question 651 · 1323 in bank

   Select 2

   A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake. According to best practice, what should the Snowflake user do? (Choose two.)

   • AProvide each non-Snowflake supplier with their own reader account.
   • BDeploy a single reader account to be shared by all of the non-Snowflake suppliers.
   • CCreate an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.
   • DUse a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.
   • EExtract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers' regions.

   Show answer

   Answer: AD

   Explanation

   Changing on A,D because A option is dealing with non-snowflake accounts and D is dealing with SnowFlake accounts on same/different regions

   Source: Adapted from community discussion — KarBiswa

   References

   • Snowflake documentation

   Next question

2. Question 652 · 1323 in bank

   Which statement about data sharing is true?

   • AAccounts can share with other accounts regardless of their Snowflake edition, without requiring help from Snowflake Support.
   • BData sharing can cross regions, but not cloud providers.
   • CThe Data Consumer can only see objects in the Data Provider’s source database that have been explicitly added to the share.
   • DA Data Provider can only share with other Snowflake customers.

   Show answer

   Answer: C

   Explanation

   C is correct answer A new object created in a database in a share is not automatically available to consumers. To make the object available to consumers, you must use the GRANT … TO SHARE command to explicitly add the object to the share. https://docs.snowflake.com/en/user-guide/data-sharing-provider.html#general-data-sharing-considerations-and-usage

   Source: Adapted from community discussion — harshagc180

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 653 · 1323 in bank

   Which command is used to load files into an internal stage within Snowflake?

   • APUT
   • BCOPY INTO
   • CTRANSFER
   • DINSERT

   Show answer

   Answer: A

   Next question

4. Question 654 · 1323 in bank

   Which object type is granted permissions for reading a table?

   • AUser
   • BRole
   • CAttribute
   • DSchema

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

5. Question 655 · 1323 in bank

   What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?

   • A1 minute
   • B5 minutes
   • C10 minutes
   • D15 minutes

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

6. Question 656 · 1323 in bank

   Several users are using the same virtual warehouse. The users report that the queries are running slowly, and that many queries are being queued. What is the recommended way to resolve this issue?

   • AReduce the warehouse STATEMENT_QUEUED_TIMEOUT_IN SECONDS parameter.
   • BReduce the warehouse AUTO_SUSPEND parameter.
   • CIncrease the warehouse MAX_CONCURRENCY_LIMIT parameter.
   • DIncrease the warehouse MAX_CLUSTER_COUNT parameter.

   Show answer

   Answer: D

   Explanation

   D - incorporate SCALE OUT to increase CONCURENCY A - NO ! - STATEMENT_QUEUED_TIMEOUT_IN_SECONDS - Amount of time, in seconds, a SQL statement remains queued for a warehouse before it is CANCELED by the system.

   Source: Adapted from community discussion — EmiB

   Next question

7. Question 657 · 1323 in bank

   Select 2

   Which data types are valid in Snowflake? (Choose two.)

   • ABLOB
   • BGeography
   • CJSON
   • DCLOB
   • EVariant

   Show answer

   Answer: BE

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 658 · 1323 in bank

   What happens when the size of a virtual warehouse is changed?

   • AQueries that are running on the current warehouse configuration are not impacted.
   • BQueries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.
   • CQueries that are running on the current warehouse configuration are aborted and are automatically resubmitted.
   • DQueries that are running on the current warehouse configuration are moved to the new configuration and finished there.

   Show answer

   Answer: A

   Explanation

   Answer is correct Resizing a running warehouse does not impact queries that are already being processed by the warehouse; the additional compute resources, once fully provisioned, are only used for queued and new queries.

   Source: Adapted from community discussion — AravindhTN

   Next question

9. Question 659 · 1323 in bank

   Select 3

   Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)

   • ADatabases
   • BTables
   • CWarehouses
   • DWorksheets

   Show answer

   Answer: ACD

   Explanation

   This is an old question now. Worksheets are now contained inside "Projects" and it isn't called the SF Web Interface any more (deprecated), it's now called SnowSight.

   Source: Adapted from community discussion — 56d43d6

   Next question

10. Question 660 · 1323 in bank

    How often are encryption keys automatically rotated by Snowflake?

    • A30 Days
    • B60 Days
    • C90 Days
    • D365 Days

    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 651. 1323 questions available.