ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 163 - PL-100 discussion

Report
Export

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.

A.

Power BI

Answers
A.

Power BI

B.

SharePoint

Answers
B.

SharePoint

C.

Power Query

Answers
C.

Power Query

D.

Dataflows

Answers
D.

Dataflows

Suggested answer: C, D

Explanation:

C: You can create a table in Dataverse and fill that table with data from an OData feed by using Power Query. You can use the same techniques to integrate data from these online and on-premises sources, among others:

SQL Server

Salesforce

IBM DB2

Access

Excel

Web APIs

OData feeds Text files

D: You can create a new Dataverse table that stores all the metadata from the dataflow run. For every refresh of a dataflow, a record is added to this table. You can also store metadata for multiple dataflow runs in the same table.

Reference: https://docs.microsoft.com/en-us/power-query/dataflows/load-dataflow-metadata-into-dataverse-table https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query

asked 05/10/2024
Areeluck Parnsoonthorn
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first