Microsoft Dynamics 365 Customer Insights – Data — Question 2

You are a Customer Data Platform Specialist. Your organization is using Power Query when connecting to Data Sources in audience insights. You need to load eCommerce Contacts to audience insights.
Which statement about loading data to audience insights using Power Query is correct?

Answer options

• A. You must create a separate Power Query data source for each entity you wish to ingest.
• B. Power Query automatically recognizes header rows in files when you use the Text/CSV connector.
• C. After you save a Power Query data source, you have to manually trigger the initial refresh process.
• D. You can add additional entities to the data source using Get Data functionality in the Power Query.

Correct answer: D

Explanation

The correct answer is D because Power Query allows users to add more entities to their data source through the Get Data functionality. Option A is incorrect as multiple entities can be ingested from a single Power Query data source. Option B is wrong because while Power Query generally recognizes headers, this may not always be the case depending on the file structure. Option C is incorrect since the initial refresh can be set to occur automatically upon saving the data source.