MB-500 : Microsoft Dynamics 365 Finance and Operations Apps Developer : Part 04

MB-500 : Microsoft Dynamics 365 Finance and Operations Apps Developer : Part 04

1. HOTSPOT

   A company is implementing Dynamics 365 Finance. Vendors receive a risk rating that is determined by their on-time delivery performance as well as their credit rating.

   You need to implement the following risk rating functionality:

   – The risk rating must accompany the credit rating when the credit rating is used.
   – The risk rating must be able to be used in other areas of the solution to determine processing outcomes.
   – The risk rating must consist of the following values:
   1 = Good
   2 = Medium
   3 = Risky
   – The risk rating must be displayed in the Miscellaneous Details tab below the Credit Rating and Credit Limit fields in the Vendor form.

   What should you do? To answer, select the appropriate options in the answer area.

   NOTE: Each correct selection is worth one point.

   

   

   Explanation:

   Box 1: Create a new enum base data type.
   An enum is a list of literals.

   Box 2: Create a table extension
   After base enums and EDTs are created, they are usually added to a table to enable data capture.

   Box 3: Use a field group
   Field and Field Groups is the most common data entry subpattern and uses a dynamic number of columns to present multiple fields or groups of fields.
   The group controls within this pattern can be used either to group fields under a label or to bind to a table field group.

2. HOTSPOT

   You have the following code:

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No.

   NOTE: Each correct selection is worth one point.

   

   

   Explanation:

   Box 1: Yes
   Add 1 to a date adds one day.

   Box 2: No
   Date2num converts a date to an integer that corresponds to the number of days since January 1, 1900 so this would give us a large number.
   Int2str converts the large number into a string.
   Str2date converts a string to a date. However, the large number would not be in the correct format for a date.

3. You are using the SysTest framework to test code in Visual Studio.

   You need to create a unit test class.

   Which three attributes can you use to create the class? Each correct answer presents a complete solution.

   NOTE: Each correct selection is worth one point.

   • TestFilter
   • Priority
   • Owner
   • EntryPoint
   • Test Property
   Explanation:

   The SysTest framework now supports the major test attributes in the adaptor to be on par with the MS Test framework adaptor. This includes attributes like Category, Owner, Priority, and Test Property.

   Note:
   The Priority attribute Sys Test Priority, which requires an integer value, is now available. A priority can only be specified once, but is supported on both the class and method level, with method level taking precedence over class level.

   The Owner attribute, Sys Test Owner, has also been added. This attribute was technically already supported for filtering in the Test Toolbox window, but the attribute itself was missing in X++. Similar to Priority, an owner can only be specified once and is supported on both the class and method level, with the method level taking precedence.

   Sys Test Property specifies a property and a value (two strings), and can now be used in the Test Toolbox window in Visual Studio. Test Property can be specified multiple times, and can exist on both the class and method level.

4. HOTSPOT

   You have the following class definition:

   

   You need to create an extension class and create a new static method in it that converts miles to kilometers and then call the method from another class.

   How should you complete the code and call the method? To answer, select the appropriate options in the answer area.

   NOTE: Each correct selection is worth one point.

   

   

   Explanation:

   Box 1: final class UnitConv_MyExtension

   Box 2: var km = UnitConv::miToKm(62.1371);

5. You are a Dynamics 365 Finance developer. You create an integer variable named totalSales.

   You need to display the value from totalSales in an info statement.

   Which three code segments can you use? Each correct answer presents a complete solution.

   NOTE: Each correct selection is worth one point.

   • info(int2str(totalSales));

   • info(totalSales);

   • info(any2str(totalSales));

   • info(strfmt("%1", totalSales));

   • info(strLine(totalSales, 1));

   Explanation:

   A: int2Str converts an integer to the equivalent string.

   C: any2Str converts an anytype value to a str value. The anytype data type is a placeholder for any data type.

   D: Example:
   void MyMethod()
   {
   for (int i = 0; i < 10; i++)
   {
   info(strfmt(“i is %1”, i));
   }
   }

6. HOTSPOT

   You are a Dynamics 365 Finance developer.

   You have the following class definition:

   

   You need to create an extension class and wrap the method by using Chain of Command (CoC). If the value of the Qty variable is less than 5, the code must cause an exception.

   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:

   Box 1: final class WebShopOrderVal_Extension

   Box 2: public static void checkQtyValue(int Qty)

   Incorrect Answers:
   Public void …
   If a static method is the target that will be wrapped, the method in the extension must be qualified by using the static keyword.

   Int Qty=0
   The method signature in the wrapper method must not include the default value of the parameter.

   Public int

7. HOTSPOT

   You have the following code:

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No.

   NOTE: Each correct selection is worth one point.

   

   

   Explanation:

   Box 1: Yes
   Here Cash Discount DP is the name of the secure server method that is tagged with the Sys Entry Point Attribute attribute.

   Box 2: Yes
   To define a report data provider class
   An RDP class extends the SRS Report Data Provider Base class. You set the SRS Report Parameter Attribute attribute to the data contract you created for the RDP class.

   Box 3: No
   Instead:
   public void process Report()

8. DRAG DROP

   You create a Visual Studio project named Product Updates.

   You must update data in a table named Product Table. You must be able to run the code from Visual Studio.

   You need to create an X++ class.

   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.

   

   

9. HOTSPOT

   You are a Dynamics 365 Finance developer. You have the following code: (Line numbers are created for reference only.)

   

   Which values does the info() method return? To answer, select the appropriate option in the answer area.

   NOTE: Each correct selection is worth one point.

   

   

   Explanation:

   Box 1: SID1234
   Parameters
   All methods have their own scope. A method can take one or more parameters. Within the scope of the method, these parameters are treated as local variables and are initialized with a value from the parameter in the method call. All parameters are passed by value, which means that you can’t change the value of the original variable. You can change only the local variable in the method. This local variable is a copy of the original variable.

   Box 2: 5

10. 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?

    • select vehicle index VehicleId;

    • select vehicle order by VehicleId;

    • select VehicleId from vehicle order by VehicleId asc;

    • select vehicle order by VehicleId desc;

11. You are a Dynamics 365 Finance developer. You create a class.

    You need to mark the class to ensure that when code is compiled, the process fails if a specific method is called in the source code.

    Which attribute should you use?

    • SysEntryPointAttribute
    • getAttributes
    • SysAttribute
    • SysObsoleteAttribute
    Explanation: 
    One use of the SysObsoleteAttribute class is to notify the compiler that the compile should fail if a particular method is called in the source code. The compiler rejects the compile, and displays the specific message that is stored in this use of the attribute.

12. 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?

    • select vehicle index VehicleId;

    • select vehicle index VehicleIdIdx;

    • select VehicleId from vehicle order by VehicleIdIdx asc;

    • select vehicle order by VehicleId desc;

    Explanation: 
    The ‘index VehicleIdIdx’ statement will cause an Order By Asc of the fields contained in the index. In this case, that means an Order By Asc of the VehicleID field.

13. HOTSPOT

    You have a Dynamics 365 Finance environment.

    You have the following code: (Line numbers are included for reference only.)

    

     

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.

    NOTE: Each correct selection is worth one point.

    

    

    Explanation:

    Box 1: Yes
    Class extension – Method wrapping and Chain of Command.
    The functionality for class extension, or class augmentation, has been improved. You can now wrap logic around methods that are defined in the base class that you’re augmenting. You can extend the logic of public and protected methods without having to use event handlers. When you wrap a method, you can also access public and protected methods, and variables of the base class. In this way, you can start transactions and easily manage state variables that are associated with your class.

    Box 2: Yes
    In the following example, the wrapper around doSomething and the required use of the next keyword create a Chain of Command (CoC) for the method. CoC is a design pattern where a request is handled by a series of receivers. The pattern supports loose coupling of the sender and the receivers
    [ExtensionOf(classStr(BusinessLogic1))]
    final class BusinessLogic1_Extension
    {
    str doSomething(int arg)
    {
    // Part 1
    var s = next doSomething(arg + 4);
    // Part 2
    return s;
    }
    }

    Box 3: Yes
    Instance and static methods can be wrapped by extension classes. If a static method is the target that will be wrapped, the method in the extension must be qualified by using the static keyword.

    Box 4: No
    Wrapper methods must always call next.

    Note: Wrapper methods in an extension class must always call next, so that the next method in the chain and, finally, the original implementation are always called. This restriction helps guarantee that every method in the chain contributes to the result.

    In the current implementation of this restriction, the call to next must be in the first-level statements in the method body.

    – Here are some important rules:
    – Calls to next can’t be done conditionally inside an if statement.
    – Calls to next can’t be done in while, do-while, or for loop statements.
    – A next statement can’t be preceded by a return statement.
    – Because logical expressions are optimized, calls to next can’t occur in logical expressions. At runtime, the execution of the complete expression isn’t guaranteed.

14. HOTSPOT

    You are a Dynamics 365 Finance developer.

    You have the following code: (Line numbers are included for reference only.)

    

     

    You need to evaluate the code.

    What is the correct output for the method? To answer, select the appropriate option in the answer area.

    NOTE: Each correct selection is worth one point.

    

    

    Explanation:

    Box 1: One, Two, Four, Fire
    The statements in the finally clause are executed when control leaves the try block, either normally or through an exception.

    Box 2: One, Three, Four, Five

    Box 3: One, Three
    Return ends the call.

    Box 4: One, Three, One, Two, Four, Five
    Retry restarts the try statement.

15. Case study

    This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

    To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

    At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

    To start the case study
    To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Quesbtion button to return to the question.

    Background

    Wide World Importers sell office supplies, furniture, and fittings to their customers across the United States. The company has the following locations:

    – a retail store in Seattle
    – a warehouse in Seattle
    – a customer support and call center in Atlanta
    – a team of field workers that provide furniture installation services at customer sites.

    Wide World Importers plans to implement Dynamics 365 Finance and Microsoft Azure cloud platform features.

    Current environment

    Customers may place orders by email, phone, or by using the company’s website. The company authorizes and processes credit card transactions by using a web-based application. Customer, inventory, supplier, and other master and transactional data is stored in a legacy database.

    The company collects feedback from customers by phone or a form on the company’s website and maintains the data in a Microsoft Excel workbook.

    Wide World Importers runs on-premises applications to manage payroll and workers compensation. The company has a set of Microsoft Power BI dashboards that present data from a reporting database.

    The company creates a Lifecycle Services (LCS) implementation project and completes Dynamics 365 Finance onboarding.

    The company maintains production, quality assurance (QA), development, user acceptance testing (UAT), and build environments.

    Requirements

    General

    – You must configure a cloud-based Dynamics 365 Finance development environment and enable code extensions that support updates.
    – You must configure version control and a Build environment.
    – You must migrate all legacy data to the new system.
    – You must implement best practices for X++ coding, the data model, caching, and security.
    – All new code must be unit tested in a development environment and then validated by the QA team before code is added to source control.

    Business processes

    – You must configure vendor trade agreements.
    – Products must be shipped directly from suppliers to customers depending on customer location to save indirect costs.
    – You must collect customer feedback on products shipped directly from vendors.
    – You must deploy code to a UAT environment for testing before deploying code to production.
    – You must validate all entries for the purchase order creation form.
    – You must develop a web portal that allows customers to browse products, place orders, and check order status. Product data for the web portal must be integrated as periodic batches.

    Business systems

    – You must install and configure a third-party solution for credit card processing within Dynamics 365 Finance. The third-party company will provide a deployable package.
    – The workers compensation application must be able to call an API to update worker compensation details in Dynamics 365 Finance.
    – You must develop a process to import payroll journals into the system.
    – You must configure the warehouse mobile device portal for warehouse operations.
    – You must install a third-party solution to support web portal integration. The solution is supplied as a source code model file.

    Vendor exclusion list

    You must develop a new solution to maintain a Vendor exclusion list for each customer and item combination. The solution must meet the following requirements:

    – Isolate all new vendor exclusion codes as a new assembly by creating a table named Vend Exclusions.
    – Create an index for the table named PrimaryIdx that uses the following fields: Cust Account, ItemId, Vend Account.
    – Ensure that users can open the Vendor Exclusion list report from the customer master form. The list must display the customer account, Item ID, and Vendor account fields.
    – Implement the Excel integration for the Vendor Exclusion List form.
    – Provide functionality to periodically export the Vendor exclusion list to prepare reports by using standard reporting capabilities of Dynamics 365 Unified Operations.
    – Develop necessary security permissions to view and maintain the new Vendor exclusion list functionality and reporting. Users with maintain rights will be able to create, update, and delete the exclusion list. – Permissions must be assigned to security roles to match company security model.
    – Maintain referential integrity with other tables.
    – Users must be presented with a warning message before a direct delivery purchase order is created for a vendor in exclusion list.
    – Sales managers must be alerted when a new exclusion record is added to the system.

    Security

    – You must implement the record level audit feature to identify the users who created the record.
    – Grant specific users rights to maintain the vendor exclusion list by using Excel.
    – You must implement validation to check whether a proposed direct delivery purchase order vendor is on the exclusion list for the customer and product combination.

    Issues

    – User1 is not able to access many features in the system. You must provide User1 administrator rights.
    – A sales manager suspects a data-related issue in the vendor exclusion list. User1 must identify the user who created the referenced exclusion records.
    – Developer2 joins the company and does not have access to a development environment or source control.
    – User2 reports performance issues when they generate direct delivery purchase orders after current updates are applied.
    – User2 reports that they cannot access new functionality and reports.

    1. HOTSPOT

       You need to implement the reporting requirements for the Vendor exclusion list.

       Which options you should use? To answer, select the appropriate options in the answer area.

       NOTE: Each correct selection is worth one point.

       

       

       Explanation:

       Scenario: Provide functionality to periodically export the Vendor exclusion list to prepare reports by using standard reporting capabilities of Dynamics 365 Finance.

       Box 1: Financial Reporting
       The financial reporting functions are available to users who have the appropriate privileges and duties assigned to them through their security roles.

       Box 2: UI Builder class
       Example:
       Defining parameters defaulting using code
       In Solution Explorer, double-click on the FM Rentals By Cust UI Builder class to open the designer.
       Locate the class build method and update the initialization code.

       The parameter initialization code sets the default values of the report execution relative to today’s date. Use the classes UI Builder to override the framework’s default handling of report parameters. Additional extension scenarios supported include:
       Automatically set query ranges based on session context using Controller classes

