Examkin

Question

Difficulty: MediumDatabase and Storage Strategy

A media company is designing a new platform to store user-uploaded video files and track viewing metadata. The platform requires:
- Storage for video files (averaging 20 MB each) with 99.999999999% durability, replicated to a secondary AWS region with an RTO of 10 minutes and an RPO of 1 minute.
- A metadata database that supports millisecond query latency, has a flexible schema, and replicates across regions to support global low-latency reads.
- Data encryption at rest using AWS KMS Customer Managed Keys that can be shared with a centralized auditing account in another AWS account.

Which two database and storage design choices should the solutions architect select to meet these requirements?

  1. Use Amazon S3 with Cross-Region Replication (CRR) configured to replicate video files to the secondary region, encrypting the buckets using Customer Managed KMS Keys (CMKs) in each region.Answer
  2. Use Amazon DynamoDB global tables to store viewing metadata, enabling replication across the primary and secondary regions to provide active-active reads and schema flexibility.Answer
  3. C
    Use Amazon Aurora Global Database with a Multi-AZ cluster for viewing metadata, routing read traffic in the secondary region directly to an RDS Multi-AZ standby instance to reduce read latency.
  4. D
    Use Amazon Aurora PostgreSQL in the primary region for viewing metadata and implement a pilot light disaster recovery strategy, keeping the database in the secondary region shut down until a failover is needed.
  5. E
    Use Amazon S3 with Cross-Region Replication (CRR) enabled for video files, encrypting the objects with the default AWS-managed KMS key (aws/s3) to simplify key sharing across accounts.

Answer

The correct choices are using Amazon S3 with Cross-Region Replication and Customer Managed KMS Keys for video storage, and using Amazon DynamoDB global tables for viewing metadata.
The correct choices are using Amazon S3 with Cross-Region Replication and Customer Managed KMS Keys for video storage, and using Amazon DynamoDB global tables for viewing metadata. S3 provides high durability and CRR supports cross-region replication with low RTO/RPO. Using Customer Managed Keys allows modifying the key policy for cross-account access. DynamoDB global tables provide a schema-flexible, low-latency, multi-region metadata store that scales horizontally.

Step-by-Step Solution

1
Analyze storage requirements for video files and metadata.
Identify that video files require durable object storage (Amazon S3) with replication, and metadata requires low latency, schema flexibility (DynamoDB).
To choose appropriate storage and database services that match the workload characteristics.
2
Evaluate disaster recovery (RTO/RPO) and security (cross-account encryption) constraints.
Determine that Customer Managed KMS Keys are needed for cross-account sharing, and active-active replica configurations like DynamoDB global tables and S3 CRR are needed for meeting RTO/RPO.
To filter out options using AWS-managed KMS keys (which can't be shared cross-account) or pilot light/offline recovery strategies (which fail RTO/RPO).

Key Concept

Selecting appropriate database and storage services based on workload patterns, performance, high availability, and cross-account encryption requirements.
Rate this question

Topics

Database and Storage Strategy

More questions from this topic