Q69 — AWS SAA-C03 Ch.14

Question 69 of 100 | ← Chapter 14

Q1069. A company is planning to deploy a data processing platform on AWS.The data processing platform is based on PostgreSQL. The company stores the data that the platform must process on premises.To comply with regulations,the company must not migrate the data to the cloud.However,the company wants to use AWS managed data analytics solutions.Which solution will meet these requirements?

• A. Create an Amazon RDS for PostgreSQL database in a VPC. Create an interface VPC endpoint to connect the on-premises PostgreSQL database to the RDS for PostgreSQL database.
• B. Create Amazon EC2 instances in an Auto Scaling group on AWS Outposts. Install PostgreSQL data analytics software on the instances.
• C. Create an Amazon EMR cluster on AWS Outposts. Connect the EMR cluster to the on-premises PostgreSQL database to perform data processing locally. ✓
• D. Create an Amazon EMR cluster in a VPC. Connect the EMR cluster to Amazon RDS for SQL Server with a linked server to connect to the company's data processing platform.

Correct Answer: C. Create an Amazon EMR cluster on AWS Outposts. Connect the EMR cluster to the on-premises PostgreSQL database to perform data processing locally.

Explanation

The solution that best meets the company's requirements for a data processing platform while keeping data on-premises is:C. Create an Amazon EMR cluster on AWS Outposts. Connect the EMR cluster to the on-premises PostgreSQL database to perform data processing locally.Explanation:- AWS Outposts: This service allows you to run AWS infrastructure and services on-premises. By deploying an EMR cluster on Outposts, the company can process data locally without migrating it to the cloud, thus complying with regulations.- Data Processing: EMR is well-suited for big data processing tasks and can connect to the on-premises PostgreSQL database for analytics purposes.Other Options:- A. Create an Amazon RDS for PostgreSQL database in a VPC: This option involves migrating the data to RDS, which does not comply with the requirement to keep data on-premises.- B. Create Amazon EC2 instances in an Auto Scaling group on AWS Outposts: While this option allows for local processing, it requires manual installation and management of PostgreSQL data analytics software, which may not be as efficient or easy to manage as using EMR.- D. Create an Amazon EMR cluster in a VPC: Similar to option A, this would involve moving data to AWS, which is not compliant with the requirement to keep data on-premises.Conclusion:Option C is the most suitable solution as it allows the company to utilize AWS managed analytics solutions while keeping the data on-premises and in compliance with regulations.