Question 126:
MindPyramid Limited is a multinational information technology and outsourcing company headquartered in Vizag, India and New Jersey, USA. Founded in 2003, the company employs approximately 2000 employees. The company offers consulting services in cloud computing, big data and analytics. They offer services to major cloud providers including AWS. The team is working with one of the major clients having their infrastructure build on AWS. Currently the client is having lot of performance issues and wants to have a detailed understanding and recommendations. MindPyramid runs Amazon Redshift Advisor to provide recommendations to improve the performance and decrease the operating costs of the Amazon Redshift cluster. Identify the recommendations. select 3 options.
Answer options:
A.Addressing uncompressed storage for a single table is a one-time optimization that requires the table to be rebuilt B.Consider moving each actively queried database to a separate dedicated cluster. Using a separate cluster can reduce resource contention and improve query performance C.Increasing the configured slots to match peak workload requirements redistributes underutilized memory to active slots D.Whenever table content changes significantly, update statistics with VACCUM E.Modify the WLM configuration to disable SQA. Amazon Redshift uses a machine learning algorithm to analyze each eligible query F.Skip compression analysis using COPY