Azure Databricks and Azure SQL Data Warehouse
Question
You have an on-premises application named App1 that uses an Oracle database.
You plan to use Azure Databricks to load data from App1 to an Azure SQL Data Warehouse instance.
You need to ensure that the App1 data is available to Databricks.
Which two Azure services should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.DE
Automate data movement using Azure Data Factory, then load data into Azure Data Lake Storage, transform and clean it using Azure Databricks, and make it available for analytics using Azure Synapse Analytics. Modernize your data warehouse in the cloud for unmatched levels of
Note: Integrate data silos with Azure Data Factory, a service built for all data integration needs and skill levels. Easily construct ETL and ELT processes code-free within the intuitive visual environment, or write your own code. Visually integrate data sources using more than 90+ natively built and maintenance-free connectors at no added cost. Focus on your data""the serverless integration service does the rest.
https://azure.microsoft.com/en-us/services/databricks/#capabilities https://azure.microsoft.com/en-us/services/data-factory/To ensure that the data from the on-premises App1 application is available to Azure Databricks, you need to use the Azure Data Factory and Azure Data Box Edge services.
Azure Data Factory (ADF) is a cloud-based integration service that enables you to create, schedule, and orchestrate data integration and data transformation workflows between on-premises and cloud-based data stores. ADF supports a wide range of data sources, including on-premises databases like Oracle, and can be used to transfer data from these sources to Azure SQL Data Warehouse.
Azure Data Box Edge is an appliance that can be deployed on-premises or in a remote location to provide a local gateway for data ingestion and processing. It has built-in compute and storage capabilities and can be used to transfer data between on-premises data sources and Azure services like Azure SQL Data Warehouse. In this scenario, you can use Azure Data Box Edge to extract data from the on-premises Oracle database and transfer it to Azure SQL Data Warehouse via ADF.
Azure Import/Export service and Azure Data Box Gateway are not relevant to this scenario, as they are used to transfer data to Azure Storage, not Azure SQL Data Warehouse.
Azure Data Lake Storage is not relevant to this scenario, as it is a cloud-based storage service for big data analytics workloads, and is not used for data ingestion and processing.
Therefore, the correct answers are E (Azure Data Factory) and C (Azure Data Box Edge).
