Exam PL-300 topic 2 question 4 discussion

A, only records with state finished are used D, personally I would transform the column to a date format and not split it since only the date part is used Not E, All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value

It says: You need to reduce the LOAD times of the query without affecting the analysis. Only answers A and E can reduce the load times. D may reduce only the time needed to process the data. Someone said that E is not the answer because: "All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value". You must read again the decription cause it says " Each answer presents a COMPLETE solutiuon" not part of a solution.

Said AD fisrt. But I changed my mind. D improves the analysis but doesn't change the performance, while D does.

I don't agree with the community in my opinion A and D are the correct ones.

A and D. As E removing column doesn't decrease load time as query load time is dependent on the number of rows in the dataset. SInce rows will remain the same even after E, and the time taken to reach the bottom of the query is still the same. removing rows is actually where you save query load time. So A and D

I think it's DE. We need optimize only loading time, so A will reduces amount of rows we are loading, but Power Query must go through all dataset to delete specified values, so it takes more time than delete entire column

D is not correct not considering whether it affects the performance but remember question said that they wished to analyse the data with the column Sales_Date but they didn't say they not including time for analysis.

I think AE is correct

Answer A is obvious. I choose answer E because we want to analyze the rows with Status = Finished, that implies that every record in the analysis would have the Canceled_Date = null. That column would add nothing to the report, so we could safely drop it and that would improve a little the load time.

E will improve load time, nor D

i was mixing up load times and processing times. option D could potentially increase loading time, it would decrease processing time. processing time is for calculations, load time...is for loading

A, D and E are correct, but since we need to choose only 2, then A & D

D does not reduce load times. Probably it increases it. If we remove rows with Status = Cancelled then Canceled Date would always be null so we better remove the column and then option E becomes better than D.

D does not reduce anything

Answer: AD Explanation: A: Removing uninteresting rows will increase query performance. D: Splitting the Sales_Date column will make comparisons on the Sales date faster. The Power BI Desktop data model only supports date/time, but they can be formatted as dates or times independently. Date/Time – Represents both a date and time value. Underneath the covers, the Date/Time value is stored as a Decimal Number Type. Since there's a T in the dates column before split, it's saved as a source text value. Splitting converts it to a numeric value. This reduces the size.

Option A is obvious. Option D reduces the cardinality of the column which can have a huge impact in the loading time of the model.

Keeping dateatime column as whole hurt Power BI Performance.