Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Vinnie
1 months ago
D) Run VBScript action - are we time-traveling back to the 90s or what? Let's keep it modern, folks!
upvoted 0 times
...
Moon
1 months ago
B) Get selected cell range from Excel worksheet action - now we're talking! Let's get that data converted in style.
upvoted 0 times
Tamesha
12 days ago
User 3: Let's go ahead and use that action to get the job done efficiently.
upvoted 0 times
...
Kris
13 days ago
User 2: Agreed, that sounds like the best solution for converting the data into JSON format.
upvoted 0 times
...
Antonette
14 days ago
User 1: I think we should go with option B) Get selected cell range from Excel worksheet action.
upvoted 0 times
...
...
Carlton
2 months ago
A) Run script action - what is this, a comedy show? We're trying to get work done here, not play mad scientist!
upvoted 0 times
Dana
18 days ago
C) Run Excel macro action.
upvoted 0 times
...
Alyce
21 days ago
E) Read from Excel worksheet action.
upvoted 0 times
...
Ryan
1 months ago
B) Get selected cell range from Excel worksheet action.
upvoted 0 times
...
...
Francine
2 months ago
C) Run Excel macro action - that's the most efficient way to get the job done. No need to reinvent the wheel!
upvoted 0 times
...
Truman
2 months 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
Kirby
1 months ago
A) Run script action could also work, but E) Read from Excel worksheet action seems more straightforward.
upvoted 0 times
...
Kirby
2 months 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
...
...
Fernanda
2 months 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
...
Krystina
2 months ago
I agree with Lucina. Option E) seems like the best solution for converting the data into JSON format.
upvoted 0 times
...
Lucina
3 months ago
I think we should recommend option E) Read from Excel worksheet action.
upvoted 0 times
...

Save Cancel