nerdexam
Amazon

MLS-C01 · Question #64

A Machine Learning Specialist has completed a proof of concept for a company using a small data sample, and now the Specialist is ready to implement an end-to-end solution in AWS using Amazon…

The correct answer is B. Push the data from Microsoft SQL Server to Amazon S3 using an AWS Data Pipeline and provide. Amazon SageMaker's training jobs are designed to consume data from Amazon S3. SageMaker cannot natively connect to Amazon RDS during training. The correct pattern is to extract data from RDS and stage it in S3, then point SageMaker at the S3 location. AWS Data Pipeline (or AWS…

Data Engineering

Question

A Machine Learning Specialist has completed a proof of concept for a company using a small data sample, and now the Specialist is ready to implement an end-to-end solution in AWS using Amazon SageMaker. The historical training data is stored in Amazon RDS. Which approach should the Specialist use for training a model using that data?

Options

  • AWrite a direct connection to the SQL database within the notebook and pull data in
  • BPush the data from Microsoft SQL Server to Amazon S3 using an AWS Data Pipeline and provide
  • CMove the data to Amazon DynamoDB and set up a connection to DynamoDB within the notebook
  • DMove the data to Amazon ElastiCache using AWS DMS and set up a connection within the

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    75% (21)
  • C
    4% (1)
  • D
    14% (4)

Explanation

Amazon SageMaker's training jobs are designed to consume data from Amazon S3. SageMaker cannot natively connect to Amazon RDS during training. The correct pattern is to extract data from RDS and stage it in S3, then point SageMaker at the S3 location. AWS Data Pipeline (or AWS Glue/DMS) can automate the RDS-to-S3 export. Option A (notebook SQL connection) is brittle and inefficient for large datasets; notebooks are for experimentation, not production pipelines. Option C (DynamoDB) adds unnecessary complexity - DynamoDB is a NoSQL key-value store not suited for ML training data staging. Option D (ElastiCache) is an in-memory caching layer, entirely inappropriate for persisting training datasets.

Topics

#Data Ingestion#ETL#Amazon S3#Amazon SageMaker

Community Discussion

No community discussion yet for this question.

Full MLS-C01 Practice