DP-700 Exam QuestionsBrowse all questions from this exam

DP-700 Exam - Question 70


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.

Exam DP-700 Question 70

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.

Show Answer
Correct Answer:

Discussion

7 comments
Sign in to comment
prabhjotOptions: AD
Feb 7, 2025

A and D have valid GUIds

IshtarSQLOptions: BD
Dec 13, 2024

Record B loads because it conforms to the updated schema (string DeviceId, StreamData with temperature). Record D loads because it conforms to the original schema (guid DeviceId, no temperature in StreamData).

PetJoh422
Feb 13, 2025

This is incorrect because it was only updated in Table 1. So passing a string to table2 which requires a GUID will fail when it is not a valid guid.

18e18d0Options: AD
Jan 31, 2025

Records B and C will not load because of invalid GUIDs

GolearnOptions: AD
Feb 3, 2025

A & C have valid GUIds in correct format and also have temperature column

Golearn
Feb 4, 2025

A & D have valid GUIds

DirectX
Feb 26, 2025

B and D. Because of GUID fields in the source data - The destination table schema has not been changed. The third field with json data is probably of type nvarchar(max) which can accommodate any json structure.

DirectX
Mar 4, 2025

I meant A and D. Answers with valid GUID

GoyeOptions: AD
Mar 5, 2025

Please explain the answer

LasAnsiasOptions: AB
Apr 16, 2025

temperature