This post is a part of the DP-800: Developing AI-Enabled Database Solutions Exam Prep Hub.
This topic falls under these sections:
Design and develop database solutions (35–40%)
   --> Design and implement SQL solutions by using AI-assisted tools
      --> Enable GitHub Copilot and Microsoft Copilot in Fabric

Note that there are 10 practice questions (with answers) at the end of each section to help you solidify your knowledge of the material. Also, there are 4 practice tests with 30 questions each available from the hub's main page below the exam topics section.

Introduction

The DP-800 exam expects candidates to understand how to enable, configure, and effectively use GitHub Copilot and Microsoft Copilot in Microsoft Fabric to improve SQL development productivity while maintaining security, governance, and responsible AI practices.

Unlike traditional SQL development topics, this objective focuses on using AI-assisted development tools rather than writing SQL syntax itself.

After studying this topic, you should be able to:

• Understand the purpose of GitHub Copilot and Microsoft Copilot in Fabric.
• Identify licensing and prerequisite requirements.
• Enable GitHub Copilot in supported development environments.
• Enable Copilot features within Microsoft Fabric.
• Understand tenant, capacity, and workspace requirements.
• Use AI assistants to generate SQL code.
• Use AI to explain, optimize, and troubleshoot SQL.
• Understand responsible AI and governance considerations.
• Identify security best practices when using AI-assisted development.

What is GitHub Copilot?

GitHub Copilot is an AI-powered coding assistant that helps developers write software by generating code suggestions based on natural language prompts and existing code.

It can:

• Generate SQL queries
• Create stored procedures
• Suggest table definitions
• Generate JOIN statements
• Explain SQL code
• Generate comments and documentation
• Help debug errors
• Recommend code improvements
• Convert natural language into SQL

GitHub Copilot is integrated into popular development environments, including:

• Visual Studio
• Visual Studio Code
• GitHub.com
• Azure Data Studio (where supported)
• SQL development environments that support Copilot extensions

For DP-800, GitHub Copilot is primarily used to accelerate SQL database development.

What is Microsoft Copilot in Fabric?

Microsoft Copilot in Microsoft Fabric is an AI assistant built directly into the Microsoft Fabric platform.

Rather than only generating code, Fabric Copilot helps users:

• Create SQL queries
• Build Data Warehouses
• Generate notebooks
• Explain SQL statements
• Create Dataflows
• Build reports
• Analyze datasets
• Summarize data
• Generate semantic model calculations
• Create pipelines
• Produce documentation

For SQL developers, Copilot can assist with creating and refining SQL scripts within Fabric Data Warehouse and SQL analytics experiences.

GitHub Copilot vs. Microsoft Copilot in Fabric

GitHub Copilot Prerequisites

Before GitHub Copilot can be used, developers generally need:

• A GitHub account
• A GitHub Copilot subscription or enterprise license
• A supported IDE (Visual Studio, Visual Studio Code, etc.)
• Internet connectivity
• Authentication with GitHub

Organizations may centrally manage Copilot licensing through GitHub Enterprise.

Enabling GitHub Copilot in Visual Studio Code

The general process includes:

1. Install Visual Studio Code.
2. Sign in to GitHub.
3. Install the GitHub Copilot extension.
4. Authenticate your GitHub account.
5. Verify that your organization permits Copilot usage.
6. Open a SQL file.
7. Begin typing or enter a natural language prompt.

Example:

-- Create a stored procedure that returns all orders placed during the last 30 days.

Copilot suggests SQL code that can then be reviewed and edited.

Enabling GitHub Copilot in Visual Studio

Visual Studio includes built-in support for GitHub Copilot after the extension is installed.

Developers typically:

• Install the GitHub Copilot extension.
• Sign in using GitHub credentials.
• Enable Copilot in the IDE settings if required.
• Open a SQL project.
• Accept or reject AI-generated suggestions.

Microsoft Fabric Copilot Requirements

Copilot in Microsoft Fabric requires several prerequisites.

These commonly include:

• A Microsoft Fabric tenant
• An eligible Fabric capacity that supports Copilot features
• Administrator approval for Copilot
• Appropriate user licensing
• A supported Fabric experience
• Access to a Fabric workspace

Not every Fabric environment automatically has Copilot enabled.

Enabling Copilot in Microsoft Fabric

Fabric administrators control whether Copilot features are available within the organization.

