Answer-first summary for fast verification
Answer: 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.
Option A is the correct answer because Azure Data Factory provides a comprehensive, serverless data integration service that can handle both batch and real-time data processing. Its integration with Azure Purview ensures GDPR compliance, and the option to use Azure Databricks for complex transformations offers flexibility. This solution meets all the given requirements effectively. Option B is incorrect because relying solely on Azure Databricks does not provide built-in GDPR compliance features and may not be the most cost-effective solution for all scenarios. Option C is incorrect as it ignores GDPR compliance and does not leverage Azure Data Factory's orchestration capabilities. Option D is incorrect because custom scripts are not scalable or reliable for enterprise-level data integration and transformation tasks, and manual GDPR compliance is error-prone.
Author: LeetQuiz Editorial Team
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.
No comments yet.