MicrosoftMicrosoft
PL-500 · Question #160
PL-500 Question #160: Real Exam Question with Answer & Explanation
Sign in or unlock PL-500 to reveal the answer and full explanation for question #160. The question stem and answer options stay visible for context.
Develop automations
Question
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?
Options
- ARun Excel macro action.
- BGet selected cell range from Excel worksheet action.
- CRun VBScript action.
- DRun script action.
- ERead from Excel worksheet action.
Unlock PL-500 to see the answer
You've previewed enough free PL-500 questions. Unlock PL-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Excel to JSON conversion#Power Automate Desktop#Scripting actions#Data transformation