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?
Instead check for blocked queries and high DTU.
A company uses Dynamics 365 Supply Chain Management and has two legal entities that distribute the same items. One of the legal entities uses advanced warehouse management.
New items that are created must meet the business needs of both companies and allow for consolidated analytics.
You need to recommend a master data management strategy to standardize the item master and meet the business requirements.
What should you recommend?
A company is planning a One Version strategy for its Dynamics 365 Finance implementation.
Developers use local, downloaded VHD development environments to develop new functionality. Previous developers had to redo some modifications because customizations were created on outdated versions of the software. The One Version strategy must therefore include steps to ensure that developers are developing against the latest updates
You need to include an update strategy for the development environments.
Solution: Update the VHD development environments each time there is a Dynamics 365 Finance major service release.
Does the solution meet the goal?
A company is moving financial workloads to Dynamics 365 Finance.
Balance sheet accounts do not require department dimension postings while profit and loss accounts require department dimensions.
You need to determine which functionality achieves the goal.
What should you recommend?
A company uses Dynamics 365 Supply Chain Management.
The system has a slow response time when sales orders are entered.
You need to identify any blocking SQL statements.
Which Lifecycle Services (LCS) tool should you use?
All SQL performance tools in LCS are available under the SQL Insights tab on the Environment Monitoring page for a specific environment. The following tabs are available:
Live View -- Shows executing statements and blocking statements. The current SQL Now page that shows performance issues will be replaced with Live View.
Index Analysis -- Shows aggregated index and table information, based on user scans, user seeks, user updates, and row count. Like performance metrics, this tool shows the trend for the selected index along with additional table metrics. This feature is not available in self-service environments.
Queries -- Shows a list of predefined queries that can be used to retrieve metrics on demand. Examples of queries include a current blocking tree, a list of active plan guides, and a list of most expensive queries.
Etc.
