C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 2

Under which two circumstances must you select “Use Input Keys” when updating a Target Table?


Options are :

  • To optimize the pushdown SQL
  • . No primary key is specified on the source table
  • No primary key is specified on the target table
  • To specify an alternative key for the update

Answer : No primary key is specified on the target table To specify an alternative key for the update

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 3

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


Options are :

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

Answer : . Use wildcards(*.?) Use a comma separated list of files

You want to split your data set into three separate tables based on the region_id field Which two methods will accomplish the desired result?


Options are :

  • Use the Case transform and specify three expressions based on the region_id value
  • Use three Query transforms each containing a different WHERE clause based on the region_id value
  • Use the Vaildation transform and specify a validation rule based on the region_id value
  • Use the Map_Operation transform and specify a mapping filter based on the region _id value.

Answer : Use the Case transform and specify three expressions based on the region_id value Use three Query transforms each containing a different WHERE clause based on the region_id value

Which two operations can a user configured with the “Monitor” role perform?


Options are :

  • Examine Job Logs
  • Execute Jobs
  • Manage Job Schedules
  • View Job Schedules
  • View Server Group Status

Answer : Examine Job Logs View Server Group Status

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 4

Which three functions can you perform using the Validation transform?


Options are :

  • To substitute invalid values with a default value
  • . To capture Data Quality statistics that can be viewed on the Data Validation dashboard
  • To define a business rule to validate each record and column
  • To check the incoming data for duplicate rows

Answer : To substitute invalid values with a default value . To capture Data Quality statistics that can be viewed on the Data Validation dashboard To define a business rule to validate each record and column

Which two operations can Data Integrator push down to the underlying database


Options are :

  • Custom Function
  • Filtering
  • Key Generation
  • Join

Answer : Filtering Join

Which two syntactical items can you check by selecting “Validate All”?


Options are :

  • Contents of SQL function calls
  • Job structure
  • Existence of variables
  • Contents of SQL transform

Answer : Job structure Existence of variables

Which two objects can be used in a Work Flow?


Options are :

  • Custom Function
  • Work Flow
  • Datastore
  • Try/catch

Answer : Work Flow Try/catch

Which two options can you configure when using a file format as a source or target I a Data Flow?


Options are :

  • . Error File
  • Default Date Format
  • File Name
  • Column Delimiter

Answer : . Error File File Name

You have two structurally equivalent data sets which you want to append into a single target. How would you connect the input data sets?


Options are :

  • . Query transform
  • Into a single target table
  • Map_Operation transform
  • . Merge transform

Answer : . Merge transform

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 1

Which three operations can a user configured with the “Operator” role perform?


Options are :

  • Execute Jobs
  • Manage Users
  • Set Log Retention periods
  • Manage Job Schedules
  • Manage Secured Central Object Library

Answer : Execute Jobs Set Log Retention periods Manage Job Schedules

What is the correct sequence of transforms to populate a Type || Slowly Changing Dimension (SCD ||)?


Options are :

  • . Key_Generation, Table_Comparison.History_Preserving
  • Table_Comparison.Key_Generation, History_Preserving
  • History_Preserving, Table_Comparison.Key_Generation
  • Table_Comparison.History_Preserving, Key_Generation

Answer : Table_Comparison.History_Preserving, Key_Generation

Which lookup caching method reduces the number of round trips to the translate table?


Options are :

  • No_Cache
  • Smart_Cache
  • Pre_Load _Cache
  • Demand_Load_Cache

Answer : Pre_Load _Cache

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 2

What are the three possible row operation codes for input to the History_ Preserving transform?


Options are :

  • Insert
  • Update
  • Normal
  • Delete
  • Discard

Answer : Insert Update Delete

Which lookup caching method reduces system memory usage?


Options are :

  • No_Cache
  • Pre_Load_Cache
  • Demand_Load_Cache
  • Smart_Cache

Answer : No_Cache

You are executing a Job in Recovery mode and the Job fails having partially loaded the Target Table. You rerun the Job by selecting “Recover from last failed execution”


