Home / Microsoft / AI-102

Microsoft AI-102 Practice Test - Questions Answers, Page 14

Question list

List of questions

Question 131

(0)

HOTSPOT Select the answer that correctly completes the sentence.

Question 132

(0)

Which statement is an example of Data Manipulation Language (DML)?

Question 133

(0)

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

Question 134

(0)

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

Question 135

(0)

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selecti

Question 136

(0)

You have data saved in the following format. Which format was used?

Question 137

(0)

What is a primary characteristic of a relational database?

Question 138

(0)

What ate two uses of data visualization? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Question 139

(0)

What should you use to build a Microsoft Power Bi paginated report?

Question 140

(0)

Which scenario is an example of a streaming workload?

Related questions

HOTSPOT You develop a test method to verify the results retrieved from a call to the Computer Vision API. The call is used to analyze the existence of company logos in images. The call returns a collection of brands named brands. You have the following code segment. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

You have an app that analyzes images by using the Computer Vision API. You need to configure the app to provide an output for users who are vision impaired. The solution must provide the output in complete sentences. Which API call should you perform?

HOTSPOT You are building an app by using the Speech SDK. The app will translate speech from French to German by using natural language processing. You need to define the source language and the output language. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

DRAG DROP You are developing a webpage that will use the Video Indexer service to display videos of internal company meetings. You embed the Player widget and the Cognitive Insights widget into the page. You need to configure the widgets to meet the following requirements: Ensure that users can search for keywords. Display the names and faces of people in the video. Show captions in the video in English (United States). How should you complete the URL for each widget? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

You are developing a method that uses the Computer Vision client library. The method will perform optical character recognition (OCR) in images. The method has the following code. During testing, you discover that the call to the GetReadResultAsync method occurs before the read operation is complete. You need to prevent the GetReadResultAsync method from proceeding until the read operation is complete. Which two actions should you perform? Each correct answer presents part of the solution. (Choose two.) NOTE: Each correct selection is worth one point.

You have a Language service resource that performs the following: • Sentiment analysis • Named Entity Recognition (NER) • Personally Identifiable Information (Pll) identification You need to prevent the resource from persisting input data once the data is analyzed. Which query parameter in the Language service API should you configure?

DRAG DROP You have a monitoring solution that uses the Azure Al Anomaly Detector service. You provision a server named Server! that has intermittent internet access. You need to deploy the Azure Al Anomaly Detector to Server 1. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You have a Video Indexer service that is used to provide a search interface over company videos on your company's website. You need to be able to search for videos based on who is present in the video. What should you do?

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 have a chatbot that uses question answering in Azure Cognitive Service for Language Users report that the responses of the chatbot lark formality when answering spurious questions You need to ensure that the chatbot provides formal responses to spurious questions. Solution: From Language Studio, you change the chitchat source to qna_chitchit_friindly.tsv. and then retrain and republish the model. Does this meet the goal?

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 have a chatbot that uses question answering in Azure Cognitive Service for Language Users report that the responses of the chatbot lack formality when answering spurious questions You need to ensure that the chatbot provides formal responses to spurious questions. Solution: From Language Studio, you change the chitchat source to qna_chitchat_professional.tsv. and then retrain and republish the model. Does this meet the goal?

Question 131

HOTSPOT

Select the answer that correctly completes the sentence.

Show Answer Comment (0)

Question 132

Which statement is an example of Data Manipulation Language (DML)?

Revoke

UPDATE

DROP

CREATE

Show Answer Comment (0)

Question 133

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

SQL Server on Azure Virtual Machines

Azure SOL Database

Azure HDInsight

Azure Cosmos DB

Show Answer Comment (0)

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?

an Index

a view

a scalar function

a table

Show Answer Comment (0)

Question 135

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection Is worth one point.

reduced administrative effort for managing the server infrastructure

complete control over backup and restore processes

in-database machine learning services S3

access to the latest features

Show Answer Comment (0)