FEFreeExamDumps.in

DP-800 Practice Questions — Page 4

Question 31

Open question ↗

An application calls external AI services from a SQL solution. Secrets must not be embedded directly in source code or scripts.

Which design should you recommend?

  • A.Use a secure secret-management and identity-based access approach.
  • B.Store the secret in a comment inside the deployment script.
  • C.Send the secret in every prompt.
  • D.Avoid rotating the secret.

Question 32

Open question ↗

An application calls external AI services from a SQL solution. Secrets must not be embedded directly in source code or scripts.

Which design should you recommend?

  • A.Use a secure secret-management and identity-based access approach.
  • B.Store the secret in a comment inside the deployment script.
  • C.Send the secret in every prompt.
  • D.Avoid rotating the secret.

Question 33

Open question ↗

Regional sales managers must query only the customers assigned to their territory. The restriction must be enforced inside the database so that all tools and applications follow the same rule.

Which feature should you recommend?

  • A.Dynamic data masking
  • B.Row-level security
  • C.Transparent data encryption
  • D.An index rebuild policy

Question 34

Open question ↗

Support analysts need to view customer records, but full credit card values must be hidden unless the user belongs to a privileged role.

Which two features are most appropriate? Each correct answer presents part of the solution.

  • A.Dynamic data masking
  • B.Role-based permissions
  • C.Auto-grow data files
  • D.Temporary tables

Question 35

Open question ↗

A mixed workload database needs predictable latency and the current service tier is undersized.

Which action should you recommend?

  • A.Review the service objective and align capacity with workload characteristics.
  • B.Disable all monitoring.
  • C.Increase retry counts without measuring anything.
  • D.Move the workload to email attachments.

Question 36

Open question ↗

A reporting query performs many key lookups and scans after a schema change.

Which action should you recommend first?

  • A.Review the execution plan and identify missing or inefficient access paths.
  • B.Drop the database and recreate it.
  • C.Delete statistics permanently.
  • D.Force every query to run serially without analysis.

Question 37

Open question ↗

A reporting query performs many key lookups and scans after a schema change.

Which action should you recommend first?

  • A.Review the execution plan and identify missing or inefficient access paths.
  • B.Drop the database and recreate it.
  • C.Delete statistics permanently.
  • D.Force every query to run serially without analysis.

Question 38

Open question ↗

After a deployment, a query that used to finish in two seconds now takes over two minutes. You need to identify the regression and, if necessary, stabilize performance quickly.

Which feature should you use first?

  • A.Query Store
  • B.Database mail
  • C.JSON_VALUE
  • D.A DDL trigger

Question 39

Open question ↗

An OLTP database experiences intermittent deadlocks during order checkout. The deadlocks involve updates to inventory and payment tables.

Which action should you recommend?

  • A.Ignore the issue because deadlocks resolve automatically.
  • B.Review deadlock graphs and align transaction access order across code paths.
  • C.Remove all indexes from the affected tables.
  • D.Increase MAXDOP to 64.

Question 40

Open question ↗

Peak-load diagnostics require correlation of waits, CPU pressure, and I/O trends.

Which toolset should you use?

  • A.Dynamic management views
  • B.Markdown files only
  • C.A temp table with no queries
  • D.Manual stopwatch timing