Exam PL-100 All Questions

View all questions & answers for the PL-100 exam

Exam PL-100 topic 3 question 33 discussion

Actual exam question from Microsoft's PL-100

Question #: 33
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 column that converts the order total to USD by using the relationship between order local currency and the USD exchange rate table in Power BI
Desktop and display this column in a Power BI chart by country/region.
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
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 daporh at June 10, 2021, 8:46 a.m.

Comments

Submit Cancel

daporh

Highly Voted 4 years ago

Answer should be A

upvoted 13 times

AbhiAg

4 years ago

hi could you plz mention why A ?

upvoted 2 times

Lenny001

4 years ago

I agree: answer is A. In Power BI Desktop it is possible to create new measures, new columns or quick measures.

upvoted 2 times

AliceVO

3 years, 1 month ago

however the question says 'custom column' and not 'calculated column' or 'measure'. I suspect the wording is meant to be confusing so that you may fall into errors.

upvoted 3 times

...

Nitrix

3 years ago

B, because you want to have the actual rates right? So calculated can give you that in real time.

upvoted 1 times

...

RazielLycas

Most Recent 2 years, 7 months ago

Selected Answer: B

I agree with the "is not calculated" theory of AliceVO

upvoted 1 times

...

Wonderama

3 years ago

Answer is A since the requirement is a visualization and visualizations are done in Power BI. See: Visualize your data quickly from Power Apps and Dynamics 365 apps (preview) - Power BI | Microsoft Docs.

upvoted 1 times

...

Sanjay_Pathak

3 years ago

It is saying create custom columns. Power BI measures are not custom columns. So answer is No.

upvoted 2 times

...

Fredone

3 years, 6 months ago

The answer is B, because the column has non calculation and the type is not currency.

upvoted 1 times

...

Dude

3 years, 6 months ago

This answer is correct, you do not need a calculated column, just create a view or chart using the currency base field. This will show all sales in the environment currency and not the amount shown in the currency field.

upvoted 1 times

...