Free SAP C-BODI-20 Exam Dumps Questions & Answers

You have a source table that contains fifty columns. You need to place business rules on thirty of the columns to check the format of the source data and filter the valid and invalid records. You also want to analyze the column values that fail. What is the recommended method you should use?

• A.Use two Query transforms with different WHERE clauses to filter the invalid records
• B.Use a Map_Operation transform to map valid and invalid data rules
• C.Use a Validation transform and enable validation rules on the required columns
• D.Use a Case transform to create two conditions that filter the invalid records

A global variable is set to restrict the number of rows being returned by the Query transform. Which two methods can you use to ensure the value of the variable is set correctly? (Choose two)

• A.Place the data-flow in a try catch block
• B.Use the debugger to view the variable value being set.
• C.View the job monitor log for the variable value
• D.Add the variable to a script inside a print statement

Which two methods can you use to specify multiple files in the same source file format? (Choose two)

• A.Specify a file Lookup table
• B.Use wildcards(*.?)
• C.Use a comma separated list of files
• D.Create a file list .txt file

Which three elements can be contained in the output schema of a query? (Choose three)

• A.Columns
• B.Nested Schemas
• C.Functions
• D.Order By
• E.Group By
• F.Filters

Which three expressions convert a null value to 0? (Choose three)

• A.If then else (field is NULL,0,field)
• B.Nvl (field,0)
• C.Case (field is NULL, 0, field)
• D.Decode (field is NULL, 0, field)