How do you build a predictive Data model for Redshift?
AWS included recently another service for Machine Learning. Amazon ML is incorporating with Redshift. You can build predictive models taking the account data from Redshift, by just giving a SQL question that is pulling the data expected to prepare the model, and Amazon ML will assemble a model that you can utilize both for batch prediction and additionally for real time predictions.
In AWS Cloud, How to login to EC2 instance if one loses .ppk file or password?
Create an AMI for that particular instance whose key was lost and launch a new instance using that AMI. Create a new key pair for this(download the .pem file and use PuttyGen to create a new .ppk file) and download it and now we can start a new instance and check for that key pair to work and then delete the old instance and continue with the new one. For this we have to make sure the new instance is created in the same availability zone as the original one.