Exam SnowPro Core All QuestionsBrowse all questions from this 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.)

    Correct Answer: B, D

    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
arpit_dataguyOptions: ABD

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

Sonny22

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

I agree its all

bibisaOptions: BD

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

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

Yah020Options: ABC

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.

HeetecOptions: BD

BD correct

Marge23Options: BD

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.

AbhaySAPOptions: BD

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

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.

Mayuri917233Options: ABD

ABD are correct

Mallikharjuna452Options: ABC

All options are correct

Ram9198Options: BD

A and C cloud provider,

Ram9198Options: BD

A and C are managed by Aws gcp azure

BobFarOptions: BD

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#

SD5713

So can someone help me which one is correct?

KarBiswaOptions: BD

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

EmiBOptions: BCD

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.

AshNjOptions: ABC

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

subbieOptions: ABC

All are correct.

subbie

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