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: B

Explanation:

Let’s break down the scenario:

Ron wants to capture insert-only changes on the source views. He’s enabled change tracking on the views and their underlying tables. Then, he’s trying to query these changes using the CHANGES() function.

Here’s a breakdown of the given options:

A. While creating a stream can help capture DML records, the scenario doesn’t mention the creation of a stream and is trying to directly query change data with the CHANGES() function. This option is plausible.

B. The syntax used, changes(information => append_only), is not correct for Snowflake. The correct syntax should be something like CHANGES(test_table, APPEND_ONLY). So this statement is also plausible.

C. Change tracking doesn’t directly allow querying with a CHANGES() function without involving a stream. This option seems less likely given the setup described.

D. The select statement might compile but due to incorrect syntax or missing setup (like missing stream), it could give erroneous results. This option is plausible.

Given the context provided, the most direct issue with Ron’s approach is the incorrect syntax of the CHANGES() function. Therefore, the most appropriate answer is:

B. Select query will fail with error: ‘SQL compilation error-Incorrect Keyword "Changes()" found’