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.

AD not E

I understand removing rows in Sales[Status] = "Cancelled" will also remove rows in Sales[Canceled_date] reporting any date (will remain only null values in this column) but to "Reduce the load times" we should decrease the size of the data model so I would also vote for the entire column Sales[Canceled_date]. Splitting the Sales[Sale_date] would increase performance of the query as the "date" part will be isolated without the "time" details, but this would increase also the size as it would add an additional column to our model (from "sale_date" single column to "sale_date"+"sale _time")

There is no cancel date in Sales column, just a text value (status)

Removing rows will increase query performance and Splitting the Sales_Date column make comparison faster.

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.