MLS-C01 Question #383: Real Exam Question with Answer & Explanation

Question

A manufacturing company stores production volume data in a PostgreSQL database. The company needs an end-to-end solution that will give business analysts the ability to prepare data for processing and to predict future production volume based the previous year's production volume. The solution must not require the company to have coding knowledge. Which solution will meet these requirements with the LEAST effort?

Options

• AUse AWS Database Migration Service (AWS DMS) to transfer the data from the PostgreSQL
• BUse AWS Glue DataBrew to read the data that is in the PostgreSQL database and to perform the
• CUse AWS Database Migration Service (AWS DMS) to transfer the data from the PostgreSQL
• DUse AWS Glue DataBrew to read the data that is in the PostgreSQL database and to perform the

Explanation

To enable business analysts without coding knowledge to prepare production data from PostgreSQL and subsequently predict future volumes, AWS Glue DataBrew is the most suitable service. It offers a visual interface for data preparation, directly addressing the no-coding requirement.

Common mistakes.

• A. AWS Database Migration Service (AWS DMS) is designed for migrating databases and does not offer data preparation, analysis, or machine learning prediction capabilities for business analysts.
• C. AWS Database Migration Service (AWS DMS) is designed for migrating databases and does not offer data preparation, analysis, or machine learning prediction capabilities for business analysts.
• D. This option is identical to option B and is the correct choice, indicating the question likely presents redundant options or multiple ways to express the correct service.

Concept tested. AWS Glue DataBrew for no-code data preparation

Reference. https://aws.amazon.com/databrew/

No community discussion yet for this question.