C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 1

Which three objects does the Management Console “Impact and Lineage analysis” capture?


Options are :

  • BusinessObjects reports
  • Source files
  • SQL function tables
  • . Lookup tables

Answer : BusinessObjects reports Source files . Lookup tables

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 2

What three types of errors can you catch in a try/catch block?


Options are :

  • Repository Access Errors
  • Database Access
  • File System Access
  • Scripting Syntax

Answer : Repository Access Errors Database Access File System Access

Which two components are required to execute a batch job?


Options are :

  • Repository
  • Designer
  • Batch Server
  • Central Management Console
  • Job Server

Answer : Repository Job Server

What are three ways to view the push down SQL generated by a Data Flow


Options are :

  • . Right –click on the Data Flow and select “Audit I Store push-down SQL
  • . Right –click on the Data Flow and select “Display Optimized SQL”
  • . Select “Display Optimized SQL” from the Validation menu.
  • Select “Trace SQL Readers” from the Trace options when executing a Job.

Answer : . Right –click on the Data Flow and select “Display Optimized SQL” . Select “Display Optimized SQL” from the Validation menu. Select “Trace SQL Readers” from the Trace options when executing a Job.

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 3

Which three methods can you use to create a local variable


Options are :

  • Select Tools | Variables | Local Variables in the Work Flow workspace
  • Select Tools | Variables | Local Variables in the Job workspace
  • Select the Variables tab in the Smart Editor of a custom function
  • Select Tools | Variables | Local Variables in the Data Flow workspace

Answer : Select Tools | Variables | Local Variables in the Work Flow workspace Select Tools | Variables | Local Variables in the Job workspace Select the Variables tab in the Smart Editor of a custom function

Which tool must you use to create a Data Integrator Local Object Repository?


Options are :

  • Central Management Console
  • Repository Manager
  • Management Console
  • Designer

Answer : Repository Manager

Your sales order fact table load contains a reference to a customer _id not found in the customer dimension table. How can you replace the customer_id with a default value and preserve the original record using the Validation transform?


Options are :

  • Select “In” option and “Action On Failure I Send to Fail”, select “For pass, substitute with”.
  • Select “Exists in table” and “Action On Failure I Send to Fail”, select “For Pass, substitute with”.
  • Select “Exists in table” and “Action On Failure I Send to Both”, select “For Pass, substitute with
  • Select “In” option and “Action On Failure I Send to Both”, select “For pass, substitute with”.

Answer : Select “Exists in table” and “Action On Failure I Send to Both”, select “For Pass, substitute with

C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 4

You are developing a data warehouse as part of a large development team (ten plus developers) Way should you recommend a multi-user configuration


Options are :

  • Store table column and relationship profile data including history
  • Track the version history history of objects(audit trrail)
  • Attach documentation based on object history
  • . Ensure only one developer is working on a specific set of objects

Answer : Track the version history history of objects(audit trrail) . Ensure only one developer is working on a specific set of objects

Where do you specify the columns for a template table?


Options are :

  • In the template table editor
  • In the output schema of the preceding transform
  • Import from the underlying database structure
  • Cut/Paste from an existing query output

Answer : In the output schema of the preceding transform

Which tool must you use to manage and configure server groups?


Options are :

  • Web Administrator
  • Metadata Manager
  • Repository Manager
  • Server Manager

Answer : Web Administrator

You are unfamiliar with the data in the customer dimension and sales fact tables. The tables are related by the customer_id field. You execute a relationship profile on the tables. Which two insights will you gain from reviewing the relationship results?


Options are :

  • Customers records in the sales table that have matching records in the customer table
  • . Foreign key constraints that ensure customers in the customers table also have matching records in the sales table
  • Customers records in the customer table that have matching records in the sales table
  • Foreign key constraints that ensure customers in the dales table also have matching records in the customer table

Answer : Customers records in the sales table that have matching records in the customer table Customers records in the customer table that have matching records in the sales table

How do you create a global variable?


Options are :

  • Select Tools | Options| Project | Variables
  • Select Tools |Variables|Global Variables in the Job workspace
  • Select Global Variables in the Job properties
  • Select Global Variables in the Work Flow properties

Answer : Select Tools |Variables|Global Variables in the Job workspace

What are the two required steps to make a database table available in a Data Flow?


Options are :

  • Profile database table
  • . Add connection details to Data Flow properties
  • . Import table metadata
  • Create a datastore

Answer : . Import table metadata Create a datastore

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 1

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


Options are :

  • Nested Schemas
  • Columns
  • Functions
  • Group By
  • Filters

Answer : Nested Schemas Columns Functions

When you read an XML schema into the Local Object Library, which three types of XM metadata are imported?


Options are :

  • Styles
  • Attributes
  • Elements
  • Data Types

Answer : Attributes Elements Data Types

Which two changes to your Source Table requires you to re-import the metadata?


Options are :

  • . Index changes
  • Truncated table data
  • . New records added
  • Table structure changes

Answer : . Index changes Table structure changes

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 2

Your source table contains sales data for multiple countries. You need to calculate sales tax differently for each specific country. The sales tax for some countries requires multiple steps to calculate. What is the recommended method you should use?


Options are :

  • Use the SQL transform and specify the sales tax calculation in the SQL statement
  • Use a Query transform and the Decode ( ) function to apply the sales tax calculations
  • Use a Validation transform to create the sales tax calculations
  • . Use a Case transform to separate the countries, then apply the Sales Tax Calculation Using Query transforms

Answer : . Use a Case transform to separate the countries, then apply the Sales Tax Calculation Using Query transforms

Which two functions can you use in a Query?


Options are :

  • . Lookup_Ext
  • Exec
  • Count
  • Sleep

Answer : . Lookup_Ext Count

Which two rules must you following to deploy a Server Group architecture?


Options are :

  • . All the Job servers in the server group must be associated with the same repository
  • Each computer can only contribute one Job server to a server group
  • . All Job servers in a server group must be active for the server group to function
  • A maximum of four servers can be added to a server group

Answer : . All the Job servers in the server group must be associated with the same repository Each computer can only contribute one Job server to a server group

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 3

Which three expressions convert a null value to 0?


Options are :

  • Case (field is NULL, 0, field)
  • Decode (field is NULL, 0, field)
  • If then else (field is NULL,0,field)
  • Nvl (field,0)

Answer : Decode (field is NULL, 0, field) If then else (field is NULL,0,field) Nvl (field,0)

Which two steps are part of the profiling configuration process?


Options are :

  • Use the Repository Manager to create the profiler repository
  • . Use the Data Quality dashboard to review high level profiler result details
  • Use the Repository Manager to create/update/delete profiler users
  • . Use the Server Manager to associate the profiler repository with the job server

Answer : Use the Repository Manager to create the profiler repository . Use the Server Manager to associate the profiler repository with the job server

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


Options are :

  • Columns that contain only null data
  • SUM of the numeric column values
  • Count of distinct values in a column
  • Distinct values in a column

Answer : Columns that contain only null data Count of distinct values in a column Distinct values in a column

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 4

Which two options must you set to capture your audit information to the Trace Logs?


Options are :

  • . Select “Enable Auditing” in the Job parameters
  • Select “Edit Job Server Config” I “Enable Auditing” in the Server Manager
  • Select Tools I Options I Designer I General I Capture Audit Data
  • Set Trace Audit Data to “Yes”

Answer : . Select “Enable Auditing” in the Job parameters Set Trace Audit Data to “Yes”

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?


Options are :

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

Answer : Use a Validation transform and enable validation rules on the required columns

Which caching method reduces the amount of system memory used by the Table_ Comparison transform


Options are :

  • In memory
  • Cached comparison table
  • Row_by_row select
  • Pre_load cache

Answer : Row_by_row select

C_BODI_20 SAP Certified Application Associate SAP BO Test Set 5

How do you commit all rows in a single transaction?


Options are :

  • Specify “Rows per commit” equal to zero
  • Specify the “Number of loaders” equal to one
  • Select “Include in transaction” in the target table options
  • Select “Commit at the end of Insert… Select”

Answer : Select “Include in transaction” in the target table options

What is the function of the Merge transform?


Options are :

  • To append two column values together
  • To apply an auto update to your target table
  • . To join incoming data sets based on a relationship
  • To apply a union all to the incoming data streams

Answer : To apply a union all to the incoming data streams

What three functions can you perform via the Web Administrator?


Options are :

  • Managing Central Object Library users and groups
  • Create Repositories
  • Adding and Removing Users
  • Setting the Log Retention period
  • Adding and Removing Jobs

Answer : Managing Central Object Library users and groups Adding and Removing Users Setting the Log Retention period

C_BOE_30 SAP BO Enterprise Certified Application Associate Set 1

Which two objects can be used in a Data Flow?


Options are :

  • Work Flow
  • XML Schema
  • Conditional
  • Template Table

Answer : XML Schema Template Table

Which two tasks can you perform using Data Integrator Designer?


Options are :

  • Create Auto Documentation
  • . Launch Data Integrator Jobs
  • Iplort Metadata
  • Schedule Data Integrator Jobs

Answer : . Launch Data Integrator Jobs Iplort Metadata

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions