Snowflake - SnowPro Advanced Architect Practice Questions & Free Practice Exam
5 free Snowflake - SnowPro Advanced Architect practice questions below, with instant explanations. The full simulator contains hundreds of exam-style questions across every topic.
Which two statements accurately describe the functional-plus-access role pattern at architect scale? Select two.
Question 2
Operations teams turn on MFA enforcement for every authentication path on a hardened account. Which path does NOT participate in Snowflake-side Duo MFA challenges by design?
Question 3
Internal applications have no existing OAuth token source and cannot federate against the corporate IdP. Snowflake must issue access tokens to the application directly. Which integration matches the requirement?
Question 4
A health records pipeline filters a VARIANT payload column using a path expression that an orchestration layer assembles at run time from a control table and passes into GET_PATH. Query Profile shows the clustered fact table scanning every micro-partition for what should be selective lookups. Which explanation matches the chapter's account of the absent pruning?
Question 5
Repeated `SELECT COUNT(*) FROM fact_orders` queries arrive on a 100 TB fact table. The response returns in milliseconds even on a cold Result Cache and even when the warehouse is suspended at the moment of arrival. Which Snowflake surface produces that response without consuming warehouse compute?
Ready for the full Snowflake - SnowPro Advanced Architect exam simulator?
Unlock the complete question bank, weighted mock exams, saved-question flashcards, and the Shark AI tutor - all inside your MyCertStack account.
