Microsoft Exam PL-300 Topic 13 Question 3 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 3
Topic #: 13

ion 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?

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

Show Suggested Answer

Suggested Answer: B

Disable Power Query load.

Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-query-load

by Kallie at May 09, 2022, 09:07 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!