Question 170:
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. What kind of below features supported by Redshift Spectrum? select 2 options.
Answer options:
A.Query the data in its original format directly from Amazon S3 in same region B.Redshift Spectrum supports the following structured and semi-structured data formats like AVRO, PARQUET, TEXTFILE, SEQUENCEFILE, RCFILE, others C.Redshift Spectrum supports only CSV and TXT formats D.Files in S3 cannot have compression for Redshift Spectrum to access the data