FEFreeExamDumps.in

DP-800 Practice Questions — Page 3

Question 21

Open question ↗

You need to calculate a rolling 30-day sales average per region and also rank the top-selling products within each region. The query must remain set-based and readable.

Which approach should you recommend?

  • A.Use a cursor to iterate through each region and product.
  • B.Use window functions with PARTITION BY and ORDER BY.
  • C.Export the data to CSV and calculate the rankings in Excel.
  • D.Create a trigger that writes aggregate rows during every insert.

Question 22

Open question ↗

A database engineering team wants an AI assistant to suggest T-SQL refactorings based on live schema metadata from SQL Server and Fabric. The solution must avoid broad, unrestricted direct database access.

Which implementation should you recommend?

  • A.Connect the assistant to MCP endpoints that expose only the required context.
  • B.Grant sysadmin access so the assistant can inspect every object directly.
  • C.Disable schema validation to reduce prompt size.
  • D.Store all schema metadata in screenshots and ask the assistant to infer the model visually.

Question 23

Open question ↗

A team wants Copilot to propose schema changes, but governance requires every suggestion to reference the current naming standards and deployment rules.

Which prompt strategy should you recommend?

  • A.Include repository conventions, schema patterns, and review criteria in the prompt context.
  • B.Use one-word prompts only.
  • C.Paste production secrets for better suggestions.
  • D.Skip all review notes.

Question 24

Open question ↗

A team wants Copilot to propose schema changes, but governance requires every suggestion to reference the current naming standards and deployment rules.

Which prompt strategy should you recommend?

  • A.Include repository conventions, schema patterns, and review criteria in the prompt context.
  • B.Use one-word prompts only.
  • C.Paste production secrets for better suggestions.
  • D.Skip all review notes.

Question 25

Open question ↗

AI-generated T-SQL migration scripts must be reviewed before release. The team needs a repeatable review workflow.

Which process should you recommend?

  • A.Require peer review and validation in the standard SQL project pipeline.
  • B.Auto-apply all generated scripts in production.
  • C.Ignore differences between environments.
  • D.Use screenshots instead of source control.

Question 26

Open question ↗

AI-generated T-SQL migration scripts must be reviewed before release. The team needs a repeatable review workflow.

Which process should you recommend?

  • A.Require peer review and validation in the standard SQL project pipeline.
  • B.Auto-apply all generated scripts in production.
  • C.Ignore differences between environments.
  • D.Use screenshots instead of source control.

Question 27

Open question ↗

Your team uses GitHub Copilot and SQL Database Projects to maintain schema scripts. Security requires that prompts avoid production secrets, while reviewers still need enough context to validate AI-generated migrations.

Which two actions should you recommend? Each correct answer presents part of the solution.

  • A.Provide schema context, naming standards, and sample non-sensitive structures in prompts.
  • B.Paste connection strings and production credentials into prompts to improve accuracy.
  • C.Require human review before applying AI-generated migration scripts.
  • D.Allow direct execution of generated code in production to shorten release cycles.

Question 28

Open question ↗

A REST endpoint exposes product data from SQL. Only approved fields should be returned to external consumers.

Which action should you recommend?

  • A.Publish only approved entities and fields.
  • B.Expose every column and trust the client to ignore sensitive values.
  • C.Return all rows and columns, then filter visually.
  • D.Disable authentication for read operations.

Question 29

Open question ↗

A compliance team requires proof that data access and schema changes are recorded for later investigation.

Which feature should you recommend?

  • A.Database auditing
  • B.A color-coded dashboard
  • C.A temporary table
  • D.A nonclustered index

Question 30

Open question ↗

A compliance team requires proof that data access and schema changes are recorded for later investigation.

Which feature should you recommend?

  • A.Database auditing
  • B.A color-coded dashboard
  • C.A temporary table
  • D.A nonclustered index