Q:
Your company needs to export aggregated data from multiple entities in Microsoft Dynamics 365 finance and operations apps for analysis.
You need to create a solution that allows for the export of combined data from several entities.
What should you do?
-
A
Manually merge data in Excel after exporting individual entities.
-
B
Develop and export a composite data entity that includes all the required entities.
-
C
Export each entity separately and combine them using an external database tool.
-
D
Create a custom SQL view in the application database to combine the data.
B