- (Topic 4)
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?
Correct Answer:
D
✑ 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.
HOTSPOT - (Topic 4)
A developer creates a profile for part-time shop supervisors and adds customizations. You plan to add new requirements to the profile.
You need to analyze the code to understand the profile and make sure there are no errors.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Solution:
The Part Time Shop Supervisor profile will be applied only to users with "Register Time" = true on User Setup: No
Variables, procedures, and triggers cannot be added on page customization objects: Yes
Line 10 should use extends instead of customizes: No
In line 18, "Unit Cost" will be moved after "Costing Method": Yes
The Part Time Shop Supervisor profile will be applied only to users with "Register Time" = true on User Setup.
✑ No
✑ The code doesn't contain any reference to the User Setup table or the Register Time field, so this is not correct. Profiles are not applied conditionally based on fields like this.
Variables, procedures, and triggers cannot be added on page customization objects.
✑ Yes
✑ Page customization objects are meant for UI modifications, such as moving or hiding fields. You cannot add variables, procedures, or triggers in a page customization object.
Line 10 should use extends instead of customizes.
✑ No
✑ In AL, when customizing a page within a profile, you use customizes rather than extends. Extends is used when modifying base application objects, but customizes is used to customize pages within a profile.
In line 18, "Unit Cost" will be moved after "Costing Method".
✑ Yes
✑ The code in line 18 is correct. The moveafter directive will move the "Unit Cost" field after the "Costing Method" field on the page layout.
Does this meet the goal?
Correct Answer:
A
HOTSPOT - (Topic 3)
You need to create the code related to the Subcontract Documents table to meet the requirement for the quality department.
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.
Solution:
Does this meet the goal?
Correct Answer:
A
- (Topic 4)
You are exporting data from Business Central.
You must export the data in a non-fixed length and width in CSV format. You need to generate an XMLport to export the data in the required format Which Format property value should you use?
Correct Answer:
B
When exporting data from Business Central and the requirement is for the data to be in a non-fixed length and width CSV format, the Format property of the XMLport should be set to VariableText (B). The VariableText format is designed for handling data exports where the fields are separated by a delimiter, such as a comma or tab, which is typical of CSV (Comma-Separated Values) files. This format allows for the flexibility needed when dealing with varying field lengths, as it does not enforce a fixed width for each field, making it ideal for CSV data exports. Setting the Format property to FixedText
(C) would enforce a fixed width for each field, which is not suitable for CSV files, while the XML format (A) is used for exporting data in an XML structure, which is different from the CSV format requirements.
HOTSPOT - (Topic 2)
You need to log an error in telemetry when the business process defined in the custom application developed for Contoso, Ltd fails.
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.
Solution:
Verbosity::Critical: This ensures that the telemetry logs the failure as a critical event. DataClassification::CustomerContent: This helps classify the error as related to customer data.
TelemetryScope::All: This ensures that the error is visible across all relevant telemetry scopes, making it easier to monitor the issue in real-time.
Does this meet the goal?
Correct Answer:
A
