This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
A database developer wants to use AI assistance while writing T-SQL in SQL Server Management Studio. Which tool should they install?
Fabric Copilot extension
GitHub Copilot through the AI Assistance workload
Azure OpenAI extension
SQL IntelliSense extension
What security practice should you follow when using AI-assisted tools with database credentials?
Store credentials in instruction files so Copilot can access them
Include connection strings in prompts for accurate suggestions
Use environment variables and never paste credentials into prompts
Grant AI tools full database access for better context
What does Model Context Protocol (MCP) enable AI assistants to do?
Generate code faster by using more powerful models
Connect directly to data sources for real-time schema and metadata access
Encrypt communications between the IDE and AI service
Store AI conversations for later reference
Where should you place a copilot-instructions.md file to apply custom instructions to a repository?
In the repository root folder
In the VS Code configuration folder
In the GitHub configuration folder at the repository root
In the user's home directory
A team wants to connect their AI assistant to a Fabric Lakehouse. What should they configure?
Install the MSSQL extension and connect directly
Publish a Fabric data agent as an MCP server and connect using the MCP endpoint URL
Use Azure Blob Storage connection strings
Configure GitHub Actions to sync with Fabric
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?