Examkin

Soru

Zorluk: ZorAWS Database Services

A digital publishing platform requires a database solution to store millions of unstructured user preferences and reading histories. This system needs a flexible schema and must deliver single-digit millisecond latency at scale. Additionally, the platform needs to run complex, resource-intensive daily SQL analytical reports on terabytes of historical reader interaction logs without degrading the performance of the live platform. Which TWO database services should be selected to meet these requirements?

  1. Amazon DynamoDB to store the unstructured user preferences and reading histories with low latencyCevap
  2. Amazon Redshift to run complex analytical queries over large historical datasetsCevap
  3. C
    Amazon RDS for PostgreSQL to store the unstructured user preferences and reading histories
  4. D
    Amazon Aurora to consolidate both the live user preferences and historical analysis into a single database instance
  5. E
    Amazon EC2 with a self-managed database to host the workloads, because AWS automatically applies operating system and database engine patches for EC2

Cevap

The correct database services are Amazon DynamoDB for unstructured, low-latency preferences, and Amazon Redshift for aggregate historical analysis.
Amazon DynamoDB is a fully managed NoSQL key-value database designed to store unstructured user preferences with flexible schemas and provide single-digit millisecond response times at scale. Amazon Redshift is a managed data warehouse optimized for complex SQL queries over massive historical datasets, allowing resource-heavy analysis to run in isolation without impacting live user operations.

Adım Adım Çözüm

1
Analyze the operational data storage requirements.
The application needs to store unstructured user preferences with flexible schemas and single-digit millisecond response times. This points directly to Amazon DynamoDB, which is optimized for high-throughput, low-latency NoSQL data.
Choosing the correct transactional storage tier reduces overhead and ensures performance.
2
Analyze the analytical data reporting requirements.
The system requires complex daily SQL reports on historical reader behavior across terabytes of logs. This points directly to Amazon Redshift, a column-oriented OLAP data warehouse that isolates analytical workloads from primary transactions.
Isolating operational and analytical databases ensures that analytics do not saturate production resources.
3
Evaluate the distractors based on the Shared Responsibility Model and architectural design principles.
Amazon RDS for PostgreSQL is relational and unsuitable for unstructured data with strict low-latency requirements. Consolidating the workloads in Amazon Aurora violates decoupling principles. Using self-managed databases on Amazon EC2 incorrectly assumes AWS manages OS and database updates.
Validating compliance against AWS best practices eliminates incorrect database patterns.

Anahtar Kavram

Selecting and combining purpose-built AWS database services to decouple transactional and analytical workloads, matching schema patterns and low-latency performance requirements.
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

AWS Database Services

Bu konudan daha fazla soru