Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario? 

Your data transfer takes 48 hours. In this case which data transfer mode will you use with Spark connector?

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

Snowpipe API provides a REST endpoint for defining the list of files to ingest that Informs Snow-flake about the files to be ingested into a table. A successful response from this endpoint means that Snowflake has recorded the list of files to add to the table. It does not necessarily mean the files have been ingested. What is name of this Endpoint? 

Mark the incorrect statement in case Data engineer using the COPY INTO command to load data from files into Snowflake tables?