Have you failed a job interview?
Send us your job interview questions and get correct answers.
You have multiple SQL databases with varying usage patterns. You need to host them and allow the compute resources allocated to the database to scale dynamically. The solution needs to meet an SLA of 99.99% uptime and have reserved capacity. How would you solve the requirements?
Experience Level: Senior
Tags: Azure CloudAzure SQL Database
Answer
Use Azure elastic pool.
Related Azure Cloud job interview questions
You deciding between storing diagnostic data to Log Analytics Workspace or Azure Storage. What could be the factors that will affect the decision?
Azure CloudAzure Log Analytics WorkspaceAzure Storage SeniorYou need to use transactions between multiple SQL databases. What database option will you use to support the transactions?
Azure CloudAzure SQL DatabaseAzure Virtual Machines SeniorHow do you configure host caching for data disk and log disk for your VM that hosts SQL Server in Azure?
Azure CloudAzure SQL DatabaseAzure Virtual Machines SeniorWhat is Azure Data Factory self-hosted integration runtime?
Azure CloudAzure Data Factory SeniorWhat is Azure Data Factory (ADF)?
Azure CloudAzure Data Factory Senior
