nerdexam
Microsoft

PL-100 · Question #341

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. The question (part of a series) proposes a specific solution - likely a canvas app or a basic built-in report - to display pie charts sourced from a SharePoint-hosted Excel file that is updated daily. The answer is No because basic canvas app reports or standard report types do…

Create business solutions

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company receives its marketing campaign performance report as a Microsoft Excel file. The company stores the file in Microsoft SharePoint. A user updates the Excel file daily with updated data. The company needs a solution that automatically displays the latest analytics. You need to create a basic report that contains pie charts that display the most profitable channels. You need to propose the right solution. Solution: Microsoft Power Apps canvas app having an Excel file imported into the app and Pie chart control. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(39 responses)
  • A
    49% (19)
  • B
    51% (20)

Explanation

The question (part of a series) proposes a specific solution - likely a canvas app or a basic built-in report - to display pie charts sourced from a SharePoint-hosted Excel file that is updated daily. The answer is No because basic canvas app reports or standard report types do not automatically refresh to reflect the latest data from an externally updated Excel file in real time or on a schedule without additional configuration. The correct approach for automatically displaying the latest analytics from a regularly updated SharePoint Excel file with rich chart types like pie charts is Power BI, which natively supports scheduled refresh from SharePoint Excel sources. The proposed solution in this series item does not fulfill the automatic-refresh and chart-display requirements.

Topics

#Power Apps#Data Connectivity#Excel Data Source#Automatic Data Refresh

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice