copilot-azure-sql-faq.yml

### YamlMime:FAQ
metadata:
  title: "Frequently asked questions about Microsoft Copilot skills in Azure SQL Database (preview)"
  description: "Frequently asked questions about Microsoft Copilot skills in Azure SQL Database."
  author: WilliamDAssafMSFT
  ms.author: wiassaf
  ms.reviewer: josephsack
  ms.service: sql-database
  ms.subservice: ai-copilot
  ms.topic: faq
  ms.date: 03/13/2024
  monikerRange: "= azuresql || = azuresql-db"

title: "Frequently asked questions about Microsoft Copilot skills in Azure SQL Database (preview)"
summary: |
  Frequently asked questions about Microsoft Copilot capabilities in Azure SQL, currently in preview. 

  Microsoft Copilot in Azure offers a set of AI-assisted experiences designed to streamline the design, operation, optimization, and health of Azure SQL Database-driven applications. It improves productivity by offering natural language to SQL conversion and self-help for database administration.

  > [!NOTE]
  > Microsoft Copilot in Azure capabilities with Azure SQL Database are currently in preview for a limited number of early adopters. To sign up for this program, visit [Request Access to Copilot in Azure SQL Database: Preview](https://aka.ms/sqlcopilot-signup).

sections:
  - name: General # Name of first section.
    questions:
      - question: |
          In Azure SQL Database, where can I find Microsoft Copilot in Azure?
        answer: |
          The preview of Copilot capabilities in Azure SQL Database includes two Azure portal experiences:

          | Azure portal location | Experiences |
          | --- | --- |
          | **Azure portal Query Editor** | [Natural language to SQL](copilot-azure-sql-overview.md#natural-language-to-sql-query): This experience within the [Azure portal query editor](../database/query-editor.md) translates natural language queries into SQL, making database interactions more intuitive.<br/> For a tutorial and examples of Copilot's natural language to SQL capabilities in Azure SQL Database, see [Natural language to SQL in the Azure portal Query editor (preview)](../copilot/query-editor-natural-language-to-sql-copilot.md). |
          | **Microsoft Copilot in Azure** | [Azure Copilot integration](copilot-azure-sql-overview.md#microsoft-copilot-in-azure-enhanced-scenarios): This experience adds Azure SQL skills into [Microsoft Copilot in Azure](/azure/copilot/overview), providing customers with self-guided assistance, empowering them to manage their databases and solve issues independently.|
      - question: |
          Are the results from Copilot reliable?
        answer: |
          Copilot is designed to generate the best possible responses with the database context it has access to. However, like any AI system, responses aren't perfect. All of Copilot's responses should be carefully tested, reviewed, and vetted before making changes to your Azure SQL Database environment.
      - question: |
          Does Copilot write perfect or optimal queries?
        answer: |
          Copilot aims to provide accurate and informative responses based on the available data. The answers generated are based on patterns and probabilities in language data, which means that they might not always be accurate. Humans should carefully review, test, and validate all content generated by Copilot.
      - question: |
          How does Copilot use data from my Azure SQL Database environment?
        answer: |
          Copilot generates responses grounded in your Azure SQL Database environment. Copilot only has access to resources that you have access to and can only perform analysis and actions that you have the permissions to perform. Copilot respects all existing access management and protections.
      - question: |
          What data does Copilot collect?
        answer: |
          User-provided prompts and Copilot's responses aren't used to further train, retrain, or improve Azure OpenAI Service foundation models that generate responses. User-provided prompts and Copilot's responses are collected and used to improve Microsoft products and services only when users have given explicit consent to include this information within feedback. We collect user engagement data, such as, number of chat sessions and session duration, the skill used in a particular session, thumbs up, thumbs down, feedback, etc. This information is retained and used as set forth in the [Microsoft Privacy Statement](https://privacy.microsoft.com/privacystatement).
      - question: |
          What should I do if I see unexpected or offensive content?
        answer: |
          The Azure team built Copilot guided by our AI principles and Responsible AI Standard. We have prioritized mitigating exposing customers to offensive content. However, you might still see unexpected results. We're constantly working to improve our technology in preventing harmful content.

          If you encounter harmful or inappropriate content in the system, you can provide feedback or report a concern by selecting the downvote button on the response. We're constantly working to improve our technology to proactively address issues in line with our [responsible AI principles](https://www.microsoft.com/ai/our-approach)
      - question: |
          How much does Copilot cost?
        answer: |
          Copilot skills in Azure SQL Database is offered at no additional cost during the preview.
      - question: |
          What Azure SQL Database offerings are supported in preview?
        answer: |
          Currently supported on General Purpose, Business Critical, Hyperscale, DTU-based Standard and Premium, Serverless, and in elastic pools.
      - question: |
          How is the transmitted prompt and query data protected?
        answer: |
          Copilot takes several measures to protect data including:
          - The transmitted data is encrypted both in transit and at rest; Copilot-related data is encrypted in transit using TLS, and at rest using Microsoft Azure's data encryption (FIPS Publication 140-2 standards). 
          - Access to log and feedback data is strictly controlled. The data is stored in a separate subscription. The data is only accessible by 1) Just-In-Time JIT approval from Azure operations personnel using [secure admin workstations](/azure/security/fundamentals/infrastructure-components#secure-service-administration).
      - question: |
          Where can I learn more about privacy and data protection?
        answer: |
          For more information on how Copilot processes and uses personal data, see the [Microsoft Privacy Statement](https://privacy.microsoft.com/privacystatement).
      - question: |
          Where can I find the preview terms for using Azure OpenAI-powered previews like Copilot?
        answer: |
          For more information, see our [preview terms](https://azure.microsoft.com/support/legal/preview-supplemental-terms/#AzureOpenAI-PoweredPreviews).
additionalContent: |
    ## Related content

    - [Microsoft Copilot skills and Azure SQL Database (preview)](copilot-azure-sql-overview.md)
    - [Natural language to SQL in the Azure portal Query editor (preview)](../copilot/query-editor-natural-language-to-sql-copilot.md)