Design and Implement SQL Solutions by Using AI-assisted Tools DP-800 Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A developer is using GitHub Copilot in Fabric to write SQL queries that access a production database. The developer notices that Copilot sometimes suggests queries that include sensitive column names. What is the best practice to reduce this risk?

   • AAsk the admin to enable the Microsoft Copilot tenant setting for additional security.
   • BDisable the MCP server connection to the production database.
   • CAvoid using production data in the development environment and use masked or synthetic data instead.
   • DUse a copilot-instructions.md file to instruct Copilot to avoid sensitive column names.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the purpose of enabling GitHub Copilot in Microsoft Fabric?

   • ATo automate the deployment of SQL databases
   • BTo replace the need for a SQL developer
   • CTo provide AI-assisted code suggestions and completions for SQL development
   • DTo manage user permissions for SQL databases
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A large enterprise uses Microsoft Fabric and has enabled GitHub Copilot for all developers. The security team requires that AI-generated SQL must not include table names from a specific sensitive schema. The development team wants to enforce this across all repositories. What is the most effective approach?

   • AAsk developers to manually avoid the schema in their prompts.
   • BEnable the Microsoft Copilot tenant setting to add a security policy.
   • CCreate a copilot-instructions.md file in each repository that explicitly forbids the sensitive schema.
   • DConfigure a global MCP server that filters out sensitive schema names.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the primary function of Microsoft Copilot in Fabric for SQL developers?

   • AIt enforces data governance policies.
   • BIt manages database backups and recovery.
   • CIt provides natural language assistance to generate and explain SQL code.
   • DIt automatically tunes query performance.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A developer is using GitHub Copilot in Fabric to generate T-SQL code for a data warehouse. The developer wants the AI to focus on performance optimization and avoid suggesting deprecated functions. The team has a repository with a copilot-instructions.md file that contains general guidelines. What should the developer do in the chat session?

   • AUse the /clear command to reset the session and then ask the question again.
   • BDisable the MCP server connection to prevent external tool interference.
   • CAsk the admin to enable the Microsoft Copilot tenant setting.
   • DReference the instruction file and provide a specific prompt that emphasizes performance and deprecation avoidance.
   Reveal Solution Discussion Select an answer first