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 3 months, 2 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 9 times
...
sesav4742
Most Recent 3 weeks, 1 day 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 1 times
...
CMDev
1 month, 1 week 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
1 month, 3 weeks 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
1 month, 3 weeks ago
answer is A
upvoted 2 times
...
...
mmanrik
3 months, 3 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
4 months, 3 weeks 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
4 months, 3 weeks 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago