Free Microsoft AI-102 Exam Practice Questions & Explanations
Prepared & Reviewed by the ValidExamDumps Editorial Team
At ValidExamDumps, we consistently monitor updates to the Microsoft AI-102 exam questions by Microsoft. Whenever our team identifies changes in the exam questions, objectives, focus areas or requirements, We immediately update our exam questions for both PDF and online practice exams. This commitment ensures our customers always have access to the most current and accurate questions. By preparing with these up to date and 100% exam domain coverage questions, our customers can successfully pass the Microsoft Designing and Implementing a Microsoft Azure AI Solution exam on their first attempt without needing additional materials or study guides.
Other certification materials providers often include outdated or removed questions by Microsoft in their AI-102 exam. These outdated questions lead to customers failing their Microsoft Designing and Implementing a Microsoft Azure AI Solution exam. In contrast, we ensure our questions bank includes only precise and up-to-date questions. Our main priority is your success in the Microsoft AI-102 exam, not profiting from selling obsolete exam questions in PDF or Online Practice Test.
You have the following data sources:
* Finance: On-premises Microsoft SQL Server database
* Sales: Azure Cosmos DB using the Core (SQL) API
* Logs: Azure Table storage
* HR: Azure SQL database
You need to ensure that you can search alt the data by using the Azure Al Search REST API. What should you do?
You are building an app that will use the Azure Video Indexer service.
You plan to train a language model to recognize industry-specific terms.
You need to upload a file that contains the industry-specific terms.
Which file format should you use?
To extend Video Indexer with industry-specific terms, you upload a plain text (TXT) file containing the vocabulary.
PDF, XML, XLS are not supported for custom vocabulary upload.
Correct Answe r: C
You have a SQL query that combines customer data and order dat
a. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SOL query. What should you create?
A view is a virtual table based on the result set of a query.
Views allow you to encapsulate complex queries (including joins and calculated columns) and make them reusable by other users.
Index improves performance but does not store or rerun queries.
Scalar function returns a single value, not a tabular result.
Table stores raw data, not queries.
You are developing an app that will use the Speech and Language APIs.
You need to provision resources for the app. The solution must ensure that each service is accessed by using a single endpoint and credential.
Which type of resource should you create?
The scenario requires:
An app that uses both Speech and Language APIs.
A single endpoint and single credential for accessing both services.
Let's analyze the options:
Option A -- Azure AI Language
Provides only language-related capabilities (text analytics, QnA, summarization, etc.).
Does not include Speech APIs.
So, this would not meet the requirement.
Option B -- Azure AI Foundry service
Previously known as Azure Cognitive Services (multi-service account).
Allows you to provision one unified resource that gives access to multiple Azure AI services (Vision, Speech, Language, Content Safety, etc.).
Provides a single endpoint and single API key/credential across these services.
Perfectly fits the requirement of the question.
Option C -- Azure AI Speech
Provides only speech-related capabilities (speech-to-text, text-to-speech, speech translation, speaker recognition).
Does not include Language APIs.
Therefore, not suitable.
Option D -- Azure AI Foundry Content Safety
Focused on safety and responsible AI (moderation of text and images).
Does not include general speech or language APIs.
Not applicable here.
Microsoft Reference
Azure AI Foundry documentation (formerly Cognitive Services)
Azure AI services overview
Provisioning Azure AI services as a single multi-service resource
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or tails completely?
The A in ACID stands for Atomicity.
Atomicity ensures that all parts of a transaction are completed. If any part fails, the entire transaction is rolled back all-or-nothing execution.
Isolation ensures transactions do not interfere with each other.
Consistency ensures data moves from one valid state to another.
Durability ensures committed changes survive failures.
Correct Answe r: B. atomicity