QuestionQ38

VerifiedIngest and transform data

You have a Fabric workspace containing an eventhouse and a KQL database named Database1. Database1 contains 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 sample data from Table2.

Question Image

Recently, the following actions were performed on Table1:

  • An additional element named temperature was added to the StreamData column.
  • The Timestamp column data type was changed to date.
  • The DeviceId column data type was changed to string.

You plan to load additional records into 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.

Choose two
Explanation

An update policy’s output must match the target table schema in column names, types, and order. A dynamic value can include additional properties such as temperature, and date-form timestamp values are compatible with the target datetime representation. A source string used for a guid target must contain a valid GUID value. The records in A and D contain valid GUID-form DeviceId values; the DeviceId values in B and C are not valid GUIDs.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!