at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below:

at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below:
A . Developer missed to create stream on the source table which can further query to capture DML records.
B . Select query will fail with error: ‘SQL compilation error-Incorrect Keyword "Chang-es()" found’
C . No Error reported, select command gives Changed records with Metadata columns as change tracking enabled on the Source views & its underlying tables.
D . Select statement complied but gives erroneous results.

View Answer

Answer: C

Explanation:

As an alternative to streams, Snowflake supports querying change tracking metadata for tables or views using the CHANGES clause for SELECT statements. The CHANGES clause enables querying change tracking metadata between two points in time without having to create a stream with an explicit transactional offset.

To Know more about Snowflake CHANGES clause, please refer the mentioned link:

https://docs.snowflake.com/en/sql-reference/constructs/changes