Question 174:
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 understand the design best practices from MindPyramid team. Please suggest the best practices in terms of designing tables. select 2 options.
Answer options:
A.choose the optimal sort key to address querying of most recent data, frequent range filtering or equality filtering and joining of multiple tables B.Define constraints to ensure uniqueness, primary-key, and foreign-key constraints. C.understand and define compression encoding techniques manually D.Define best distribution key to distribute the fact table and one dimension table on their common columns, large dimensions with high cardinality in the filtered result set and handle uniform distribution for small dimension tables E.use the maximum column size for convenience of design of large tables F.varchar and char store data more efficiently than the date data types. Use char and varchar more frequently G.Splitting of the data that is being loaded into multiple files