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

Exam DP-700 All Questions

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

Exam DP-700 topic 1 question 3 discussion

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

You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

  • A. a Dataflow Gen1 dataflow
  • B. a data pipeline
  • C. a KQL queryset
  • D. a notebook
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Tuki93 at Dec. 8, 2024, 4:33 p.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
robertlavigne
Highly Voted 6 months, 3 weeks ago
Selected Answer: B
B. Notebooks can’t go through a gateway, KQL isn’t appropriate for a sql db. Gen1 dataflows are deprecated. Data pipelines work through a datagateway and are fast
upvoted 12 times
...
ogbenisho
Most Recent 1 month, 3 weeks ago
Selected Answer: B
Copy data is meant to ingest data from source systems to Landing zone (Bronze layer/ Raw Layer). Copy data is a capacity from Data Pipeline.
upvoted 1 times
...
Wipag
1 month, 3 weeks ago
Selected Answer: B
Purpose-built for orchestrating data movement. Supports Copy Data activity, which works with: On-prem SQL Server via gateway Fabric warehouse as a sink Provides scheduling, retries, logging, etc. Correct and most robust solution in Fabric for this task.
upvoted 1 times
...
DarioReymago
2 months ago
Selected Answer: B
is correct
upvoted 1 times
...
Danielnimi
2 months, 1 week ago
Selected Answer: B
The pipeline in Fabric works same way as pipeline n Data Dactory. It supports the use of self-hosted Integrated Runtime (IR) which is used to establish connection between a private network (on-prem) and Azure cloud.
upvoted 1 times
...
sesav4742
3 months, 4 weeks ago
Selected Answer: B
A data pipeline, since it has the "Copy data" activity, the most efficient way to copy data into fabric when there are no transformations to be done
upvoted 3 times
...
CMDev
4 months, 2 weeks ago
Selected Answer: B
It says, you need to copy data, dont specify if we need to do some transformations. In this case, a data pipeline with an activity "copy data" is enough and the best choice in terms of efficency and minimal effort. Check this link: https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-pipeline-dataflow-spark
upvoted 1 times
...
arunmewada
5 months ago
Selected Answer: B
I attempted to use a **data pipeline** to load data directly from **on-premises** to the **warehouse**, but since the warehouse does not support external sources, I first loaded the data into a **Lakehouse** and then moved it to the **warehouse**.
upvoted 1 times
arunmewada
5 months ago
answer is A
upvoted 2 times
...
...
mmanrik
6 months, 4 weeks ago
Selected Answer: B
A data pipeline, since it has the "Copy data" activity, the most efficient way to copy data into fabric when there are no transformations to be done (if there are a Dataflow Gen 2 might be better, depends on the amount of data to be copied).
upvoted 2 times
...
QAZdbarhate12345678
8 months ago
Selected Answer: B
• In this case, a data pipeline can be used to transfer data from Database1 (the SQL Server database) to Warehouse1 (in the Fabric workspace).
upvoted 3 times
...
Tuki93
8 months ago
Selected Answer: B
Dataflow Gen 1 is deprecated.
upvoted 2 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