MB-820 無料問題集「Microsoft Dynamics 365 Business Central Developer」
You need to handle the removal of the Description field and the Clone procedure without breaking other extensions.
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.
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.
正解：
Explanation:
In Business Central, when you need to handle the removal of fields and procedures to ensure that other extensions are not affected by these changes, you typically follow a two-step deprecation process. This allows other developers and users to adapt to the changes before they are fully enforced. Here are the steps to handle the removal:
* Mark as Obsolete: In the first version where the decision to remove the field or procedure is made, you set the ObsoleteState to Pending and provide an ObsoleteReason. This doesn't remove the feature but indicates to users and developers that it will be removed in the future. This step is crucial for backward compatibility.
* Removal: In a subsequent version, after users have had time to adapt to the deprecation warning, you can then remove the field or procedure or set the ObsoleteState to Removed.
Based on these guidelines, here are the three actions you should perform in sequence:
* Set the Description field as ObsoleteState = Pending and ObsoleteReason = 'Not in use' in version
2.0.0.0.
* Set the Clone procedure as ObsoleteState = Pending and ObsoleteReason = 'Not in use' in version
2.0.0.0.
* Remove the Description field from the Issue table in version 2.0.0.1.
These steps will ensure that anyone using the Description field or Clone procedure will receive a warning about the pending deprecation before it is actually removed, thereby minimizing the impact on other extensions and providing a clear path for migration.
When handling the removal of fields and procedures in Microsoft Dynamics 365 Business Central, the process should be carried out in a way that allows other extensions or dependent features to adapt to the changes without causing immediate failures.
* Set Obsolete State and Reason for Description Field (Version 2.0.0.0): The first step involves marking the Description field as obsolete by setting the ObsoleteState to 'Pending'. This is a non-breaking change, signaling to other developers and users that the field is planned for removal in a future version.
An ObsoleteReason should also be provided to explain why the field is being deprecated.
* Set Obsolete State and Reason for Clone Procedure (Version 2.0.0.0): Similarly, the Clone procedure should be marked as obsolete with the ObsoleteState set to 'Pending'. This indicates that the procedure is no longer in use and will be removed in the future. Providing an ObsoleteReason is best practice as it explains the rationale behind the decision.
* Remove the Description Field (Version 2.0.0.1): In the subsequent version, after the developers and users have been given time to adapt to the deprecation notice, the Description field can be safely removed from the Issue table. This is considered a breaking change, hence it is done after the field has been marked as obsolete in a previous version.
The reason for not removing the Description field and Clone procedure immediately in version 2.0.0.0 is to avoid causing runtime errors for any extensions or integrations that may depend on these components. By following this sequence, you provide a clear deprecation path that helps maintain the stability of the overall system while evolving the schema.
A company is implementing Business Central.
In the per-tenant extension, TableA Header and TableA Line are document tables, and TableB Header and TableB Line are document history tables.
The company requires that the resulting dataset of query objects contain the following records:
* All records from TableA Header even if no matching record value exists in the linked TableA Line
* Records from TableB Header where a match is found in the linked TableB Line field You need to configure the linked data item to generate the required dataset.
Which SqlJoinType should you use? To answer, move the appropriate SqUoinTypes to the correct dataset requirements. You may use each SqlJoinType once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
In the per-tenant extension, TableA Header and TableA Line are document tables, and TableB Header and TableB Line are document history tables.
The company requires that the resulting dataset of query objects contain the following records:
* All records from TableA Header even if no matching record value exists in the linked TableA Line
* Records from TableB Header where a match is found in the linked TableB Line field You need to configure the linked data item to generate the required dataset.
Which SqlJoinType should you use? To answer, move the appropriate SqUoinTypes to the correct dataset requirements. You may use each SqlJoinType once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
正解：
Explanation:
* Include all records from TableA Header even if no matching record value exists in the linked TableA Line: LeftOuterJoin
* Include only matched records from TableB Header: InnerJoin
In SQL and similarly in Business Central when defining table relationships in query objects, the type of join determines how records from one table are combined with records from another table. Here's what each join type means in the context of the company's requirements:
* LeftOuterJoin:
* A LeftOuterJoin includes all records from the 'left' table (TableA Header) and the matched records from the 'right' table (TableA Line). If there is no match, the result is NULL on the side of the 'right' table. This is why it fits the requirement to include all records from TableA Header even if there is no matching record in TableA Line.
* InnerJoin:
* An InnerJoin includes records when there is at least one match in both tables. So, it will only include records from TableB Header where a corresponding match is found in TableB Line. If there is no match, the records from TableB Header will not appear in the result set. This aligns with the requirement to include only matched records from TableB Header.
By using these join types, the company can ensure that their dataset includes the appropriate records from the document tables and document history tables according to their specified requirements.
You create an 'AddltemsToJson" procedure and publish it.
The procedure fails to run.
You need to fix the errors in the code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
The procedure fails to run.
You need to fix the errors in the code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
正解：
Explanation:
* In line 13, replace the Add method with Insert. = NO
* In line 15, replace the WriteTo method with ReadFrom. = NO
* Change the ItemObject variable type from JsonObject to JsonToken. = NO
* Move line 08 in the beginning of REPEAT .. UNTIL. = YES
The provided code is intended to serialize a list of items from the Item table into a JSON array format. Here is a breakdown of the code and the necessary corrections:
* In line 13, "ItemsArray.Add(ItemObject)": This line is correctly using the Add method to add the ItemObject to the ItemsArray. The Add method is the correct method to use for adding items to a JsonArray. Therefore, there is no need to replace Add with Insert.
* In line 15, "ItemsArray.WriteTo(RequestText)": The WriteTo method is used correctly to serialize the ItemsArray into a JSON formatted string and store it in the RequestText variable. The ReadFrom method is used for the opposite operation, i.e., to deserialize a JSON formatted string into a JsonArray, which is not the goal in this context. Hence, no change is needed here.
* Change the ItemObject variable type from JsonObject to JsonToken: The ItemObject variable is intended to hold JSON objects representing individual items, making JsonObject the appropriate type.
JsonToken is not a type used in this context within AL for Business Central, and thus the variable type should remain as JsonObject.
* Move line 08, "Clear(ItemObject)": This line should be moved inside the repeat loop to ensure that the ItemObject is cleared for each item in the loop. Placing it before the repeat would only clear it once before the loop starts, which could lead to incorrect serialization as the previous item's properties would not be cleared from the ItemObject.
The logic for serializing records into JSON is a common operation when interfacing with APIs or web services in Business Central, and the pattern shown in the code is typical for such operations.
You create the following Vendor table and Item table in Business Central.
You require the following data set to assign vendors to items.
You need to create a query to assign the vendors.
Which three code blocks should you use to develop the solution? To answer, move the appropriate code blocks from the list of code blocks 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.
You require the following data set to assign vendors to items.
You need to create a query to assign the vendors.
Which three code blocks should you use to develop the solution? To answer, move the appropriate code blocks from the list of code blocks 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.
正解：
Explanation:
To create a query that assigns vendors to items in Business Central, use the following code blocks in sequence:
* dataitem(Vendor; Vendor)
* dataitem(Item; Item)
* DataItemLink = "Vendor No." = Item.Vendor_No;
Creating a query:In Business Central, a query object is used to combine data from multiple tables. You start by specifying each table as a data item. In this case, you would start with the Vendor table and then the Item table. After specifying the data items, you need to link them together. The DataItemLink property is used to establish a relationship between two data items based on a common field. Here, you are linking the Vendor and Item tables on the "Vendor No." field, which is present in both tables. This link ensures that the query will return a dataset that includes related records from both tables based on the vendor number. The order of the code blocks ensures the logical flow and relationships between tables as required for the query.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question set might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen.
A company creates a Business Central app and a table named MyTable to store records when sales orders are posted.
Users report the following issues:
* The users receive permission errors related to MyTable.
* Users are no longer able to post sales orders since installing the new app.
* The users cannot access the list page created in MyTable.
You need to resolve the user issues without creating new permission sets. You must use the principle of least privilege.
Solution: Decorate the event subscriber used for inserting data in MyTable by entering (lnherentPermissions (PermissionOb]ectType:TableData. Database:MyTable. 'R')] Does the solution meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen.
A company creates a Business Central app and a table named MyTable to store records when sales orders are posted.
Users report the following issues:
* The users receive permission errors related to MyTable.
* Users are no longer able to post sales orders since installing the new app.
* The users cannot access the list page created in MyTable.
You need to resolve the user issues without creating new permission sets. You must use the principle of least privilege.
Solution: Decorate the event subscriber used for inserting data in MyTable by entering (lnherentPermissions (PermissionOb]ectType:TableData. Database:MyTable. 'R')] Does the solution meet the goal?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
A company owns and operates hotels, restaurants, and stores.
When the staff orders materials from the purchasing department, the requests are not directed to the correct approvers.
The staff requires a new field named Approver from which they can select the appropriate approver. The field must include the following options:
* Hotel manager
* Restaurant manager
* Store manager
* Purchasing manager
You need to create the Approver field in the Item table by using an AL extension.
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.
When the staff orders materials from the purchasing department, the requests are not directed to the correct approvers.
The staff requires a new field named Approver from which they can select the appropriate approver. The field must include the following options:
* Hotel manager
* Restaurant manager
* Store manager
* Purchasing manager
You need to create the Approver field in the Item table by using an AL extension.
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.
正解：
Explanation:
To create the Approver field in the Item table using an AL extension, perform the following actions in sequence:
* Create an enum object named Approver and include all options.
* Create a table extension object for an Item table with an Approver field of enum type named Approver in the fields section.
* Create a page extension object that extends the Item Card object. Add the field to the fields section.
Build and extend tables:To add a new field to an existing table in Business Central using AL extension, you need to define an enumeration (enum) with the possible values for the new field. Then, you create a table extension object where you add the new field and specify its type as the enum you created. This adds the field to the Item table. Finally, you modify the user interface to display the new field by creating a page extension for the Item Card page and adding the new field to it.
A company is deploying Business Central on-premises.
The company plans to use a single-tenant deployment architecture.
You need to describe how the data is stored and how the Business Central Server is configured.
In which two ways should you describe the single-tenant architecture? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
The company plans to use a single-tenant deployment architecture.
You need to describe how the data is stored and how the Business Central Server is configured.
In which two ways should you describe the single-tenant architecture? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正解：A、E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
A company plans to import and export data with Business Central
You must configure an XMLport that provides the following implementation;
* Specifies import 01 export on the Request page at run time
* Formats the data in a non-fixed length CSV format
You need to create the XMLport.
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.
You must configure an XMLport that provides the following implementation;
* Specifies import 01 export on the Request page at run time
* Formats the data in a non-fixed length CSV format
You need to create the XMLport.
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.
正解：
Explanation:
Direction: Both
Format: VariableText
You are configuring an XMLport for Business Central with the following requirements:
* Specifies import or export on the Request page at runtime.
* Formats the data in a non-fixed length CSV format.
XMLport Configuration:
* Specifies import or export on the Request page at runtime.The Direction property must be set to Both.
* This allows the XMLport to both import and export data depending on user selection during runtime.
* Formats the data in a non-fixed length CSV format.The Format property must be set to VariableText.
* VariableText is used for delimited text formats like CSV, which do not have a fixed length for fields.