Free Snowflake SnowPro-Advanced-Architect Practice Exams Questions 2026  - TheExamsLabs

It is recommended to assign ACCOUNTADMIN role to atleast two user

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00AM, to recover some objects.The STAGING schema has 50 days of retention.The Architect runs the following statement:CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00');The Architect receives the following error: Time travel data is not available for schema STAGING. Therequested time is either beyond the allowed time travel period or before the object creation time.The Architect then checks the schema history and sees the following:CREATED_ON|NAME|DROPPED_ON2021-06-02 23:00:00 | STAGING | NULL2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00How can cloning the STAGING schema be achieved?

A company needs to have the following features available in its Snowflake account: 1. Support for Multi-Factor Authentication (MFA) 2. A minimum of 2 months of Time Travel availability 3. Database replication in between different regions 4. Native support for JDBC and ODBC 5. Customer-managed encryption keys using Tri-Secret Secure 6. Support for Payment Card Industry Data Security Standards (PCI DSS) In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

A company needs to share a Snowflake data table with data consumers who do not have Snowflake accounts.What is the recommended way to to this?

For which use cases, will you use cross-cloud and cross-region replication?