nerdexam
Microsoft

PL-100 · Question #214

A company creates an app that uses Microsoft Dataverse tables. The app creator wants to verify that the app is operating as expected by using a sample set of real-world data. You need to import the…

The correct answer is C. Power Query D. Dataflows. Power Query (C) is a data transformation and loading tool available directly in Power Apps (via the 'Get data' experience) that can connect to many sources and import records into Dataverse tables. Dataflows (D) are a Power Platform feature built on Power Query that allow you…

Create business solutions

Question

A company creates an app that uses Microsoft Dataverse tables. The app creator wants to verify that the app is operating as expected by using a sample set of real-world data. You need to import the sample data into Dataverse tables. Which two technologies can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options

  • APower BI
  • BSharePoint
  • CPower Query
  • DDataflows

How the community answered

(42 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    93% (39)

Explanation

Power Query (C) is a data transformation and loading tool available directly in Power Apps (via the 'Get data' experience) that can connect to many sources and import records into Dataverse tables. Dataflows (D) are a Power Platform feature built on Power Query that allow you to define ETL processes to extract, transform, and load data into Dataverse on a scheduled or on-demand basis. Both are purpose-built for importing data into Dataverse. Power BI (A) is a reporting and visualization tool - it can read from Dataverse but cannot write or import data into it. SharePoint (B) is a collaboration platform and does not directly import data into Dataverse tables.

Topics

#Dataverse#Data Import#Power Query#Dataflows

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice