What should be done to ensure that the web tier does not come online before the database is completely configured?

An n-tier application requires a table in an Amazon RDS MySQL DB instance to be dropped and repopulated at each deployment. This process can take several minutes and the web tier cannot come online until the process is complete. Currently, the web tier is configured in an Amazon EC2 Auto Scaling group, with instances being terminated and replaced at each deployment. The MySQL table is populated by running a SQL query through an AWS CodeBuild job.

What should be done to ensure that the web tier does not come online before the database is completely configured?
A . Use Amazon Aurora as a drop-in replacement for RDS MySQ
B . Use snapshots to populate the table with the correct data.
C . Modify the launch configuration of the Auto Scaling group to pause user data execution for 600 seconds, allowing the table to be populated.
D . Use AWS Step Functions to monitor and maintain the state of data population. Mark the database in service before continuing with the deployment.
E . Use an EC2 Auto Scaling lifecycle hook to pause the configuration of the web tier until the table is populated.

View Answer

Answer: D