SAP C_BOWI_42 Quiz 20 Topic 4 Questions 96-100

Question: 1

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

There are 2 correct answers to this question.

Response:

ALeft()

BLeftPad()

CLeftTrim()

DConcatenate()

Show Answer

Question: 2

Which three statements about the If() function are correct?

There are 3 correct answers to this question.

Response:

AValues within the function must be in quotes.

BThe function can be used to create a variable.

CThe function can contain an aggregate function.

DThen and Else keywords can be used within the function instead of the semicolon.

Show Answer

Question: 3

Which two statements about the If() function are correct?

There are 2 correct answers to this question.

Response:

ACan contain a SQL statement

BCan contain a Case expression

CContains a Boolean expression

DCan contain nested If() statements

Show Answer

Question: 4

Which three are drill options?

There are 3 correct answers to this question.

Response:

AHide drill toolbar

BShow drill filters

CPrompt if drill requires additional data

DSynchronize drill on report blocks

Show Answer

Question: 5

How do you duplicate a query?

Please choose the correct answer.

Response:

AChoose Duplicate Query in the Tools Menu

BSelect Duplicate Query in Properties in the Query Panel

CRight-click Query in the Report Manager and select Duplicate Query

DRight-click the Query Tab in the Query Panel and select Duplicate Query

Show Answer

Which two functions can you use to concatenate the strings 'England' and 'New' to create the string 'New England'?There are 2 correct answers to this question.Response:

Which three statements about the If() function are correct?There are 3 correct answers to this question.Response:

Which two statements about the If() function are correct?There are 2 correct answers to this question.Response:

Which three are drill options?There are 3 correct answers to this question.Response:

How do you duplicate a query?Please choose the correct answer.Response:

SAP C_BOWI_42 Quiz:20 Topic:4 Questions:96-100

Which two functions can you use to concatenate the strings 'England' and 'New' to create the string 'New England'?
There are 2 correct answers to this question.
Response:

Which three statements about the If() function are correct?
There are 3 correct answers to this question.
Response:

Which two statements about the If() function are correct?
There are 2 correct answers to this question.
Response:

Which three are drill options?
There are 3 correct answers to this question.
Response:

How do you duplicate a query?
Please choose the correct answer.
Response: