What role does the Instance Fleet configuration play in cost optimization?
General/Otherhard
2
What types of instance types would you choose for cost efficiency?
General/Othereasy
3
How would you configure workload management (WLM) queues for heavy queries?
Python/Codingeasy
4
How would you decide between using DISTKEY and SORTKEY?
Python/Codingmedium
5
Compare Glue partition discovery with Hive MSCK/ADD PARTITION. Explain the operational and cost implications of crawler-based vs. partition-projection approaches. When does partition projection become necessary, and what are its limitations?
SQLmedium
6
Explain how you would optimize Redshift query performance for a reporting system with large fact tables.
SQLmedium
7
Explain the differences between table re-creation and ALTER TABLE operations.
SQLmedium
8
Explain the use of Amazon Athena for serverless querying.
SQLhard
+20 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.