Microsoft Microsoft Certifications MB-700 Questions & Answers

• Question 1:

  A company implements Dynamics 365 Supply Chain Management.

  The company uses a third-party analytics software solution for reporting. The solution requires permissions to ensure T-SQL code can access data.

  The company must include Dynamics 365 Supply Chain Management data in the analytics software solution to display data in a single view with other data.

  You need to identify the correct data analytics approach.

  Which solution should you use?

  A. Dual-write

  B. Microsoft Dataverse

  C. Bring your own database (BYOD)

  D. Entity store

  E. Power Bl

  Correct Answer: C

  The BYOD feature is recommended for the following scenarios:

  You must export data into your own data warehouse.

  You use analytical tools other than Power BI, and those tools require T-SQL access to data.

  You must perform batch integration with other systems.

  Incorrect:

  Not D: Entity store is the operational data warehouse. Entity store provides built-in integration of operational reports with Power BI. Ready-made reports and analytical workspaces use Entity store. If you write Power BI reports by using data in

  your application environment, you should use Entity store.

  Reference:

  https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/export-entities-to-your-own-database

• Question 2:

  You are preparing a proof of concept environment using Dynamics 365 Finance.

  You need to analyze the results generated from the Regression suite automation tool (RSAT).

  Which Lifecycle Services tool should you use to store the RSAT testing files?

  A. Asset library

  B. Business process modeler

  C. Usage profiler

  D. Methodologies

  Correct Answer: B

• Question 3:

  A company produces automotive components. The company uses Microsoft Excel to track the quantity of parts on hand. The company wants to automate processes to track inventory using Dynamics 365 Supply Chain Management You

  need to ensure that the company can track supplies and determine when to purchase new inventory.

  Which two features should you use?

  Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Demand forecasting

  B. Master planning

  C. Purchase requisitions

  D. Purchase agreements

  E. Purchase policies

  Correct Answer: AB

  Reference: https://docs.microsoft.com/en-us/dynamics365/supply-chain/master-planning/planning-optimization/demand-forecast

• Question 4:

  A company is implementing Dynamics 365 Finance. The company plans to use Business process modeler (BPM) tool to align their business processes with industry-standard processes.

  You need to help the company get started using BPM.

  Which prerequisite should the company install?

  A. Business events catalog

  B. Asset library

  C. American Productivity and Quality Center (APQC) membership

  D. Azure DevOps project

  Correct Answer: D

  Business process modeler (BPM) in Lifecycle Services (LCS), prerequisites To effectively use BPM, you must have Microsoft Office 2010 and a Microsoft Azure DevOps project. Reference: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/bpm-overview

• Question 5:

  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 sets 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 in the review screen. A company is planning to implement Dynamics 365 Supply Chain Management with three

  locations. Two locations must use United States currency (USD) as the default currency. The third location must use Canadian currency (CAD).

  One US facility and the Canadian facility must use advanced warehouse functionality. The other US facility must use basic warehousing.

  You need to configure the legal entity, site, and warehouse architecture to meet the requirements.

  Solution: Create one legal entity and differentiate capabilities by warehouse.

  Does the solution meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead create three legal entities, one for each facility. Default currency is configured per legal entity. Advanced warehouse is configured per warehouse.

• Question 6:

  You are planning to implement Dynamics 365 Finance.

  Accountants in your organization need to be able to enter multiple lines into payment journals.

  You need to recommend a tool tor expediting data entry.

  What should you recommend?

  A. Use the desktop version of Microsoft Excel to use the Excel Data Connector app.

  B. Use the Data migration tool.

  C. Use an aggregate data entity to expose data to the Microsoft Excel Data Connector app.

  D. Use Microsoft Excel online to use The Excel Data Connector app.

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/use-excel-add-in

• Question 7:

  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 sets 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 in the review screen.

  A company implements Dynamics 365 Finance.

  Forms and reports take longer than usual to open and run in the production environment.

  You need to investigate the performance issue by using SQL Insights in Lifecycle Services (LCS).

  Solution: Get table fragmentation details and index rebuild suggestions.

  Does the solution meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead check for blocked queries and high DTU.

  Reference: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/performancetroubleshooting

