Microsoft

MB-500 Free Practice Questions — Page 15

Question 143

You are a Dynamics 365 Finance developer. You have a table named FMVehicle that contains a field named VehicleId. The table has an index named VehicleIdIdx on the VehicleId field. You declare a table buffer named vehicle to refer to the table. You need to select all records from the FMVehicle table in ascending order based on VehicleId field in the vehicle variable. Which embedded-SQL statement should you use?

A. select vehicle order by VehicleIdIdx desc;
B. select vehicle order by VehicleId;
C. select vehicle order by vehicleIdIdx asc;
D. select vehicleId from vehicle order by vehicleId asc;
Show Answer
Correct Answer: B
Explanation:
In X++ embedded SQL, to retrieve all records sorted in ascending order by a field, use `order by <fieldName>`. Ordering is specified by fields, not index names. Ascending is the default, so `select vehicle order by VehicleId;` is correct. Option D selects only the field rather than all table records into the table buffer.

Question 144

DRAG DROP - A company uses Dynamics 365 Finance. You create a new extension for a standard table. You need to add a new method in the extension. Which five 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.

Illustration for MB-500 question 144
Show Answer
Correct Answer: Create a new project in Visual Studio. Add a new class to the Visual Studio project with the _Extension suffix. Decorate the class with the [ExtensionOf(tableStr(TableName))] attribute. Set the class as final. Add a new method to the class and implement it.
Explanation:
A table extension method is implemented in a new extension class. The class is named with the _Extension suffix, decorated with the ExtensionOf(tableStr(...)) attribute, declared final, and then the new method is added.

Question 145

DRAG DROP - You need to add new fields to the standard form and organize the grid to meet the requirements. In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

Illustration for MB-500 question 145
Show Answer
Correct Answer: 1. Find the WHSTmpStatusChangeDetails form in the Application Object Tree (AOT). 2. Right-click the form in the Application Object Tree (AOT). 3. Create an extension of the form in the project. 4. Drag the Product Name and Batch ID fields from the data source to the grid on the form extension.
Explanation:
In Dynamics 365 Finance and Operations, you first locate the base form, then create a form extension from it, and finally modify the extension by adding the required fields to the grid.

Question 146

You need to meet the requirements for the purchase order creation form. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE: each correct selection is worth one point.

A. Create a class and add a form data source event handler method to the class.
B. In Application Explorer, create a table extension and implement validation.
C. In Application Explorer, create a form extension and implement validation.
D. Implement Chain of Command (CoC) and method wrapping by creating a form extension class.
Show Answer
Correct Answer: A, D
Explanation:
To add custom validation or behavior to the purchase order creation form, you can either attach a form data source event handler in a class or use Chain of Command (method wrapping) by creating a form extension class. A table extension validates table data generally, not specifically the form's behavior, and form extensions do not directly implement validation without event handlers or CoC.

Question 147

DRAG DROP - A company has a cloud-based installation of Dynamics 365 Finance. The company also has Dynamics 365 Sales and Customer Service systems. The company implements an analytical reports solution. You need to select the applicable storage feature for each requirement. Which storage feature should you use to meet each requirement? To answer, drag the appropriate storage options to the correct requirements. Each storage option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:

Illustration for MB-500 question 147
Show Answer
Correct Answer: Import data from various systems into one reporting database and extend tables. → Bring your own database Develop and extend Power BI reports and publish automatically through the application deployment lifecycle. → Entity store
Explanation:
Bring your own database (BYOD) consolidates data from multiple systems into an external SQL database and supports extending tables. Entity store is the Finance analytical store optimized for embedded/Power BI reporting and integrates with application deployment.

Question 148

You are Dynamics 365 Finance developer. You need to initialize an embedded Microsoft Power BI report. Which code segment should you add to the form initialization method?

A. initializeReportControlInternal( powerBIConfiguration, reportParameters, reportControl, showError )
B. getPBIReportByResourceName( resourceName )
C. importAndStorageReport( powerBIConfiguration, resourceName, isUpdate )
D. initializeCustomReportControl( resourceName, formGroupControl, reportCustomParams )
Show Answer
Correct Answer: D
Explanation:
To initialize an embedded Microsoft Power BI report on a Dynamics 365 Finance form, the helper used for embedded custom report controls is initializeCustomReportControl(resourceName, formGroupControl, reportCustomParams). The other options retrieve a report, import/store a report, or are internal/helper methods rather than the form initialization API intended for embedding.

Question 149

You create a new class. Class compilation must fail if a specific method in the source code is called. You need to mark the class with the appropriate attribute. Which attribute should you use?

A. SysAppSecurityAttribute
B. SysTestCategory
C. SysObsoleteAttribute
D. SysAttribute
Show Answer
Correct Answer: C
Explanation:
SysObsoleteAttribute is used to mark classes or methods as obsolete. It can be configured so that use of the marked element causes a compilation error rather than just a warning, preventing compilation if the obsolete API is called.

Question 150

A company uses Dynamics 365 Finance. You have two tables as shown: When an employee is deleted from EmplTable, the corresponding bank account information must automatically be deleted from EmplBankAccount You need to ensure that the requirement is met. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Set the value of the OnDelete property to Restricted.
B. Select the foreign key relation properties from EmplBankAccount.
C. Select the foreign key relation properties from EmplTable.
D. Set the value of the OnDelete property to Cascade.
Show Answer
Correct Answer: B, D
Explanation:
To automatically delete related records in EmplBankAccount when the parent employee record in EmplTable is deleted, configure the delete action on the foreign key relationship defined in the child table. Select the foreign key relation properties from EmplBankAccount and set the OnDelete property to Cascade so dependent bank account records are removed automatically. Restricted would prevent deletion while related records exist, and configuring the parent table's relation is not the correct location.

Question 151

You have a table in which multiple properties must be changed. Multiple table properties are locked down at the base table and must not be overwritten. You need to modify the table properties by extending the table. Which table property can you populate in a table extension by using the property sheet?

A. Cache lookup
B. Save data per company
C. Modified date time
D. Clustered index
Show Answer
Correct Answer: C
Explanation:
In Dynamics 365 Business Central/AL, most core table properties such as Cache lookup, Save data per company, and Clustered index are defined on the base table and cannot be changed in a table extension. A table extension can populate metadata such as the Modified date time property via the property sheet, while locked structural properties cannot be overridden.

Question 152

DRAG DROP - An error occurs when an employee creates a new workflow using a custom approval element to track the status of a document. You need to ensure that the workflow is created correctly. In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

Illustration for MB-500 question 152
Show Answer
Correct Answer: Develop the workflow approval component. Create a workflow structure. Configure the business process steps. Enable the workflow for the business scenario.
Explanation:
First build the custom approval component, then create the workflow structure that uses it, configure the workflow/business process steps, and finally enable the workflow for the target business scenario.

$19

Get all 295 questions with detailed answers and explanations

  • Instant download HTML + PDF delivered the moment payment clears.
  • Secure Stripe checkout we never see or store your card details.
  • 7-day refund if files are defective see our refund policy.