Exam SnowPro Advanced Architect topic 1 question 72 discussion

A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows.



The general query patterns for the table are:

1. DeviceId, IOT_timestamp and CustomerId are frequently used in the filter predicate for the select statement
2. The columns City and DeviceManufacturer are often retrieved
3. There is often a count on UniqueId

Which field(s) should be used for the clustering key?