SOL-C01 Question #306: Real Exam Question with Answer & Explanation

Question

In Snowflake Notebooks, you execute a cell containing a SQL query that retrieves data from a view based on multiple underlying tables. The execution status shows 'Success', but the output displays stale data. You are certain that the underlying tables have been updated recently. Which of the following steps are MOST likely to resolve this issue?

Options

• ARefresh the Snowflake Notebook session by disconnecting and reconnecting.
• BDrop and recreate the view to ensure it reflects the latest data from the underlying tables.
• CSuspend and resume the Snowflake warehouse associated with the Notebook to clear any cached
• DCheck the definition of the view to ensure it is not using a 'SECURE VIEW' without proper
• EExecute 'ALTER VIEW REBUILD to force a refresh of the view's metadata and data.

Explanation

Stale data despite successful execution suggests caching or privilege issues. Suspending and resuming the warehouse (C) clears potential caches. Secure views (D) might require specific privileges if the user running the notebook lacks access to the underlying data at the time the view was created, or may be based on data at a specific time travel point. Refreshing the session (A) or rebuilding the view (E) may not always guarantee a refresh of cached results. Dropping and recreating a view (B) is a drastic measure and should be considered only if other options fail.

No community discussion yet for this question.