Foundational Snowflake certification covering the AI Data Cloud architecture, access and governance, data loading, performance, and data collaboration, with a worked explanation on every practice question.
Free sample questions
No account needed. Every question has a worked explanation, just like the full bank.
lock_openFree sampleSnowflake AI Data Cloud Features and Architectureeasy
A data engineer is describing how the Snowflake architecture is structured. Which statement correctly identifies the three independent layers that make up the platform?
- ADatabase storage, query processing using virtual warehouses, and cloud services that coordinate the whole system.check_circle Correct
- BDatabase storage, an in-memory cache layer, and a reporting layer that renders dashboards for end users.
- CA staging layer, a transformation layer, and a presentation layer arranged in a traditional ETL pipeline.
- DA metadata layer, a security layer, and a billing layer that together meter and charge for usage.
Identify the three Snowflake layers as database storage, query processing, and cloud services. Snowflake separates storage, compute, and coordination into three distinct layers so each can scale on its own without affecting the others, which is the defining feature of the architecture.
Why A is correct: This is the documented three-layer architecture: storage, query processing through virtual warehouses, and cloud services, each scaling independently.
Why B is wrong: An in-memory cache and a reporting layer are not the named architectural layers, so this misstates the design even though caching does exist within compute.
Why C is wrong: These describe a generic ETL data-flow pattern, not the Snowflake platform layers, so the option is tempting but wrong for this question.
Why D is wrong: Metadata, security, and billing are functions handled inside cloud services, not three separate top-level layers, so this option is incorrect.
lock_openFree sampleSnowflake AI Data Cloud Features and Architectureeasy
An administrator needs to run a large reporting job on a bigger virtual warehouse without copying or reloading any of the underlying table data. Which property of the Snowflake architecture makes this possible?
- AEach virtual warehouse keeps its own permanent copy of the table data, so a larger warehouse already holds the rows.
- BStorage and compute are separated, so any virtual warehouse can read the same stored data independently of its own size.check_circle Correct
- CThe cloud services layer physically moves the data into the warehouse before each query runs against it.
- DData must first be exported to an external stage and reloaded whenever the warehouse size is changed for a job.
Explain that separated storage and compute let any warehouse size read the same stored data. Because the storage layer is centralised and decoupled from compute, virtual warehouses of any size query the same persisted data directly, with no copy or reload needed when compute changes.
Why A is wrong: Warehouses do not hold permanent copies of table data; they cache only transiently, so this misdescribes how storage works.
Why B is correct: The separation of storage from compute lets any warehouse access the shared storage layer, so resizing compute never requires moving the data.
Why C is wrong: Cloud services coordinates and optimises queries but does not physically relocate stored data into compute, so this option is incorrect.
Why D is wrong: Resizing a warehouse never requires exporting or reloading data, so this contradicts the storage and compute separation it tempts you with.
lock_openFree sampleSnowflake AI Data Cloud Features and Architectureeasy
In the Snowflake architecture, which layer is responsible for executing SQL queries using the compute resources that an account provisions?
- AThe database storage layer, which holds the compressed table data and organises it into micro-partitions.
- BThe cloud services layer, which handles authentication, metadata, and query optimisation across the account.
- CThe query processing layer, which uses virtual warehouses to perform the actual compute for each query.check_circle Correct
- DThe metadata layer, which tracks micro-partition statistics that are used for pruning during a scan.
Recognise that the query processing layer executes SQL through virtual warehouses. The query processing layer is the compute tier, made up of virtual warehouses that read from storage and perform the scanning, joining, and aggregation needed to answer each SQL query.
Why A is wrong: Storage persists the table data in micro-partitions but does not run the queries, so it is the wrong layer for execution.
Why B is wrong: Cloud services coordinates and optimises work but does not itself perform the compute-heavy query execution, making this tempting but wrong.
Why C is correct: Query processing is the compute layer where virtual warehouses execute SQL, which is exactly what the question asks about.
Why D is wrong: Metadata about partitions lives within cloud services and is not a separate execution layer, so this option does not run queries.
Frequently asked questions
- How many questions are on the COF-C03 exam?
- The SnowPro Core Certification (COF-C03) (COF-C03) exam has 100 questions and runs for 115 minutes. The format is multiple choice and multiple select, at a pearson vue testing center or online proctored.
- What score do I need to pass COF-C03?
- The pass mark is 750 / 1000. Examworthy gives you a per-domain readiness score so you can see which domains are holding you back before you book.
- How much does the COF-C03 exam cost?
- The exam costs 175 USD to sit. Practising on Examworthy is free to start, with a worked explanation on every question.
- How does Examworthy help me prepare for COF-C03?
- Every practice question carries a worked explanation and a per-distractor rationale, mapped to the official blueprint domains. You learn why each answer is right or wrong, not just the letter.
- Is Examworthy affiliated with Snowflake?
- No. Examworthy is not affiliated with or endorsed by Snowflake. Our questions are original, blueprint-aligned practice material; we never reproduce live exam items.
Examworthy is not affiliated with or endorsed by Snowflake. All questions are original, blueprint-aligned practice material. We never reproduce live exam items. COF-C03 and related marks belong to their respective owners.
