It is a compute resource used for supported workloads, separate from persisted table storage.
Illustrative scenario
An analyst runs queries using a chosen warehouse.
Explain your reasoning
Apply the answer to this scenario: What happens to stored data when compute suspends? State your assumptions, the expected outcome and how you would check it before changing a real system.
Common follow-up
What happens to stored data when compute suspends?
It permits independently managed compute workloads over persisted data, subject to platform behaviour and cost.
Illustrative scenario
Loading and reporting use different compute resources.
Explain your reasoning
Apply the answer to this scenario: Does separation eliminate all contention? State your assumptions, the expected outcome and how you would check it before changing a real system.
It identifies a location used for loading or unloading data, either internal or external.
Illustrative scenario
A CSV file is staged before loading.
Explain your reasoning
Apply the answer to this scenario: Which permissions protect an external stage? State your assumptions, the expected outcome and how you would check it before changing a real system.
In loading usage, it loads staged data into a table using file-format and other configured options.
Illustrative scenario
Load a prepared batch of CSV files.
Explain your reasoning
Apply the answer to this scenario: How do you inspect rejected records? State your assumptions, the expected outcome and how you would check it before changing a real system.
It defines how staged content should be parsed, including format-specific options.
Illustrative scenario
A pipe-delimited file requires a matching delimiter.
Explain your reasoning
Apply the answer to this scenario: How do quoted delimiters affect parsing? State your assumptions, the expected outcome and how you would check it before changing a real system.
It stores semi-structured values that can be queried through supported paths and conversions.
Illustrative scenario
An event payload contains nested JSON.
Explain your reasoning
Apply the answer to this scenario: When should frequently used fields become typed columns? State your assumptions, the expected outcome and how you would check it before changing a real system.
Common follow-up
When should frequently used fields become typed columns?
It expands supported nested structures into rows, potentially multiplying the result count.
Illustrative scenario
An order has an array of line items.
Explain your reasoning
Apply the answer to this scenario: How do you preserve the original event identity? State your assumptions, the expected outcome and how you would check it before changing a real system.
It provides access to historical data within configured retention and supported object limits.
Illustrative scenario
Inspect a table before a mistaken change.
Explain your reasoning
Apply the answer to this scenario: Why is retention not unlimited backup? State your assumptions, the expected outcome and how you would check it before changing a real system.
Supported cloning creates a new object from an existing state without initially copying all underlying data blocks.
Illustrative scenario
Create an isolated development table from a known point.
Explain your reasoning
Apply the answer to this scenario: How can later changes affect storage cost? State your assumptions, the expected outcome and how you would check it before changing a real system.
It is a container for privileges that users or other roles can be granted according to the security model.
Illustrative scenario
A reporting role can read curated tables.
Explain your reasoning
Apply the answer to this scenario: Why avoid granting broad administrative roles to routine users? State your assumptions, the expected outcome and how you would check it before changing a real system.
Common follow-up
Why avoid granting broad administrative roles to routine users?
It organizes database objects and provides a scope for naming and privileges.
Illustrative scenario
Raw and curated tables live in separate schemas.
Explain your reasoning
Apply the answer to this scenario: How do managed access schemas change grant control? State your assumptions, the expected outcome and how you would check it before changing a real system.
Common follow-up
How do managed access schemas change grant control?
It exposes change information relative to an offset for a supported source object.
Illustrative scenario
A downstream process consumes table changes.
Explain your reasoning
Apply the answer to this scenario: Does selecting from a stream alone advance its offset? State your assumptions, the expected outcome and how you would check it before changing a real system.
Common follow-up
Does selecting from a stream alone advance its offset?
It runs supported SQL or procedural work under a configured schedule or trigger and execution context.
Illustrative scenario
A transformation follows ingestion.
Explain your reasoning
Apply the answer to this scenario: Which role and warehouse context apply? State your assumptions, the expected outcome and how you would check it before changing a real system.
It supports continuous file ingestion using configured pipes and supported event or API mechanisms.
Illustrative scenario
New staged files are loaded after notification.
Explain your reasoning
Apply the answer to this scenario: How would you diagnose missing notifications? State your assumptions, the expected outcome and how you would check it before changing a real system.
It maintains a query-defined result through managed refresh behaviour and a target lag objective.
Illustrative scenario
A transformation chain maintains curated results.
Explain your reasoning
Apply the answer to this scenario: Is target lag an absolute freshness guarantee? State your assumptions, the expected outcome and how you would check it before changing a real system.
It is a storage organization unit used by Snowflake; metadata helps eliminate unnecessary scanning.
Illustrative scenario
A selective predicate reduces partitions scanned.
Explain your reasoning
Apply the answer to this scenario: How is this different from manually named partitions? State your assumptions, the expected outcome and how you would check it before changing a real system.
Common follow-up
How is this different from manually named partitions?
It concerns how data values are organized for pruning; explicit clustering keys have maintenance costs.
Illustrative scenario
Large tables are frequently filtered on a common key.
Explain your reasoning
Apply the answer to this scenario: How would you prove the benefit exceeds the cost? State your assumptions, the expected outcome and how you would check it before changing a real system.
It helps investigate executed queries, outcomes and resource-related evidence within its access and retention constraints.
Illustrative scenario
Find a failed load statement.
Explain your reasoning
Apply the answer to this scenario: Which role can see the needed history? State your assumptions, the expected outcome and how you would check it before changing a real system.
It filters results after window functions are evaluated.
Illustrative scenario
Keep ROW_NUMBER equal to one for each product.
Explain your reasoning
Apply the answer to this scenario: How does this differ from WHERE? State your assumptions, the expected outcome and how you would check it before changing a real system.
It has different recovery characteristics from a permanent table and is suitable only when those tradeoffs are accepted.
Illustrative scenario
A reproducible intermediate dataset needs short-lived storage.
Explain your reasoning
Apply the answer to this scenario: What recovery protections are lost? State your assumptions, the expected outcome and how you would check it before changing a real system.