SnowPro Core Certification — Question 786

What is the default behavior of internal stages in Snowflake?

Answer options

• A. Named internal stages are created by default.
• B. Users must manually create their own internal stages.
• C. Data files are automatically staged to a default location.
• D. Each user and table are automatically allocated an internal stage.

Correct answer: D

Explanation

The correct answer is D because Snowflake automatically allocates an internal stage for each user and table, allowing for easier data management. Option A is incorrect as it refers to named internal stages, which are not the default. Option B is wrong since manual creation is not necessary for internal stages. Option C is misleading because while data files can be staged, the emphasis on a default location does not reflect the actual behavior.