Exam PL-600 topic 3 question 26 discussion

Actual exam question from Microsoft's PL-600

Question #: 26
Topic #: 3

A company plans to import 2.5 million data rows into Microsoft Dataverse during a go-live process. The import job will run as a single import job.

You run a test on the import and observe that some of the rows did not import.

You need to identify which rows did not import.

Which tool should you use?

A. Azure Event Hub
B. Import Data Wizard
C. Microsoft Power Platform dataflows
D. Azure Service Bus

Show Suggested Answer

Suggested Answer: C 🗳️

by 967d27a at April 23, 2024, 10:07 p.m.

Comments

Submit Cancel

MLeniger

3 days, 10 hours ago

Selected Answer: B

The correct answer is: B. Import Data Wizard Here's why: When importing data into Microsoft Dataverse, especially during a go-live process, the Import Data Wizard is the appropriate tool to: Track the status of the import job. Identify failed rows and view detailed error messages. Download error logs to analyze and correct issues in the data. Why not the others? A. Azure Event Hub: This is used for streaming large volumes of data, typically for telemetry or logging—not for importing data into Dataverse. C. Microsoft Power Platform dataflows: These are used for scheduled or recurring data ingestion and transformation, not for one-time bulk imports. D. Azure Service Bus: This is a messaging service used for decoupling applications and services—not for data import tracking.

upvoted 1 times

...

loftuscheek

2 months ago

Selected Answer: B

Answer is B , "single import job" no need for dataflow After running an import job using the Import Data Wizard in Microsoft Power Platform, the tool provides a summary of the import process. This summary typically includes: The total number of records attempted. The number of records successfully imported. A log file or list detailing the records that failed to import, along with the reason for the failure.

upvoted 1 times

loftuscheek

2 months ago

in MS docs its recommended for under 20k rows so answer is C

upvoted 1 times

...

MercuryOne

5 months, 3 weeks ago

Selected Answer: C

I would choose C even if Import Data Wizard is a better toll to view logs, error. The recommended no of rows for Import Data Wizard is20K rows or fewer but it can also import 2.5 million https://learn.microsoft.com/en-us/power-platform/admin/import-data-all-record-types

upvoted 2 times

...

uberlord

7 months, 1 week ago

Selected Answer: C

The Import Data Wizard in Microsoft Dataverse has a limit of 1 million rows per import job. Since you're looking to import 2.5 million rows in a single job, this would exceed that limit. In this case, you may need to break the data into smaller batches or consider using C. Microsoft Power Platform dataflows. Dataflows can handle larger datasets and allow for more efficient imports while providing better error handling and monitoring capabilities.

upvoted 4 times

...