Microsoft Exam PL-100 Topic 7 Question 75 Discussion

Actual exam question for Microsoft's PL-100 exam

Question #: 75
Topic #: 7

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 Bl report querying Excel file using its path.

Does the solution meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: A

by Deangelo at Apr 20, 2024, 05:35 AM

Limited Time Offer

25%

Off

Get Premium PL-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Junita

4 months ago

I'm leaning towards agreeing that the proposed solution does meet the goal, but there could be room for improvement.

upvoted 0 times

...

Cristy

5 months ago

I would prefer a solution that can also pull data from other sources, not just Excel.

upvoted 0 times

...

Ira

5 months ago

I think the proposed solution is efficient for generating the pie charts.

upvoted 0 times

...

Felicitas

5 months ago

I see both points. It's important that the latest analytics are displayed automatically.

upvoted 0 times

...

Mayra

6 months ago

I disagree. I believe the solution should automatically update the report without querying.

upvoted 0 times

...

Cruz

6 months ago

I think the solution meets the goal because it queries the Excel file directly.

upvoted 0 times

...

Lyndia

7 months ago

Great, let's implement it then.

upvoted 0 times

...

Fernanda

7 months ago

Yes, the solution meets the goal.

upvoted 0 times

Yoko

6 months ago

The Power BI report querying the Excel file path is an efficient way to achieve the goal.

upvoted 0 times

...

Junita

6 months ago

This solution will definitely meet the company's needs for displaying real-time data.

upvoted 0 times

...

Lindsey

6 months ago

The automated solution will ensure accurate and up-to-date analytics.

upvoted 0 times

...

Francis

6 months ago

The company will save time not having to manually create updated reports.

upvoted 0 times

...

Franchesca

6 months ago

That's perfect for displaying the most profitable channels using pie charts.

upvoted 0 times

...

Emily

6 months ago

Great, the Power BI report will automatically update with the latest data from the Excel file.

upvoted 0 times

...

Micheline

6 months ago

Yes

upvoted 0 times

...