A company wants to provide data scientists with near real-time read-only access to the company's production Amazon RDS for PostgreSQL database. The database is currently configured as a Single-AZ database. The data scientists use complex queries that will not affect the production database. The company needs a solution that is highly available.Which solution will meet these requirements MOST cost-effectively?
Answer(s): D
The correct answer is D. A Multi-AZ cluster deployment with two readable standby instances provides highly available, near real-time read-only access through read endpoints, meeting HA and access needs while avoiding impact on production. A) Scaling during maintenance risks downtime and does not ensure HA for reads. B) A larger secondary in Multi-AZ still uses a single writable primary; data scientists accessing the secondary may lag and does not provide two read endpoints for load distribution. C) Adds two read replicas but does not provide a true multi-AZ cluster with writable primary failover behavior; it also may introduce replication lag and complexity without the specified two readable standbys.
A company runs a three-tier web application in the AWS Cloud that operates across three Availability Zones. The application architecture has an Application Load Balancer, an Amazon EC2 web server that hosts user session states, and a MySQL database that runs on an EC2 instance. The company expects sudden increases in application traffic. The company wants to be able to scale to meet future application capacity demands and to ensure high availability across all three Availability Zones.Which solution will meet these requirements?
Answer(s): A
A) Correct. RDS MySQL with Multi-AZ provides high availability across AZs for the database. ElastiCache Redis offers highly available in-memory caching and session storage, improving performance for scaling reads and sessions. Auto Scaling across three AZs ensures fault tolerance and capacity for traffic spikes, meeting HA and scale requirements.B) Incorrect. ElastiCache Memcached lacks Redis’s advanced features and persistence; Redis is preferred for session storage with persistence and richer data structures. Also, Memcached does not provide the same HA capabilities as Redis in managed deployments.C) Incorrect. DynamoDB with DAX provides a NoSQL approach but introduces application redesign; while scalable, it departs from the proven RDBMS MySQL model and requires significant changes. Session storage and relational querying patterns may not map cleanly.D) Incorrect. Single AZ for RDS breaks HA across AZs. Requires manual failover and does not meet the availability requirement despite Redis being in place.
A global video streaming company uses Amazon CloudFront as a content distribution network (CDN). The company wants to roll out content in a phased manner across multiple countries. The company needs to ensure that viewers who are outside the countries to which the company rolls out content are not able to view the content.Which solution will meet these requirements?
CloudFront geographic restrictions with an allow list directly blocks viewers outside specified countries, matching phased rollout requirements.A) Correct: Geographic restriction (allow list) ensures only chosen countries can access content; custom error message handles blocked requests gracefully.B) Signed URLs/cookies restrict access by user/session, not by country, and do not enforce country-based gating for a phased rollout.C) Encryption alone protects content in transit/storage but does not enforce regional access, so viewers in allowed regions could still access.D) Time-based signed URLs control expiration, not geographic access, so it does not enforce country restrictions.
A company wants to use the AWS Cloud to improve its on-premises disaster recovery (DR) configuration. The company's core production business application uses Microsoft SQL Server Standard, which runs on a virtual machine (VM). The application has a recovery point objective (RPO) of 30 seconds or fewer and a recovery time objective (RTO) of 60 minutes. The DR solution needs to minimize costs wherever possible.Which solution will meet these requirements?
Answer(s): B
AWS DMS with a warm standby RDS for SQL Server meets tight RPOs/RTOs while minimizing cost by continuously applying CDC to a standby DB in AWS, enabling fast failover and SQL Server compatibility with managed service. A) Multi-site active/active with Always On Enterprise is costly and complex for DR across on-prem and AWS, exceeding required cost-minimization. C) AWS Elastic Disaster Recovery with pilot light focuses on rapid recovery but not as cost-efficient for this RPO/RTO combination and may require more storage. D) Nightly backups plus S3 is insufficient for 30s RPO and 60m RTO. B aligns with RPO/RTO and cost goals.
A company has an on-premises server that uses an Oracle database to process and store customer information. The company wants to use an AWS database service to achieve higher availability and to improve application performance. The company also wants to offload reporting from its primary database system.Which solution will meet these requirements in the MOST operationally efficient way?
The correct answer is D because Amazon Aurora provides a highly available, fault-tolerant managed database with built-in read replicas (Aurora replicas) for offloading heavy read/reporting workloads, improving performance and reducing operational overhead. Aurora is compatible with various workloads and supports multi-AZ-like fault tolerance within a single cluster, yielding high availability without manual failover complexity.A is incorrect: DMS is for migration/continuous replication, not for optimizing ongoing reporting workload separation and availability in prod. B is incorrect: Single-AZ with a read replica in same zone does not offer the resilience and performance benefits of a multi-AZ/replica setup. C is incorrect: Multi-AZ deployment with Oracle does provide HA but not the most operationally efficient read-scaling via managed read replicas as Aurora offers.
Post your Comments and Discuss Amazon AWS-SOLUTION-ARCHITECT-ASSOCIATE exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AWS-SOLUTION-ARCHITECT-ASSOCIATE content, but please register or login to continue.