DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ20

Secure, optimize, and deploy database solutions

You have a GitHub Codespaces environment with GitHub Copilot Chat installed that is connected to a Microsoft Fabric SQL database named DB1. DB1 contains tables named Sales.Orders and Sales.Customers.

You use GitHub Copilot Chat in the context of DB1.

A company policy prohibits sharing customer Personally Identifiable Information (PII), secrets, and query result sets with any AI service.

You need to use GitHub Copilot Chat to write and review Transact-SQL code for a new stored procedure that joins Sales.Orders to Sales.Customers and returns customer names and email addresses. The solution must NOT share the actual data in the tables with GitHub Copilot Chat.

What should you do?

Explanation

Using schema details alone supplies the table and column structure needed to draft and review the Transact-SQL procedure without disclosing customer records, PII, credentials, secrets, or query result sets to the AI service.

Community Discussion

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