DRAG DROP
You have a SQL database in Microsoft Fabric that contains a table named WebSite. Logs. WebSite.Logs
stores application telemetry data.
Website.Logs contains a nvarehar(iMx) column named log that stores JSON documents.
You have a daily report that filters by the $.severity JSON property and returns Logld. LogDateTime, and log. The report frequently causes full table scans.
You need to modify Website. Logs to support efficient filtering by $. severity and avoid key lookups for the columns returned by the report.
How should you complete the Transact-SQL code to avoid full table scans?
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.
Drag each option into the matching blank slot.