• Question 8:

  A company is upgrading their AX 2012 R3 environment to Dynamics 365 Finance. The company plans to upgrade the data store by using a phased approach.

  You need to define the strategy to migrate master data and opening balances.

  Which tool should you recommend?

  A. Data migration tool

  B. Upgrade analysis

  C. Usage profiler

  D. Data Import/Export Framework

  Correct Answer: D

  *

  Data Import/Export Framework (DIXF)

  Data Management Framework (DMF) is in Dynamics 365, DIXF in AX 2012. A possible solution is to use DIXF to export data from AX 2012 followed by import using DMF in Dynamics 365.

  *

  Data upgrade tool

  This Microsoft Dynamics AX 2012 data upgrade process is for self-service environments. Complete the sections of this topic in the following order:

  1.

  Prerequisites

  2.

  Data upgrade process ?Run the AX2012DataUpgradeToolKit.exe application to complete the upgrade process.

  3.

  Reporting section of the application ?Review the reports of the replication validation, replication status, data upgrade status, and rollback data upgrade status.

  4.

  Tooling section of the application.

  For this question:

  Correct answers include:

  *

  Data upgrade tool

  *

  Data Import/Export Framework Incorrect answers include:

  *

  Business process modeler

  *

  Combine XPO tool

  *

  Data migration tool

  *

  Microsoft Dynamics AX Intelligent Data Management Framework

  *

  Upgrade analysis

  *

  Usage profiler Incorrect:

  *

  Business process modeler BPM is not related to migration.

  Business process modeler (BPM) in Microsoft Dynamics Lifecycle Services (LCS) is a tool that you can use to create, view, and modify repeatable implementations that are based on business process libraries. BPM helps you align your business processes with industry-standard processes that are described by the American Productivity and Quality Center (APQC). You can perform fit-gap analysis between your business requirements and the default processes in finance and operations apps. Additionally, you can add new business processes that aren't already defined.

  *

  Data migration tool DMT applies to AX2009 only.

  *

  Upgrade analysis Run the upgrade analyzer tool against your AX 2012 environment. This tool will assist you in identifying data that can be cleaned up without losing any functionality. It also reviews your existing SQL configuration and recommends optimization for performance improvement. Deprecated features that you are currently using in AX will be highlighted to help you discover gaps in functionality and alternatives will be offered.

  *

  Microsoft Dynamics AX Intelligent Data Management Framework Data Management Framework (DMF) is in Dynamics 365.

• Question 9:

  A company manufactures and distributes sporting goods. The company uses Dynamics 365 Finance and Project Operations.

  A user's primary role is managing projects. The user must also have access to trial balances and journal entries.

  You need to determine the correct license assignment for this user.

  Which two licenses should you assign to the user? Each correct answers presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Finance attach

  B. Finance base

  C. Project Operations base

  D. Project Operations attach

  Correct Answer: BD

  Base licenses and cost savings opportunities for "attach" licenses Microsoft provides a cost-effective way for a single Dynamics 365 user to obtain full user licensing for multiple products. Licenses for products that provide core business functionality qualify as base licenses. (See the table below.) Each has one or more additional applications that are frequently used by people in the same roles and that qualify as attach licenses for that user. (These are sometimes referred to as subsequent qualifying applications.) To take advantage of the special attach license pricing:

  1.

  Buy the first base user license at standard pricing.

  2.

  Review which attach licenses are available for that base. (See the qualifying products for each base license below.)

  3.

  Buy attach licenses for the same user at an attach license price. You may buy as many attach licenses as are available for that base license. Reference: https://go.microsoft.com/fwlink/p/?LinkId=866544 (Dynamics 365 Licensing Guide)

• Question 10:

  A holding company with three independently managed and operated subsidiaries is implementing Dynamics 365 Finance.

  The company needs to ensure the restriction of data for each company from subsidiary counterparts. You need to determine an organization structure.

  Which structure should you recommend?

  A. single legal entity with security policies

  B. separate legal entities

  C. single legal entity with custom business unit financial dimension

  D. single entity that consolidates legal entities

  E. single legal entity with default business unit financial dimension

  Correct Answer: B