Azure Databricks and Azure Synapse Analytics
Question
You have an on-premises application named App1 that uses an Oracle database.
You plan to use Azure Databricks to transform and load data from App1 to an Azure Synapse Analytics 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.BD
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 on-premises App1 data is available to Azure Databricks for transformation and loading into Azure Synapse Analytics, you need to include two Azure services in the solution:
Azure Data Factory: Azure Data Factory (ADF) is a cloud-based data integration service that enables you to create, schedule, and orchestrate ETL/ELT workflows at scale. You can use ADF to copy data from on-premises data sources, such as App1's Oracle database, to cloud-based storage or data processing services, such as Azure Data Lake Storage or Azure Synapse Analytics. ADF supports a range of data sources and destinations, including on-premises and cloud-based systems, and provides built-in connectors for common data stores, including Oracle Database. By using ADF, you can create a pipeline that extracts data from App1's Oracle database and loads it into Azure Data Lake Storage or Azure Synapse Analytics, where it can be processed by Azure Databricks.
Azure Data Lake Storage: Azure Data Lake Storage (ADLS) is a cloud-based storage service that enables you to store and analyze large amounts of data at scale. ADLS is designed for big data workloads and provides a hierarchical namespace that can store data in various formats, such as Parquet, ORC, and CSV. ADLS integrates with other Azure services, such as Azure Databricks and Azure Synapse Analytics, and supports the Azure Blob storage interface, making it easy to move data between ADLS and other Azure services. By using ADLS, you can store App1's data in the cloud, where it can be accessed by Azure Databricks for transformation and loading into Azure Synapse Analytics.
Therefore, the correct answers are:
- D. Azure Data Factory
- B. Azure Data Lake Storage
