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

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

Suggested Answer: B 🗳️

by Tuki93 at Dec. 8, 2024, 4:33 p.m.

Comments

Submit Cancel

robertlavigne

Highly Voted 5 months 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 10 times

...

ogbenisho

Most Recent 1 week 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 week, 2 days 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 weeks, 3 days ago

Selected Answer: B

is correct

upvoted 1 times

...

Danielnimi

3 weeks, 2 days 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

2 months, 1 week 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

3 months 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

3 months, 1 week 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

3 months, 1 week ago

answer is A

upvoted 2 times

...

mmanrik

5 months, 1 week 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

6 months, 2 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

6 months, 2 weeks ago

Selected Answer: B

Dataflow Gen 1 is deprecated.

upvoted 2 times

...