exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 2 question 15 discussion

Actual exam question from Microsoft's DP-700
Question #: 15
Topic #: 2
[All DP-700 Questions]

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.


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.

  • A.
  • B.
  • C.
  • D.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
prabhjot
Highly Voted 1 month ago
Selected Answer: AD
A and D have valid GUIds
upvoted 6 times
...
IshtarSQL
Highly Voted 2 months, 4 weeks ago
Selected Answer: BD
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).
upvoted 5 times
PetJoh422
3 weeks, 5 days ago
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.
upvoted 1 times
...
...
Goye
Most Recent 6 days, 23 hours ago
Selected Answer: AD
Please explain the answer
upvoted 1 times
...
DirectX
2 weeks ago
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.
upvoted 1 times
DirectX
1 week ago
I meant A and D. Answers with valid GUID
upvoted 1 times
...
...
Golearn
1 month ago
Selected Answer: AD
A & C have valid GUIds in correct format and also have temperature column
upvoted 3 times
Golearn
1 month ago
A & D have valid GUIds
upvoted 1 times
...
...
18e18d0
1 month, 1 week ago
Selected Answer: AD
Records B and C will not load because of invalid GUIDs
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago