Which query will fail if a table was created with DDL: CREATE TABLE MYTABLE (ID INTEGER, NAME VARCHAR)?

• A. SELECT * FROM MYTABLE
• B. SELECT * FROM Mytable
• C. SELECT * FROM \"MYTABLE\"
• D. SELECT * FROM \"Mytable\"

Answer: (D)

In Snowflake, unquoted identifiers are automatically converted to uppercase, while quoted identifiers preserve the exact case and are case-sensitive. Creating a table with an unquoted name results in MYTABLE stored as MYTABLE. You can reference it with an unquoted name (or with a quoted uppercase version), but using a mixed-case quoted name will not match.

So, queries using the unquoted name or the exact uppercase quoted form will succeed, while the query that attempts to reference the table with a mixed-case quoted identifier will fail.