Home › Certifications › Snowflake SnowPro Core › AI Data Cloud Architecture and Editions
24 multiple-choice questions and 11 flashcards on AI Data Cloud Architecture and Editions, about 8% of the Snowflake SnowPro Core bank. Every one carries a written rationale.
AI Data Cloud Architecture and Editions is one of 9 chapters in CoStudy's Snowflake SnowPro Core bank, and it holds 24 of the bank's 301 multiple-choice questions — roughly 8% of the total. That proportion is not arbitrary: chapters follow the certifying body's published exam outline, and the number of questions in each is set by that domain's published weight, so the share of your practice time this chapter takes matches the share of the real exam it accounts for.
Studying by chapter is worth doing once you have a diagnostic score. A single overall percentage tells you whether you are close; it does not tell you which domain is dragging. Working a weak chapter in isolation, and re-testing it in isolation, is the fastest way to move a score that has stalled — and it is why the mock exams in CoStudy report by domain rather than as one number.
3 questions drawn from this chapter, with the full rationale shown — the controlling principle behind the right answer, and why each wrong option tempts and fails.
What's the relationship between a database and a schema in Snowflake?
Answer: B — A database contains schemas, which hold tables
B) Correct — the hierarchy is database, then schema, then tables, views and stages. A) Inverts the containment. C) They are distinct object types. D) Warehouses are compute and sit outside this hierarchy.
A user reruns an identical query minutes later with every warehouse suspended, and results return in under a second. Which layer served that response?
Answer: A — The cloud services layer, which retains the query result independently of compute
A) Correct — the query result cache is maintained by cloud services, so a matching reuse needs no running warehouse. B) is the classic mix-up with the warehouse local disk cache, which is lost on suspend and could not serve this. C) confuses the metadata cache, which answers only certain aggregate lookups, not full result reuse. D) is wrong because drivers do not cache result sets across sessions in this way.
Snowflake's architecture has how many distinct layers?
Answer: C — 3
A/B/D) Wrong. C) Correct — Cloud Services, Compute (virtual warehouses), Storage. Separation of compute and storage is foundational.
4 cards from the 11 in this chapter.
List the Snowflake editions in ascending order of capability.
Standard, Enterprise, Business Critical, and Virtual Private Snowflake (VPS).
SnowPro Core exam format?
100 questions, 115 minutes. Multiple choice + multiple select. $175 USD. Valid 2 years.
Snowflake is described as a hybrid of shared-disk and shared-nothing architectures. Explain what each half contributes.
Shared-disk: one central persisted storage layer that all compute nodes can see, so there is a single copy of the data. Shared-nothing: each virtual warehouse has its own local cache and compute resources and processes its slice of data independently, giving MPP performance and workload isolation.
Snowflake editions?
Standard, Enterprise, Business Critical, Virtual Private Snowflake (VPS). Features + price scale up.
These are a sample. The full AI Data Cloud Architecture and Editions chapter runs 35 items with per-chapter progress tracking, on the web and in the iOS app.
Open Snowflake SnowPro Core in CoStudy →