Question 1
IntermediateAccelerate Workload Migration and Modernization · Determine a new architecture for existing workloads
A financial services company is modernizing its on-premises data warehouse to AWS. The current system uses a legacy ETL tool that is not cloud-native. The company wants to build a new data lake on Amazon S3 and use a combination of serverless and managed services for ingestion, processing, and analytics. A key requirement is to provide business analysts with a unified SQL interface to query both structured data in Amazon Redshift and semi-structured data (JSON, Parquet) in the data lake. The solution must enforce fine-grained access control at the table and column level for all queries. Which solution meets these requirements most effectively?
Answer and explanation
Correct answer: B
This is the optimal solution. Amazon Redshift Spectrum allows querying data in Amazon S3 directly from Redshift, providing a unified SQL interface. AWS Lake Formation provides a centralized way to manage fine-grained permissions (table, column, row-level) for data in both the S3 data lake (via the AWS Glue Data Catalog) and Amazon Redshift. This approach meets all requirements for a unified interface and granular access control with managed services.
