Linear regression is a machine learning approach that can be used to solve this problem. Linear
regression is a supervised learning technique that can model the relationship between one or more 
input variables (features) and an output variable (target). In this case, the input variables could be
the historical sales data of the part, such as the quarter, the demand, the price, the inventory, etc.
The output variable could be the number of units to be produced for the part. Linear regression can
learn the coefficients (weights) of the input variables that best fit the output variable, and then use
them to make predictions for new data. Linear regression is suitable for problems that involve
continuous and numeric output variables, such as predicting house prices, stock prices, or sales
volumes.

References:
AWS Machine Learning Specialty Exam Guide
Linear Regression

Updating the existing SageMaker endpoint to use a new configuration that is weighted to send 5% of
the traffic to the new variant is the simplest approach with the least risk to deploy the model and roll
it back, if needed. This is because SageMaker supports A/B testing, which allows the Specialist to
compare the performance of different model variants by sending a portion of the traffic to each
variant. The Specialist can monitor the metrics of each variant and adjust the weights accordingly. If
the new variant does not perform as expected, the Specialist can revert traffic to the last version by
resetting the weights to 100% for the old variant and 0% for the new variant. This way, the Specialist
can deploy the model without affecting the customer experience and roll it back easily if
needed.

References:
Amazon SageMaker
Deploying models to Amazon SageMaker hosting services

Area Under the ROC Curve (AUC) is a metric that measures the performance of a binary classifier
across all possible thresholds. It is also known as the probability that a randomly chosen positive
example will be ranked higher than a randomly chosen negative example by the classifier. AUC is a
good metric to compare different classification models because it is independent of the class
distribution and the decision threshold. It also captures both the sensitivity (true positive rate) and
the specificity (true negative rate) of the model.

References:
AWS Machine Learning Specialty Exam Guide
AWS Machine Learning Specialty Sample Questions

Pushing the data from Microsoft SQL Server to Amazon S3 using an AWS Data Pipeline and providing
the S3 location within the notebook is the best approach for training a model using the data stored in
Amazon RDS. This is because Amazon SageMaker can directly access data from Amazon S3 and train
models on it. AWS Data Pipeline is a service that can automate the movement and transformation of
data between different AWS services. It can also use Amazon RDS as a data source and Amazon S3 as
a data destination. This way, the data can be transferred efficiently and securely without writing any
code within the notebook.
References:
Amazon SageMaker
AWS Data Pipeline

Amazon EMR is a service that can process large amounts of data efficiently and cost-effectively. It
can run distributed frameworks such as Apache Spark, which can perform feature engineering on big
data. Amazon SageMaker SDK is a Python library that can interact with Amazon SageMaker service to
train and deploy machine learning models. It can also use Amazon EMR as a data source for training
data. References:
Amazon EMR
Amazon SageMaker SDK