Question 61:
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 in their DWH built on Redshift, and wants to understand the design best practices of Redshift from MindPyramid team. Please suggest the best practices in improving the queries. Select 4 options.
Answer options:
A.Use CASE Expression to perform complex aggregations instead of selecting from the same table multiple times B.Avoid using functions in query predicates C.Avoid using predicates to restrict the dataset D.use a WHERE clause to restrict the dataset E.Use sort keys in the GROUP BY clause to improve aggregations F.do not use subqueries in cases where one table in the query is used only for predicate conditions and the subquery returns a minor number of rows