Foundational Snowflake certification covering the AI Data Cloud architecture, access and governance, data loading, performance, and data collaboration.
Free sample questions
No account needed. Every question explains why every answer is right or wrong, 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 sampleData Loading, Unloading, and Connectivitymedium
An engineer wants to stage local files that relate to exactly one target table, without creating any stage object first, and references the staged files when running COPY INTO that table. Which stage should the engineer use, and how is it referenced?
- AThe table stage referenced as @%target_table, because each table has an implicit stage that needs no separate creation and is intended for files loaded into that one tablecheck_circle Correct
- BA user stage referenced as @~, because every user receives a personal staging area that is automatically scoped to whichever single table they later load data into from it
- CA named internal stage referenced as @my_stage, because Snowflake provisions one named stage for each table at creation time so files placed there load only into that table
- DAn external stage referenced as @ext_stage, because external stages need no object creation and automatically bind themselves to the one table named in the following COPY INTO command
Identify the implicit table stage, referenced as @%table_name, as the staging area scoped to a single table that needs no separate stage object. Snowflake automatically provides an implicit table stage for every table, addressed with the @%table_name syntax, so no CREATE STAGE step is required; it is designed for files that load into that one table, which makes it the correct choice when the staged files relate to exactly one target table.
Why A is correct: Every table has an implicit table stage addressed as @%table_name that requires no CREATE STAGE step, making it the right fit for files destined for that single table.
Why B is wrong: The user stage exists per user and is referenced with @~, but it is not tied to one table, so the automatic single-table scoping claimed here is wrong.
Why C is wrong: A named stage must be explicitly created with CREATE STAGE and is not auto-provisioned per table, so this both invents a stage and contradicts the no-create requirement.
Why D is wrong: External stages must be created and point at cloud storage rather than a single table, so the no-creation and auto-binding claims here are both incorrect.
More free COF-C03 practice questions, every answer explainedFrequently asked questions
- How many questions are on the COF-C03 exam?
- The SnowPro Core Certification (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, and every answer is explained, right and wrong.
- Is there a COF-C03 practice exam?
- Yes. Examworthy's exam mode runs a timed COF-C03 practice exam (mock) paced to match the real exam, scored per domain so you can see exactly where you stand against the blueprint. Timed mocks are free with an account.
- How does Examworthy help me prepare for COF-C03?
- Every practice question explains why the right answer is right and why each wrong one is wrong, mapped to the official blueprint domains. You learn the reasoning, 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.
