You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields: Reading Time (datetime) DateKey (date) LocationKey (whole number) Temp C (decimal) You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships. You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location. What two actions should you perform? Each correct answer presents part of the solution.Select all answers that apply. Create a column that contains the time values for the start of the hour of the Reading Time value. Disable the query load on the Temperatures query in the Power Query Editor. Remove the rows that occur exactly at 0 minutes and 0 seconds on the hour. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. Use the Group By functionality to aggregate the rows by DateKey, Reading Time, and LocationKey and then create a max Temp C value per row.