Hotspot Question Your company, named Contoso, Ltd., has an Azure subscription that contains the following resources: - An Azure Synapse Analytics workspace named contosoworkspace1 - An Azure Data…

This question tests knowledge of Azure data integration services and Azure Synapse Analytics sharing capabilities to meet specific requirements for data upload/transformation and restricted partner access.

Submitted by haruto_sh· Mar 6, 2026Design data storage solutions

Question

Hotspot Question Your company, named Contoso, Ltd., has an Azure subscription that contains the following resources: - An Azure Synapse Analytics workspace named contosoworkspace1 - An Azure Data Lake Storage account named contosolake1 - An Azure SQL database named contososql1 The product data of Contoso is copied from contososql1 to contosolake1. Contoso has a partner company named Fabrikam Inc. Fabrikam has an Azure subscription that contains the following resources: - A virtual machine named FabrikamVM1 that runs Microsoft SQL Server 2019 - An Azure Storage account named fabrikamsa1 Contoso plans to upload the research data on FabrikamVM1 to contosolake1. During the upload, the research data must be transformed to the data formats used by Contoso. The data in contosolake1 will be analyzed by using contosoworkspace1. You need to recommend a solution that meets the following requirements: - Upload and transform the FabrikamVM1 research data. - Provide Fabrikam with restricted access to snapshots of the data in contosoworkspace1. What should you recommend for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:

Exhibit

Answer Area

Upload and transform the data:
Azure Data Box GatewayAzure Data ShareAzure Synapse pipelines
Provide restricted access:
Azure Data Box GatewayAzure Data ShareAzure Synapse pipelines

Explanation

Approach. For uploading and transforming FabrikamVM1 research data to contosolake1, the correct recommendation is Azure Data Factory (ADF) with a Self-hosted Integration Runtime (SHIR). The SHIR is installed on FabrikamVM1 (or on a machine that can access it) to securely connect the on-premises/VM SQL Server to the cloud, while ADF pipelines handle the transformation to Contoso's data formats during the copy activity. For providing Fabrikam with restricted access to snapshots of data in contosoworkspace1, the correct recommendation is Azure Synapse Analytics Shared Datasets (using Azure Purview or specifically the Azure Synapse Share / Microsoft Purview Data Sharing feature). This allows Contoso to share specific dataset snapshots with Fabrikam's Azure subscription in a controlled, read-only manner without giving broad access to the workspace itself.

Concept tested. The core concepts tested are: (1) Azure Data Factory Self-hosted Integration Runtime as the mechanism to connect to VMs running SQL Server outside the Azure network for data ingestion and transformation, and (2) Azure Synapse Analytics data sharing capabilities (such as Azure Synapse Share or in-place/snapshot sharing) to provide external partners with restricted, governed access to analytical data snapshots without full workspace access.

Reference. https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime | https://learn.microsoft.com/en-us/azure/synapse-analytics/share-with-data-explorer

Topics

#Azure Synapse pipelines#Azure Data Share#cross-organization data sharing#data transformation

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice