Absolute Free SnowPro-Advanced-Architect Exam Practice for Comprehensive Preparation 

CREATE OR REPLACE DATABASE MY_DB DATA_RETENTION_TIME_IN_DAYS=30;

CREATE OR REPLACE SCHEMA S1 DATA_RETENTION_TIME_IN_DAYS=50;

How long will we be able to access the data from the schema using the Time Travel functionality if we drop the database?

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage). Why Is this occurring? 

What should the Architect do?