Exam AI-100 topic 4 question 24 discussion

Actual exam question from Microsoft's AI-100

Question #: 24
Topic #: 4

You create an Azure Machine Learning Studio experiment.
You plan to publish the experiment as a Machine Learning Web service.
You need to ensure that you can consume the web service from Microsoft Excel spreadsheets.
What should you use?

A. a Batch Execution Service (BES) and an API key
B. a Batch Execution Service (BES) and an Azure managed identity
C. a Request-Response Service (RRS) and an Azure managed identity
D. a Request-Response Service (RRS) and an API key

Show Suggested Answer

Suggested Answer: D 🗳️
Steps to Add a New web service -
1. Deploy a web service or use an existing Web service.
2. Click Consume.
3. Look for the Basic consumption info section. Copy and save the Primary Key and the Request-Response URL.
4. In Excel, go to the Web Services section (if you are in the Predict section, click the back arrow to go to the list of web services).
5. Click Add Web Service.
6. Paste the URL into the Excel add-in text box labeled URL.
7. Paste the API/Primary key into the text box labeled API key.
8. Click Add.
References:
https://docs.microsoft.com/en-us/azure/machine-learning/studio/excel-add-in-for-web-services

by sayak17 at Sept. 24, 2020, 5:37 p.m.

Comments

Submit Cancel

rveney

2 years ago

You should use a Request-Response Service (RRS) and an API key to consume the web service from Microsoft Excel spreadsheets. You can create a Request-Response Service (RRS) endpoint for your Azure Machine Learning model and generate an API key to authenticate requests to the endpoint. You can then use the Excel Power Query add-in to connect to the RRS endpoint and retrieve predictions from your model. The add-in allows you to specify the API key and the input data for the model, and it returns the predictions as a table in Excel

upvoted 1 times

...

sayak17

4 years, 9 months ago

The Request-Response Service (RRS) template creates a web app that allows you to send a single row of data to the web service to get a single result. The Batch Execution Service (BES) template creates a web app that allows you to send many rows of data to get multiple results. https://github.com/uglide/azure-content/blob/master/articles/machine-learning/machine-learning-consume-web-service-with-web-app-template.md

upvoted 3 times

sayak17

4 years, 9 months ago

and this is the link showing rrs being used with API key in excel https://docs.microsoft.com/en-us/azure/machine-learning/classic/consuming-from-excel

upvoted 9 times

...