Question No 1

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Choose the Choices:

Standard tables, including shared tables.

Views, including secure views

Directory tables

Query Log Tables

External tables

Question No 2

Tasks may optionally use table streams to provide a convenient way to continuously process new or changed dat a. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table and either consume the change data or skip the current run if no change data exists. Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?

Choose the Choices:

Question No 3

1. + - ------------------------------------------------------------- + 2. | SYSTEM$CLUSTERING_INFORMATION('SF_DATA', '(COL1, COL3)') | 3. | - ------------------------------------------------------------- | 4. | { | 5. | "cluster_by_keys" : "(COL1, COL3)", | 6. | "total_partition_count" : 1156, | 7. | "total_constant_partition_count" : 0, | 8. | "average_overlaps" : 117.5484, | 9. | "average_depth" : 64.0701, | 10. | "partition_depth_histogram" : { | 11. | "00000" : 0, | 12. | "00001" : 0, | 13. | "00002" : 3, | 14. | "00003" : 3, | 15. | "00004" : 4, | 16. | "00005" : 6, | 17. | "00006" : 3, | 18. | "00007" : 5, | 19. | "00008" : 10, | 20. | "00009" : 5, | 21. | "00010" : 7, | 22. | "00011" : 6, | 23. | "00012" : 8, | 24. | "00013" : 8, | 25. | "00014" : 9, | 26. | "00015" : 8, | 27. | "00016" : 6, | 28. | "00032" : 98, | 29. | "00064" : 269, | 30. | "00128" : 698 | 31. | } | 32. | } | 33. + - ------------------------------------------------------------- + The Above example indicates that the SF_DATA table is not well - clustered for which of following valid reasons?

Choose the Choices:

Zero (0) constant micro - partitions out of 1156 total micro - partitions.

High average of overlapping micro - partitions.

High average of overlap depth across micro - partitions.

Most of the micro - partitions are grouped at the lower - end of the histogram, with the majority of micro - partitions having an overlap depth between 64 and 128.

ALL of the above

Question No 4

Mark a Data Engineer, looking to implement streams on local views & want to use change tracking metadata for one of its Data Loading use case. Please select the incorrect understanding points of Mark with respect to usage of Streams on Views?

Choose the Choices:

For streams on views, change tracking must be enabled explicitly for the view and un - derlying tables to add the hidden columns to these tables.

The CDC records returned when querying a stream rely on a combination of the offset stored in the stream and the change tracking metadata stored in the table.

Views with GROUP BY & LIMIT Clause are supported by Snowflake.

As an alternative to streams, Snowflake supports querying change tracking metadata for views using the CHANGES clause for SELECT statements.

Enabling change tracking adds a pair of hidden columns to the table and begins storing change tracking metadata. The values in these hidden CDC data columns provide the input for the stream metadata columns. The columns consume a small amount of stor - age.

Question No 5

To advance the offset of a stream to the current table version without consuming the change data in a DML operation, which of the following operations can be done by Data Engineer? [Select 2]

Choose the Choices:

using the CREATE OR REPLACE STREAM syntax, Recreate the STREAM

Insert the current change data into a temporary table. In the INSERT statement, query the stream but include a WHERE clause that filters out all of the change data (e.g. WHERE 0 = 1).

A stream advances the offset only when it is used in a DML transaction, so none of the options works without consuming the change data of table.

Delete the offset using STREAM properties SYSTEM$RESET_OFFSET( <stream_id> )

Practice Snowflake DEA-C01 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

DEA-C01 Exam Features

DEA-C01 PDF Dumps