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: D 🗳️

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

Comments

Submit Cancel

DigiTransformer

Highly Voted 9 months, 1 week 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 5 times

...

Acrious

Most Recent 2 weeks, 5 days ago

Selected Answer: D

Your goal is to convert it into JSON that is not going to happen simply by reading the values.

upvoted 1 times

...

sugaSri

4 months, 2 weeks ago

Selected Answer: D

For your specific requirement of converting Excel data into JSON format for a bulk upload to a CRM system, the "Run script" action (D) is more suitable. It offers the flexibility and control needed to perform the data conversion accurately.

upvoted 2 times

...

BP_Bot1

8 months, 2 weeks ago

Selected Answer: E

Correct

upvoted 2 times

Acrious

2 weeks, 3 days ago

reading the values does nothing to it, it needs to be converted, which you do in a Script so D

upvoted 1 times

...

c2b1c40

9 months, 3 weeks 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

...