Microsoft Updated AI-102 Exam Questions and Answers by orin

https://learn.microsoft.com/en-us/azure/cognitive-services/language-service/named-entity-recognition/overview Named Entity Recognition (NER) is one of the features offered by Azure Cognitive Service for Language, a collection of machine learning and AI algorithms in the cloud for developing intelligent applications that involve written language. The NER feature can identify and categorize entities in unstructured text. For example: people, places, organizations, and quantities.

In relational database systems such as Microsoft SQL Server or Azure SQL Database, the following definitions apply:

Stored Procedure:

A stored procedure is a precompiled block of Transact-SQL (T-SQL) code stored in the database. It can contain control-of-flow statements, queries, and business logic. When executed, it runs as a single unit within the database engine. This matches the definition of " a block of code that runs in a database. "

Table:

A table is a structured set of rows and columns used to store data, not a block of executable code.

View:

A view is a virtual table based on the result of a SQL query. It is used for abstraction and simplification of queries, not for executing code blocks.

Index:

An index is a database structure that improves the speed of data retrieval. It is not executable code.

Thus, the only option that correctly describes " a block of code that runs in a database " is a stored procedure.

Correct Answer: A stored procedure

Microsoft References

Stored Procedures (Database Engine)

Azure SQL Database - Stored procedures overview

SQL Server Views

SQL Server Tables

SQL Server Indexes

Scenario Recap:

Proposed Solution: Deploy service1 with a public endpoint, and configure a Network Security Group (NSG) for vnet1.

Analysis:

NSGs only control inbound/outbound traffic at the VNet/subnet or NIC level.

Configuring NSGs does not create private connectivity to Cognitive Search.

Traffic still flows over the public endpoint.

Answer: B. No

NSGs filter traffic, but they don’t prevent routing via the public internet. Only Private Link does.

You need to monitor a video stream while ensuring the microphone stays enabled and detect when the user asks a question. The simplest/lowest-effort approach is to use Azure AI Speech-to-text to transcribe the user’s audio in real time, then apply a lightweight check (e.g., interrogatives like “who/what/how” or final “?”) to detect a question. Object detection or the Face service analyze visual content (objects/faces/emotions) and cannot tell whether a spoken utterance is a question. Language detection only identifies which language is being spoken; it does not transcribe or classify questions.

References

Azure AI Speech: real-time speech-to-text (streaming) for transcription and downstream analysis.

https://learn.microsoft.com/azure/ai-services/speech-service/speech-to-text

Face service overview (not for speech/question detection).

https://learn.microsoft.com/azure/ai-services/computer-vision/overview-identity

Custom Vision object detection overview (visual objects, not spoken questions).

https://learn.microsoft.com/azure/ai-services/custom-vision-service/object-detection-overview

Language detection capability description (identifies language only).

https://learn.microsoft.com/azure/ai-services/language-service/language-detection/overview