Exam Name: | SnowPro Advanced: Architect Certification Exam | ||
Exam Code: | ARA-C01 Dumps | ||
Vendor: | Snowflake | Certification: | SnowPro Advanced: Architect |
Questions: | 162 Q&A's | Shared By: | alyssia |
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
An Architect for a multi-national transportation company has a system that is used to check the weather conditions along vehicle routes. The data is provided to drivers.
The weather information is delivered regularly by a third-party company and this information is generated as JSON structure. Then the data is loaded into Snowflake in a column with a VARIANT data type. This
table is directly queried to deliver the statistics to the drivers with minimum time lapse.
A single entry includes (but is not limited to):
- Weather condition; cloudy, sunny, rainy, etc.
- Degree
- Longitude and latitude
- Timeframe
- Location address
- Wind
The table holds more than 10 years' worth of data in order to deliver the statistics from different years and locations. The amount of data on the table increases every day.
The drivers report that they are not receiving the weather statistics for their locations in time.
What can the Architect do to deliver the statistics to the drivers faster?
Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?