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

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam
Go to Exam

Exam DP-900 topic 1 question 168 discussion

Actual exam question from Microsoft's DP-900
Question #: 168
Topic #: 1
[All DP-900 Questions]

DRAG DROP -
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Azure Data factory -
Relevant Azure service for the three ETL phases are Azure Data Factory and SQL Server Integration Services (SSIS).

Box 2: Azure Synapse Analytics -
You can copy and transform data in Azure Synapse Analytics by using Azure Data Factory
Note: Azure Synapse Analytics connector is supported for the following activities:
✑ Copy activity with supported source/sink matrix table
✑ Mapping data flow
✑ Lookup activity
✑ GetMetadata activity
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse
by hmAZtime at April 7, 2021, 2:53 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
[Removed]
Highly Voted 3 years, 3 months ago
At first I thought it could be both Cosmos and Synapse. But reading again; they're asking for a datawarehouse, not a database, so that leaves Synapse as the only suitable solution.
upvoted 22 times
Yomzie
8 months ago
Cosmos DB is already part of the Data Source. Azure Data Factory extracts, cleans, and present the data for storage & analysis. Azure Synapse Analytics does the analytics.
upvoted 1 times
...
rajat7878
2 years, 8 months ago
Given answer is absolutely correct.
upvoted 3 times
...
...
mamahani
Highly Voted 1 year, 6 months ago
I took the exam 12.04.2023; this question appeared,correct answer Azure Data Factory / Azure Synapse Analytics
upvoted 6 times
...
tahsinet
Most Recent 1 year, 7 months ago
azure data factory - azure synapse analytics
upvoted 2 times
...
AVP_Riga
3 years, 4 months ago
Why Synapse is used for data warehousing there? As I understand Synapse is for Analitics...
upvoted 6 times
jerkyflexoff
3 years, 4 months ago
its a replacement all in one OLAP (Data Warehouse) for SSAS. MS have felt the need to rebrand stuff for the shiny cloud replacement.
upvoted 5 times
...
Chaos2807
2 years, 5 months ago
Azure Synapse Analytics (formerly Datawarehouse) this Azure service can be used for datawarehousing
upvoted 4 times
...
Ihueghian
3 years, 4 months ago
I don't get it either
upvoted 2 times
Ihueghian
3 years, 4 months ago
Maybe because of this: "Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage, and serve data for immediate BI and machine learning needs."
upvoted 3 times
...
...
...
Sanketsarfare
3 years, 4 months ago
Correct Answer
upvoted 6 times
...
hmAZtime
3 years, 6 months ago
Agree with the answer. Data Factory process the data from different sources by ETL, output data to Synapse for DWHS.
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