C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 3

You need to use an extremely web service within data integrator. What information will you need to configure data integrator to use this web service


Options are :

  • Web Service Definition Language (WSDL)
  • XML schema definition (XSD)
  • Web service URL
  • Document Type definition (DTD)

Answer : Web Service Definition Language (WSDL)

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 4

Which two items are included on the Operational Dashboard


Options are :

  • Job Execution Statistics
  • Job Schedules
  • Job Server Resource Utilization
  • Job Execution Duration

Answer : Job Execution Statistics Job Execution Duration

Which two transforms can you use to unnest XML source data?


Options are :

  • Pivot
  • XML_Pipeline
  • Hierarchy_Fattening
  • Query

Answer : XML_Pipeline Query

What are two techniques you can use when recovering a Job to avoid duplicate data loading?


Options are :

  • Use the Table_Comparison transform
  • Use the Map_CDC_Operation transform
  • Run the Job in Recover mode
  • Select “Auto Correct Load” on the Target Table options

Answer : Use the Table_Comparison transform Select “Auto Correct Load” on the Target Table options

Which two tasks must you perform to ensure the businessObject universe Bolder transfers the correct metadata lineage information


Options are :

  • Calculate column dependencies
  • Calculate column dependencies
  • Calculate usage dependencies
  • Calculate column mappings

Answer : Calculate usage dependencies Calculate column mappings

You create an expression that tests in the "Zip code" field matches a standard format to five numeric digits and the value begins with a 1or 2 which expression must you use to do this?


Options are :

  • match_pattern( value.'?[112]9999')
  • match_pattern( value.'[12]9999')
  • match_pattern( value.'[112]9999')
  • match_pattern( value.'?[12]9999')

Answer : match_pattern( value.'[12]9999')

Which lookup function returns multiple columns?


Options are :

  • Lookup
  • Lookup _Adv
  • Lookup_Seq
  • Lookup_Ext

Answer : Lookup_Ext

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 1

In which three objects can you create parameter variables


Options are :

  • Work Flow
  • Data Flow
  • Job
  • Query
  • Custom functions

Answer : Work Flow Data Flow Custom functions

Where can the XML_Pipeline transform be used within a data flow?


Options are :

  • Immediately after an XML template
  • Immediately after a Query containing nested data.
  • Immediately after an XML source message
  • Immediately after an XML source file

Answer : Immediately after an XML source message Immediately after an XML source file

You create a data flow that contains an XML file as the output. The XML file structure contains an element that is used to group other element. This element occurs once in the output XML file. Which method can you use to ensure that this element is populated correctly? For interactive and self-paced preparation of exam DMDI301, try our practice exams. Practice exams also include self assessment and reporting features


Options are :

  • Leave the form clause of the single element schema empty
  • Enter the value"1" in the single element schema mapping
  • Use a row_Generation transform and select one row then map the transform into the from clause of the single element schema
  • Place the source table that contains your source rows into the form clause of the single element schema

Answer : Use a row_Generation transform and select one row then map the transform into the from clause of the single element schema

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 2

Which two interfaces requires an adapter data store


Options are :

  • Sap R/3
  • COBOL copybook
  • Web service
  • MQ series

Answer : Web service MQ series

How do you set the degree of parallelism value at which a data flown use


Options are :

  • Right-click work flow select properties and enter a number for the "Degree of parallelism
  • Select the target table editor and enter a number for the "Number of loaders".
  • Select each transform in the data flow select properties and enter a number for the degree of parallelism.
  • Right-click data flow. Select properties and enter a number for the degree of parallelism

Answer : Right-click data flow. Select properties and enter a number for the degree of parallelism

Which two engines process jobs on the Application server


Options are :

  • Job Server
  • Batch Server
  • Access Server
  • Designer

Answer : Job Server Access Server

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 3

You have two related source tables (Department and Employees). Some employee records do not contain values for Department _ID. Which method ensures all Employees records are selected form the resulting query


Options are :

  • Specify the Employees. Department _ID = Department . Department_ID (+) in the WHERE clause.
  • Specify Employees as outer source and Department as inner source in the OUTER JOIN
  • Specify the Employees. Department _ID (+) = Department. Department _ID in the WHERE clause
  • .Specify Department as outer source and Employees as inner source in the OUTER JOIN

Answer : Specify Employees as outer source and Department as inner source in the OUTER JOIN

You need to build a job that reads a file that contains headers and footers. The header record always starts with 00. The body records start with 01. The footer record starts with 99. The header record contains customer details. The body records contain sales information. The footer indicates the number of rows in the file. The three record types contain different number of fields. You need to use all information in the file for your data flow which technique can your user to interpret this type of file.


Options are :

  • Create one format template and three data flows to configure the "ignore row markers" option to interpret the different parts of the file
  • Create three file format templates one for the header body and footer records. Load the file using three data flows and use the "ignore row marks" to separate out the header body and footer records.
  • Create one file format templates and select "yes" to "File contains Header/Footer" and the specify the header and footer markers and use the format in one data flow.
  • Create three file format templates for the format the contains the most fields. Use this format in one data flow and use case transform to separate out the header body and footer records.

