COF-C02 practice questions 301–310

1. Question 301 · 1323 in bank

   Which privilege must be granted to show data categories in a Data Exchange?

   • AMONITOR PRIVILEGE
   • BUSAGE PRIVILEGE
   • COWNERSHIP PRIVILEGE
   • DIMPORTED PRIVILEGES

   Show answer

   Answer: D

   Explanation

   https://docs.snowflake.com/en/user-guide/data-exchange-marketplace-privilegesGranting administrator privileges in a Data Exchange By default, only an account administrator (a user with the ACCOUNTADMIN role) in the Data Exchange administrator account can manage a Data Exchange, which includes the following tasks: Add or remove members. Approve or deny listing approval requests. Approve or deny provider profile approval requests. Show categories. To support delegating these tasks to other users, the IMPORTED PRIVILEGES privilege can be granted on a Data Exchange to other roles."

   Source: Adapted from community discussion — 37ceea2

   References

   • Snowflake documentation

   Next question

2. Question 302 · 1323 in bank

   Which Snowflake feature is used for both querying and restoring data?

   • ACluster keys
   • BTime Travel
   • CFail-safe
   • DCloning

   Show answer

   Answer: B

   Explanation

   Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.

   Source: Adapted from community discussion — greenlever

   Next question

3. Question 303 · 1323 in bank

   Select 2

   What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

   • AScaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
   • BScaling out adds clusters of varying sizes to a virtual warehouse.
   • CScaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
   • DSnowflake recommends using both scaling up and scaling out to handle more concurrent queries.
   • EScaling up resizes a virtual warehouse so it can handle more complex workloads.
   • FScaling up adds additional database servers to an existing running cluster to handle larger workloads.

   Show answer

   Answer: AE

   References

   • Snowflake documentation

   Next question

4. Question 304 · 1323 in bank

   What is the minimum Snowflake edition that has column-level security enabled?

   • AStandard
   • BEnterprise
   • CBusiness Critical
   • DVirtual Private Snowflake

   Show answer

   Answer: B

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

5. Question 305 · 1323 in bank

   What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

   • AINITIALLY_SUSPENDED = TRUE/FALSE
   • BSTART_AFTER_CREATE = TRUE/FALSE
   • CSTART_THE = 60 // (seconds from now)
   • DSTART_TIME = CURRENT_DATE()

   Show answer

   Answer: A

   Explanation

   Answer is correct: - Syntax CREATE [ OR REPLACE ] WAREHOUSE [ IF NOT EXISTS ] [ [ WITH ] objectProperties ] [ objectParams ] Where: objectProperties ::= WAREHOUSE_SIZE = XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE MAX_CLUSTER_COUNT = MIN_CLUSTER_COUNT = SCALING_POLICY = STANDARD | ECONOMY AUTO_SUSPEND = | NULL AUTO_RESUME = TRUE | FALSE INITIALLY_SUSPENDED = TRUE | FALSE RESOURCE_MONITOR = COMMENT = ' ' ENABLE_QUERY_ACCELERATION = TRUE | FALSE QUERY_ACCELERATION_MAX_SCALE_FACTOR =

   Source: Adapted from community discussion — Nagesh_CL

   Next question

6. Question 306 · 1323 in bank

   Which object allows you to limit the number of credits consumed within a Snowflake account?

   • AAccount Usage Tracking
   • BResource Monitor
   • CWarehouse Limit Parameter
   • DCredit Consumption Tracker

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

7. Question 307 · 1323 in bank

   Select 2

   When cloning a database, what is cloned with the database? (Choose two.)

   • APrivileges on the database
   • BExisting child objects within the database
   • CFuture child objects within the database
   • DPrivileges on the schemas within the database
   • EOnly schemas and tables within the database

   Show answer

   Answer: BD

   Explanation

   A. Privileges on the database -- This is not correct as source for cloning do not inherit privileges B. Existing child objects within the database --- This is correct C. Future child objects within the database --- This is not correct D. Privileges on the schemas within the database Most Voted -- As Schema is child, it inherits all grants E. Only schemas and tables within the database --- This is not correct

   Source: Adapted from community discussion — SandipMore

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 308 · 1323 in bank

   Which of the following describes the Snowflake Cloud Services layer?

   • ACoordinates activities in the Snowflake account
   • BExecutes queries submitted by the Snowflake account users
   • CManages quotas on the Snowflake account storage
   • DManages the virtual warehouse cache to speed up queries

   Show answer

   Answer: A

   Explanation

   A. Coordinates activities in the Snowflake account - CLOUD SERVICE LAYER B. Executes queries submitted by the Snowflake account users - COMPUTE LAYER C. Manages quotas on the Snowflake account storage - STORAGE LAYER D. Manages the virtual warehouse cache to speed up queries - COMPUTE LAYER

   Source: Adapted from community discussion — EmiB

   Next question

9. Question 309 · 1323 in bank

   What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

   • A30 days
   • B7 days
   • C48 hours
   • D24 hours

   Show answer

   Answer: D

   Explanation

   Thus, the maximum total CDP charges incurred for a temporary table are 1 day (or less if the table is explicitly dropped or dropped as a result of terminating the session). During this period, Time Travel can be performed on the table. https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

   Source: Adapted from community discussion — kjdfsafc87456

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 310 · 1323 in bank

    When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

    • AA single join node uses more than 50% of the query time
    • BPartitions scanned is equal to partitions total
    • CAn AggregateOperator node is present
    • DThe query is spilling to remote storage

    Show answer

    Answer: D

    Explanation

    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. https://docs.snowflake.com/en/user-guide/ui-query-profile.html#queries-too-large-to-fit-in-memory

    Source: Adapted from community discussion — c0d3g

    References

    • Snowflake documentation

    Next question

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

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