Question 77 of 170 from exam DP-200: Implementing an Azure Data Solution

Prev Question Next Question

Question

DRAG DROP -

You implement an event processing solution using Microsoft Azure Stream Analytics.

The solution must meet the following requirements:

-> Ingest data from Blob storage

-> Analyze data in real time

-> Store processed data in Azure Cosmos DB

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Select and Place:

Show Answer

Explanations

Step 1: Configure Blob storage as input; select items with the TIMESTAMP BY clause

The default timestamp of Blob storage events in Stream Analytics is the timestamp that the blob was last modified, which is BlobLastModifiedUtcTime. To process the data as a stream using a timestamp in the event payload, you must use the TIMESTAMP BY keyword.

Example:

The following is a TIMESTAMP BY example which uses the EntryTime column as the application time for events:

SELECT TollId, EntryTime AS VehicleEntryTime, LicensePlate, State, Make, Model, VehicleType, VehicleWeight, Toll, Tag

FROM TollTagEntry TIMESTAMP BY EntryTime

Step 2: Set up cosmos DB as the output

Creating Cosmos DB as an output in Stream Analytics generates a prompt for information as seen below.

Step 3: Create a query statement with the SELECT INTO statement.

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-inputs

Prev Question Next Question