1.
Your company’s branch offices are all over the world, they use a software with a multi-regional deployment on AWS, they use MySQL 5.6 for data persistence. The task is to run an hourly batch process and read data from every region to compute cross-regional reports which will be distributed to all the branches. This should be done in the shortest time possible. How will you build the DB architecture in order to meet the requirements?
2.
You have a distributed application that periodically computes large calculations across mulitple EC2 instances. The application is also designed to recover gracefully from instance failure. Which of the following would be cost-effective yet not affecting the jobs
3.
A startup is running a pilot deployment of around 100 sensors to measure street noise and air quality in urban areas for 3 months. It was noted that every month around 4GB of sensor data is generated. The company uses a load balanced auto scaled layer of EC2 instances and a RDS database with 500 GB standard storage. The pilot was a success and now they want to deploy at least 100K sensors which need to be supported by the backend. You need to store the data for at least 2 years to analyze it. Which setup of the following would you prefer?
4.
You are required to setup a database in AWS, which will require frequent and granular updates. You will require a specific amount of storage. Which of these is the recommended storage option when you run a database on an instance that will require frequent and granular updates?
5.
A customer implemented AWS Storage Gateway with a gateway-cached volume at their main office. An event takes the link between the main and branch office offline. Which methods will enable the branch office to access their data?
6.
In VPCs with private and public subnets, database servers should ideally be launched into:
7.
Amazon Redshift is built on upon which database
8.
Which of the following operators cannot be overloaded?
9.
You are required to deploy a relational database service by spending the least amount of time possible in administering it. Which of these will meet this requirement?
10.
You are required to import an existing infrastructure from a dedicated hosting provider to AWS. The process that manages the following also needs to be automated:

  • Manages backups
  • Software patching
  • Automatic failure detection and recovery
The existing setup uses an Oracle database.
Which of these AWS databases will you use?