- What is the purpose of using AWS Redshift database ?
- What are the advantages of AWS Redshift database over an On-premise data warehouse solution ?
- What is Redshift Spectrum ?
- What are the roles of leader node and compute node ?
- What is a sort key ?
- How do you choose a Sort Key for a table ?
- How do you change a sort key ?
- What are the various distribution styles and How do you choose the distribution style ?
- How do you change the distribution style of a table ?
- What is vacuuming ? How do you vacuum a table ?
- How frequently do you vacuum the redshift tables ?
- What are the various types of vacuuming in Redshift ?
- How do you cancel a running query in Redshift ?
- What system views do you use in your day-to-day work ?
- How do you disable a user account in Redshift (User is no longer with the organization) ?
- How do you copy tables from one Redshift cluster to another ?
- What is the purpose of analyzing tables in Redshift ?
- How frequently do you analyze the tables?
- What is a materialized view ?
- What are the various ways of refreshing a materialized view ?