nerdexam
Microsoft

PL-100 · Question #58

A company has an on-premises system that stores product information. The company plans to replace the information with a Power Platform solution that uses the Common Data Service. The Power Platform…

The correct answer is A. Dataflow D. Data gateway. Two tools are needed: (A) Dataflow and (D) Data gateway. A Dataflow uses Power Query to connect to data sources, transform data (cleanse, reshape, merge), and load it into Common Data Service/Dataverse - it handles the ETL (Extract, Transform, Load) requirement. An on-premises…

Create business solutions

Question

A company has an on-premises system that stores product information. The company plans to replace the information with a Power Platform solution that uses the Common Data Service. The Power Platform solution needs to use data from the product information system. You need to transform and import the data from the product information system. Which two tools should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • ADataflow
  • BBusiness process flow
  • CPower BI Desktop
  • DData gateway

How the community answered

(44 responses)
  • A
    84% (37)
  • B
    9% (4)
  • C
    7% (3)

Explanation

Two tools are needed: (A) Dataflow and (D) Data gateway. A Dataflow uses Power Query to connect to data sources, transform data (cleanse, reshape, merge), and load it into Common Data Service/Dataverse - it handles the ETL (Extract, Transform, Load) requirement. An on-premises Data gateway is required because the source system is on-premises; it acts as a secure bridge between the on-premises data and cloud services like Power Platform. Business process flow is for automating user workflows, not importing data. Power BI Desktop is for analytics and reporting, not for writing data into Common Data Service.

Topics

#Data integration#Power Platform Dataflows#Data Gateway#Data transformation

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice