Exam AI-100 topic 4 question 16 discussion

Actual exam question from Microsoft's AI-100

Question #: 16
Topic #: 4

Your company plans to implement an AI solution that will analyze data from IoT devices.
Data from the devices will be analyzed in real time. The results of the analysis will be stored in a SQL database.
You need to recommend a data processing solution that uses the Transact-SQL language.
Which data processing solution should you recommend?

A. Azure Stream Analytics
B. SQL Server Integration Services (SSIS)
C. Azure Event Hubs
D. Azure Machine Learning

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://www.linkedin.com/pulse/getting-started-azure-iot-services-stream-analytics-rob-tiffany

by awron_durat at Dec. 29, 2020, 7 p.m.

Comments

Submit Cancel

rveney

2 years ago

A. Azure Stream Analytics. To process data from IoT devices in real-time using the Transact-SQL language and store the results in a SQL database. Azure Stream Analytics is a fully managed real-time analytics service provided by Microsoft Azure. It enables you to process and analyze streaming data from various sources, including IoT devices, in real time. With Stream Analytics, you can use Transact-SQL (T-SQL) queries to perform real-time transformations, aggregations, filtering, and computations on the incoming data.

upvoted 1 times

...

Cornholioz

4 years, 4 months ago

Correct, although ASA provides a query language which is a subset of the standard T-SQL syntax. https://docs.microsoft.com/en-us/stream-analytics-query/stream-analytics-query-language-reference#:~:text=Azure%20Stream%20Analytics%20offers%20a%20SQL%20query%20language

upvoted 1 times

...

awron_durat

4 years, 6 months ago

The answer provided is correct.

upvoted 2 times

...