Exam DP-200 topic 1 question 3 discussion

Actual exam question from Microsoft's DP-200

Question #: 3
Topic #: 1

You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations.
The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency.
You need to secure the transfer of data between on-premises databases and Microsoft Azure.
What should you do?

A. Install a standalone on-premises Azure data gateway at each location
B. Install an on-premises data gateway in personal mode at each location
C. Install an Azure on-premises data gateway at the primary location
D. Install an Azure on-premises data gateway as a cluster at each location

Show Suggested Answer

Suggested Answer: D 🗳️
You can create high availability clusters of On-premises data gateway installations, to ensure your organization can access on-premises data resources used in
Power BI reports and dashboards. Such clusters allow gateway administrators to group gateways to avoid single points of failure in accessing on-premises data resources. The Power BI service always uses the primary gateway in the cluster, unless it's not available. In that case, the service switches to the next gateway in the cluster, and so on.
References:
https://docs.microsoft.com/en-us/power-bi/service-gateway-high-availability-clusters

by Treadmill at May 31, 2020, 9:52 a.m.

Comments

Submit Cancel

Treadmill

Highly Voted 4 years, 11 months ago

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-high-availability-clusters

upvoted 9 times

...

chaoxes

Highly Voted 4 years, 5 months ago

D. Clusters is correct. The answer is ok.

upvoted 5 times

...

syu31svc

Most Recent 4 years, 5 months ago

D is correct

upvoted 2 times

...

uomer

4 years, 6 months ago

IGNORE MY EARLIER COMMENT, The answer is spark because SPARK has the functionality of INTERACTIVE QUERIES AS WELL. Spark In-memory processing, interactive queries, micro-batch stream processing https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hadoop-provision-linux-clusters

upvoted 1 times

...

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam