What is the default behavior of CloudFormation in this scenario?
CloudFormation will roll back the stack and delete the stack.
CloudFormation will roll back the stack but will not delete the stack.
CloudFormation will prompt the user to roll back the stack or continue.
CloudFormation will successfully complete the stack but will report a failed status for the DB instance.
Explanations:
CloudFormation does not automatically delete the stack when a resource creation fails. The default behavior is to roll back the stack.
If a resource creation fails, CloudFormation automatically rolls back the entire stack to its previous state, which may involve deleting successfully created resources like EC2 instances or ELBs.
CloudFormation does not prompt the user to decide whether to roll back or continue. The stack rollback happens automatically on failure.
CloudFormation does not allow the stack to complete successfully if any resource creation fails. The stack will not be marked as complete if there are failures.
I structure that the answer is:
CloudFormation will roll back the stack but will not delete the stack.