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

Question

You have a Fabric workspace that contains an eventhouse and a KQL database named Database1. Database1 has the following: - A table named Table1 - A table named Table2 - An update policy named Policy1 - Policy1 sends data from Table1 to Table2. The following is a sample of the data in Table2. [Table showing Timestamp, DeviceId, StreamData] Recently, the following actions were performed on Table1: - An additional element named temperature was added to the StreamData column. - The data type of the Timestamp column was changed to date. - The data type of the DeviceId column was changed to string. You plan to load additional records to Table2. Which two records will load from Table1 to Table2? Each correct answer presents a complete solution. Note: Each correct selection is worth one point.

Options

• ATable with Timestamp (datetime: 2024-05-18 12:45:17.16524), DeviceId (guid: 81416f30-60a2-4e75-9b19-2a84ea059735), StreamData ({ "index": 0, "eventid": "719afca0-be30-4559-bb5e-59feade642f6", "temperature": 32})
• BTable with Timestamp (datetime: 2024-05-21 12:45:17.16524), DeviceId (guid: 81416f30), StreamData ({ "index": 0, "eventid": "719afca0-be30-4559-bb5e-5werade642f6", "temperature": 27})
• CTable with Timestamp (datetime: 2024-05-23 12:45:17.16524), DeviceId (guid: 81416f3002a4e759b192a84ea0597352d3dyle3), StreamData ({ "index": 0, "eventid": "719afca0-be30-4559-bb5e-59feade642f6"}) (Note: Missing 'temperature' field)
• DTable with Timestamp (datetime: 2024-05-24 12:45:17.16524), DeviceId (guid: 81416f30-60a2-4e75-9b19-2a84ea059735), StreamData ({ "index": 0, "eventid": "719afca0-be30-4559-bb5e-59feade642f6", "temperature": null})