Hotspot Question
You have an Azure subscription that contains an Azure SQL database named DB1.
You have the Query Performance Insight analysis shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: No
In the exhibit we see: TOP 5 queries by CPU, Metrics aggregation: AVG
The graphic display average query CPU usage, not the peak DTU consumption.
Box 2: Yes
This is the red line.
Box 3: No
It is the average runtime.
Note: The bottom grid shows aggregated information for the visible queries:
Query ID, which is a unique identifier for the query in the database.
CPU per query during an observable interval, which depends on the aggregation function.
*-> Duration per query, which also depends on the aggregation function.
Total number of executions for a specific query.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use

Comment: *

Name: *

Email: *

Verification: *

You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak.
You plan to deploy an Always On availability group that will have the following configurations:
VM1 will host the primary replica of DB1.
VM2 will host a secondary replica of DB1.
You need to prepare the secondary database on VM2 for the availability group.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server?view=sql-server-ver15

Comment: *

Name: *

Email: *

Verification: *

You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named DB1.
A user named User 1 has an Azure AD account.
You need to provide User1 with the ability to add and remove columns from the tables inDBV The solution must use the principle of least privilege.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point

• A.Create a login and an associated database user.
• B.Create a contained database user.
• C.Assign the database user the db.ddladmm role.
• D.Assign the database user the db.owner role.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named DB1 in the General Purpose service tier.
The performance metrics for DB1 are shown in the following exhibit.

You need to reduce the Log 10 percentage. The solution must minimize costs.
What should you do?

• A.Change Service tier to Business Critical.
• B.Increase the number of vCores.
• C.B. Change Recovery model to Simple.
• D.Perform a checkpoint operation.

Comment: *

Name: *

Email: *

Verification: *