You work for MDFT Pro, a well-known training agency planning to deploy a new Azure virtual machine to host a Microsoft SQL Server instance for their student information system. Mark, the Database Infrastructure Architect, is designing the storage configuration to ensure optimal performance for the critical student database. The system processes thousands of student enrollment transactions daily, updates course registrations in real-time, and maintains strict data consistency requirements. Mark needs to configure separate disks for different SQL Server components, with specific focus on minimizing latency for transaction logs to ensure fast commit times and minimizing the impact on the virtual machine’s overall IO throughput. He has asked you to recommend the most appropriate disk type specifically for the transaction logs workload, which is critical for maintaining database ACID properties and recovery capabilities.
Which type of disk should you use for the Transaction Logs workload?
Choose the correct answer from the options below.
Explanations for each answer: