exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 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 🗳️

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
robertlavigne
Highly Voted 1 month, 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 7 times
...
arunmewada
Most Recent 21 hours, 32 minutes 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
21 hours, 27 minutes ago
answer is A
upvoted 1 times
...
...
mmanrik
1 month, 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 1 times
...
QAZdbarhate12345678
3 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
3 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago