A developer has a source system provided by another company. One of the columns in a table has spaces before each piece of data and is in uppercase which makes the reports unreadable. How can this…

Question

Options

• Athere is no built in capability for this in a data module and the developer needs to create a
• Bthere is no built in capability for this in a data module and the report needs Trim and Lower
• Cusing the 'Clean' menu item on the data item
• Dusing the 'Prepare' menu item on the data item

• A
  83% (20)
• B
  4% (1)
• C
  13% (3)

Explanation

Option A is correct because data modules in this context (likely IBM Cognos Analytics) do not provide a built-in, point-and-click menu option to simultaneously remove leading spaces and convert text to lowercase - the developer must create a custom expression using functions like TRIM() and LOWER() directly on the data item.

Option B is wrong on the right track functionally (Trim and Lower are indeed the needed operations) but is incorrect because placing that logic in the report rather than the data module violates the principle of fixing data quality at the source layer - every report consuming that module would otherwise need the same workaround.

Option C is a distractor: there is no 'Clean' menu item in a data module for this purpose, making it an invented option designed to sound plausible.

Option D is similarly a distractor: while a 'Prepare' option may exist in data module interfaces for other purposes, it does not resolve the specific combination of leading-space removal and case transformation described here.

Memory tip: Think "fix it at the source, manually." Data modules sound powerful, but for string cleanup like spacing and casing, you're writing the expression yourself - no magic menu exists. If you see answer choices offering a neat UI shortcut inside a data module for text formatting, treat them with suspicion.

No community discussion yet for this question.