SnowPro Core Certification — Question 635

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table.

What will the query from the view return?

Answer options

• A. The data from the permanent table.
• B. The data from the temporary table.
• C. An error stating that the view could not be compiled.
• D. An error stating that the referenced object could not be uniquely identified.

Correct answer: B

Explanation

The query from the view will return data from the temporary table because it takes precedence over the permanent table when both share the same name in the same schema. The other options are incorrect as they suggest that the view would reference the permanent table or result in an error, neither of which occurs in this scenario.