Answer : Create three file format templates one for the header body and footer records. Load the file using three data flows and use the "ignore row marks" to separate out the header body and footer records.

In which object can you use audit points and rules?


Options are :

  • Work Flow
  • Data Flow
  • Script
  • Job

Answer : Data Flow

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 4

Your table contains the "sales_date" and "sales-time" fields both fields are data type archer (20). The "sales_date" format is 21-jan- 1980'. The "sales_time" format is '18-30-12'. You need to combine both fields and load the results into a single Target field of the data time data type. Which expression must you use to perform the conversion?


Options are :

  • to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')
  • to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss')
  • to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss')
  • to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss')

Answer : to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss') to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss')

You are sourcing COBOL data from a Mainframe. Which three COBOL features does native data integrator support?


Options are :

  • ISAM
  • RECORD OCCURS
  • REDEFINES
  • OCCURS DEPENDING

Answer : RECORD OCCURS REDEFINES OCCURS DEPENDING

You need to merge two tables from heterogeneous data sources and apply multiple join conditions. The tables contain very large data volumes. What is the recommended method to maximize performance and reduce system resources


Options are :

  • Use the Merge transform to merge the data into a single Table before applying the join conditions
  • Use the Data_Transfer transform to stage the tables in the same database before applying the join conditions
  • Use the Query transform to join the two tables by applying the join conditions.
  • Use the Query transform to join the two tables by applying the join conditions.

Answer : Use the Data_Transfer transform to stage the tables in the same database before applying the join conditions

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 5

Your table contains the "sales_date" and "sales-time" fields both fields are data type archer (20). The "sales_date" format is 21-jan- 1980'. The "sales_time" format is '18-30-12'. You need to combine both fields and load the results into a single Target field of the data time data type. Which expression must you use to perform the conversion


Options are :

  • to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')
  • to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss')
  • to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss')
  • to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss')

Answer : to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss')

Which three functions can you use in a script?


Options are :

  • To_Char
  • Count
  • Sysdate
  • Sleep

Answer : To_Char Sysdate Sleep

The "full name" field contains the first and last name of each employee separated by a space. Which two expressions can you use to extract only the employee's last name from this field?


Options are :

  • parse_ext(employee_name,2,' ')
  • word_ext(employee_name,2,' ')
  • parse(employee_name,2,' ')
  • word(employee_name,2,' ')

Answer : word_ext(employee_name,2,' ') word(employee_name,2,' ')

C_BOE_30 SAP BO Enterprise Certified Application Associate Set 1

Which are the three types of Data Integrator repositories?


Options are :

  • Job
  • Central
  • Profiler
  • Local
  • Batch

Answer : Central Profiler Local

You are developing a data warehouse as part of a large development team (ten plus developers). Why should you recommednd a multi-user configuration?


Options are :

  • Assign object rights by development group
  • Notify development teams when changes occur automatically
  • Enable developers to evert to previous versions of objects
  • Generate data lineage and impact analysis for the development project

Answer : Assign object rights by development group Enable developers to evert to previous versions of objects

Which conditional function lets you specify multiple conditional statements in one function call?


Options are :

  • Cond
  • Select…..case
  • Decode
  • If then else

Answer : Decode

C_BOE_30 SAP BO Enterprise Certified Application Associate Set 2

In the data flow properties, select "SQL Exception file" and enter the filename


Options are :

  • Single configuration for a single data store.
  • Multiple data store configurations for single data stores
  • Single configuration from multiple data store
  • Multiple data store configurations for multiple data stores

Answer : Single configuration from multiple data store

Your data integrator environment interprets year values greater than 15 as 1915 instead of 2015. you must ensure data integrator interprets any date from "00 to 90" as "2000 to 2090" without making direct modifications to the underlying data flow. Which method should you use to accomplish this task?


Options are :

  • Open the server manger and select edit job server config and modify the "Century change year to 90
  • Open the web administration tool and select management l requisiteness edit the production requsitury and modify the "Century change year to 90".
  • On the job server, open the windows l control panel l regional settings l Customize data and modify the two digit year interpretation to 90
  • Log into the designer and select tools l Options l data l General and modify the "Century change year" to 90

Answer : Log into the designer and select tools l Options l data l General and modify the "Century change year" to 90

You have declared a local variable in a Work Flow. Which three objects in the Work Flow can use the variable?


Options are :

  • Data Flow
  • Conditional
  • Script
  • While

Answer : Conditional Script While

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 1

Which three column level metadata attributes are transferred to the semantic universe layer of businessobjects Enterprise via the businessobjects universe builder


Options are :

  • Default values
  • Business Name
  • Column_Usage
  • Business Description

Answer : Business Name Column_Usage Business Description

In which three places can you set a global variable?


Options are :

  • Work Flow properties
  • Job properties
  • Script
  • Web Administrator

Answer : Job properties Script Web Administrator

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions