Which object in Dynamics 365 Finance and Operations is used to create an index on a table?

Field node in the table designer

Index node in the table designer

Relation node in the table designer

A query that retrieves customer transactions frequently filters on the CustomerAccount field and the TransactionDate field. The table already has a non-clustered index on CustomerAccount. The query is still slow. What should you do?

Drop the existing index on CustomerAccount and create a clustered index on TransactionDate.

Create a composite index on CustomerAccount and TransactionDate.

Create a separate index on TransactionDate only.

Use the 'Include' option to add TransactionDate as an included column to the existing index.

A table has a non-clustered index on the Status field. Queries that filter on Status and OrderDate are slow. You need to modify the index to improve performance. What should you do?

Add OrderDate as an included column to the existing index.

Change the index to a composite index on Status and OrderDate.

Drop the index and create a new one on OrderDate only.

A financial report that uses a data provider to fetch data from multiple tables is timing out. The report is used by controllers to view monthly balances. You need to improve the report's performance. What should you do?

Move the report to a batch process that runs overnight.

Optimize the data provider query by adding appropriate indexes on the tables used in the report's query.

Increase the report's timeout value in the report design.

Change the report to use a 'CrossCompany' query to include all legal entities.

A table has an existing non-clustered index on the 'Status' field. A new query filters on both 'Status' and 'CreatedDateTime'. The query is slow. You need to modify the index to improve performance without affecting other queries that use the index. What should you do?

Drop the existing index and create a new composite index on 'Status' and 'CreatedDateTime'.

Create a new separate index on 'CreatedDateTime' and leave the existing index unchanged.

Change the index key to 'CreatedDateTime' and then 'Status'.

Add 'CreatedDateTime' as an included column to the existing index on 'Status'.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 7Objective 3

Optimize Performance MB-500 Practice Questions (Page 7)

Part of the Implement security and optimize performance domain, which accounts for 10–15% of the MB-500 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~4–10 in this domain), expect 1–3 from this objective — we provide 41 practice questions to prepare you well beyond it. (estimate)

41questions here

9free pages

10concepts

10–15%of the exam

Questions 31–35

31foundation · easy
Which object in Dynamics 365 Finance and Operations is used to create an index on a table?
Select an answer first
32application · medium
A query that retrieves customer transactions frequently filters on the CustomerAccount field and the TransactionDate field. The table already has a non-clustered index on CustomerAccount. The query is still slow. What should you do?
Select an answer first
33application · medium
A table has a non-clustered index on the Status field. Queries that filter on Status and OrderDate are slow. You need to modify the index to improve performance. What should you do?
Select an answer first
34application · medium
A financial report that uses a data provider to fetch data from multiple tables is timing out. The report is used by controllers to view monthly balances. You need to improve the report's performance. What should you do?
Select an answer first
35expert · hard
A table has an existing non-clustered index on the 'Status' field. A new query filters on both 'Status' and 'CreatedDateTime'. The query is slow. You need to modify the index to improve performance without affecting other queries that use the index. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to MB-500

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “MB-500” is a trademark of its owner, used for identification only.