COF-C02 practice questions 431–440

1. Question 431 · 1323 in bank

   Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

   • ACompute layer
   • BStorage layer
   • CCloud infrastructure layer
   • DCloud services layer

   Show answer

   Answer: D

   Explanation

   Ans - D. Query execution is different from Query processing. Query execution is performed in the processing layer. While The services layer for Snowflake authenticates user sessions, provides management, enforces security functions, performs query compilation and optimization, results cache and coordinates all transactions

   Source: Adapted from community discussion — isolated_sniper

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 432 · 1323 in bank

   If a size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

   • A4
   • B8
   • C16
   • D32

   Show answer

   Answer: B

   Explanation

   Ok, after 250+ questions so far out of 600+ I have to say I am very disappointed in the quality of the answers. 70% of the answers provided by Examtopics are incorrect in this exam prep. I expect to have 2% or so wrong answers but 70% is unacceptable is causing more confusion that helping at this point. For a paying customer, I would say that is absolutely unacceptable.

   Source: Adapted from community discussion — LinoT

   References

   • Snowflake documentation

   Next question

3. Question 433 · 1323 in bank

   A clustering key was defined on a table, but it is no longer needed. How can the key be removed?

   • AALTER TABLE [TABLE NAME] PURGE CLUSTERING KEY
   • BALTER TABLE [TABLE NAME] DELETE CLUSTERING KEY
   • CALTER TABLE [TABLE NAME] DROP CLUSTERING KEY
   • DALTER TABLE [TABLE NAME] REMOVE CLUSTERING KEY

   Show answer

   Answer: C

   Explanation

   Dropping the Clustering Keys for a Table At any time, you can drop the clustering key for a table using ALTER TABLE: ALTER TABLE DROP CLUSTERING KEY

   Source: Adapted from community discussion — GiselaS

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 434 · 1323 in bank

   What is a core benefit of clustering?

   • ATo guarantee uniquely identifiable records in the database
   • BTo increase scan efficiency in queries by improving pruning
   • CTo improve performance by creating a separate file for point lookups
   • DTo provide data redundancy by duplicating micro-partitions

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

5. Question 435 · 1323 in bank

   Which statement is true about Multi-Factor Authentication (MFA) in Snowflake?

   • AMFA can be enforced or applied for a given role.
   • BSnowflake users are automatically enrolled in MFA.
   • CUsers enroll in MFA by submitting a request to Snowflake Support.
   • DMFA is an integrated Snowflake feature.

   Show answer

   Answer: D

   Explanation

   MFA support is provided as an integrated Snowflake feature, powered by the Duo Security service, which is managed completely by Snowflake. MFA is enabled on a per-user basis; however, at this time, users are not automatically enrolled in MFA. To use MFA, users must enroll themselves. https://docs.snowflake.com/en/user-guide/security-mfa

   Source: Adapted from community discussion — srj_mehta

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

6. Question 436 · 1323 in bank

   What data type should be used to store JSON data natively in Snowflake?

   • AJSON
   • BString
   • CObject
   • DVARIANT

   Show answer

   Answer: D

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 437 · 1323 in bank

   Select 2

   What should be considered when deciding to use a Secure View? (Choose two.)

   • ANo details of the query execution plan will be available in the query profiler.
   • BOnce created there is no way to determine if a view is secure or not.
   • CSecure views do not take advantage of the same internal optimizations as standard views.
   • DIt is not possible to create secure materialized views.
   • EThe view definition of a secure view is still visible to users by way of the information schema.

   Show answer

   Answer: AC

   References

   • Snowflake documentation

   Next question

8. Question 438 · 1323 in bank

   Select 2

   Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

   • ACustomers can change the size of the Warehouse after creation
   • BA Warehouse can be resized while running
   • CA Warehouse can be configured to suspend after a period of inactivity
   • DA Warehouse can be configured to auto-resume when new queries are submitted

   Show answer

   Answer: AB

   Explanation

   Correct, you can configure auto suspend and auto resume: https://docs.snowflake.com/en/user-guide/warehouses-considerations#automating-warehouse-suspension AND you can resize a wh even when it is running: https://docs.snowflake.com/en/user-guide/warehouses-overview

   Source: Adapted from community discussion — 56d43d6

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 439 · 1323 in bank

   Select 2

   The information schema provides storage information for which of the following objects? (Choose two.)

   • AUsers
   • BDatabases
   • CInternal stages
   • DResource monitors
   • EPipes

   Show answer

   Answer: BC

   Explanation

   Each database created in your account automatically includes a built-in, read-only schema named INFORMATION_SCHEMA. The schema contains the following objects: Views for all the objects contained in the database, as well as views for account-level objects (i.e. non-database objects such as roles, warehouses, and databases) Table functions for historical and usage data across your account.

   Source: Adapted from community discussion — Kate0204

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 440 · 1323 in bank

    What is a responsibility of Snowflake’s virtual warehouses?

    • AInfrastructure management
    • BMetadata management
    • CQuery execution
    • DQuery parsing and optimization
    • EManagement of the storage layer

    Show answer

    Answer: C

    Next question

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

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