AI-102 Exam Questions

What is the primary purpose of a data warehouse?

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support d...

Your company has a repotting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution us...

You need to create a visualization of running sales totals per quarter as shown in the following exhibit. What should you create in Cower Bl Desktop;1

Which Azure Storage service implements the key/value model?

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or tails completely?

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store...

You need to store event log data that is semi-structured and received as the logs occur. What should you use?

What should you use to automatically delete blobs from Azure Blob Storage?

What is a characteristic of a non-relational database?

You are building a retail kiosk system that will use a custom neural voice. You acquire audio samples and consent from the voice talent. You need to create a voice talent profile....

You have an app named App1 that uses an Azure AI Services model to identify anomalies in a time series data stream. You need to run App1 in a location that has limited connectivity...

You plan create an index for an Azure AI Search service by using the Azure portal. The Azure AI Search service will connect to an Azure SQL database. The Azure SQL database contain...

You have an Azure loT hub that receives series data from machinery. You need to build an app that will perform the following actions: - Perform anomaly detection across multiple co...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You develop a Conversational Azure AI Language Understanding model by using Language Studio. During testing, users receive incorrect responses to requests that do NOT relate to the...

Drag and Drop Question Match the Azure services to the appropriate locations in the architecture. To answer, drag the appropriate service from the column on the left to its locatio...

Drag and Drop Question Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the r...

Drag and Drop Question Match the Azure Cosmos DB APIs to the appropriate data structures. To answer, drag the appropriate API from the column on the left to its data structure on t...

You have an Azure AI Search instance that indexes purchase orders by using Azure AI Document Intelligence. You need to analyze the extracted information by using Microsoft Power BI...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some q...

You have a factory that produces food products. You need to build a monitoring solution for staff compliance with personal protective equipment (PPE) requirements. The solution mus...

You have an Azure AI Search solution and a collection of blog posts that include a category field. You need to index the posts. The solution must meet the following requirements: -...

You need to build a solution that will use optical character recognition (OCR) to scan sensitive documents by using the Computer Vision API. The solution must NOT be deployed to th...

You need to measure the public perception of your brand on social media by using natural language processing. Which Azure service should you use?

You have an Azure AI Search solution and an enrichment pipeline that performs Sentiment Analysis on social media posts. You need to define a knowledge store that will include the s...

You use the Microsoft Bot Framework Composer to build a chatbot that enables users to purchase items. You need to ensure that the users can cancel in-progress transactions. The sol...

SIMULATION You need to create a Text Analytics service named Text12345678, and then enable logging for Text12345678. The solution must ensure that any changes to Text12345678 will...

SIMULATION You need to create a search service named search12345678 that will index a sample Azure Cosmos DB database named hotels-sample. The solution must ensure that only Englis...

SIMULATION You plan to create a solution to generate captions for images that will be read from Azure Blob Storage. You need to create a service in Azure AI Services for the soluti...

SIMULATION You need to create a Azure AI Document Intelligence resource named fr12345678. Use the Azure AI Document Intelligence sample labeling tool at https://fott-2-1.azurewebsi...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION You need to configure and publish bot12345678 to support task management. The intent must be named TaskReminder. The LUDown for the intent is in the C:\Resources\LU fold...

SIMULATION You need to configure bot12345678 support the French (FR-FR) language. Export the bot to C:\Resources\Bot\Bot1.zip. To complete this task, use the Microsoft Bot Framewor...

SIMULATION You need to configure and publish bot12345678 to answer questions by using the frequently asked questions (FAQ) located at https://docs.microsoft.com/en-us/ azure/bot-se...

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...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION Use the following login credentials as needed: - To enter your username, place your cursor in the Sign in box and click on the username below. - To enter your password,...

SIMULATION You need to create and publish a bot that will use Language Understanding and QnA Maker. The bot must be named bot12345678. You must publish the bot by using the User1-1...

SIMULATION You need to create a QnA Maker service named QNA12345678 in the East US Azure region. QNA12345678 must contain a knowledge base that uses the questions and answers avail...