Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.
What is a difference between Azure SQL Database vCore and DTU purchase model?
Experience Level: Senior
Tags: Azure CloudAzure SQL Database
Answer
DTU is a blend of CPU, Memory, Reads and Writes and a database having 5 DTUs will perform 5 times better than another database having just 1 DTU.
vCore feels similar to the on-prem environment. You can choose the number of cores and size of the database. Based upon the cores that you have chosen changes the maximum size of the database that you can have.
Related Azure Cloud job interview questions
You need to recommend a disaster recovery solution for your Azure CosmosDB database that needs to remain available even when the whole region fails. What should you include in the recommendation?
Azure CloudAzure Cosmos DB SeniorYou need to design a backup solution for Azure SQL Database that will store backups that can be restored for up to 5 years. What solution will you recommend?
Azure CloudAzure SQL Database SeniorYou want to use Azure Hybrid Benefit (AHB) for Azure SQL Database. What purchase model can you use it with?
Azure CloudAzure SQL Database SeniorWhat is Azure SQL Database vCore purchase model?
Azure CloudAzure SQL Database SeniorYou use Azure CosmosDB with Table API. You need to make sure that the database will be available even if the whole region fails. How will you solve the requirements?
Azure CloudAzure Cosmos DB Senior