<< Prev Question Next Question >>

Question 11/26

You have an Azure SQL database that contains a table named stores, stores contains a column named description and a vector column named embedding.
You need to implement a hybrid search query that meets the following requirements:
* Uses full-text search on description for the keyword portion
* Returns the top 20 results based on a combined score that uses a weighted formula of 60% vector distance and 40% full-text rank How should you configure the query components? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (26q)
Question 1: You have an Azure SQL database that supports the OLTP worklo...
Question 2: You have an Azure SQL database named DB1 that contains two t...
Question 3: You have an Azure SQL database that contains a column named ...
Question 4: You have a database named DB1. The schema is stored in a Git...
Question 5: You have an Azure SQL database that supports the OLTP worklo...
Question 6: You have a database named DB1. The schema is stored in a Git...
Question 7: You have an Azure SQL database That contains a table named d...
Question 8: You have an Azure SQL database that contains a table named k...
Question 9: You have an Azure SQL database that supports an OLTP applica...
Question 10: You need to recommend a solution for the development team to...
Question 11: You have an Azure SQL database that contains a table named s...
Question 12: You need to create a table in the database to store the tele...
Question 13: You are creating a table that will store customer profiles. ...
Question 14: You have a GitHub Actions workflow that builds and deploys a...
Question 15: You have an Azure subscription. The subscription contains an...
Question 16: You have a SQL database in Microsoft Fabric that contains a ...
Question 17: You need to meet the database performance requirements for m...
Question 18: Your company has an ecommerce catalog in a Microsoft SQL Ser...
Question 19: You have a Microsoft SQL Server 2025 instance that contains ...
Question 20: You need to design a generative Al solution that uses a Micr...
Question 21: You have an SDK-style SQL database project stored in a Git r...
Question 22: You have an Azure SQL database named AdventureWorksDB that c...
Question 23: You have a Microsoft SQL Servei 2025 database that contains ...
Question 24: You have an Azure SQL database that stores order data. A rep...
Question 25: You have an Azure SQL database named SalesDB that contains t...
Question 26: Your development team uses GitHub Copilot Chat in Microsoft ...