Question 1

How can Python variable substitution be performed in Snowflake notebooks?

Options :

A : By manually editing data files

B : By configuring network settings

C : By using placeholders in SQL queries

D : By writing HTML code

Answer: C

Question 2

Which types of stages are supported in Snowflake for data loading and unloading? (Select TWO)

Options :

A : Managed Stages

B : Permanent Stages

C : Temporary Stages

D : External Stages

E : Internal Stages

Answer: D,E

Question 3

What Snowflake parameter is configured in the Query Processing layer?

Options :

A : The minimum and maximum serverless compute limits

B : The types of tables available in an account

C : The sizing of virtual warehouses

D : The minimum and maximum micro-partition limits

Answer: C

Question 4

What is the SHOW GRANTS SQL command primarily used for?

Options :

A : To view the history of data loads.

B : To display all privileges granted to a role or user.

C : To list all active users in the account.

D : To show current warehouse credit usage.

Answer: B

Question 5

Which SQL command is commonly used to load structured data from a stage into a Snowflake table?

Options :

A : INSERT INTO

B : COPY INTO

C : LOAD DATA

D : IMPORT DATA

Answer: B