Question 60
For this Snowflake situation — A Python notebook prototype authenticates successfully but uses the wrong active database and schema in its queries. — the team adopts: Set and verify the intended session database and schema before executing application SQL. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Include active role, database, and schema checks in notebook setup routines. It controls the recurring exposure associated with this mechanism: Snowflake session context affects how unqualified object identifiers are resolved. The original action, set and verify the intended session database and schema before executing application SQL., still needs operational checks when the environment or workload changes.
Incorrect Answers
That safeguard is relevant to: Programmatic connectors provide supported application access without automating browser presentation controls. The current failure instead follows from: Snowflake session context affects how unqualified object identifiers are resolved. Its prevention measure is “Include active role, database, and schema checks in notebook setup routines”.
The suggested review tracks a different technical risk: Snowflake writes new micro-partition versions for data changes and manages older versions for recovery policies. Here the sustained control must address: Snowflake session context affects how unqualified object identifiers are resolved. Choose “Include active role, database, and schema checks in notebook setup routines”.
That safeguard is relevant to: Compute isolation allows distinct throughput, latency, and spending controls over shared data. The current failure instead follows from: Snowflake session context affects how unqualified object identifiers are resolved. Its prevention measure is “Include active role, database, and schema checks in notebook setup routines”.