Microsoft Dynamics 365 Customer Insights – Data — Question 21

An organization is using Microsoft Power Query when connecting to data sources in Microsoft Dynamics 365 Customer Insights.

You need to load eCommerce Contacts to Dynamics 365 Customer Insights using Power Query.

Which is an appropriate action to take when using Power Query to ingest data?

Answer options

• A. You can only add additional columns to the dataset in Power Query before the data source is created in Dynamics 365 Customer Insights.
• B. You must create a separate Power Query data source for each entity you wish to ingest.
• C. After you save a Power Query data source, you have to manually trigger the initial refresh process.
• D. You must select Power Query as an import method when creating the data source.

Correct answer: D

Explanation

The correct answer is D, as it is essential to select Power Query as the import method to successfully load data into Dynamics 365 Customer Insights. Option A is incorrect because additional columns can be added after the data source is created. Option B is wrong since multiple entities can be ingested using a single Power Query data source. Option C is also incorrect because the initial refresh can occur automatically after saving the data source.