SnowPro Advanced Architect Certification (SNOWPRO) - Snowflake Actual Exam Questions
Last updated on March 10, 2026
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
Account
Database
Schema
Table
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
USAGE_VIEWER
GOVERNANCE_VIEWER
OBJECT_VIEWER
SECURITY_VIEWER
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
What is a limitation of a Materialized View?
A Materialized View cannot support any aggregate functions
A Materialized View can only reference up to two tables
A Materialized View cannot be joined with other tables
A Materialized View cannot be defined with a JOIN
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Each Snowflake account can be hosted in a different cloud vendor and region.
Each Snowflake account must be hosted in a different cloud vendor and region
All Snowflake accounts must be hosted in the same cloud vendor and region
Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
Cross join
Inner join
Natural join
Outer join
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.