Get 50% Flat Discount on This Special Offer | Limited Time Offer - Ends In COUPON: SAVE50

Practice Snowflake DEA-C01 Exam Questions

Page: 1/13
Total 65 Questions
Question No 1
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
Choose the Choices:


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:


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:


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:


Page: 1/13
Total 65 Questions