MCB Data Cloud Certification Practice Exam

Which formula correctly displays the value of the raw data column of "revenue" plus a 5% margin?

1. SELECT(["revenue"]*1.05)

2. sourceField("revenue")*5%

3. sourceField("revenue")*1.05

4. SELECT(["REVENUE"]*1.05)

The correct answer is: sourceField("revenue")*1.05

The choice that correctly displays the value of the raw data column of "revenue" plus a 5% margin is based on the fundamental calculation of increasing a value by a certain percentage. The formula takes the value from the "revenue" column and multiplies it by 1.05. This is because multiplying by 1.05 effectively adds 5% to the original amount. When calculating a percentage increase, it's standard practice to express it in this way where you add 100% (which is represented as 1) to the desired percentage increase (in this case, 5%, which is represented as 0.05). In this formula, multiplying the "revenue" by 1.05 means you're getting the original value plus an additional 5% of that value. Various other options presented do not correctly portray this calculation. For instance, using 5% directly in formulas or a different multiplier doesn't account for adding to the base revenue in the proper format. Thus, choice C stands out as the correct approach to achieve the desired output of revenue plus a 5% margin.