Secure Data Transfer between On-Premises Databases and Microsoft Azure
Question
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?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.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.
https://docs.microsoft.com/en-us/power-bi/service-gateway-high-availability-clustersTo secure the transfer of data between on-premises databases and Microsoft Azure, you can use Azure on-premises data gateway. Azure on-premises data gateway acts as a bridge between your on-premises data sources and cloud services such as Power BI and Logic Apps.
Option A suggests installing a standalone on-premises Azure data gateway at each location. This option is not optimal since installing a standalone on-premises Azure data gateway at each location can lead to a high cost and maintenance overhead. Also, it does not ensure high availability or fault tolerance.
Option B suggests installing an on-premises data gateway in personal mode at each location. Personal mode is a single-user mode for development and testing purposes. It is not recommended for production use since it does not support high availability or fault tolerance.
Option C suggests installing an Azure on-premises data gateway at the primary location. This option is better than option A and B since it reduces the installation and maintenance overhead. However, it does not ensure high availability or fault tolerance.
Option D suggests installing an Azure on-premises data gateway as a cluster at each location. This option is the best among all the options since it ensures high availability and fault tolerance. When you install the Azure on-premises data gateway as a cluster, you can configure multiple gateway instances to work together as a single entity. This configuration ensures that the solution can handle failover scenarios and minimize latency.
Therefore, the correct answer is option D: Install an Azure on-premises data gateway as a cluster at each location.
