practice sheet · all objectives switch to smart practice →
Microsoft Certified: Fabric Data Engineer Associate
You are building a Fabric Eventstream query that correlates a real-time stream of toll events with a persisted lookup table that maps license plates to registration data. Which JOIN characteristic distinguishes this reference data JOIN from other JOINs used in stream processing?
Explanation
This is the only JOIN supported in Stream Analytics where a temporal bound is not necessary.
Reference data JOIN is supported for inner JOIN (default) and left outer JOIN, with reference data on the right side of the JOIN operator.
reference data does not make the time progress so the stream on the left side needs to get new events in order to
In a Fabric Eventstream job you must guarantee a single explicit schema on an input, informing the job of the schema with no risk of deviation, accepting that non-compliant rows will be dropped. Which approach meets this requirement?
Explanation
CREATE TABLE : define a single explicit schema to an input. Rows with conversion errors are removed from the stream
This approach allows to inform the job of the schema of a given input, with no risk of deviation.
Locked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to review