You manage an on-premises Microsoft SQL server that has a database named DB1.

User report that a query takes a long time to execute. The query has the following wait statistics.

You have an on-premises Microsoft SQL server that has a database named DB1. DB1 contains several tables that are stretched to Microsoft Azure.

You plan to deploy Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine will have a 30-TB database and will have 10 1-TB VHDs for the database.

You have a database named DB1 that contains a table named Table1. Table1 has 1 billion rows.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique sol…

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question…

Note: This question is part of a series of questions…

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might h…

Note: This question is part of a series of questions that present the same scenario. Each…