You are building an Azure virtual machine.
You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS.
You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS.
You need to configure storage for the virtual machine to support the database.
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.

Correct Answer:

1 - a storage pool
2 - a virtual disk that uses stripe layout
3 - a volume
Reference:
https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases.
The databases perform slower than expected.
You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1.
What should you do?

• A.Run Query Store-based queries
• B.Review information provided by SQL Server Profiler-based traces
• C.Review information provided by Query Performance Insight
• D.Run dynamic management view-based queries

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.

FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?

• A.page compression
• B.row compression
• C.columnstore compression
• D.columnstore archival compression

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently.
You enable columnstore archival compression.
What are two possible results of the configuration? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.Queries that use the index will consume more disk I/O.
• B.Queries that use the index will retrieve fewer data pages.
• C.The index will consume more disk space.
• D.The index will consume more memory.
• E.Queries that use the index will consume more CPU resources.

Comment: *

Name: *

Email: *

Verification: *

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.
Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.
You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.
What should you include in the recommendation?

• A.Azure Backup
• B.Azure Information Protection
• C.Windows Server Failover Cluster
• D.Azure Site Recovery

Comment: *

Name: *

Email: *

Verification: *