XYZ company is moving its data services to azure as part of cloud adoption.
Currently, there is data which is existing in the on-prem network.
You are planning to use the HTTP connector method for copying this data.You plan to retrieve data from an HTTP/S endpoint by using the HTTP GET or POST methods.
Which of the following options is best suited?
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: A.
There are few main points in this question which we need to focus on to identify the exact answer.
The first one is about the choice of connector used.
The HTTP connect method is used here to copy data.
Unlike Rest connector or Web Table connecter, it helps download data from any HTTP endpoint.Currently, Azure Database for MariaDB is not supported in the case of sink used, but Azure blob storage is supported.
Secondly, the question says that the datastore is in the on-prem network.
So, we will need a self-hosted integration runtime to connect to it.
Option A is correct: Azure blob storage is a supported sink, and Self-hosted integration runtime is required to connect data store in on-prem network.
Options B, C, D are incorrect: Azure Database for MariaDB is not a supported sink in the case of HTTP connecter.
Azure integration runtime is wrong since it is used if the datastore is a managed cloud data service.
To know more, please refer to the docs below:
When moving data from an on-premises network to Azure, the HTTP connector method can be used to retrieve data from an HTTP/S endpoint using the HTTP GET or POST methods. However, to transfer data using this method, an Integration Runtime (IR) is required.
In this scenario, there are two types of Integration Runtimes that can be used: Self-hosted Integration Runtime (SHIR) and Azure Integration Runtime (AIR).
A Self-hosted Integration Runtime is installed on a virtual machine or on-premises server within the on-premises network. This type of Integration Runtime is used to transfer data between an on-premises data source and an Azure destination.
An Azure Integration Runtime is a fully-managed service provided by Azure that can be used to transfer data between different data stores, regardless of their location.
Regarding the options provided in the question:
Option A suggests using a self-hosted Integration Runtime with Azure Blob storage as the sink. This option is a good choice if the data is not in a structured format, as Azure Blob storage is a cost-effective solution for storing unstructured data such as images, videos, and log files. However, if the data is in a structured format, then using Azure Blob storage may not be the best option.
Option B suggests using a self-hosted Integration Runtime with Azure Database for MariaDB as the sink. This option is a good choice if the data is in a structured format and if the data needs to be stored in a relational database management system (RDBMS). However, if the data is not in a structured format, then using Azure Database for MariaDB may not be the best option.
Option C suggests using an Azure Integration Runtime with Azure Blob storage as the sink. This option is a good choice if the data is not in a structured format and if cost-effectiveness is a priority. Azure Blob storage can be used to store large amounts of unstructured data at a low cost. However, if the data is in a structured format, then using Azure Blob storage may not be the best option.
Option D suggests using an Azure Integration Runtime with Azure Database for MariaDB as the sink. This option is a good choice if the data is in a structured format and if the data needs to be stored in an RDBMS. However, if the data is not in a structured format, then using Azure Database for MariaDB may not be the best option.
In conclusion, the best option for transferring data using the HTTP connector method depends on the nature of the data. If the data is unstructured and cost-effectiveness is a priority, then Option C, Azure Integration Runtime with Azure Blob storage as the sink, is the best choice. If the data is structured and needs to be stored in an RDBMS, then Option D, Azure Integration Runtime with Azure Database for MariaDB as the sink, is the best choice.