ARA-C01 Question #86: Real Exam Question with Answer & Explanation

Question

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?

Options

• ACreate an additional table in the schema for longitude and latitude. Determine a regular task to fill
• BAdd search optimization service on the variant column for longitude and latitude in order to query
• CDivide the table into several tables for each year by using the timeframe information from the
• DDivide the table into several tables for each location by using the location address information from