DP-700 Question #101: Real Exam Question with Answer & Explanation

Question

You have a Fabric workspace that contains an eventhouse named Eventhouse1. In Eventhouse1, you plan to create a table named DeviceStreamData in a KQL database. The table will contain data based on the following sample: | Timestamp | DeviceId | StreamData | |-------------------|--------------------|---------------------------------------------------------------------------------| | 2024-05-18 | 81410f30-60a2-4e75- | {"Index": 0, "eventId": "70f0f4e0-be30-4559-bb5e-59feade642f6", "isActive": true, "latitude": 5.390013, "longitude": -60.120235, "Tags": ["tempor"]} | | 12:45:17.30526 | 8619-2abde4869755 | | | 2024-05-18 | bb6d6e1e-02aa-4e17- | {"Index": 0, "eventId": "703222b2-fbcb-43c0-82d6-ecd49a990bf5", "isActive": true, "latitude": -56.153786, "longitude": 130.870907, "Tags": ["adipisicing"]} | | 12:45:21.76423 | 8cba-116cd4458d52 | | | 2024-05-18 | 717bf67d-0e5d-498f- | {"Index": 0, "eventId": "05730280-0d4a-41f8-8e59-f75e200930a9", "isActive": true, "latitude": -21.39209, "longitude": 123.959442, "Tags": ["cull"]} | | 12:45:23.98642 | 9f21-e60aaf258056 | | | 2024-05-18 | 1a390b71-af4f-4df5- | {"Index": 0, "eventId": "00929141-8092-4d16-89eb-002f9f57e2bb", "isActive": true, "latitude": -84.926214, "longitude": -11.498907, "Tags": ["ex"]} | | 12:45:31.39523 | 4f7d-2316d6d001f7 | | | 2024-05-18 | 2f0ba7d0-6dff-4081- | {"Index": 0, "eventId": "08842b87-c0b4-48b2-99f0-4fb5c75ff6f3", "isActive": true, "latitude": -49.909339, "longitude": -177.505775, "Tags": ["laboris"]} | | 12:45:37.43343 | 8f7f-dd039564c3260 | | You need to use a KQL query to develop the solution for Eventhouse1.