
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with designing a data integration and transformation solution for a multinational corporation. The corporation's data landscape includes a mix of on-premises SQL Server databases, Azure Cosmos DB for NoSQL data, and Azure Blob Storage for file-based data. The solution must comply with GDPR, support real-time data processing for some sources, and batch processing for others, all while minimizing costs. Which of the following solutions best meets these requirements? (Choose one option)
A
Implement Azure Data Factory to orchestrate and execute data movement and transformation across all data sources, utilizing its integration with Azure Purview for GDPR compliance, and Azure Databricks for complex transformations when needed.
B
Use Azure Databricks exclusively for all data processing needs, leveraging its ability to handle both batch and real-time data processing, and integrate directly with Azure Blob Storage and Azure Cosmos DB without additional services.
C
Deploy Azure Stream Analytics for real-time data processing and Azure Batch for batch processing, storing all processed data in Azure SQL Database for unified access, ignoring the need for GDPR compliance tools.
D
Create custom scripts using Azure Functions to move and transform data between sources and destinations, manually ensuring GDPR compliance and handling both real-time and batch processing within the same functions.