Options are :

  • The objects completed prior to and including the failed Data Flow are re-run in Auto-correct mode
  • The transaction is rolled back and the Job re-executes from the beginning
  • The objects completed prior to the failed Data Flow are skipped and the failed Data Flow continues from the point of failure
  • The objects completed prior to the failed Data Flow are skipped and the failed Data Flow is rerun from the beginning

Answer : The objects completed prior to the failed Data Flow are skipped and the failed Data Flow is rerun from the beginning

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 3

Which three operations can Data Integrator push down to the underlying database?


Options are :

  • Aggregation
  • Distinct Row
  • Ordering
  • Union

Answer : Aggregation Distinct Row Ordering

In which three objects can you include a try/catch block?


Options are :

  • Job
  • Script
  • Work Flow
  • Data Flow

Answer : Job Script Work Flow

How do you create multiple instances of the same Data Flow?


Options are :

  • Right-click_Copy/Paste Data Flow from the Job wrorkspace
  • Right-click+Replicate Data Flow from the Job workspace
  • . Right-click+Replicate on the Data Flow in the Local Object Library
  • Right-click_Copy/Paste Data Flow in the Local Object Library

Answer : . Right-click+Replicate on the Data Flow in the Local Object Library

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 4

You are running a Job in Debug mode, How long is the captured data persisted?


Options are :

  • . While the Data Flow is active in the workspace
  • While the Debug is active
  • Permanently stored in the Job Server Logs
  • Until the Job is re-executed

Answer : While the Debug is active

You are unfamiliar with the data in your customer dimension table. You decide to run a column profile on the table. Which three insights will you gain from reviewing the column profile results?


Options are :

  • Maximum string length for a varchar column
  • Number of rows that have every column duplicated
  • Count of distinct values in a column
  • Distinct values in a column

Answer : Maximum string length for a varchar column Count of distinct values in a column Distinct values in a column

Which three options are available for selecting when an audit rule fails


Options are :

  • Raise Exception
  • Write Data to Error Table
  • Script
  • Email to List

Answer : Raise Exception Script Email to List

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 5

Multiple developers are working on different projects and you want to configure a single Central Object Library. Which two requirements warrant using a Secured Central Object Library?


Options are :

  • Restrict groups of developers from adding specific objects
  • Restrict groups of developers from accessing specific objects
  • Restrict groups of developers from viewing the history of specific objects
  • Restrict groups of developers from deleting specific objects

Answer : Restrict groups of developers from accessing specific objects Restrict groups of developers from deleting specific objects

Which SQL statement displays when the “Trace SQL Readers” option is set to “Yes”?


Options are :

  • SQL from the Table_Comparison transform
  • SQL to the target tables
  • SQL from the Lookup_ext function
  • SQL from the source tables

Answer : SQL from the source tables

How do you associate a repository with the Management Console?


Options are :

  • Open the Server Manager and select “Edit Job Server Config | Add Repository
  • Open Web Administrator and select “Management |Repositories | Add”
  • Open the Server Manager and select “Edit Server Group Config| Add Repository
  • Open the Web Administrator and select “Server Groups| Server Group Config| Add Repository”

Answer : Open Web Administrator and select “Management |Repositories | Add”

C_BOE_30 SAP BO Enterprise Certified Application Associate Set 1

Where do you specify the error file to capture flat file format errors?


Options are :

  • File Format Editor
  • Trace Options of the Job
  • . Server Manager Tool
  • . Properties of the Data Flow

Answer : File Format Editor

Which three operations are available between a Local and Central Object Library?


Options are :

  • Check In
  • Add
  • Export
  • Get

Answer : Check In Add Get

Where is the data stored for a template table?


Options are :

  • Job Server memory during Job execution
  • Underlying database table only during execution
  • . Job Server memory during and after Job execution
  • Underlying database table during and after execution

Answer : Underlying database table during and after execution

C_BOE_30 SAP BO Enterprise Certified Application Associate Set 2

Which three types of group level permissions are available in a Secured Central Object Library?


Options are :

  • Full
  • Write
  • None
  • Read
  • Hidden

Answer : Full None Read

You have a Job open in the workspace. Which two objects on the current Job workspace are validated by selecting the “Validate Current” option?


Options are :

  • Script
  • Data Flow
  • Work Flow
  • Conditional

Answer : Script Conditional

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions