DP-800 Practice Test

DP-800 Practice Test practice questions, page 3 of 3, with answer review and explanations.

Question 11

Your development team uses GitHub Copilot Chat in Microsoft SQL Server Management Studio (SSMS) to generate and run Transact-SQL queries against an Azure SQL database named DB1. DB1 contains tables that store sensitive customer data. You need to ensure that any Transact-SQL queries that run from GitHub Copilot Chat in SSMS are restricted by the same permissions as the developer’s database login. What prevents the GitHub Copilot Chat-run queries from accessing data beyond the developer’s access?

  1. GitHub Copilot Chat runs queries in a read-only sandbox that is isolated from production database permissions.
  2. GitHub Copilot Chat runs queries by using the developer’s database identity and permissions.
  3. GitHub Copilot Chat filters query results on the client side to remove rows the developer is unauthorized to see.
  4. GitHub Copilot Chat uses different row-level security (RLS) policies than the developer.