Multi SelectImplement AI capabilities in database solutions
Question 6. You need to recommend a solution that will resolve the ingestion pipeline failure issues. Which two actions should you recommend? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Enable snapshot isolation on the database.
B. Use a trigger to automatically rewrite malformed JSON.
C. Add foreign key constraints on the table.
D. Create a unique index on a hash of the payload.
E. Add a check constraint that validates the JSON structure.
Drag OrderDesign and develop database solutions
Question 7. You need to meet the database performance requirements for maintenance data How should you complete the Transact-SQL code? To answer, drag the appropriate values to the correct targets. Each value 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. Answer:
A. CREATE TRIGGER dbo.trgMaintenanceEvents_Updatetimestamp ON dbo.MaintenanceEvents AFTER UPDATE AS BEGIN UPDATE m SET LastModifiedutc = SYSUTCDATETIME() FROM dbo.MaintenanceEvents m INNER JOIN inserted i ON m.MaintenanceId = i.MaintenanceId WHERE m.LastModifiedutc < i.LastModifiedutc END
B. CREATE TRIGGER dbo.trgMaintenanceEvents_Updatetimestamp ON dbo.MaintenanceEvents AFTER UPDATE AS BEGIN UPDATE m SET LastModifiedutc = GETUTCDATE() FROM dbo.MaintenanceEvents m INNER JOIN inserted i ON m.MaintenanceId = i.MaintenanceId END
C. CREATE TRIGGER dbo.trgMaintenanceEvents_Updatetimestamp ON dbo.MaintenanceEvents AFTER UPDATE AS BEGIN UPDATE m SET LastModifiedutc = SYSUTCDATETIME() FROM dbo.MaintenanceEvents m INNER JOIN deleted i ON m.MaintenanceId = i.MaintenanceId END
Multiple ChoiceDesign and develop database solutions
Question 8. You need to recommend a solution to lesolve the slow dashboard query issue. What should you recommend?
A. Create a clustered index on Lastupdatedutc.
B. On Fleetid, create a nonclustered index that includes Lastupdatedutc. inginestatus, and BatteryHealth.
C. On Lastupdatedutc. create a nonclustered index that includes Fleetid.
D. On Fleetid, create a filtered index where lastupdatedutc > DATEADD(DAV, -7, SYSuTCOATETIME()).
Multiple ChoiceImplement AI capabilities in database solutions
Question 9. You need to enable similarity search to provide the analysts with the ability to retrieve the most relevant health summary reports. The solution must minimize latency. What should you include in the solution?
A. a computed column that manually compares vector values
B. a standard nonclustered index on the Fmbeddings (vector (1536)) column
C. a full-text index on the Fmbeddings (vector (1536)) column
D. a vector index on the Embedding* (vector (1536)) column
Multi SelectDesign and develop database solutions
Question 10. You need to create a table in the database to store the telemetry data. You have the following Transact-SQL code. Answer:
A. The code meets the database performance requirements for partitioning.
B. The code meets the database performance requirements for JSON property querying.
C. Queries that filter on $.location.heading will use the VehicleTelemetry_Location index.