Free Practice Snowflake SnowPro-Advanced-Data-Engineer Exam Questions 2026

For a business group, you need to create a table with customer demography data in snowflake. Business users will need to do both range and equality searches on the table. Which of the below techniques will you use to speed up the queries.

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. What is term used to call these Transaction?

For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?

Lets say you created a schema and a table as below
    CREATE OR REPLACE SCHEMA TIME_TRAVEL_SCHEMA DATA_RETENTION_TIME_IN_DAYS =10;
    CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data