Question 109:
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 are the below best practices that can be enabled to improve query performance, overall costs and security? Select 5 options.
Answer options:
A.Break large files into many smaller files, Typically of file size of 64 MB or larger B.Group smaller files into a single large file. Typically of file size of 512 MB or larger C.Store files for a table in the same folder D.Store files for a table into different sub-folders E.Keep all the files about the same size. If some files are much larger than others, Redshift Spectrum can`t distribute the workload evenly F.To reduce storage space, improve performance, and minimize costs, compress data files into gzip, snappy or bzip2 G.Use Server-side encryption (SSE-S3) using an AES-256 encryption key, managed by Amazon S3 or keys managed by AWS Key Management Service (SSE-KMS). H. Use S3 client side encryption