Câu 3: TDVAN5: Teradata Vantage Administration

At a large car manufacturer, huge volumes of diagnostic data for cars are collected in the following table: The master data for each car is stored in the following table: Many reports require data from both tables by joining via column VehicleId. A very frequently performed query on the system returns the number of events by FaultCode and ModelType. This query consumes many CPU and I/O resources each day. Which action should the Administrator take to improve the runtime and resource consumption for this query?

1. A. Use an aggregate join index with columns FaultCode, ModelType, as well as an appropriate aggregate function. — đáp án hiện tại
2. B. Use a sparse join index with columns FaultCode and ModelType, as well as an appropriate filter function.
3. C. Use a NUSI on VehicleEvent.FaultCode and a NUSI on Vehicle.ModelType
4. D. Use a single table join index on VehicleEvent hashed by FaultCode and another single table join index on Vehicle hashed by ModelType.Answer: A -Explanation:To improve the runtime and resource consumption for a query that returns the number of events by FaultCode and ModelType from the two tables VehicleEvent and Vehicle, the most appropriate action would be: