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

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

1. DRAG DROP

   You are a Dynamics 365 Finance developer.

   The sales department manager must to be able to view total customers by region and total sales by regions.

   You need to build key performance indicators (KPIs) and display them on a tile in the application.

   How should you model the KPI? To answer, drag the appropriate objects to the correct KPI components. Each object 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:

   Box 1: Aggregate measurements
   Measures are aggregate numbers, such as Total Sales or Number of Orders.

   Box 2: Aggregate dimension
   Dimensions are slicers, such as Product, Vendor, or Customer, that help you analyze the measure.

   Box 3: Aggregate date entity
   By using the model-driven approach, you can create data entities by directly referencing aggregate measurements and aggregate dimensions. These are known as aggregate data entities. Aggregate data entities are read-only data entities that are used for reporting purposes. To consume aggregate data when you build charts and other client controls, add the aggregate data to a form as a data source.

2. DRAG DROP

   You are a Dynamics 365 Finance developer.

   You have a report in an existing model that connects with the following objects:

   – in-memory table
   – data provider class
   – controller class
   – contract class

   The report is locked for modifications.

   You need to create an extension of the in-memory table in a model and you add the new field to the 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.

   

   

3. You are a 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?

   • addReportControl(formGroupControl)

   • initializeReportControl(WorkspaceName, FormGroup)

   • initializeReportControlOnWorkspace(powerBIConfiguration, reportParameters, formGroupControl)

   • deployOrUpdateReport(powerBIConfiguration, reportName, resourceName)

   Explanation: 
   PBIReportHelper.initializeReportControl method is used to embed a Power BI report (.pbix resource) in a form group control.

4. You are a Dynamics 365 Finance developer.

   You need to create a key performance indicator (KPI) that shows total sales by region.

   Which two objects should you create? Each correct answer presents part of the solution.

   NOTE: Each correct selection is worth one point.

   • dimension for region
   • dimension for total sales
   • aggregated view for total sales
   • measure for region
   • measure for total sales
   Explanation:

   An aggregate measurement is a model that contains a collection of measures together with their corresponding dimensions. Measures are aggregate numbers, such as Total Sales or Number of Orders. Dimensions are slicers, such as Product, Vendor, or Customer, that help you analyze the measure. For example, the measure of Total Sales isn’t useful unless it can be sliced by Product, Region, and Customer.

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

   • getPBIReportByResourceName(resourceName)

   • initializeReportControl(WorkspaceName, FormGroup)

   • importAndStoreReport(powerBIConfiguration, resourceName, isUpate)

   • deployOrUpdateReport(powerBIConfiguration, reportName, resourceName)

6. HOTSPOT

   A company requires a change to one of the base Microsoft SQL Server Reporting Services (SSRS) reports. The report must include a new field that automatically filters the report based on the user who opens the report.

   You need to add the new field as specified.

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

   NOTE: Each correct selection is worth one point.

   

   

7. The warehouse manager at Contoso, Ltd. wants to display a tile in the user interface that will show total RAFs per hour.

   You need to create a key performance indicator (KPI) that meets these requirements.

   What two components should you create? Each correct answer presents part of the solution.

   NOTE: Each correct selection is worth one point.

   • aggregate dimensions
   • data entity
   • aggregate measurements
   • TempDB table
   Explanation:

   When you have completed modeling the aggregate measurement, you can deploy the aggregate measurement and continue with building KPIs and visualizations. You have 2 deployment choices:
   – Stage in Entity Store
   – In-memory real-time

   Note: RAF = report as finished

8. You have a cloud-based Dynamics 365 Finance production environment.

   You need to access the data to create Microsoft Power BI reports for the business.

   What should you use?

   • aggregate measurements
   • aggregate dimensions
   • Analysis Cubes
   • Entity store
   Explanation: 
   When you have completed modeling the aggregate measurement, you can deploy the aggregate measurement and continue with building KPIs and visualizations. You have 2 deployment choices:
   – Stage in Entity Store. This option leverages Entity store, the operational data store that enables near real-time PowerBI reporting.
   – In-memory real-time

9. You have a cloud-based Dynamics 365 Finance production environment.

   You need to access the data to create Microsoft Power BI reports for the business.

   What should you use?

   • Power BI embedded
   • views
   • aggregate dimensions
   • data entities

10. HOTSPOT

    You are a Dynamics 365 Finance developer.

    A form uses a synchronous call based on a saleID value. There are long wait times for the form to complete processing. You must allow the user to continue to work while the form processes and inform the user immediately when the processing completes.

    You need to implement the correct method calls and behavior.

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

    NOTE: Each correct selection is worth one point.

    

    

    Explanation:

    Box 1: Global:runAsync
    Use runAsync methods on the Global or FormRun classes.

    Box 2: container

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

    • initializeReportControlOnWorkspace(powerBIConfiguration,
      reportParameters, formGroupControl)

    • importAndStorageReport(powerBIConfiguration, resourceName,
      
      isUpdate)

    • initializeCustomReportControl(resourceName, formGroupControl,
      
      reportCustomParams)

    • addReportControl (formGroupControl)

    Explanation:

    PBIReportHelper.initializeReportControl method is used to embed a Power BI report (.pbix resource) in a form group control.

    PBIReportHelper::initializeReportControl(‘FMPBIWorkspaces’, powerBIReportGroup);

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

    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 VendExclusions.
    – Create an index for the table named PrimaryIdx that uses the following fields: CustAccount, ItemId, VendAccount.
    – 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. You need to implement the migration requirements.

       Which two options can you use? Each correct answer presents a complete solution.

       NOTE: Each correct selection is worth one point.

       • a data entity and bring your own database (BYOD)
       • a public data entity and the Excel add-in
       • a data entity and Entity store
       • a data entity and a Data management import job
       Explanation:

       Scenario: Implement the Excel integration for the Vendor Exclusion List form.

       B: By opening entity data in Excel, you can quickly and easily view and edit the data by using the Excel add-in.

    2. DRAG DROP

       You need to implement the company’s integration requirements.

       Which integration strategies should you use? To answer, drag the appropriate integration strategies to the correct requirements. Each integration strategy 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:

       Box 1: asynchronous
       An asynchronous pattern is a non-blocking pattern, where the caller submits the request and then continues without waiting for a response.

       Box 2: Synchronous
       A synchronous pattern is a blocking request and response pattern, where the caller is blocked until the callee has finished running and gives a response.

       Box 3: Synchronous

       Box 4: asynchronous
       Batch data is asynchronous.

    3. You need to investigate the Vendor exclusion list issue.

       What should you do?

       • Navigate to the General tab, select Record Info, and then select Show all fields.
       • Navigate to the Options tab, select Record Info, and then select Show all fields.
       • Navigate to the General tab and select Database log.
       • Navigate to the Page options tab, select Record Info, and then select Show all fields.
       Explanation:

       Scenario: A sales manager suspects a data-related issue in the vendor exclusion list. User1 must identify the user who created the referenced exclusion records.

       Database logging is a feature in D365FO which helps us to track inserts, updates, and deletes on the intended tables provided if we are fine with the overhead of extra logging for every database operation on enabled tables.

    4. You need to implement the payroll application data process.

       Which two objects should you create? Each correct answer presents part of the solution.

       NOTE: Each correct selection is worth one point.

       • a data contract class that uses the Data Contract Attribute attribute
       • a service class that has a public method which accepts a single parameter for a contract
       • a class that extends Sys Operation Service Base
       • an UI Builder class that extends Sys Operation Automatic UI Builder
       Explanation:

       Scenario: You must develop a process to import payroll journals into the system.

       A: Data Contract: Data contract class is the model class defining attributes needed for batch operations. These attributes are provided by the user, in a dialog. Data Contract Attribute attribute is needed for the class and the properties methods requires Data Member Attribute attribute.

       C: Service: Service class extends from the Sys Operation Service Base class and contains the business logic for the batch operation. Developers often tend to add the business logic in controller classes, which violates the Single responsibility principle.

       Incorrect Answers:
       D: UI Builder: UI Builder class extends from Sys Operation Automatic UI Builder class and is used for adding custom behavior to dialog / dialog fields dynamically constructed by the Sys Operation framework.

13. DRAG DROP

    A company plans to deploy Dynamics 365 Finance.

    You need to recommend deployment options for the company.

    What should you recommend? To answer, drag the appropriate deployment options to the correct application requirement. Each deployment 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.

    

    

14. DRAG DROP

    You need to set up a recurring integration to enable file exchanges between Dynamics 365 Finance and a third-party system.

    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.

    

    

    Explanation:

    Step 1: Set up a data project

    Step 2: Create a recurring data job
    1. Create a recurring data job
    On the Data project page, select Create recurring data job (Step 2)
    Enter a valid name and a description for the recurring data job.
    On the Set up authorization policy tab, enter the application ID that was generated for your application, and mark it as enabled.
    Expand Advanced options tab, and specify either File or Data package (Step 3)
    Select Set processing recurrence, and then, in the Define recurrence dialog box, set up a valid recurrence for your data job (Step 4)

    Step 3: Specify whether you are using a file or data package.

    Step 4: Set up the processing recurrence

    Step 5: Link a new application ID to the data recurring data job
    You can use integration REST endpoints to integrate with the client, submit documents (import), or poll available documents for download (export). These endpoints support OAuth.

15. DRAG DROP

    You are a Dynamics 365 Finance developer.

    You need to configure integration between Dynamics 365 Finance and other tools.

    Which integration types should you use? To answer, drag the appropriate integration types to the correct requirement. Each integration type 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:

    Box 1: synchronous
    A synchronous pattern is a blocking request and response pattern, where the caller is blocked until the callee has finished running and gives a response.

    Box 2: Asynchronous
    An asynchronous pattern is a non-blocking pattern, where the caller submits the request and then continues without waiting for a response.

    Box 3: synchronous

    Box 4: Asynchronous
    A typical Batch job.

16. You are a Dynamics 365 Finance developer.

    You make changes to an existing class.

    You need to compare the code that is in source control with the updated class. In Visual Studio, you display Team Explorer.

    What are three possible ways to achieve the goal? Each correct answer presents a complete solution.

    NOTE: Each correct selection is worth one point.

    • In Team Explorer, select Compare with Latest Version.
    • In Team Explorer, select Compare with Workspace Version.
    • In Team Explorer, select Compare Files.
    • Run the tf diff command.
    • Run the vsdiffmerge command.
    Explanation:

    Example:
    In Team Explorer, right-click FMRental.xml, and select Compare with Latest Version.

    

    – Choose Compare with Latest Version to see how the changes you have made compare to the latest version of the file on your Team Foundation Server.
    – Choose Compare with Workspace Version to see what changes you have made to the version you checked out.

    D: The diff tool of Visual Studio is very good to compare two files.
    It compares, and if it is possible, displays differences between two files, files in two folders, or a shelveset and a local or a server file.

    Syntax:
    tf diff[erence] itemspec [/version:versionspec] [/type:filetype]
    [/format:format [/ignorespace] [/ignoreeol] [/ignorecase] [/recursive]
    [/options][/noprompt][/login:username,[password]]

    Incorrect Answers:
    E: vsdiffmerge is used for merging.

17. An organization has two million customers that are part of the International customer group.

    Validation must occur when customer records are updated. For all customers where the value of the customer group field is international, you must the delivery mode to Air.

    You need to update the customer records.

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

    NOTE: Each correct selection is worth one point.

    • 

    • 

    • 

    • 

    • 

    Explanation:

    This is Update and Update_RecordSet Code sample. Result of both will be same .

    TestTable TestTable;

    //Update_Recordset
    update_recordset TestTable setting Name =”New Enterprises” where TestTable.Accountnum ==”uS-027″;

    //Update
    ttsBegin;
    while select forupdate TestTable where TestTable.Accountnum ==”uS-027″
    {
    TestTable.Name =”New Enterprises”;
    TestTable.update();
    }
    ttsCommit;
    info(“OK”);

18. HOTSPOT

    You are a Dynamics 365 Finance developer.

    You need to export data from all products into a data package every day at 2 a.m. You open the Data Management workspace.

    How should you complete the process? To answer, select the appropriate options in the answer area.

    NOTE: Each correct selection is worth one point.

    

    

    Explanation:

    Box 1: Export
    Select the Import or Export (in this case) tile to create a new data project.

    Box 2: Data source
    Enter a valid job name, data source, and entity name.

    Box 3: Data project page
    O the Data project page, select Create recurring data job.

    Box 4: Setup authorization policy
    In the Set up authorization policy tab, enter the application ID that was generated for your application, and mark it as enabled.

19. You are training a new Dynamics 365 Finance developer.

    You need to recommend where asynchronous integrations should be used instead of synchronous integrations.

    For which scenario should you recommend asynchronous integration?

    • A warehouse wants to track movement of all inventory from scanners to the system.
    • A retailer wants to ensure gift card balances are communicated back to the system from point of sale (POS) terminals in near real-time.
    • A company uses an on-premises inventory management system that needs to receive sales order data every hour throughout the day.
    • A service company needs workers to be able to access just-in-time inventory data from the field by using a third-party Software as a Service (SaaS) application to ensure they have parts to complete a service.

20. HOTSPOT

    You are a Dynamics 365 Finance developer.

    You have the following entities.

    

    You must create the required fields and relationships in the staging tables.

    You need to develop a composite entity that uses the Order Header and Order Line entities.

    Which object should you use for each action? To answer, select the appropriate options in the answer area.

    NOTE: Each correct selection is worth one point.