Discuss Snowflake SOL-C01 Exam Topic 2 Question 4

What is a benefit of using an external stage to load data into Snowflake?

AExternal stages reduce data storage costs because data is stored outside Snowflake.

BExternal stages provide automatic data purging after successful loads.

CExternal stages are more secure than internal stages for sensitive data.

DExternal stages reduce the number of objects in a database.

Suggested Answer: A

External stages point to files in external cloud storage (S3, Azure Blob, GCS). Because the data is not stored inside Snowflake, the user avoids Snowflake storage charges, which can significantly reduce cost for large staging datasets.

External stages do not automatically delete files, are not inherently more secure than internal stages, and still count as database objects even though they reference external storage.

==================

Get Premium SOL-C01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

30 comments · newest first

Ruby 5 months ago

D is interesting too. Fewer objects mean easier management overall.

Gayla 5 months ago

I feel like B is underrated. Automatic purging could save time.

Talia 6 months ago

True, but A still stands out. Cost efficiency is key for many companies.

Mee 6 months ago

But what about C? Security is super important for sensitive data.

Oretha 6 months ago

I agree, A makes sense. External stages really help with that.

Alita 6 months ago

B) sounds good, but is it really automatic?

Arlette 6 months ago

D) is definitely a plus, fewer objects means easier management.

Dannie 6 months ago

Surprised to see A) is a benefit, didn't know that!

Graham 7 months ago

I disagree, I think internal stages are just as secure.

Kathryn 7 months ago

A) is true, external stages can save on storage costs!

Craig 7 months ago

I feel like there was a point about automatic data purging with external stages, but I can't remember if that's actually a benefit or not.

Nickolas 8 months ago

I practiced a similar question where external stages were mentioned, and I think they do help reduce the number of objects in a database.

Carri 8 months ago

Option B is a joke. Automatic data purging? That's not a real benefit.

Alise 8 months ago

D is just silly. External stages don't reduce the number of database objects.

Buddy 8 months ago

C is also a good option. External stages can provide better security for sensitive data.

Altha 8 months ago

I agree, option A is the best answer. Storing data externally is more cost-effective.

Ernie 9 months ago

Option A is correct. External stages reduce data storage costs by storing data outside of Snowflake.

Jeanice 9 months ago

I'm a bit confused on this one. I know external stages are used for loading data, but I'm not sure about the specific benefits compared to internal stages. I'll have to review my notes before deciding.

Johna 9 months ago

I'm leaning towards option C - that external stages are more secure than internal stages for sensitive data. That makes sense to me, since the data is stored outside of Snowflake's environment.

Lorriane 9 months ago

Okay, I'm pretty sure the right answer is that external stages provide automatic data purging after successful loads. That seems like a really useful feature for managing data efficiently.

Dean 9 months ago

Hmm, I'm not totally sure about this one. I know external stages are used for loading data, but I'm not confident about the specific benefits. I'll have to think this through carefully.

Elouise 10 months ago

I think the key benefit here is that external stages reduce data storage costs, since the data is stored outside of Snowflake. That's my best guess for this one.

Ressie 3 months ago

↳ replying to Elouise

Less clutter in the database is nice too!

Jina 3 months ago

↳ replying to Elouise

I think the automatic purging feature is also useful.

Desmond 3 months ago

↳ replying to Elouise

True, but cost savings are hard to ignore.

Wai 4 months ago

↳ replying to Elouise

But what about security? External stages might be safer.

Kami 5 months ago

↳ replying to Elouise

I agree, reducing storage costs is a big plus!

Magdalene 10 months ago

I think A is the best choice. Saving on storage costs is huge!

Twana 10 months ago

I remember something about external stages being more secure, but I can't recall the specifics. Was it related to sensitive data?

Rebecka 10 months ago

I think external stages might help with storage costs since data is kept outside of Snowflake, but I'm not entirely sure.

Snowflake SOL-C01 Exam - Topic 2 Question 4 Discussion