Microsoft Fabric Analytics Engineer Associate DP-600

Microsoft Fabric Analytics Engineer Associate DP-600

Get started today

Ultimate access to all questions.


You are required to integrate prescriptive analytics into a report for a logistics company aiming to optimize their delivery routes. The dataset includes 'RouteID', 'Distance', 'Time', 'VehicleType', and 'Cost'. Describe how you would use optimization models in Microsoft Fabric to suggest the optimal routes for each vehicle type, considering factors like distance, time, and cost. Include the type of optimization model you would use and the data preprocessing steps necessary.




Explanation:

For optimizing delivery routes, a mixed-integer programming model is suitable as it can handle discrete decisions like route selection. Preprocessing involves handling missing values and aggregating data by VehicleType to ensure each vehicle's data is considered individually.