Question 190
A SQL script refers to a plain CUSTOMER table and metadata capitalizes the name. What Snowflake convention applies?
Explanation
Correct Answer
Correct: default identifier case folding. Unquoted identifier is generally normalized to uppercase according to Snowflake identifier rules.
Incorrect Answers
Not correct for this case: Double-quoted identifier preserves case and special characters subject to exact matching; the scenario specifically needs default identifier case folding.
Not correct for this case: Fully qualified object name includes database and schema context for an object; the scenario specifically needs default identifier case folding.
Not correct for this case: USE SCHEMA changes the session's current schema resolution context; the scenario specifically needs default identifier case folding.