Discuss Snowflake SOL-C01 Exam Topic 3 Question 7

Where is unstructured data stored in Snowflake?

AIn the Cloud Services layer

BIn internal or external stages

CIn external tables

DIn tables with a single VARCHAR column

Suggested Answer: B

Unstructured data such as PDF files, images, and other binary documents is stored in stages in Snowflake. These stages may be internal stages, which Snowflake manages directly, or external stages, which reference external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. Stages are the designed mechanism for storing and accessing unstructured files so that they can be processed with functions like PARSE_DOCUMENT or accessed via directory tables.

External tables are used to query structured or semi-structured data (for example, Parquet or JSON) stored in external locations, not to store raw unstructured binary content. The Cloud Services layer coordinates metadata, security, and query services; it does not store user data. Tables with a single VARCHAR column might be used as an improvised approach for small text blobs, but this is not the native or recommended method for managing unstructured data at scale.

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

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

33 comments · newest first

Eloisa 5 days ago

I agree with Pearly. Stages are designed for that purpose.

Pearly 10 days ago

I think it's B) In internal or external stages. Makes sense for unstructured data.

Tomoko 15 days ago

I agree with B) In internal or external stages. That's where we load files, right?

Han 20 days ago

I’m leaning towards D) In tables with a single VARCHAR column. Seems like a simple solution.

Candra 26 days ago

I feel like A) In the Cloud Services layer could be right too. It’s where processing happens.

Beula 1 month ago

I think it's B) In internal or external stages. Makes sense for unstructured data.

Lizette 1 month ago

I agree with B. Unstructured data needs flexible storage options.

Tu 1 month ago

I lean towards D) In tables with a single VARCHAR column. Seems like a simple solution.

Darnell 2 months ago

I feel like A) In the Cloud Services layer could be right too. But not sure.

Stanton 2 months ago

I think it's B) In internal or external stages. Makes sense for unstructured data.

Tori 2 months ago

Agreed, stages are the way to go for unstructured data!

Irving 2 months ago

Wait, can unstructured data really be in just a VARCHAR column?

Diane 2 months ago

Definitely in stages, no doubt about it!

Melissa 2 months ago

I thought it was in external tables?

Annamae 3 months ago

It's stored in internal or external stages!

Bernardine 3 months ago

I agree with B, makes the most sense!

Ryan 3 months ago

Wait, can unstructured data really just be in a VARCHAR column?

Rosendo 3 months ago

Definitely B, that's the way to go!

Jovita 3 months ago

I thought it was in external tables?

Joesph 3 months ago

It's stored in internal or external stages!

Kayleigh 4 months ago

Yeah, stages make the most sense for unstructured data.

Reita 5 months ago

Wait, can unstructured data really just be in a VARCHAR column?

Johnetta 5 months ago

Definitely in stages, no doubt about it!

Nada 5 months ago

I thought it was in external tables?

Alaine 6 months ago

It's stored in internal or external stages!

Lorrine 6 months ago

I feel like unstructured data could be in tables with a single VARCHAR column, but that seems too simplistic for Snowflake.

Bonita 6 months ago

I practiced a question similar to this, and I think the Cloud Services layer might be involved, but it feels a bit off.

Miesha 6 months ago

I remember something about external tables, but I can't recall if they specifically handle unstructured data.

Rocco 6 months ago

I think unstructured data is stored in internal or external stages, but I'm not completely sure.

Tarra 6 months ago

I thought unstructured data could also go into tables with a single VARCHAR column, but that seems too simple.

Adell 7 months ago

I practiced a question like this, and I feel like the answer is definitely B, but I could be mixing it up.

Tula 7 months ago

I remember something about external tables, but that might be for structured data.

Marsha 7 months ago

I think unstructured data is stored in internal or external stages, but I'm not completely sure.

Snowflake SOL-C01 Exam - Topic 3 Question 7 Discussion