Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.
How do you configure host caching for data disk and log disk for your VM that hosts SQL Server in Azure?
Experience Level: Senior
Tags: Azure CloudAzure SQL DatabaseAzure Virtual Machines
Answer
- Log - None.
- Data - ReadOnly.
Disk caching setting recommendation on when to use this setting
- None - Configure host-cache as None for write-only and write-heavy disks.
- ReadOnly - Configure host-cache as ReadOnly for read-only and read-write disks.
- ReadWrite - Configure host-cache as ReadWrite only if your application properly handles writing cached data to persistent disks when needed.
Related Azure Cloud job interview questions
You need to use transactions between multiple SQL databases. What database option will you use to support the transactions?
Azure CloudAzure SQL DatabaseAzure Virtual Machines SeniorYou 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?
Azure CloudAzure SQL Database SeniorWhat is Azure Data Factory self-hosted integration runtime?
Azure CloudAzure Data Factory SeniorWhat is Azure Data Factory (ADF)?
Azure CloudAzure Data Factory SeniorWhat is Azure SQL Managed Instance?
Azure CloudAzure SQL Database Senior
