
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with designing a data sharing strategy for an organization with multiple departments. The strategy must ensure data security, compliance with industry standards, and efficient access to data from various sources. The organization is looking for a solution that not only consolidates data but also facilitates collaboration and analysis across departments. Considering the need for scalability, cost-effectiveness, and the ability to handle real-time data processing, which of the following solutions would BEST meet these requirements? (Choose one option)
A
Deploy separate Azure Data Lake Storage Gen2 accounts for each department, implementing strict access controls to ensure data is only accessible to authorized users within each department.
B
Implement a centralized Azure Data Lakehouse that aggregates data from all sources, using Azure Active Directory for fine-grained access control, but without integrating analytics tools for cross-departmental collaboration.
C
Utilize Azure Data Factory to orchestrate data movement from various sources into a centralized Azure SQL Data Warehouse, enabling users to access data via Power BI for analysis, but lacking real-time data processing capabilities.
D
Leverage Azure Synapse Analytics to create a unified analytics platform that integrates data warehousing, big data analytics, and data integration, enabling secure data sharing, real-time processing, and collaborative analysis across the organization.