Typical steps include:

1. Open the Fabric Admin Portal.
2. Navigate to Tenant Settings.
3. Locate Copilot and AI settings.
4. Enable Copilot for the organization or selected security groups.
5. Save configuration changes.
6. Assign users to workspaces with Copilot-enabled capacities.

Organizations may choose to enable Copilot only for specific departments or security groups.

Workspace Considerations

Users generally require:

• Workspace access
• Appropriate workspace role
• Capacity that supports AI features

Having access to Fabric alone does not guarantee Copilot availability.

Security Permissions

Fabric administrators may control:

• Who can use Copilot
• Which workspaces allow AI
• Which security groups receive access
• Which users can create AI-assisted content

This supports governance and compliance requirements.

Using GitHub Copilot for SQL Development

GitHub Copilot can assist with:

Creating Tables

Example prompt:

Create a SQL table for storing customer orders.

Copilot generates a table definition including columns, data types, and constraints.

Generating Stored Procedures

Example prompt:

Create a stored procedure that returns orders by customer.

Copilot generates the T-SQL, which should then be reviewed before deployment.

Creating Functions

Developers can request:

• Scalar functions
• Table-valued functions
• Aggregate calculations
• String manipulation
• Date calculations

Writing Complex Queries

Copilot can generate:

• JOIN statements
• CTEs
• Window functions
• Recursive queries
• JSON queries
• Graph queries
• Regular expression queries
• Error handling logic

Using Copilot in Fabric

Fabric Copilot supports natural language interactions.

Example:

Show the top ten customers by total sales during the last fiscal year.

Copilot may generate the corresponding SQL query automatically.

Explaining SQL Code

One valuable feature is code explanation.

Example prompt:

Explain this stored procedure.

Copilot can summarize:

• joins
• filters
• business logic
• aggregations
• performance considerations

This is especially useful when maintaining legacy SQL code.

Optimizing SQL Queries

Copilot can suggest improvements such as:

• adding indexes
• eliminating unnecessary scans
• simplifying joins
• reducing nested queries
• replacing cursors
• improving readability

However, recommendations should always be validated using execution plans and performance testing.

AI-Assisted Documentation

Developers can use Copilot to generate:

• procedure descriptions
• function documentation
• parameter explanations
• inline comments
• technical documentation

Good documentation improves maintainability and collaboration.

Responsible AI Considerations

Neither GitHub Copilot nor Fabric Copilot should be considered authoritative.

Developers remain responsible for:

• correctness
• performance
• security
• compliance
• testing
• deployment approval

AI accelerates development but does not replace engineering judgment.

Security Best Practices

When using AI assistants:

• Never include passwords in prompts.
• Do not paste connection strings.
• Remove API keys.
• Avoid sharing production customer data.
• Use anonymized sample data whenever possible.
• Review generated SQL for SQL injection vulnerabilities.
• Verify permissions follow the Principle of Least Privilege.
• Follow organizational AI governance policies.

Common Limitations

AI assistants may:

• Generate inefficient SQL.
• Hallucinate nonexistent syntax.
• Recommend deprecated features.
• Omit indexes.
• Produce insecure dynamic SQL.
• Misinterpret business requirements.

Always validate generated code before using it in production.

GitHub Copilot vs Manual Development

DP-800 Exam Tips

Be familiar with:

• GitHub Copilot licensing prerequisites
• Supported development environments
• Fabric Copilot enablement requirements
• Tenant settings that control Copilot
• Workspace and capacity requirements
• Appropriate use of AI-generated SQL
• Responsible AI principles
• Security and governance responsibilities
• Human review of AI-generated code
• Organizational approval for AI usage

Remember:

GitHub Copilot primarily assists developers inside coding environments, while Microsoft Copilot in Fabric provides AI assistance across multiple Fabric workloads, including SQL development, analytics, notebooks, and reporting.

Key Takeaways

• GitHub Copilot is an AI-powered coding assistant that accelerates SQL development.
• Microsoft Copilot in Fabric provides AI assistance throughout the Microsoft Fabric ecosystem.
• Fabric administrators control Copilot availability through tenant settings and capacity configuration.
• Developers need appropriate permissions, licensing, and workspace access.
• AI-generated SQL should always be reviewed, tested, and validated.
• Sensitive information should never be included in AI prompts.
• AI improves productivity but does not replace secure software development practices.

Practice Exam Questions

Question 1

A database developer wants to use GitHub Copilot in Visual Studio Code. Which prerequisite is required before Copilot can provide code suggestions?

A. Install the GitHub Copilot extension and authenticate with a licensed GitHub account

B. Enable Microsoft Fabric capacity

C. Create a SQL Server Agent job

D. Install Azure Data Factory

Correct Answer: A

Explanation: GitHub Copilot requires a GitHub account, an appropriate Copilot license, installation of the GitHub Copilot extension, and authentication before AI-powered code suggestions become available.

Question 2

Who typically enables Microsoft Copilot features for an organization using Microsoft Fabric?

A. Every workspace member individually

B. SQL Server service account

C. Fabric administrator through tenant settings

D. Database owner

Correct Answer: C

Explanation: Microsoft Fabric administrators manage Copilot availability through tenant settings and can enable it for the entire organization or selected security groups.

Question 3

Which task is GitHub Copilot best suited to assist with?

A. Replacing SQL Server security auditing

B. Automatically approving production deployments

C. Generating SQL code and stored procedures from natural language prompts

D. Creating Azure subscriptions

Correct Answer: C

Explanation: GitHub Copilot is designed to help developers generate, explain, and improve code, including SQL statements, stored procedures, and database objects.

Question 4

A developer asks Copilot to optimize a SQL query. What should the developer do before deploying the suggested code?

A. Assume the generated code is correct

B. Skip performance testing

C. Disable indexes

D. Review, test, and validate the generated SQL

Correct Answer: D

Explanation: AI-generated code should always undergo testing, performance evaluation, security review, and validation before being used in production.

Question 5

Which Microsoft Fabric requirement is commonly necessary for users to access Copilot features?

A. Workspace access and a Copilot-supported Fabric capacity

B. SQL Server Express Edition

C. Windows Server Failover Clustering

D. SQL Server Agent enabled

Correct Answer: A

Explanation: Users generally require access to a Fabric workspace that resides on a capacity supporting Copilot features, along with the necessary permissions.

Question 6

What is an appropriate use of Microsoft Copilot in Fabric?

A. Automatically bypassing security reviews

B. Generating SQL queries from natural language requests

C. Granting database administrator privileges

D. Disabling tenant governance

Correct Answer: B

Explanation: Fabric Copilot can translate natural language requests into SQL queries and assist with other Fabric workloads, but it does not replace security or governance processes.

Question 7

Which statement best describes the relationship between GitHub Copilot and Microsoft Copilot in Fabric?

A. They perform exactly the same functions in every environment.

B. GitHub Copilot only works with Power BI.

C. Fabric Copilot replaces all integrated development environments.

D. GitHub Copilot primarily assists with coding, while Fabric Copilot assists across multiple Microsoft Fabric experiences.

Correct Answer: D

Explanation: GitHub Copilot focuses on AI-assisted software development within supported IDEs, whereas Fabric Copilot provides AI capabilities across data engineering, analytics, warehousing, notebooks, reporting, and SQL experiences.

Question 8

Which information should never be included in an AI prompt when requesting SQL assistance?

A. Sample table names

B. General business requirements

C. Production passwords and connection strings

D. Desired query output

Correct Answer: C

Explanation: Sensitive information such as passwords, connection strings, API keys, and confidential customer data should never be shared with AI tools.

Question 9

Which benefit does GitHub Copilot provide during SQL development?

A. It automatically deploys production databases.

B. It generates AI-assisted code suggestions that can improve developer productivity.

C. It permanently replaces code reviews.

D. It guarantees optimal query performance.

Correct Answer: B

Explanation: GitHub Copilot accelerates development by generating code suggestions, but developers remain responsible for testing, reviewing, and validating the generated code.

Question 10

Which statement reflects Microsoft’s recommended approach to AI-assisted database development?

A. AI-generated code should always be deployed without modification.

B. AI eliminates the need for peer reviews.

C. AI-generated code should be treated as a draft that developers validate for correctness, security, and performance.

D. AI guarantees compliance with organizational policies.

Correct Answer: C

Explanation: AI-generated code should be viewed as a productivity aid rather than authoritative output. Developers are responsible for verifying functionality, security, performance, compliance, and adherence to organizational standards before deployment.

Go to the DP-800 Exam Prep Hub main page