Q 1. You have been given a CSV file that gets updated frequently. You have to move data from this CSV file to Redshift as and when a new entry is encountered. You have created an event in s3 to invoke a Lambda function whenever a PUT operation takes place. This Lambda function runs a Glue job which is responsible for shifting the data. When you put some data in s3, you are not able to see any addition in the Redshift table. Which command can help you to view in redshift to see what did the glue job exactly do?
You have a data warehouse maintained at AWS Redshift. The data volume and velocity both have increased lately. One option is to keep scaling the cluster horizontally at the expanse of a higher cost of course. Which of the following archiving options are available for you to query the entire data as usual (maybe with a compromise in the querying time) but with a low or no additional cost?
Note: There can be multiple correct answers to this question.
Q 3. Your client wanted you to integrate the cloudwatch with the Amazon Redshift. You told him that currently Cloudwatch is not supported by Redshift. Meanwhile, there is a third party software which can serve the purpose. Which third party software serve this purpose and which API will use to push Redshift matrics?