Question 39:
Parson Fortunes Ltd is an Asian-based department store operator with an extensive network of 131 stores, spanning approximately 4.1 million square meters of retail space across cities in India, China, Vietnam, Indonesia and Myanmar. Parson built a VPC to host their entire enterprise infrastructure on cloud. Parson has large assets of data around 20 TB’s of structured data and 45 TB of unstructured data and is planning to host their data warehouse on AWS and unstructured data storage on S3. The files sent from their on premise data center are also hosted into S3 buckets. Parson IT team is well aware of the scalability, performance of AWS services capabilities. Parson hosts their web applications, databases and the data warehouse built on Redshift in VPC The structured, semi-structured and unstructured formats are stored in S3 in various buckets. This data be joined and queried along with data in Redshift using Redshift Spectrum. Also Parson Fortunes use other AWS services like Athena, and EMR. How can this data be accessed through Redshift Spectrum? Select 3 options.
Answer options:
A.Redshift Spectrum accesses external databases in Athena and EMR using external schema and external tables B.Amazon Redshift external schema references an external database in an external data catalog C.Amazon Redshift external schema references an external database in an internal data catalog D.For external schemas, Amazon Redshift needs authorization to access the data catalog in Athena and the data files in Amazon S3 using IAM Roles and policies E.For external schemas, Amazon Redshift needs authorization to access the data catalog in Athena, but not the data files in Amazon S3 using IAM Roles and policies