DP-300 Exam Question 41

You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order.
You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 42

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:
* Minimize costs.
* Aggregate Intelligent Insights telemetry from each database.
What should you do?
  • DP-300 Exam Question 43

    Which counter should you monitor for real-time processing to meet the technical requirements?
  • DP-300 Exam Question 44

    You have SQL Server on an Azure virtual machine that contains a database named DB1.
    You view a plan summary that showsthe durationin milliseconds of each execution of query 1178902 as shown in the following exhibit:

    What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
  • DP-300 Exam Question 45

    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.