Snowflake - SnowPro Core Practice Questions & Free Practice Exam

5 free Snowflake - SnowPro Core practice questions below, with instant explanations. The full simulator contains hundreds of exam-style questions across every topic.

Open the full Practice Zone Create a free account

Question 1

FLATTEN exposes metadata columns describing each generated row in its output. Which three columns does FLATTEN produce? Choose three.

Question 2

Which ACCOUNT_USAGE view records total credits billed by a warehouse during each metering window?

Question 3

A transient table loses its data the moment its Time Travel window expires. Which protection layer remains unavailable for transient tables?

Question 4

Marketplace auto-fulfillment replicates data into a new consumer region the first time access is requested. Replication then runs on the configured refresh cadence after the initial snapshot completes. Which party absorbs the replication storage and refresh cost?

Question 5

Thirty minutes after a permanent table is dropped, the owning team needs the table restored to meet a reporting deadline. DATA_RETENTION_TIME_IN_DAYS was set to zero on this table earlier in the week to reduce storage cost. UNDROP returns an error. AT and BEFORE queries also fail. Which recovery path applies?

Ready for the full Snowflake - SnowPro Core exam simulator?

Unlock the complete question bank, weighted mock exams, saved-question flashcards, and the Shark AI tutor - all inside your MyCertStack account.

See pricing Browse other certifications