- (Exam Topic 5)
You have an Azure SQL database named D61.
You need to identify how much unused space in megabytes was allocated to DB1.
How should you complete the Transact-SQL query? To answer select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You have SQL Server on an Azure virtual machine.
You need to add a 4-TB volume that meets the following requirements:
Maximizes IOPs
Uses premium solid state drives (SSDs)
What should you do?

1. A. Attach two mirrored 4-TB SSDs.
2. B. Attach a stripe set that contains four 1-TB SSDs.
3. C. Attach a RAID-5 array that contains five 1-TB SSDs.
4. D. Attach a single 4-TB SSD.

Correct Answer: B
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?tabs=window

- (Exam Topic 5)
You have an instance of SQL Server on Azure Virtual Machine named SQL1.
You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort.
Where should you store the metrics?

1. A. a Log Analytics workspace
2. B. Azure Event Hubs
3. C. Azure SQL Database
4. D. an Azure Blob storage container

Correct Answer: A

- (Exam Topic 5)
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?

1. A. Azure Backup
2. B. Azure Information Protection
3. C. Windows Server Failover Cluster
4. D. Azure Site Recovery

Correct Answer: D
Reference:
https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-test-failover-to-azure

- (Exam Topic 5)
You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2. You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution.
NOTE:Each correct selection is worth one point.

1. A. Enable query optimizer fixes.
2. B. Enable Resource Governor.
3. C. Enable parameter sniffing.
4. D. Create a workload group.
5. E. Configure In-memory OLTP.
6. F. Run the Database Engine Tuning Advisor.
7. G. Reduce the Max Degree of Parallelism value.

Correct Answer: BD
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server