1. A company is migrating a large on-premises Oracle data warehouse (approximately 80 TB) to AWS for analytics modernization. They want to re-platform to a fully managed AWS service optimized for complex analytical queries across large datasets, and they want to minimize ongoing administrative effort. Which combination of AWS services represents the BEST migration and target architecture approach? (Select TWO)
- A. Use AWS Database Migration Service (DMS) to migrate the data
- B. Use AWS Snowball Edge to physically transfer the 80 TB dataset to AWS✓ Correct
- C. Load the migrated data into Amazon RDS for Oracle as the target analytics database
- D. Load the migrated data into Amazon Redshift as the target analytics database✓ Correct
- E. Use Amazon SageMaker to store and query the migrated data warehouse
- F. Use Amazon DynamoDB as the target analytics database
Explanation
AWS Snowball Edge is correct for the data transfer. At 80 TB, transferring data over the internet or Direct Connect would take an extremely long time and incur high data transfer costs. Snowball Edge is a physical device that AWS ships to the customer; data is loaded locally and shipped back to AWS for high-speed ingestion — the ideal approach for large-scale, one-time migrations. Amazon Redshift is correct as the target platform. It is AWS's fully managed, petabyte-scale cloud data warehouse specifically optimized for OLAP (complex analytical queries) with columnar storage and massively parallel processing (MPP) — the direct modern replacement for an on-premises Oracle data warehouse. AWS DMS is a strong tool for ongoing, incremental data replication and schema conversion but for an 80 TB initial bulk load, Snowball Edge is far more practical and efficient; DMS alone would be very slow at this scale. Amazon RDS for Oracle is a managed relational database service but is designed for OLTP workloads, not data warehousing — it would not provide the analytical query performance of Redshift and still uses an Oracle license cost. Amazon SageMaker is a machine learning platform for building and deploying ML models — it is not a data warehouse or general analytics query engine. Amazon DynamoDB is a NoSQL key-value and document database optimized for millisecond-latency OLTP workloads, not for complex multi-table analytical queries typical of a data warehouse.