ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 2 question 35 discussion

Actual exam question from Microsoft's AZ-305
Question #: 35
Topic #: 2
[All AZ-305 Questions]

HOTSPOT
-

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.

Show Suggested Answer Hide Answer
Suggested Answer:
by mykola_yakovliev at Oct. 6, 2023, 9:22 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mykola_yakovliev
Highly Voted 1 year, 4 months ago
Provided answers look correct. For ETL operations use Azure Data Factory and Azure Synapse Pipelines are based on Azure Data Factory. Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences For restricted access use Azure Data Share: Azure Data Share enables organizations to securely share data with multiple customers and partners. Data providers are always in control of the data that they've shared and Azure Data Share makes it simple to manage and monitor what data was shared, when and by whom. In this case snapshot-based sharing should be used. Source: https://learn.microsoft.com/en-us/azure/data-share/overview
upvoted 20 times
...
jcxxxxx2020
Highly Voted 1 year, 2 months ago
This question appeared on my exam today. Answer is correct
upvoted 13 times
...
[Removed]
Most Recent 3 months, 3 weeks ago
CORRECT
upvoted 2 times
...
Teerawee
5 months, 3 weeks ago
-Azure Synapse pipelines -Azure Data Share
upvoted 1 times
...
23169fd
8 months, 1 week ago
The given answer is correct. Azure Synapse pipelines: They allow you to orchestrate data movement and transformation efficiently, integrating well with other Azure services. Azure Data Share: Provides a secure way to share data snapshots with restricted access, ensuring Fabrikam has controlled and read-only access to the necessary data.
upvoted 1 times
...
RanOlfati
11 months, 2 weeks ago
Data Warehouse Layer: Use Azure Synapse Analytics (formerly known as Azure SQL Data Warehouse). Managed Serving Layer for OLAP: Use Azure Analysis Services. Azure Analysis Services is an enterprise-grade analytics engine that provides a managed OLAP database for running and serving complex analytical models.
upvoted 1 times
...
eduardobbs
12 months ago
Got his on my exam on 06/Mar/24
upvoted 10 times
...
StixxNSnares
1 year, 3 months ago
Azure synapse pipelines - Azure Synapse Pipelines is a cloud-based data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and data transformation https://www.sqlshack.com/export-data-from-azure-sql-database-to-azure-data-lake-storage/ Azure Data Share - Azure Data Share is a simple and safe service for sharing big data with external organizations2. It allows you to easily share data with other organizations, and it provides capabilities to ensure that only authorized users have access to the shared data. https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-set-up-access-control
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago