You add a .NET application to a Docker container and deploy the container to Azure Service Fabric. You use a corporate base image that includes Microsoft SQL
Server for storing data.
You deploy the application to development and staging environments. No issues are reported. You deploy the application to your production environment. Data is not persisted in the production environment.
You need to resolve the issue.
What should you do?
A. Install Docker tools in the container.
B. In the docker-compose.override.yml file, configure the db service to start before the web application.
C. Update the connection string in the web.config file to point to the SQL Server database in the container.
D. Remove SQL Server from the base image and convert the database to Azure SQL Database.
By the reference content of “When running the Fabrikam Fiber CallCenter application in production, the data needs to be persisted in a database. There is currently no way to guarantee persistent data in a container, therefore you cannot store production data in SQL Server in a container.”
I consider D is the correct answer.