試験PL-300J トピック2 問題444 スレッド

Choose A (Remove the rows in which sales [status] has a value of Canceled); D (Split Sales [Sale_Date] into separate date and time columns). The key constraint is to reduce the load times of the query without affecting the analysis. Power Query should resolve this requirement before the data enters the semantic model. The chosen transformation preserves the required rows and grain while converting the source layout into an analysis-ready table. This directly matches the current study-guide objective " Create and transform columns "
. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Create and transform columns " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications
/resources/study-guides/pl-300