SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 117


What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)

Show Answer
Correct Answer: BD

Snowflake is a cloud-based data warehousing service that completely abstracts away the underlying hardware and software management from its customers. This means that customers do not need to worry about patching software or maintaining metadata and statistics, as these are automatically handled by Snowflake. While installing and configuring hardware and physical security are critical aspects of on-premises systems, they are managed by Snowflake's underlying cloud infrastructure providers (such as AWS, Azure, or GCP), not by Snowflake itself. Thus, Snowflake's direct responsibilities are mainly in the areas of software patching and metadata/statistics maintenance.

Discussion

17 comments
Sign in to comment
arpit_dataguyOptions: ABD
Jan 28, 2022

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

Sonny22
Mar 25, 2022

The are not on prem though as you noted and the question refers to On-Prem. I'd argue all are correct as sometimes organizations do set up their own data centers and ensure security along with other operational aspects like electricity, water etc for cooling and maintenance

MultiCloudIronMan
Jul 20, 2023

I agree its all

bibisaOptions: BD
Apr 5, 2023

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.

KarBiswaOptions: BD
Feb 9, 2023

No physical security as it is cloud based and no hardware usage

Mayuri917233Options: ABD
May 11, 2023

ABD are correct

AbhaySAPOptions: BD
Jun 21, 2023

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.

PrashantGupta1616
Jun 11, 2024

When choosing cluster size, SF will handle the hardware provisioning. SaaS is provided for end users, although it is SF's responsibility to take care of hardware, software, and metadata.

Marge23Options: BD
Sep 16, 2023

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.

HeetecOptions: BD
Oct 29, 2023

BD correct

Yah020Options: ABC
May 7, 2024

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.

subbieOptions: ABC
Jan 16, 2023

All are correct.

subbie
Jan 16, 2023

ABCD. Maintaining the physical security of a server room (key cards, door locks, etc.)

AshNjOptions: ABC
Jan 20, 2023

As a snowflake customer, you shouldnt worry about if it is azure or AWS providing physical security. It becomes responsibility of SNOWFLAKE

EmiBOptions: BCD
Mar 6, 2023

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.

KarBiswaOptions: BD
Mar 16, 2023

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

SD5713
Mar 23, 2023

So can someone help me which one is correct?

BobFarOptions: BD
Oct 12, 2023

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#

Ram9198Options: BD
Oct 15, 2023

A and C are managed by Aws gcp azure

Ram9198Options: BD
Oct 30, 2023

A and C cloud provider,

Mallikharjuna452Options: ABC
Jul 19, 2024

All options are correct