Exam SnowPro Core topic 1 question 117 discussion

Physical security is the responsibility of the cloud vendor we have chosen. i.e. either GCP, Azure or AWS.

ALL TRUE

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.

Agreed

All options are correct

This question was aslo asked in the Level Up: Snowflake Key Concepts & Architecture What common tasks for traditional on-premises database and IT staff are not required with Snowflake? Select all that apply. A Maintaining metadata B Maintaining statistics C Maintaining the physical security of a server room (key cards, door locks, etc.) D Maintaining database objects ABC correct Submit So for this question you can say all the answers are correct.

A and C cloud provider,

BD correct

A and C are managed by Aws gcp azure

BD is correct answer There is no hardware (virtual or physical) to select, install, configure, or manage. There is virtually no software to install, configure, or manage. Ongoing maintenance, management, upgrades, and tuning are handled by Snowflake. Physical security is the responsibility of the cloud vendor we have chosen. i.e. either GCP, Azure or AWS. https://docs.snowflake.com/en/user-guide/intro-key-concepts#

BD correct ans. SNOWFLAKE is a true self-managed service, meaning: • There is no hardware (virtual or physical) to select, install, configure, or manage. • There is virtually no software to install, configure, or manage. • Ongoing maintenance, management, upgrades, and tuning are handled by Snowflake.

BD - As Snowflake is SAAS based, and Hardware and Physical Security doesn't come under SAAS Snowflake is a true self-managed service, meaning: There is no hardware (virtual or physical) to select, install, configure, or manage. There is virtually no software to install, configure, or manage. Ongoing maintenance, management, upgrades, and tuning are handled by Snowflake.

ABD are correct

B. Patching software D. Maintaining metadata and statistics Snowflake is a cloud-based data warehousing platform that eliminates the need for customers to manage hardware infrastructure, physical security, and related tasks. These responsibilities are handled by Snowflake's cloud infrastructure provider, and Snowflake also automatically manages the patching of software and maintenance of metadata and statistics for its customers. Option A (Installing and configuring hardware) and Option C (Physical security) are not provided by Snowflake since they are handled by the cloud infrastructure provider.

So can someone help me which one is correct?

B and D are the correct options https://docs.snowflake.com/en/user-guide/intro-key-concepts#:~:text=There%20is%20no,handled%20by%20Snowflake.

All 4 Snowflake "provide for customers" - doesn't matter if SF itself or Cloud provider. Customer has contract with Snowflake, not with the Cloud provider.