DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ89

VerifiedSecure, optimize, and deploy database solutions

A development team uses Microsoft Visual Studio Code with the MSSQL extension and the GitHub Copilot Chat extension.

The team connects to an Azure SQL database by using individual database logins and uses the @mssql chat participant to generate and run Transact-SQL queries from prompts.

What is used to make sure GitHub Copilot Chat-generated queries run in the developer's context?

Explanation

Individual database logins establish each developer’s database identity. Azure SQL authorizes data access and actions through that user’s database role memberships and explicit object-level permissions, so queries generated by GitHub Copilot Chat run with the permissions of the connected developer rather than with GitHub, Azure resource-management, or instruction-file permissions.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!