Microsoft DP-800 actual dump : Developing AI-Enabled Database Solutions

Your company has an ecommerce catalog in a Microsoft SQL Server 202b database named SalesDB SalesDB contains a table named products, products contains the following columns:
* product.id (int)
* product_name (nvarchar(200))
* description (nvarchar(max))
* category (nvarchar(50))
* brand (nvarchar(W))
* price (decimal)
* sku (nvarchar(40))
The description fields ate updated dairy by a content pipeline, and price can change multiple times per day.
You want customers to be able to submit natural language queries and apply structured filters for brand and price. You plan to store embeddings in a new VECTOR(1536) column and use VECTOR_SEARCH(...
METRIC=' cosine ' ...).
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

You have an Azure SQL database named SalesDB that supports an ecommerce application. SalesDB contains a table named dbo.Orders that has a clustered index on a column named orderid.
dbo.Orders receives continuous OLTP inserts and updates during business hours.
Your analytics team runs hourly aggregate queries that scan dbo.Orders to calculate revenue trends for recent dates.
You need to improve the performance of the hourly analytics queries without significantly affecting OLTP throughput. The solution must meet the following requirements:
Support near-real-time (NRT) analytics on the dbo.Orders table.
Reduce read time when retrieving analytical data from dbo.Orders.
Support indexing only rows that match a predicate, such as Active = 1.
Which type of index should you use for each requirement? To answer, drag the appropriate index types to the correct requirements. Each index type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Vou have a Microsoft Fabric workspace named Workspace1 that contains a SQL database named SalesDB and an API for GraphQL tern named SalesApi.
You have a Microsoft Entra group named SqlUsers.
From Workspace1, you assign permission to SalesApi as shown in the following exhibit.

The connection to SalesDB has the connectivity option configured as shown in the following exhibit.

SqlUsers has the Viewer role for Workspace1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You have an Azure SQL database named SalesDB on a logical server named sales-sql01.
You have an Azure App Service web app named OrderApi that connects to SalesDB by using SQL authentication.
You enable a user-assigned managed identity named OrderApi-Id for OrderApi.
You need to configure OrderApi to connect to SalesDB by using Microsoft Entra authentication. The managed identity must have read and write permissions to SalesDB.
Which Transact-SQL statements should you run in SalesDB?

• A. CREATE USER [OrderApi-Id] WITH PASSWORD = ' P@ssw0rd! ' ;
  ALTER ROLE db_datareader ADD MEMBER [OrderApi-Id];
  ALTER ROLE db_datawriter ADD MEMBER [OrderApi-Id];
• B. CREATE USER [OrderApi-Id] FROM EXTERNAL PROVIDER;
  ALTER ROLE db_datareader ADD MEMBER [OrderApi-Id];
  ALTER ROLE db_datawriter ADD MEMBER [OrderApi-Id];
• C. CREATE LOGIN [OrderApi-Id] WITH PASSWORD = ' P@ssw0rd! ' ;
  ALTER SERVER ROLE sysadmin ADD MEMBER [OrderApi-Id];
• D. CREATE LOGIN [OrderApi-Id] FROM EXTERNAL PROVIDER;
  ALTER ROLE db_datareader ADD MEMBER [OrderApi-Id];
  ALTER ROLE db_datawriter ADD MEMBER [OrderApi-Id];

You have an Azure SQL database that contains a table named Rooms. Rooms was created by using the following transact-SQL statement.

You discover that some records in the Rooms table contain NULL values for the Owner field. You need to ensure that all future records have a value for the Owner field. What should you add?

• A. a check constraint
• B. a foreign key
• C. a unique constraint
• D. a nonclustered index