You plan to deploy a reporting database to Azure. The database will contain 30 GB of dat
a. The amount of data will increase by 300 MB each year.
Rarely will the database be accessed during the second and third weeks of each month. During the first and fourth week of each month, new data will be loaded each night.
You need to recommend a solution for the planned database. The solution must meet the following requirements:
Minimize costs.
Minimize administrative effort.
What should you recommend?
Serverless is a compute tier for single Azure SQL Databases that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview
https://docs.microsoft.com/en-us/azure/hdinsight/
https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale
Currently there are no comments in this discussion, be the first to comment!