FEFreeExamDumps.in

DP-300 Practice Questions — Page 30

Question 291

Open question ↗

You are evaluating the role assignments.

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:

Question 291

Question 292

Open question ↗

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

  • A.dynamic data masking
  • B.Conditional Access in Azure
  • C.service principals
  • D.row-level security (RLS)

Question 293

Open question ↗

You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements.

How should you collect and stream metrics? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Question 293

Question 294

Open question ↗

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

  • A.Business Critical 4-vCore
  • B.Hyperscale
  • C.General Purpose v-vCore
  • D.Serverless

Question 295

Open question ↗

Which counter should you monitor for real-time processing to meet the technical requirements?

  • A.SU% Utilization
  • B.CPU% utilization
  • C.Concurrent users
  • D.Data Conversion Errors

Question 296

Open question ↗

You need to identify the cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

  • A.sys.dm_pdw_nodes_tran_locks
  • B.sys.dm_exec_compute_node_errors
  • C.sys.dm_exec_requests ✓
  • D.sys.dm_cdc_errors
  • E.sys.dm_pdw_nodes_os_wait_stats
  • F.sys.dm_tran_locks ✓