Valid DP-800 Dumps shared by EduDump.com for Helping Passing DP-800 Exam! EduDump.com now offer the newest DP-800 exam dumps, the EduDump.com DP-800 exam questions have been updated and answers have been corrected get the newest EduDump.com DP-800 dumps with Test Engine here:
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?
Correct Answer: B
The correct answer is B . Microsoft's SSMS Copilot documentation states that queries from Copilot in SSMS are executed under the context of the user's login and permissions , and that there are no separate permissions for Copilot in SSMS . That means Copilot-run Transact-SQL cannot access more data than the developer's own database principal is already allowed to access. That is why the other options are incorrect: * A is wrong because Copilot does not use a separate read-only sandbox in place of database permissions. * C is wrong because enforcement is not a client-side filtering trick; it is enforced by the database security context of the current login. * D is wrong because Copilot does not apply a different RLS model from the developer; it simply runs under the same login context. So the security boundary is the developer's existing database identity and permissions .
