Free Snowflake SnowPro-Advanced-Data-Engineer Exam Questions

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.

Which system table will you use to get the total credit consumption over a specific time period?

Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform

Which are the Cloud Platforms that Support Calling an External Function? 

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