Question 1
A Snowflake data team faces this situation: A financial analytics team wants two departments to query one governed dataset without competing for the same compute resources. Which action BEST meets the specific requirement?
Explanation
Correct Answer
The correct approach is to assign separate virtual warehouses to the workloads while keeping the shared tables in centralized Snowflake storage. The supporting mechanism is: Snowflake separates virtual warehouse compute from database storage so independent workloads can access the same governed data. A meaningful verification is: Both departments query the same table version while their warehouse execution and credit consumption remain independently observable. The other choices address different platform concerns, not this specific requirement.
Incorrect Answers
The proposed action belongs to the mechanism: A virtual warehouse supplies execution resources while managed table data persists in the database storage layer. Here the stated fault follows a different mechanism: Snowflake separates virtual warehouse compute from database storage so independent workloads can access the same governed data. The corrective choice is “Assign separate virtual warehouses to the workloads while keeping the shared tables in centralized Snowflake storage”.
The offered action targets: Snowflake Notebooks provide integrated interactive SQL and Python development around Snowflake data resources. The case facts point instead to: Snowflake separates virtual warehouse compute from database storage so independent workloads can access the same governed data. Implement “Assign separate virtual warehouses to the workloads while keeping the shared tables in centralized Snowflake storage” to address that specific condition.
This alternative is a response to another technical cause: Snowflake writes new micro-partition versions for data changes and manages older versions for recovery policies. The reported case instead depends on: Snowflake separates virtual warehouse compute from database storage so independent workloads can access the same governed data. The action that directly addresses it is “Assign separate virtual warehouses to the workloads while keeping the shared tables in centralized Snowflake storage”.