COF-C02 Question 181

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose ABC1

  All are correct ! “Snowflake manages all aspects of software and hardware installation and updates. This includes: • Maintaining the infrastructure (including physical and environmental security) • Managing software updates and patches • Optimizing data storage and metadata management.”

• Chose ABD1

  ALL TRUE

• Chose BD1

  The correct answers are B. Patching software and D. Maintaining metadata and statistics. Here’s why: B. Patching software: Snowflake handles all software patching and updates automatically, which eliminates the need for customers to manage this aspect, making it a self-managed service. D. Maintaining metadata and statistics: Snowflake automatically manages metadata and statistics, optimizing query performance without manual intervention by users. Regarding the other options: A. Installing and configuring hardware: This is handled by Snowflake, but since there is no hardware to manage (virtual or physical), it’s not something customers need to do, which aligns with the self-managed nature of the platform. C. Physical security: This is the responsibility of the cloud provider (e.g., AWS, Azure, GCP), not Snowflake itself. So, the correct answers are B and D.