COF-C02 practice questions 101–110

1. Question 101 · 1323 in bank

   When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

   • AWhen using a paid listing on the Snowflake Marktetplace
   • BWhen using a private listing on the Snowflake Marketplace
   • CWhen using a personalized listing on the Snowflake Marketplace
   • DWhen using a Direct Share with another account

   Show answer

   Answer: B

   Explanation

   https://other-docs.snowflake.com/en/collaboration/provider-listings-auto-fulfillment#about-cross-cloud-auto-fulfillment " If your data product is a share, use auto-fulfillment in most cases. For all listings shared with specific consumer accounts, Snowsight automatically detects whether or not the target account is in a different region and enables auto-fulfillment. You cannot manually replicate private listings to other regions. " Listing with specific consumer accounts > B

   Source: Adapted from community discussion — Yiouk

   References

   • Snowflake documentation

   Next question

2. Question 102 · 1323 in bank

   True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Explanation

   Each object has an owner, who can in turn grant access to that object. To own an object means that a role has the OWNERSHIP privilege on the object. Each securable object is owned by a single role, which by default is the role used to create the object. When this role is assigned to users, they effectively have shared control over the object. In a regular schema, the owner role has all privileges on the object by default, including the ability to grant or revoke privileges on the object to other roles. https://docs.snowflake.com/en/user-guide/security-access-control-overview

   Source: Adapted from community discussion — c0d3g

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 103 · 1323 in bank

   Select 2

   Which languages require that User-Defined Function (UDF) handlers be written inline? (Choose two.)

   • AJava
   • BJavascript
   • CScala
   • DPython
   • ESQL

   Show answer

   Answer: BE

   References

   • Snowflake documentation

   Next question

4. Question 104 · 1323 in bank

   Which task privilege does a Snowflake role need in order to suspend or resume a task?

   • AUSAGE
   • BOPERATE
   • CMONITOR
   • DOWNERSHIP

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

5. Question 105 · 1323 in bank

   What is a directory table in Snowflake?

   • AA separate database object that is used to store file-level metadata.
   • BAn object layered on a stage that is used to store file-level metadata.
   • CA database object with grantable privileges for unstructured data tasks.
   • DA Snowflake table specifically designed for storing unstructured files.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

6. Question 106 · 1323 in bank

   Select 2

   What factors impact storage costs in Snowflake? (Choose two.)

   • AThe account type
   • BThe storage file format
   • CThe cloud region used by the account
   • DThe type of data being stored
   • EThe cloud platform being used

   Show answer

   Answer: AC

   Explanation

   In this page, https://docs.snowflake.com/en/user-guide/cost-understanding-data-storage it mentioned that, > The amount charged depends on your type of account (Capacity or On Demand) and region (US or EU). So it should be A and C

   Source: Adapted from community discussion — zzeng

   References

   • Snowflake documentation

   Next question

7. Question 107 · 1323 in bank

   Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

   • AUSAGE_VIEWER
   • BGOVERNANCE_VIEWER
   • COBJECT_VIEWER
   • DSECURITY_VIEWER

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

8. Question 108 · 1323 in bank

   How should clustering be used to optimize the performance of queries that run on a very large table?

   • AManually re-cluster the table regularly.
   • BChoose one high cardinality column as the clustering key.
   • CUse the column that is most-frequently used in query select clauses as the clustering key.
   • DAssess the average table depth to identify how clustering is impacting the query.

   Show answer

   Answer: D

   Explanation

   its D select clause is the column you choose to select. We dont care about that. We care about the columns being filtered in the WHERE clause.

   Source: Adapted from community discussion — joshguy40

   References

   • Snowflake documentation

   Next question

9. Question 109 · 1323 in bank

   Which privilege must be granted by one role to another role, and cannot be revoked?

   • AMONITOR
   • BOPERATE
   • COWNERSHIP
   • DALL

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

10. Question 110 · 1323 in bank

    How can performance be optimized for a query that returns a small amount of data from a very large base table?

    • AUse clustering keys
    • BCreate materialized views
    • CUse the search optimization service
    • DUse the query acceleration service

    Show answer

    Answer: C

    Explanation

    "The search optimization service aims to significantly improve the performance of certain types of queries on tables, including: Selective point lookup queries on tables. A point lookup query returns only one or a small number of distinct rows. Use case examples include: Business users who need fast response times for critical dashboards with highly selective filters. Data scientists who are exploring large data volumes and looking for specific subsets of data. Data applications retrieving a small set of results based on an extensive set of filtering predicates."

    Source: Adapted from community discussion — Jacobr5000

    References

    • Snowflake documentation

    Next question

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

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