Exam MB-700 topic 2 question 49 discussion

Actual exam question from Microsoft's MB-700

Question #: 49
Topic #: 2

A company implements Dynamics 365 Supply Chain Management.

The company uses a third-party analytics software solution for reporting. The solution requires permissions to ensure T-SQL code can access data.

The company must include Dynamics 365 Supply Chain Management data in the analytics software solution to display data in a single view with other data.

You need to identify the correct data analytics approach.

Which solution should you use?

A. Dual-write
B. Microsoft Dataverse
C. Bring your own database (BYOD)
D. Entity store
E. Power BI

Show Suggested Answer

Suggested Answer: C 🗳️

by kroush at June 24, 2023, 9:17 p.m.

Comments

Submit Cancel

924ppk

1 year ago

To integrate Dynamics 365 Supply Chain Management data with a third-party analytics software solution, the most suitable approach would be Entity store. This feature allows you to create a data store that can be used by external applications, such as your analytics software, to access Dynamics 365 data1. It’s designed to provide a secure and efficient way to share data between Dynamics 365 and other systems.

upvoted 1 times

924ppk

1 year ago

Bring your own database (BYOD) BYOD allows data from Dynamics 365 to be exported to an Azure SQL Database. This database can then be accessed using T-SQL, making it an ideal choice for third-party analytics tools that require direct SQL access to data. This approach also facilitates combining Dynamics 365 data with other data sources in a single view. Entity store The Entity Store is an operational data store optimized for analytical workloads and is designed for use with embedded Power BI reports in Dynamics 365. However, it is not intended for direct T-SQL access by third-party tools. Power BI

upvoted 4 times

...

kroush

1 year, 11 months ago

correct

upvoted 2 times

...