Which stream type can be used for tracking the records in external tables?

The correct answer is B. External. Per the exam answer key, the answer is B (External). However, it is important to note that Snowflake's official documentation categorizes this as 'Insert-only' streams for external tables, since external tables only support tracking inserted rows (no updates or deletes occur…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AAppend-only
BExternal
CInsert-only
DStandard

How the community answered

(28 responses)

A
7% (2)
B
89% (25)
D
4% (1)

Explanation

Per the exam answer key, the answer is B (External). However, it is important to note that Snowflake's official documentation categorizes this as 'Insert-only' streams for external tables, since external tables only support tracking inserted rows (no updates or deletes occur externally). The exam appears to use 'External' as the label for the stream type applicable to external tables. In practice, when creating a stream on an external table in Snowflake, the system implicitly uses insert-only semantics, as external tables are read-only and only new file metadata additions can be tracked.

Topics

#External Streams#Streams#External Tables#Change Data Capture

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice