MB-820 · Question #116
You have a query object named Items Query. You write code using an Items Query query variable. You need to export the Items Query query data to a file. Which SaveAs function should you use?
The correct answer is D. SaveAsCsv. SaveAsCsv is the correct function to export the query data to a CSV (Comma-Separated Values) file, which is a commonly used text format for data exports. SaveAsExcel would export to an Excel file, SaveAsWord to a Word document, and SaveAsHtml to an HTML file, but since the…
Question
You have a query object named Items Query. You write code using an Items Query query variable. You need to export the Items Query query data to a file. Which SaveAs function should you use?
Options
- ASaveAsExcel
- BSaveAsJson
- CSaveAsHtml
- DSaveAsCsv
How the community answered
(32 responses)- A6% (2)
- C3% (1)
- D91% (29)
Explanation
SaveAsCsv is the correct function to export the query data to a CSV (Comma-Separated Values) file, which is a commonly used text format for data exports. SaveAsExcel would export to an Excel file, SaveAsWord to a Word document, and SaveAsHtml to an HTML file, but since the requirement is to export to a file and the question doesn't specify any particular file format other than what fits standard data exports, CSV is the most fitting and efficient format for this scenario.
Topics
Community Discussion
No community discussion yet for this question.