Examkin

Soru

Zorluk: OrtaAWS Database Services

A retail company is building a business intelligence platform to analyze customer purchasing patterns over the last five years. The system must perform complex, multi-table analytical queries on massive volumes of aggregated transactional data to generate weekly reports. Which AWS database service is specifically designed to support this type of online analytical processing (OLAP) workload?

  1. A
    Amazon DynamoDB
  2. B
    Amazon ElastiCache
  3. Amazon RedshiftCevap
  4. D
    Amazon EC2 with a self-installed database

Cevap

Amazon Redshift
Amazon Redshift is a fully managed, petabyte-scale data warehouse service designed specifically for complex analytical and business intelligence workloads. It uses columnar storage and massive parallel processing (MPP) to query large datasets efficiently.

Adım Adım Çözüm

1
Analyze the workload requirements: the system needs to perform complex, multi-table analytical queries on massive volumes of historical sales data.
Identified the workload as Online Analytical Processing (OLAP) rather than Online Transactional Processing (OLTP).
This helps narrow down the database service type to data warehousing solutions.
2
Evaluate the capabilities of the database options against the OLAP requirements.
Determined that Amazon Redshift is the optimized, fully managed AWS data warehouse designed specifically for OLAP.
Amazon DynamoDB is NoSQL, Amazon ElastiCache is for caching, and Amazon EC2 is a self-managed virtual machine, leaving Amazon Redshift as the correct fit.

Anahtar Kavram

AWS Database Services
Bu soruyu puanla

Konular

AWS Database Services

Bu konudan daha fazla soru