C_BOWI_40 Question #48: Real Exam Question with Answer & Explanation

The correct answer is B: LeftPad(). Both Concatenate() and LeftPad() can produce the string 'New England' from the two input strings, while Left() and LeftTrim() serve different purposes.

Question

Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?

Options

ALeft()
BLeftPad()
CLeftTrim()
DConcatenate()

Explanation

Both Concatenate() and LeftPad() can produce the string 'New England' from the two input strings, while Left() and LeftTrim() serve different purposes.

Common mistakes.

A. Left() extracts a specified number of characters from the left side of a single string and cannot join two separate strings together.
C. LeftTrim() removes leading whitespace or specified characters from the beginning of a string and has no ability to join or concatenate two strings.

Concept tested. Web Intelligence string concatenation with Concatenate and LeftPad

Reference. https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/af135fd0571649c9ad35c8aab4490ef6/46d33c946e041014910aba7db0e91070.html

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice