exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 4 discussion

Actual exam question from Microsoft's DP-700
Question #: 4
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. an Apache Spark job definition
  • B. a data pipeline
  • C. a Dataflow Gen1 dataflow
  • D. an eventstream
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 5 months, 2 weeks ago
Selected Answer: B
B. Notebooks and eventstreams can’t go through a gateway, . Gen1 dataflows are deprecated. Data pipelines work through a datagateway and are fast
upvoted 7 times
...
Wipag
Most Recent 2 weeks, 4 days ago
Selected Answer: B
You are copying data from: Source: On-premises SQL Server (Database1) Destination: A Microsoft Fabric warehouse (Warehouse1) Connectivity: Via on-premises data gateway You need a solution that: Supports copying structured data Can connect through a gateway Can write to a warehouse Supports scheduling, error handling, and data flow control
upvoted 1 times
...
DarioReymago
3 weeks, 5 days ago
Selected Answer: B
otra vez?
upvoted 1 times
...
sesav4742
2 months, 3 weeks ago
Selected Answer: B
B. Notebooks and eventstreams can’t go through a gateway, . Gen1 dataflows are deprecated. Data pipelines work through a datagateway and are fast
upvoted 1 times
...
sesav4742
2 months, 3 weeks ago
Selected Answer: B
Correct Answer is B
upvoted 1 times
...
MSka
3 months ago
Selected Answer: B
It’s B
upvoted 2 times
...
QAZdbarhate12345678
6 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 4 times
...
Tuki93
7 months ago
Selected Answer: B
Dataflow Gen 1 is deprecated.
upvoted 1 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 ...