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

Questions 31–35

1. 31foundation · easy

   In Microsoft Fabric, where do you enable GitHub Copilot to assist with SQL solution development?

   • AIn the GitHub repository settings
   • BIn the Fabric admin portal under tenant settings
   • CIn the Power BI service settings
   • DIn the SQL database properties within Fabric
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   In a Copilot in Fabric chat session, what do MCP tool options control?

   • AWhich external tools the Copilot can access
   • BThe formatting of SQL code output
   • CThe verbosity of the Copilot's responses
   • DThe security level of the chat session
   Reveal Solution Discussion Select an answer first
4. 33foundation · easy

   What is the purpose of a GitHub Copilot instruction file (e.g., .github/copilot-instructions.md)?

   • ATo configure the Copilot subscription billing
   • BTo define the database schema for the project
   • CTo store the history of all Copilot interactions
   • DTo provide project-specific guidelines that Copilot follows when generating code
   Reveal Solution Discussion Select an answer first
5. 34expert · hard

   A developer is using GitHub Copilot Chat to generate a complex SQL query that joins data from a Fabric lakehouse and a SQL Server database. The developer has two MCP servers configured, but the model keeps producing queries that reference only one data source. The developer needs the model to reliably use both sources in a single query. What should the developer do?

   • ADisable one MCP server and manually copy data from the other source into the lakehouse.
   • BIncrease the temperature setting to encourage the model to explore different query structures.
   • CVerify that both MCP servers are active and authenticated, then explicitly describe the join requirement in the prompt.
   • DCreate a single MCP server that exposes both data sources as one combined tool.
   Reveal Solution Discussion Select an answer first
6. 35expert · hard

   A team maintains a large Fabric SQL repository with multiple subdirectories. They want GitHub Copilot to apply different coding conventions for stored procedures versus ad-hoc queries. They also want the rules to be applied automatically without requiring developers to switch settings. What should they do?

   • AAsk developers to manually switch between two instruction files using a VS Code extension.
   • BUse a Model Context Protocol (MCP) server to inject different rules based on the file path.
   • CCreate a single instruction file at the repository root with all rules and rely on the model to choose the right one.
   • DCreate multiple instruction files in different subdirectories, each with rules for that directory's content.
   Reveal Solution Discussion Select an answer first