Exam AI-100 topic 4 question 26 discussion

Actual exam question from Microsoft's AI-100

Question #: 26
Topic #: 4

You are building an Azure Analysis Services cube for your AI deployment.
The source data for the cube is located in an on premises network in a Microsoft SQL Server database.
You need to ensure that the Azure Analysis Services service can access the source data.
What should you deploy to your Azure subscription?

A. a site-to-site VPN
B. a data gateway
C. Azure Data Factory
D. a network gateway

Show Suggested Answer

Suggested Answer: B 🗳️
From April 2017 onward we can use On-premises Data Gateway for Azure Analysis Services. This means you can connect your Tabular Models hosted in Azure
Analysis Services to your on-premises data sources through On-premises Data Gateway.

References:
https://biinsight.com/on-premises-data-gateway-for-azure-analysis-services/

by CodeAnant at Aug. 31, 2019, 5:59 a.m.

Comments

Submit Cancel

ari_ira

Highly Voted 5 years, 6 months ago

I think B is correct https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway

upvoted 11 times

princesskay

5 years, 1 month ago

I agree its is B.

upvoted 5 times

...

rveney

Most Recent 1 year, 11 months ago

You should deploy an On-premises data gateway to your Azure subscription to ensure that the Azure Analysis Services service can access the source data. An On-premises data gateway is required when an Azure Analysis Services server in the cloud needs to connect to on-premises data sources. The gateway provides secure data transfer between on-premises data sources and your Azure Analysis Services servers in the cloud. You can install and configure an On-premises data gateway to connect to on-premises data sources from an Azure Analysis Services server. You can download and install the gateway on a computer in your organization, register the gateway with the Gateway Cloud Service, create a gateway resource in Azure, and connect the gateway resource to servers. You can configure the AlwaysUseGateway server property to specify the server resource to access all data sources through an On-premises data gateway. You can also configure the gateway to use a proxy server if necessary

upvoted 1 times

...

AlfuryDB

4 years, 2 months ago

This one is quite straightforward. Let me explain: A) is it possible? yes of course but do we need it? 1 simple service, do you want to get into ExpressRoute or S2S VPNs configurations? there must be something simpler. C) The main reason of ADF is to orchestrate and offer a platform for integration purposes but are we talking about on-premises integration or with? https://docs.microsoft.com/en-us/azure/data-factory/#:~:text=Azure%20Data%20Factory%20is%20Azure's,with%20full%20compatibility%20in%20ADF. D) This solution alone does not do anything here without configuring the rest of the components. Therefore data gateway helps with this scenario. It's a simple way to connect an on-premises service with the cloud. Are there others? Yes, and with different flavours (e.g. azure relay from a different angle). However, the solution is more simplistic with data gateway. This can be done in 4 steps: https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway

upvoted 1 times

...