You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? 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/azure-sql/database/monitoring-with-dmvs

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in
the following table.

You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the
following requirements:
* The first six numerals of each customer's phone number must be masked.
* The last four digits of each customer's phone number must be visible.
* Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer
area.
Hot Area:

Correct Answer:

Section: [none]
Explanation:
Box 1: 0
Custom String : Masking method that exposes the first and last letters and adds a custom padding string in
the middle. prefix,[padding],suffix
Box 2: xxx-xxx
Box 3: 5
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as 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.
Hot Area:

Correct Answer:

Section: [none]
Explanation:
Box 1: Yes
We see: Tuning option: Create index ON
CREATE INDEX - Identifies indexes that may improve performance of your workload, creates indexes, and
automatically verifies that performance of queries has improved.
Box 2: No
Box 3: Yes
FORCE LAST GOOD PLAN (automatic plan correction) - Identifies Azure SQL queries using an execution plan
that is slower than the previous good plan, and queries using the last known good plan instead of the regressed
plan.

Comment: *

Name: *

Email: *

Verification: *

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.
You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.
You need to configure VNET1 to support the migration.
What should you do?

• A.Configure service endpoints.
• B.Configure virtual network peering.
• C.Deploy an Azure firewall.
• D.Configure network security groups (NSGs).

Comment: *

Name: *

Email: *

Verification: *

You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.
Which Azure Storage functionality should you include in the solution?

• A.time-based retention
• B.change feed
• C.lifecycle management
• D.soft delete

Comment: *

Name: *

Email: *

Verification: *