SnowPro Specialty: Native Apps free question 4 / 10 · Domain 2: Build Snowflake Native Applications
A setup script runs CREATE SCHEMA IF NOT EXISTS app_config and, on the next line, CREATE TABLE IF NOT EXISTS params(...). The table is not created in app_config. What does the setup script page say the script should do?
- Name app_config as the default schema in the manifest file
- Create the schema as a versioned schema so it becomes current
- Qualify the table as app_config.params
- Add USE SCHEMA app_config after the CREATE SCHEMA line
Show the answer and explanation
Answer: C
Why this is correct
The best practice "Include the target schema when creating objects" says the CREATE SCHEMA command does not change the session context. Objects must be qualified with the target schema when they are created. The page's example is CREATE SCHEMA IF NOT EXISTS app_config followed by CREATE TABLE IF NOT EXISTS app_config.params(...). The unqualified table name in the question is not resolved into the new schema, so the fix is to write the schema name into each statement that creates an object in it.
Why the other options are wrong
"Add USE SCHEMA app_config after the CREATE SCHEMA line" … The page's best practice is not to switch context but to qualify objects with the target schema when they are created, as in its own example.
"Create the schema as a versioned schema so it becomes current" … Whether a schema is versioned decides how its objects behave across versions. It does not make the schema the current one for later statements.
"Name app_config as the default schema in the manifest file" … The manifest gives the setup script location, versions and configuration; the page's fix for this case is in the CREATE statements themselves.
Write every statement to stand alone
The same best practices recommend idempotent CREATE forms, CREATE OR REPLACE or CREATE IF NOT EXISTS, because the setup script can run more than once during installation and upgrade. Fully qualified names keep each statement correct whichever order it runs in.