Similar to the other table types (transient and permanent), temporary tables belong to a specified database and schema; however, because they are session-based, they aren’t bound by the same uniqueness requirements. This means you can create temporary and non-temporary tables with the same name within the same schema.
However, note that the temporary table takes precedence in the session over any other table with the same name in the same schema.
https://docs.snowflake.com/en/user-guide/tables-temp-transient
View contains query that references the perm table. so, when query is executed on the view, it will run the query definition on the view. So, 'A' is correct
when a view is defined on a permanent table, it continues to reference the permanent table even if a temporary table with the same name is created in the same schema
Changing my answer to A - According to the documentation, when a view is defined on a permanent table, it continues to reference the permanent table even if a temporary table with the same name is created in the same schema. The view will not be affected by the temporary table.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
miomio123
Highly Voted 7 months, 2 weeks agoJRayan
Most Recent 4 days, 3 hours agoJRayan
1 day, 13 hours agos_indira15
1 week, 4 days agoravuri_rk
7 months, 2 weeks agoMultiCloudIronMan
7 months, 2 weeks agoMultiCloudIronMan
1 month, 3 weeks ago