SnowPro Associate: Platform Question 28
Single answer● Snowflake NotebooksA data analyst wants to use a Snowflake Notebook to explore a large sales table, create a few visualizations, and share the notebook with teammates so they can rerun the analysis on demand. The analyst can open Snowsight and has access to the database and schema, but when attempting to run notebook cells, execution fails due to missing compute resources. Which action should be taken to enable the notebook to run successfully?
- A
Grant the analyst access to a warehouse or compute pool that the notebook can use for execution
- B
Convert the notebook into a dashboard, because notebooks cannot execute queries directly
- C
Create a Snowpipe pipeline for the sales table so notebook cells can run against streamed data
- D
Enable cross-region replication for the database so the notebook can provision temporary compute automatically
Show answer and explanation
Correct answer: A
Explanation
This question tests practical understanding of how Snowflake Notebooks run in Snowsight. A common real-world issue is assuming that access to the database and schema is enough. In practice, notebooks also need compute resources to execute cells. For SnowPro Associate-level understanding, the key principle is that query and notebook execution depends on access to the configured compute resource, such as a warehouse and, where applicable, a compute pool. Snowflake documentation for Notebooks and general Snowflake access control emphasizes that users need both object privileges and the ability to use the execution resource. Snowpipe and replication are separate platform capabilities and do not address notebook runtime execution requirements.
- A. Correct.
Correct. Snowflake Notebooks require compute to execute code and queries. Depending on the notebook runtime, this means access to an appropriate warehouse or compute pool. Having access only to data objects in Snowsight is not sufficient if the user cannot use the compute resource configured for the notebook.
- B. Incorrect.
Incorrect. Snowflake Notebooks are designed to run interactive code, SQL, and analysis workflows directly in Snowflake. Converting to a dashboard is unrelated to the missing execution resource problem. Dashboards are for presentation and monitoring, not for solving notebook runtime access issues.
- C. Incorrect.
Incorrect. Snowpipe is used for continuous data ingestion, not for providing compute access to notebook execution. Even if the sales data were streamed into Snowflake, the notebook would still need an authorized compute resource to run cells.
- D. Incorrect.
Incorrect. Cross-region replication is for replicating supported Snowflake objects and data across regions or accounts for business continuity and distribution scenarios. It does not provide notebook execution compute or automatically provision temporary resources for users.