
Ultimate access to all questions.
You are required to integrate prescriptive analytics into a report for an e-commerce company aiming to optimize their inventory management. The dataset includes 'ProductID', 'StockLevel', 'SalesVolume', and 'LeadTime'. Describe how you would use optimization models in Microsoft Fabric to suggest the optimal stock levels for each product, considering factors like sales volume and lead time. Include the type of optimization model you would use and the data preprocessing steps necessary.
A
Use a linear programming model, preprocess data by normalizing and splitting into training and test sets.
B
Choose a decision tree model, preprocess data by encoding categorical variables and scaling numerical features.
C
Implement a mixed-integer programming model, preprocess data by handling missing values and aggregating by ProductID.
D
Select a neural network model, preprocess data by binning and reducing dimensionality.