MCB Data Cloud Certification Practice Exam

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the MCB Data Cloud Certification Exam with interactive quizzes. Utilize flashcards and multiple choice questions for a comprehensive study experience. Each question includes hints and explanations to enhance learning. Gear up for your certification!

Practice this question and more.

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

SELECT(["revenue"]*1.05)
sourceField("revenue")*5%
sourceField("revenue")*1.05
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.