Exam MB-700 topic 4 question 13 discussion

Actual exam question from Microsoft's MB-700

Question #: 13
Topic #: 4

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: Create a non-unique index on a table.

Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by Architect101 at March 7, 2024, 2:22 p.m.

Comments

Submit Cancel

Architect101

9 months ago

Selected Answer: B

correction - B - as you can't implement this solution 'in LCS'

upvoted 3 times

...

Architect101

9 months ago

Selected Answer: A

Non-Unique Index: - A non-unique index allows duplicate values in the indexed columns (a unique index does not allow this). - It speeds up query performance by providing a quick lookup mechanism, but it does not enforce uniqueness. - Non-unique indexes are commonly used to improve the retrieval speed of data in columns that may contain duplicate values.

upvoted 1 times

...