ExamGecko
Search Search Login
Home Home / Microsoft / MB-820
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have an XMLport that exports items from a database to an XML file. You need to change the export format from XML to CSV. What should you do?
A company plans to meet new regulatory requirements. The regulator has issued new tax tiers. You need to update the base application table by using a table extension. Which table field property can you change?
You need to allow debugging in an extension to view the source code. In which file should you specify the value of the allowDebugging property?
DRAG DROP A company has the following custom permission set: You need to make the permission set visible on the Permission Sets page. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
HOTSPOT You need to create the Install codeunit that is requited in the extension used for installing or updating the Housekeeping app. Which data type or declaration should you use? To answer, select the appropriate options in the answer area. NOTE; Each correct selection is worth one point.
HOTSPOT A company uses Business Central. The company is generating a detailed custom report. A user observes that the generated report dataset contains more Delivery Line records than expected for one specific Delivery Header. You need to generate a report that contains the accurate number of records. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
HOTSPOT You create a procedure to check if a purchase order has lines. The procedure returns false for purchase order PO-00001 even though it has purchase lines. You need to fix the code to get the correct result. For each of the following statements, select Yes if the statement is true Otherwise, select No. NOTE- Each correct selection is worth one point.
You ate creating a view for a Business Central app. The view requires a custom layout that displays only customer records with a balance greater than 500 in local currency. You need to configure the view to specify that it has a custom layout. Which property combination should you use?
HOTSPOT You need to parse the API JSON response and retrieve each order no. in the response body. How should you complete the code segment? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP You need to implement the Issue Management module and expose the Postlssue method. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: Note than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Question 87 - MB-820 discussion

Report
Export

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?

A.

SaveAsExcel

Answers
A.

SaveAsExcel

B.

SaveAsWoid

Answers
B.

SaveAsWoid

C.

SaveAsHiml

Answers
C.

SaveAsHiml

D.

SaveAsCsv

Answers
D.

SaveAsCsv

Suggested answer: D

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.

For more information, see the Query Object Functions in Business Central.

Show Answer
asked 13/10/2024
Roger Berger
27 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms