What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).
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, lOT_timestamp and Customerld are frequently used in the filter predicate for the select statement
2. The columns City and DeviceManuf acturer are often retrieved
3. There is often a count on Uniqueld
Which field(s) should be used for the clustering key?
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?
A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