16. Case study

    This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

    To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

    At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

    To start the case study
    To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.

    Background

    First Up Consultants provides Commercial Cleaning services to its clients. The company purchases all its cleaning supplies from Best For You Organics Company.

    First Up Consultants is using a cloud-based Dynamics 365 Finance instance. The system has a foundation table named CashDisc that contains one cash discount record for each cash discount type.

    Best For You Organics Company invoices First Up Consultants and allows cash discounts based on how fast an invoice is paid. First Up Consultants is entitled to a two percent discount from Best for You Organics for any invoice that is paid within 10 days and has a minimum invoice amount of $2,500.

    Business requirements

    All new and extended objects must be located in an existing model named Finance Ext. The creation of new models is not permitted.

    Best For You Organics Company requires that First Up Consultants apply specific minimum invoice amounts to each cash discount record. A cash discount may only be applied when the minimum invoice amount requirement has been met. The new field must be added to the Cash Disc form grid with the allowable visible number of characters set to 10.

    First Up Consultants must retrieve the required Cash Discount methods and corresponding minimum invoice amounts directly from Best For You Organics Company’s enterprise resource planning (ERP) system.

    The Chief Financial Officer (CFO) requires the following reports:

    – A report that shows all outstanding invoices, their cash discount types including the new minimum threshold applicable, and the amount of the discount. The report must only be accessed by users who are members of the Accounts Payable Manager role.
    – You must create a Microsoft Excel workbook that lists unpaid invoices to Best For You Organics Company that have a due date earlier than 5/1/2019 and an Invoice Amount between $20,000 and $100,000.

    Cash discounts for unpaid invoices must be updated with the new minimum invoice amounts.

    Technical requirements

    Vendor Invoices Past Due form

    You must be able to filter the grid on the Vendor Invoices Past Due form. By default, you must filter the form based on the Due Date, Invoice Amount, and Vendor columns. Users must be able to apply reusable user-specific filters to a page using multiple fields.

    Cash Disc form

    You must extend the Cash Disc form to add a new field named Minimum Invoice Amount to the form. You must add a new Extended Data Type to the extension model for the new field. The new field must be added above the discount method field. The field must display 10 characters.

    The accounts payable manager and the accounts payable clerk have Delete access to the form. You must alter permissions to limit accounts payable clerks to have only View access to the form.

    Cash Discount Records report

    You must create a report that shows a list of Cash Disc records. You must include the Minimum Invoice Amount field and filtered data by using the CashDisc.DiscMethod field. Applicable security objects must be created in the existing “Finance Ext” model and configured so the report is accessible by those users mapped to the accounts payable role.

    Batch jobs

    You must create a batch job that runs on the last day of each month to update the current unpaid invoices with changes in the minimum invoice amount. The job must meet the following requirements:

    – Accept the following parameters: Vendor, DueDate.
    – Be callable by an Action menu item.
    – Allow users to specify vendors to include in the job.
    – Use Sys Operation Framework for all batch jobs.

    You must create a batch job to identify modified CashDisc.MinimumInvoiceAmount values and apply these to open Purchase Lines.

    1. DRAG DROP

       You need to create the outstanding invoice report for the CFO.

       Which attributes should you use? To answer, drag the appropriate attributes to the requirements. Each attribute answer 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.

       

       

       Explanation:

       Scenario: The Chief Financial Officer (CFO) requires the following reports:
       A report that shows all outstanding invoices, their cash discount types including the new minimum threshold applicable, and the amount of the discount. The report must only be accessed by users who are members of the Accounts Payable Manager role.

       Box 1: Data Contract Attribute
       Data Contract Attribute – This attribute is applied to an X++ class and specifies that the class can be used as a data contract (that it should be serialized).

       Box 2: Data Member Attribute
       Data Member Attribute – This attribute is applied to a parm (parameter) method on an X++ data contract class and specifies that the data member should be serialized.

       Box 3: SRS Report Parameter Attribute
       You set the SRS Report Parameter Attribute attribute to the data contract you created for the RDP class.

