Q:
You need to optimize the data model for a new feature that tracks international trade agreements.

You need to ensure that the table design supports efficient data retrieval and storage. It must still maintain referential integrity between trade agreements and participating countries.

What should you do? Each correct answer presents part of the solution. Choose three.

A Add a relation to the trade agreements table that references the countries table with corresponding delete actions.
B Create an index on the trade agreements table to improve query performance on frequently accessed fields.
C Implement field groups in the trade agreements table to optimize data retrieval for forms and reports.
D A, B and C

Share this MCQ

Answer: D

Explanation:

Wrong: Remove all indices from the trade agreements table to reduce storage overhead.

Wrong: Increase the size of string fields in the countries table to accommodate longer country names.

Wrong: Duplicate country data in both the trade agreements and countries tables for faster access.

Adding a relation with delete actions ensures referential integrity and cascading deletes or updates where appropriate. Creating an index on frequently accessed fields improves query performance without unnecessary storage overhead. Implementing field groups optimizes data retrieval for user interfaces and reports. Increasing the size of string fields unnecessarily does not contribute to efficiency and may increase storage costs. Removing all indices would degrade performance. Duplicating data in multiple tables violates normalization principles and can lead to data inconsistencies.

Create tables and table fields - Training | Microsoft Learn

Add fields to tables through extension - Finance & Operations | Dynamics 365 | Microsoft Learn

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

Share Above MCQ

‹ Previous Next ›

Write your comment

Learn More MCQ Questions from Certification Exam Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Report Question