Exam PL-200 topic 5 question 35 discussion

Actual exam question from Microsoft's PL-200

Question #: 35
Topic #: 5

HOTSPOT
-

A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data.

The company requires that the contacts be added to Dataverse automatically every day.

You need to identify which tools are required to create and perform the import.

What should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by StewartCooke at Oct. 17, 2023, 9:16 a.m.

Comments

Submit Cancel

33a7f9e

10 months, 1 week ago

Create the import: B. Dataflow: Dataflows are designed to extract, transform, and load data from various sources, including Excel files, into Dataverse. Perform the import: D. Power Query: Power Query is used within dataflows to connect to the Excel file, transform the data as needed, and load it into Dataverse.

upvoted 4 times

...

jkaur

1 year, 4 months ago

dataflow Power Query

upvoted 4 times

...

Sweden2022

1 year, 7 months ago

I think the given answer is correct. Dataflow: Dataflows enable you to ingest, transform, and load data into Dataverse. They can be created using Power Query, Power Apps, Power BI, and other Power Platform services. Dataflows allow you to automate the import process and ensure that the contacts are added to Dataverse automatically every day

upvoted 3 times

...

Joey444

1 year, 9 months ago

These are the correct answers: Import From Excel Power Query When importing form excel, you can add refresh automatically settings in order for it to run once a day. While adding the excel file, you will use Power Query.

upvoted 1 times

ammu12345

7 months, 1 week ago

Import from excel is a daily activity, so data flow is apt

upvoted 1 times

...

BewiseExams

1 year, 9 months ago

How will it be performed automatically if it's "Import from Excel" ?

upvoted 2 times

...

StewartCooke

1 year, 10 months ago

S.O.S , save this soul help me with this question!

upvoted 1 times

JohnChung

1 year, 7 months ago

See this link. It says that you can get data from Excel files to Dataverse automatically on a schedule by using dataflow Power Query is used to perform the import https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

upvoted 6 times

...