17. You are a Dynamics 365 Finance developer. You create a key performance indicator (KPI) in a development environment.

    You need to display the KPI.

    What should you do?

    • Create a new workspace and add the KPI to the workspace.
    • Create a tile and add the KPI to the tile.
    • Add the KPI to an existing form.
    Explanation: 
    KPIs and aggregate data that are shown on the dashboard, or a workspace, can be secured by using menu items.

18. You are a Dynamics 365 Finance developer. You create a key performance indicator (KPI) that will enable users to be able to see the total sales per region. You create a tile named Sales Region and link the KPI to the tile.

    You need to ensure that users can view this tile on a form in the user interface.

    What should you do?

    • Create an extension of the form that will contain the new tile and KPI. Add the tile to the extended form.
    • Open the form that will contain the new tile. Add the tile to the form.
    • Create a new workspace. Add the KPI to the workspace from the user interface.

19. HOTSPOT

    You are creating a Dynamics 365 Finance report. You cannot query the data for the report directly.

    You must include parameters to specify data for the report.

    You need to create the report.

    What should you use? To answer, select the appropriate options in the answer area.

    NOTE: Each correct selection is worth one point.

    

    

    Explanation:

    Box 1: Data contract class
    A data contract class defines the parameters for a report that is bound to a report data provider (RDP) class. You can specify one or more groups of report parameters, the order of the groups, and the order in which the report parameters appear in a print dialog box.

    Box 2: Report data provider class
    Report data provider class – processes business logic based on parameters and a query, and then returns the tables as a dataset for the report.

    Box 3: Data Contract Attribute
    Data Contract Attribute – This attribute is applied to an X++ class and specifies that the class can be used as a data contract (that it should be serialized).

    Box 4: Data Member Attribute
    Data Member Attribute – This attribute is applied to a parm (parameter) method on an X++ data contract class and specifies that the data member should be serialized.

    Box 5: SRS Report Parameter Attribute
    You set the SRS Report Parameter Attribute attribute to the data contract you created for the RDP class.

20. You are a Dynamics 365 Finance developer.

    You need to deploy a new report in a development environment.

    From which two locations can you deploy the report? Each correct answer presents a complete solution.

    NOTE: Each correct selection is worth one point.

    • Package deployment
    • Build project
    • Application Explorer
    • Solution Explorer
    • Build Models options
    Explanation:

    A: An AOT package is a deployment and compilation unit of one or more models that can be applied to an environment. It includes model metadata, binaries, reports and other associated resources.

    D: