SnowPro Advanced: Architect — Question 17

Which of the following are characteristics of Snowflake’s parameter hierarchy?

Answer options

• A. Session parameters override virtual warehouse parameters.
• B. Virtual warehouse parameters override user parameters.
• C. Table parameters override virtual warehouse parameters.
• D. Schema parameters override account parameters.

Correct answer: D

Explanation

The correct answer is D because schema parameters indeed have higher precedence than account parameters in Snowflake's parameter hierarchy. Options A, B, and C are incorrect as they incorrectly describe the precedence relationships within the hierarchy.