What should you do?

You have an Azure SQL database named sqldb1.

You need to minimize the possibility of Query Store transitioning to a read-only state.

What should you do?
A . Halve the value of Data Flush Interval.
B . Double the value of Statistics Collection Interval.
C . Halve the value of Statistics Collection Interval.
D . Double the value of Data Flush Interval.

View Answer

Answer: B

Explanation:

Follow these same steps to create striped virtual disk:

✑ Create Log Storage Pool.

✑ Create Virtual Disk

✑ Create Volume

Box 1: a storage pool

Box 2: a virtual disk that uses stripe layout

Disk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks.

Box 3: a volume

Reference: https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/