Free Microsoft AI-102 Practice Test & Real Exam Questions
You need to enable speech capabilities for a chatbot.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: C,D,E
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Select the answer that correctly completes the sentence.
Correct Answer:
Explanation:
In SQL, DML (Data Manipulation Language) statements include SELECT , INSERT , UPDATE , and DELETE . Often, you need to filter which rows are affected or returned. That filtering is done with the WHERE clause.
Let's review the options:
ALTER
Used in Data Definition Language (DDL), not DML.
Alters the structure of a database object (e.g., add/remove columns, modify constraints).
Not used to filter rows.
ON
Used in JOIN operations to specify the relationship between tables.
Does not specify row-level filtering criteria in general DML.
SET
Used in the UPDATE statement to assign new values to columns.
Does not specify which rows to update.
WHERE
Used in DML statements to specify criteria for rows that must match.
Examples:
SELECT * FROM Customers WHERE Country = ' USA ' ;
DELETE FROM Orders WHERE OrderDate < ' 2020-01-01 ' ;
UPDATE Products SET Price = Price * 1.1 WHERE CategoryID = 5;
Thus, the correct clause is WHERE.
The answer: WHERE
Microsoft References
SQL WHERE clause
SQL UPDATE with WHERE
SQL DELETE with WHERE
You are building a chatbot for a travel agent. The chatbot will use the Azure OpenAI GPT 3.5 model and will be used to make travel reservations.
You need to maximize the accuracy of the responses from the chatbot.
What should you do?
You need to maximize the accuracy of the responses from the chatbot.
What should you do?
Correct Answer: B
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Which scenario is an example of a streaming workload?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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 question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You build a language model by using a Language Understanding service. The language model is used to search for information on a contact list by using an intent named FindContact.
A conversational expert provides you with the following list of phrases to use for training.
Find contacts in London. Who do I know in Seattle?
Search for contacts in Ukraine.
You need to implement the phrase list in Language Understanding.
Solution: You create a new intent for location.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You build a language model by using a Language Understanding service. The language model is used to search for information on a contact list by using an intent named FindContact.
A conversational expert provides you with the following list of phrases to use for training.
Find contacts in London. Who do I know in Seattle?
Search for contacts in Ukraine.
You need to implement the phrase list in Language Understanding.
Solution: You create a new intent for location.
Does this meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have the following files:
* File1.pdf
* File2.jpg
* File3.docx
* File4.webp
* FileS.png
Which files can you analyze by using Azure Al Content Understanding?
* File1.pdf
* File2.jpg
* File3.docx
* File4.webp
* FileS.png
Which files can you analyze by using Azure Al Content Understanding?
Correct Answer: E
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You have a blog that allows users to append feedback comments. Some of the feedback comments contain harmful content that includes discriminatory language.
You need to create a prototype of a solution that will detect the harmful content. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to create a prototype of a solution that will detect the harmful content. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You are developing an application to recognize employees' faces by using the Face Recognition API. Images of the faces will be accessible from a URI endpoint.
The application has the following code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
The application has the following code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
A). True
B). True
C). True
B: see this example code from documentation that uses PersonGroup of size 10,000 :
https://docs.microsoft.com/en-us/azure/cognitive-services/face/face-api-how-to-topics/how-to-add-faces the question wants to trick you into thinking you need to use a LargePersonGroup for a size of 10,000 - but the documentation for it doesn ' t include this limitation or criteria: https://docs.microsoft.com/en-us/azure
/cognitive-services/face/face-api-how-to-topics/how-to-use-large-scale
Reference:
https://docs.microsoft.com/en-us/azure/cognitive-services/face/face-api-how-to-topics/use-persondirectory
You have an Azure subscription.
You are building a social media app that will enable users to share images.
You need to ensure that inappropriate content uploaded by the users is blocked. The solution must minimize development effort.
What are two tools that you can use? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.
You are building a social media app that will enable users to share images.
You need to ensure that inappropriate content uploaded by the users is blocked. The solution must minimize development effort.
What are two tools that you can use? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.
Correct Answer: B,C
Vote an answer
You are building a solution that will detect anomalies in sensor data from the previous 24 hours.
You need to ensure that the solution scans the entire dataset, at the same time, for anomalies.
Which type of detection should you use?
You need to ensure that the solution scans the entire dataset, at the same time, for anomalies.
Which type of detection should you use?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You are building an image sharing app that will use Azure AI to prevent users from sharing sexually explicit images.
You need to ensure that inappropriate images are identified correctly. The solution must minimize development effort.
What should you use?
You need to ensure that inappropriate images are identified correctly. The solution must minimize development effort.
What should you use?
Correct Answer: C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
