A financial services company is migrating an on-premises relational transaction database t… — AWS Certified Solutions Architect - Associate

A financial services company is migrating an on-premises relational transaction database to Amazon RDS for PostgreSQL. The database is $1\text{ TB}$ in size and requires high availability with automatic failover to support regulatory compliance. The database storage must support a constant baseline performance of $6,000\text{ IOPS}$ . The company wants to minimize costs while meeting all performance and compliance requirements.

Which database storage and availability configuration is the most cost-effective solution?

Deploy the database on Amazon RDS for PostgreSQL in a Multi-AZ configuration using gp3 storage with $6,000\text{ IOPS}$ of provisioned performance.Cevap
B
Deploy the database on Amazon RDS for PostgreSQL in a Single-AZ configuration using gp3 storage with $6,000\text{ IOPS}$ , and create a Read Replica in a different Availability Zone to serve as the automatic failover target.
C
Migrate the database to Amazon DynamoDB in provisioned capacity mode with $6,000\text{ Write Capacity Units (WCUs)}$ and $6,000\text{ Read Capacity Units (RCUs)}$ to handle the required I/O throughput.
D
Deploy the database on Amazon RDS for PostgreSQL in a Multi-AZ configuration using gp3 storage, export daily transaction logs to Amazon S3 Standard-Infrequent Access (S3 Standard-IA), and delete the S3 objects after $7\text{ days}$ to minimize storage costs.

Cevap

Deploy the database on Amazon RDS for PostgreSQL in a Multi-AZ configuration using gp3 storage with 6,000 IOPS of provisioned performance.

The correct option is the one proposing Multi-AZ with gp3 storage. Amazon RDS gp3 storage allows users to provision IOPS and throughput independently of storage capacity. For a database requiring

6,000\text{ IOPS}

and

1\text{ TB}

of storage, gp3 is the most cost-effective storage type because the baseline is

3,000\text{ IOPS}

and the additional

3,000\text{ IOPS}

can be provisioned at a low cost without increasing the storage volume size. A Multi-AZ deployment satisfies the high availability and automatic failover requirements.

Adım Adım Çözüm

Analyze storage cost-optimization for

6,000\text{ IOPS}

and

1\text{ TB}

size.

Amazon RDS gp3 storage allows independent provisioning of IOPS up to

6,000\text{ IOPS}

at a low cost. Amazon RDS gp2 requires

2\text{ TB}

of storage to get

6,000\text{ IOPS}

since gp2 gives

3\text{ IOPS/GB}

. Thus, gp3 is the most cost-effective storage type.

Choosing the correct storage type ensures that the database receives the required I/O performance without paying for unnecessary storage capacity.

Evaluate high availability requirements.

Regulatory compliance requires automatic failover, which is provided by Amazon RDS Multi-AZ deployments using synchronous replication.

Single-AZ deployments with Read Replicas utilize asynchronous replication and do not support automatic failover out of the box.

Identify the most cost-effective option that satisfies both requirements.

The combination of Multi-AZ with gp3 storage and

6,000\text{ IOPS}

meets all requirements at the lowest cost.

This configuration avoids overprovisioning storage or incurring S3 lifecycle penalties.

Anahtar Kavram

Cost-optimized storage and high availability configuration in Amazon RDS.

Tahmini Süre:2m 0s

Soru

Cevap

Adım Adım Çözüm

Anahtar Kavram

Sık Yapılan Hatalar

Konular