Exam PL-500 topic 2 question 35 discussion

Actual exam question from Microsoft's PL-500

Question #: 29
Topic #: 2

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?

A. Run Excel macro action.
B. Get selected cell range from Excel worksheet action.
C. Run VBScript action.
D. Run script action.
E. Read from Excel worksheet action.

Show Suggested Answer

Suggested Answer: E 🗳️

by c2b1c40 at April 17, 2024, 10:53 a.m.

Comments

Submit Cancel

BP_Bot1

3 months, 3 weeks ago

Selected Answer: E

Correct

upvoted 2 times

...

DigiTransformer

4 months, 2 weeks ago

This article makes me think it could be D. Run script action - https://learn.microsoft.com/en-us/office/dev/scripts/develop/use-json

upvoted 3 times

...

c2b1c40

5 months ago

I would recommend option A. Run Excel macro action. Excel macros can be used to automate repetitive tasks and complex workflows in Excel. In this case, you could create a macro that reads the data from the Excel file, converts it into JSON format, and then saves it. This JSON file can then be used for the bulk upload to the CRM system

upvoted 2 times

...

Exam PL-500 All Questions

View all questions & answers for the PL-500 exam

Exam PL-500 topic 2 question 35 discussion

Comments

BP_Bot1

DigiTransformer

c2b1c40

SY0-701