PL-300 · Question #159
You have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table. The table has 12 million rows. All the columns are
The correct answer is A. Split the DateTime column into separate date and time columns.. To decrease the model adjustments are needed in the model itself, so of the selections to separate the date and time would reduce the size as the way vertipaq compressions works for repeated values.
Question
You have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table. The table has 12 million rows. All the columns are needed for analysis. You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data. What should you do?
Exhibit
Options
- ASplit the DateTime column into separate date and time columns.
- BDisable the Power Query load.
- CRound the Longitude column two decimal places.
- DChange the data type of the TempCelsius column to Integer
How the community answered
(39 responses)- A77% (30)
- B15% (6)
- C5% (2)
- D3% (1)
Explanation
To decrease the model adjustments are needed in the model itself, so of the selections to separate the date and time would reduce the size as the way vertipaq compressions works for repeated values.
Topics
Community Discussion
No community discussion yet for this question.