Microsoft Exam PL-500 Topic 7 Question 27 Discussion

Actual exam question for Microsoft's PL-500 exam

Question #: 27
Topic #: 7

[All PL-500 Questions]

A list of accounts pending payment is generated from SAP as a Microsoft Excel file on a local machine.

Data must be converted into JSON format for a bulk upload to a customer relationship management (CRM) system.

You need to recommend a solution.

Which solution should you recommend?

ARun script action.

BGet selected cell range from Excel worksheet action.

CRun Excel macro action.

DRun VBScript action.

ERead from Excel worksheet action.

Show Suggested Answer

Suggested Answer: C

by Natalie at Sep 01, 2023, 04:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

8 days ago

E) Read from Excel worksheet action - that's the way to go! Converts the data straight from the Excel file into JSON format.

upvoted 0 times

...

15 days ago

I'm not sure about option E). I think option C) Run Excel macro action could also work well for this task.

upvoted 0 times

...

16 days ago

I agree with Lucina. Option E) seems like the best solution for converting the data into JSON format.

upvoted 0 times

...

17 days ago

I think we should recommend option E) Read from Excel worksheet action.

upvoted 0 times

...