Exam PL-100 topic 3 question 35 discussion

Actual exam question from Microsoft's PL-100

Question #: 35
Topic #: 3

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 has locations in multiple countries and regions across four continents.
The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table.
You need to create a visualization that displays the total amount of orders by country/region in USD.
Proposed solution:
Create a custom calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart.
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
Instead use a calculated field.
Need to calculate the exchange rate in USD.
Calculated columns are calculated in real-time when they are retrieved.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes

by Lenny001 at June 16, 2021, 7:20 p.m.

Comments

Submit Cancel

Lenny001

Highly Voted 4 years ago

Calculated fields refer to Dataverse table. The question does not mention Dataverse. On the other hand on Power BI it is possible to create new measures, new columns or quickmeasures. So the answer should ne No.

upvoted 10 times

...

Dude

Most Recent 3 years, 6 months ago

I suppose this answer is correct although a bit of a hacky way of doing things. For myself, I would have just created a standard bar chart where the data field is the currency base (OOTB this is the USD converted version **assuming your environment base currency is USD), this way no matter what currency your customer accounts and sales opportunities display as, I will still be able to view all sales in USD.

upvoted 2 times

cAMP

2 years, 3 months ago

I really don't understand the whole question set given the presence of base currency. It should be just about how to visualize, not olympics around creating currency conversion. This sh*t is OOB on Dataverse.

upvoted 1 times

...

Rivet

3 years, 9 months ago

Is this a trick question?? "total amount of orders by country/region in USD. Proposed solution:.... total amounts by REGION in a Power BI chart. The scenario includes "several countries in each region" so the totals have to be at Country/Region level.

upvoted 1 times

LeDarius3762

2 years, 10 months ago

In the other questions similar to this one, all mention country/region level. It's tricky or poorly written. But if I take it as it states, the answer is no because it's only by REGION and we need COUNTRY/REGION

upvoted 1 times

...

passtest

3 years, 11 months ago

Order table is in dataverse eventhough is not mentioned. Hence I would go for A

upvoted 2 times

...