- (Exam Topic 5)
You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:
The web app must be hosted on an Azure virtual network.
The Azure SQL database must be assigned a private IP address.
The Azure SQL database must allow connections only from the virtual network. You need to recommend a solution that meets the requirements.
What should you include in the recommendation?

1. A. Azure Private Link
2. B. a network security group (NSG)
3. C. a database-level firewall
4. D. a server-level firewall

Correct Answer: A
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview

- (Exam Topic 5)
You have an Azure subscription.
You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template.
How should you complete the ARM template? To answer, select the appropriate options in the answer area.
NOTE:Each correct selection is worth one point.

Solution:
Graphical user interface, text, application, Word, email Description automatically generated
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure-powe

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

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

1. A. Halve the value of Data Flush Interval.
2. B. Double the value of Statistics Collection Interval.
3. C. Halve the value of Statistics Collection Interval.
4. D. Double the value of Data Flush Interval.

Correct Answer: A
The Max Size (MB) limit isn't strictly enforced. Storage size is checked only when Query Store writes data to disk. This interval is set by the Data Flush Interval (Minutes) option. If Query Store has breached the
Maximum size limit between storage size checks, it transitions to read-only mode. Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store

- (Exam Topic 5)
You have an Azure SQL database named DBI that contains a nonclustered index named index1. End users report slow queries when they use index1.
You need to identify the operations that are being performed on the index. Which dynamic management view should you use?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: D

- (Exam Topic 5)
You have an Azure SQL Database managed instance. The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.
What should you use?

1. A. the Azure portal
2. B. Extended Events
3. C. Query Store
4. D. dynamic management views

Correct Answer: D
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-qu