A manufacturing company stores last year’s production volume data in a PostgreSQL database. Business analysts (who do not write code) must be able to prepare the data and build a model to forecast future production volume. Which end-to-end solution requires the least effort and no coding?
Choose an answer
Tap an option to check your answer.
Correct answer: Use AWS Glue DataBrew to connect to the PostgreSQL database and perform data preparation. Use Amazon SageMaker Canvas for model building and predictions..
Why this is the answer
This solution is optimal because it leverages fully managed, low-code/no-code services. AWS Glue DataBrew allows business analysts to visually prepare data from PostgreSQL without writing code, directly addressing the "no coding" requirement. Amazon SageMaker Canvas is a no-code machine learning service designed for business analysts to build, train, and deploy models, including forecasting, with a visual interface. This combination requires the least effort and no coding. The other options are less suitable: Using Amazon EMR requires coding skills (e.g., Spark, Hive) and significant effort to manage. Using AWS Glue for data preparation typically involves writing PySpark scripts, which violates the "no coding" constraint for business analysts. While AWS Glue DataBrew is good for preparation, using Amazon SageMaker Studio for modeling usually implies coding (e.g., Python notebooks) for model development, which is not suitable for analysts who "do not write code.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed