SOL-C01 · Question #306
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 sta
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #306. The question stem and answer options stay visible for context.
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.
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.