What is the minimum number of disks required for each database when using P30 storage disk type?

You plan to deploy Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine will have two databases. Each database will reside on a separate VHD and will be between 600 and 800 GB.

Each database will have the I/O requirements shown in the following table.

You are evaluating whether to use the P30 storage disk type.

What is the minimum number of disks required for each database when using P30 storage disk type? (Select two.)
A . DB1: 0
B . DB1: 1
C . DB1:2
D . DB1: 3
E . DB1:4
F . DB2: 0
G . DB2: 1
H . DB221
. DB2: 3
. DB24

View Answer

Answer: CG

Explanation:

P30 stats: Disk size is 1024 GB (1 TB), IOPS per disk is 5000.

Recommendation: Use a minimum of 2 P30 disks (1 for log files and 1 for data files and TempDB; or stripe two or more disks and store all files in a single volume).

References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/premium-storage#scalability-and-performance-targets