Q: 11
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed,
columnar format?
Options
Discussion
I actually picked C, thinking query processing might do some of that optimization during execution. Not 100% sure though since storage layer does a lot too. Anyone else see it this way?
D imo. Metadata Management tricks people since it sounds like it might deal with data organization.
Pretty confident it’s B. Database Storage is where Snowflake actually stores and restructures the data into that compressed columnar format. The other layers are more about compute, metadata, or external services. Let me know if you disagree but seems clear enough!
Think it's B, but worth checking the official guide since similar questions pop up there.
B
B (unless they're asking about logical metadata, but nothing in question hints at that)
I'd go B. That's the layer that handles the actual data storage and formatting.
Option B. I've seen similar questions on official practice tests and the Snowflake doc, so looks right.
Looks like B. Database Storage is the only layer that actually handles data reorg for compression and columnar storage. Compute and metadata layers don't touch the physical format, unless you're talking about maintenance or something special, which isn't implied here. Let me know if someone has seen a weird corner case.
Yeah, this is B. Database Storage does that behind the scenes, organizing data into their special compressed format. Makes sense since compute layer just processes queries. Correct me if I missed something!
Be respectful. No spam.
