COF-C02 practice questions 461–470

1. Question 461 · 1323 in bank

   What is a best practice after creating a custom role?

   • ACreate the custom role using the SYSADMIN role.
   • BAssign the custom role to the SYSADMIN role.
   • CAssign the custom role to the PUBLIC role.
   • DAdd _CUSTOM to all custom role names.

   Show answer

   Answer: B

   Explanation

   answer is B Custom roles (i.e. any roles other than the system-defined roles) can be created by the USERADMIN role (or a higher role) as well as by any role to which the CREATE ROLE privilege has been granted. By default, a newly-created role is not assigned to any user, nor granted to any other role. When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN.

   Source: Adapted from community discussion — SnowProCertDec22

   References

   • Snowflake documentation

   Next question

2. Question 462 · 1323 in bank

   Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

   • AStandard
   • BPremium
   • CEnterprise
   • DBusiness Critical

   Show answer

   Answer: D

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

3. Question 463 · 1323 in bank

   Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?

   • ABytes sent over the network
   • BSynchronization
   • CInitialization
   • DRemote spillage

   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

   Source: Adapted from community discussion — girgir

   References

   • Snowflake documentation

   Next question

4. Question 464 · 1323 in bank

   Which of the following Snowflake capabilities are available in all Snowflake editions? (Choose two.)

   • ACustomer-managed encryption keys through Tri-Secret Secure
   • BAutomatic encryption of all data
   • CUp to 90 days of data recovery through Time Travel
   • DObject-level access control
   • EColumn-level security to apply data masking policies to tables and views

   Show answer

   Answer: B

   Explanation

   Busines Critical and VPS A. Customer-managed encryption keys through Tri-Secret Secure Enterprise: C. Up to 90 days of data recovery through Time Travel E. Column-level security to apply data masking policies to tables and views All: B. Automatic encryption of all data D. Object-level access control

   Source: Adapted from community discussion — Kate0204

   References

   • Snowflake documentation

   Next question

5. Question 465 · 1323 in bank

   A PUT command can be used to stage local files from which Snowflake interface?

   • ASnowSQL
   • BSnowflake classic web interface (UI)
   • CSnowsight
   • D.NET driver

   Show answer

   Answer: A

   Explanation

   PUT command Usage The command cannot be executed from the Worksheets page in the Snowflake web interface; instead, use the SnowSQL client to upload data files, or check the documentation for the specific Snowflake client to verify support for this command. https://roboquery.com/app/syntax-put-command-snowflake

   Source: Adapted from community discussion — leozhang

   References

   • Snowflake documentation

   Next question

6. Question 466 · 1323 in bank

   Select 2

   Which of the following indicates that it may be appropriate to use a clustering key for a table? (Choose two.)

   • AThe table contains a column that has very low cardinality.
   • BDML statements that are being issued against the table are blocked.
   • CThe table has a small number of micro-partitions.
   • DQueries on the table are running slower than expected.
   • EThe clustering depth for the table is large.

   Show answer

   Answer: DE

   Explanation

   DE Queries on the table are running slower than expected or have noticeably degraded over time. The clustering depth for the table is large. https://docs.snowflake.com/en/user-guide/tables-clustering-keys#label-considerations-for-choosing-clustering

   Source: Adapted from community discussion — girgir

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 467 · 1323 in bank

   Which cache type is used to cache data output from SQL queries?

   • AMetadata cache
   • BResult cache
   • CRemote cache
   • DLocal file cache

   Show answer

   Answer: B

   Explanation

   Result Cache: Which holds the results of every query executed in the past 24 hours. These are available across virtual warehouses, so query results returned to one user is available to any other user on the system who executes the same query, provided the underlying data has not changed. Local Disk Cache: Which is used to cache data used by SQL queries. Whenever data is needed for a given query it's retrieved from the Remote Disk storage, and cached in SSD and memory.

   Source: Adapted from community discussion — Kate0204

   Next question

8. Question 468 · 1323 in bank

   Which of the following describes how clustering keys work in Snowflake?

   • AClustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
   • BClustering keys sort the designated columns over time, without blocking DML operations.
   • CClustering keys create a distributed, parallel data structure of pointers to a table's rows and columns.
   • DClustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time.

   Show answer

   Answer: B

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 469 · 1323 in bank

   Select 2

   Which of the following operations require the use of a running virtual warehouse? (Choose two.)

   • ADownloading data from an internal stage
   • BListing files in a stage
   • CExecuting a stored procedure
   • DAltering a table
   • EQuerying data from a materialized view

   Show answer

   Answer: CE

   Explanation

   These 3 do not require active Warehouse: Downloading data from an internal stage Listing files in a stage Creating and Altering table.

   Source: Adapted from community discussion — c0d3g

   References

   • Snowflake documentation

   Next question

10. Question 470 · 1323 in bank

    What is used to limit the credit usage of a virtual warehouse within a Snowflake account?

    • ALoad monitor
    • BResource monitor
    • CQuery Profile
    • DStream

    Show answer

    Answer: B

    References

    • Snowflake documentation

    Next question

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

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