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
You have a Job open in the workspace. Which three objects on the current Job workspace can you validate by selecting the ?Validate All? option
Options are :
- Data
- WorkFlow
- Data Flow
- Script
Answer : WorkFlow
Data Flow
Script
You create a job containing two work flows and three data flows. The data flows are single threaded and contain no additional function calls or sub data flow operations running as separate processes. How many "al_engine"processes will run on the job server?
Options are :
Answer : Four
You load over 10,000.000 records from the "customer" source table into a staging are a. You need to remove the duplicate customer during the loading of the source table. You do not nee tot record or audit the duplicates. Which two do-duplicating techniques will ensure that best performance
Options are :
- Use a Query transform to order the incoming data set an use the previous_row-value in the where clause to filter any duplicate row
- Use the Query transform to order the incoming data set. Then a table_comparison transform with "input contains duplicates" and the "sorted input" options selected
- Use the lookup_ext function. With the Pre_load_cache" option selected to test each row for duplicates.
- Use tha table_ comparison transform with the "input contains duplicates" and "cached comparison table" selected
Answer : Use a Query transform to order the incoming data set an use the previous_row-value in the where clause to filter any duplicate row
Use the Query transform to order the incoming data set. Then a table_comparison transform with "input contains duplicates" and the "sorted input" options selected
You create a real-time job that processes data from an external application. Which two mechanisms enable the external application to send/receive messages to the real-time job?
Options are :
- E-mail
- Adapter instance
- File on shared server
- Web service call
Answer : Adapter instance
Web service call
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 1
Which three combinations of input and output schemas are permitted in on embedded data flow
Options are :
- 1 input and multiple outputs
- 0 input and 1 outputs
- 1 input and 1 outputs
- 1 input and 0 outputs
Answer : 0 input and 1 outputs
1 input and 1 outputs
1 input and 0 outputs
Which three objects can you use as a source in a Data Flow?
Options are :
- Excel file
- Template table
- Row_Generation transform
- Pivot transform
Answer : Excel file
Template table
Row_Generation transform
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 2
When is a template table created in the database?
Options are :
- You right-click and select ?Create? on a template table
- You right-click and select ?Import? a template table to a permanent table
- You create a template table on the Data Flow
- You execute a Job
Answer : You execute a Job
Which two data integrator objects/operations support load balancing in a server Group based architecture
Options are :
- Lookup_ext
- Script
- Job
- While loop
Answer : Lookup_ext
Job
Which three objects does the Management Condole ?Iplact and Lineage analysis? capture?
Options are :
- Source tables
- Target files
- SQL transform tables
- BusinessObjects universes
Answer : Source tables
Target files
BusinessObjects universes
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 3
Data integrator conations "Execute only once" logic on which two objects?
Options are :
- Scripts
- Data flows
- Conditionals
- Work flows
Answer : Data flows
Work flows
Some of your incoming data are rejected by the database table because of conversion errors and primary key violations. You want to edit and load the failed data rows manually using the SQL Query tool. How can you perform this action?
Options are :
- In the target table editor select "use overflow file", select "write SQL"and enter the filename. B. In the job properties select "trace SQL_Errors" and copy the failed SQL command from the job trace log
- Use the SQL contained in the error log file in the "BusinessObject/data integration/logs?"directory
- In the data flow properties, select "SQL Exception file" and enter the filename
Answer : In the target table editor select "use overflow file", select "write SQL"and enter the filename. B. In the job properties select "trace SQL_Errors" and copy the failed SQL command from the job trace log
Which function must you use to call an external program?
Options are :
Answer : Exec
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 4
Which two types of database metadata can be imported by browsing?
Options are :
- Function
- Trigger
- View
- Stored procedure
- Table
Answer : View
Table
What is the function of the Case transform
Options are :
- To map a column value based on multiple conditions.
- To join data sets from separate streams based on conditional logic
- To select a Job path based on conditional logic.
- To split data sets based on conditional logic into separate streams
Answer : To split data sets based on conditional logic into separate streams
Which two Data Integrator objects are reusable
Options are :
- Flat File Format
- Script
- While Loop
- Work Flow
Answer : Flat File Format
Work Flow
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 5
Which three applications can you use to schedule Data Integrator batch jobs
Options are :
- Third party scheduling applications
- Data Integrator Designer
- Data Integrator Scheduler
- BusinessObjects Enterprise Scheduler
Answer : Third party scheduling applications
Data Integrator Scheduler
BusinessObjects Enterprise Scheduler
Which two steps are part of the profiling configuration process?
Options are :
- . Use Metadata Reports to review the profiler results.
- Use the Web Administrator to submit a column profiler job on a particular table.
- Use the Designer to log into the profiler repository
- Use the Web Administrator to associate the profiler repository with the Web Administrator
Answer : Use the Designer to log into the profiler repository
Use the Web Administrator to associate the profiler repository with the Web Administrator
You create a two stage process for transferring data from a source system to a target data warehouse via a staging area. The job you create runs both processes in an overnight schedule. The job fails at the point of transferring the data from the staging area to the target data warehouse. During the work day you want to return the job without impacting the source system and therefore want to just run the second stage of the process to transfer the data from the staging area to the data warehouse. How would you design this job?
Options are :
- Create one data flow which extracts from the source system and populates both the staging area and the target data warehouse
- Create two data flows the first extracting the data from the source system the second transferring the data to the target data warehouse
- . Create one data flow which extracts the data form the source system and uses a data_transfer transform to stage the data in the staging area before then continuing to transfer the data to the target data warehouse
- Create two data flows the first extracting the data from the source system and uses a data_tranfer transform to write the data to the staging area. The second data flow extracts the data from the staging area and transfers it to the target data warehouse.
Answer : Create two data flows the first extracting the data from the source system the second transferring the data to the target data warehouse
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 1
You want to join a "sales", "customer" and "product" table. Each table resides on a different data store and will not pushdown to one SQL command. The "sales" table contains approximately five millions rows. The "customer" table contains approximately five thousand rows. The "product" table contains fifty records.
How would you set the source table options to maximize performance of this operation?
Options are :
- Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
- Set the sales table joins rank to 30 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
- Set the sales table joins rank to 10 and cache to "No". Set the customer table joins rank to 20
and cache to "yes". Then set the product table join rank to 30 and cache to "yes".
- Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 10 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
Answer : Set the sales table joins rank to 30 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
Which two object must you use to create a valid real_time job
Options are :
- Data flow that contains an XML-Source file and has the "Make Port" option selected
- Data flow that contains an XML-Source-message.
- Data flow that contains an XML-Target file and has the "Make Port" option selected.
- Data flow that contains an XML-Target-message
Answer : Data flow that contains an XML-Source-message.
Data flow that contains an XML-Target-message
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
Options are :
- Use the debugger to view the variable value being set
- View the job monitor log for the variable value
- Place the data-flow in a try catch block
- Add the variable to a script inside a print statement
Answer : Use the debugger to view the variable value being set
Add the variable to a script inside a print statement
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 2
You are working in a multi-user central repository based environment. You select "Rename owner" on an object which is not checked out. The object has one or more dependent objects in the local repository. What is the outcome?
Options are :
- Data Integrator renames the individual object owner.
- Data integrator displays a second window listing the dependent objects. when you click "continue" the object owner is renamed and all of the dependent objects are modified.
- Data Integrator renames the owner of all 0bjects within the selected data store
- Data Integrator displays the "This object is checked out from central repository "X". Please select Tools Central Repository. to activate that repository before renaming Message.
Answer : Data integrator displays a second window listing the dependent objects. when you click "continue" the object owner is renamed and all of the dependent objects are modified.
Where do imported stored procedures appear in the Local Object Library
Options are :
- Datastore Functions
- External Functions
- Built-in Functions
- Custom Functions
Answer : Datastore Functions
How long is the table data within a persistent cache data store retained
Options are :
- Until the execution of the batch job
- Until the job server is restarted
- Until the table is reloaded
- Until the real-time service is restarted
Answer : Until the table is reloaded
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 3
You want to print the ?Employee?s name? string to the trace log. Which expression is correct?
Options are :
- Print(?Enployee?s name?);
- Print(?Enployee?s name?);
- Print(?Enployee\?s name?);
- Print(?Employee"s name?);
Answer : Print(?Enployee\?s name?);
Which two items are included on the Operational Dashboards
Options are :
- Job Server Resource Utilization History
- Job Execution Duration History
- Job Schedule History
- Job Execution Statistics History
Answer : Job Execution Duration History
Job Execution Statistics History
What transform must you use to join two source tables?
Options are :
- Map_Operation
- Case
- Query
- Table_Comparison
Answer : Query
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 4
What are the three possible row operation codes for output from the Table_ Comparison transform?
Options are :
- Delete
- Update
- Insert
- Normal
- Discard
Answer : Delete
Update
Insert
Your data flow loads the contents of "order_details "and" order_headers "into one XML file that contains a node <HEADER> and a child mode <DETAIL>. How should you populate the structure in your Query?
Options are :
- In the HEADER schema use the order_headers for from and put order_header.order_id = order details.order_id in where clause. In the detail schema use the order_details for from and leave where empty
- In the header schema use the order_header for from and leave where empty in the detail schema use the order_header for from and put order_header order_id = order_details order_id in where clause.
- In the header schema use the order_headers for from, and in where clause put order_header order_id = order details order_id in the detail schema use the order_header, order_details for from and leave where empty.
- In the HEADER schema use the order headers for from and leave where empty in the detail schema use the order details for From and Where clause put order_header_id =order_details order_id.
Answer : In the HEADER schema use the order headers for from and leave where empty in the detail schema use the order details for From and Where clause put order_header_id =order_details order_id.
You want to join the "sales" and "customer" tables. Both tables reside in different data stores. The "sales" table contains approximately five million rows. The "customer" table Contains approximately five thousand rows, the join occurs in memory. How would you set the source table options to maximize the performance of the operation?
Options are :
- Set the sales table joins tank to 10 and the cache to "yes" then set the customer table join tank to 5 and cache to "yes".
- Set the sales table joins tank to 10 and the cache to "No" then set the customer table join tank to 5 and cache to "yes".
- Set the sales table joins tank to 5 and the cache to "Yes" then set the customer table join tank to 10 and cache to "No
- Set the sales table joins tank to 5 and the cache to "No" then set the customer table join tank to 10 and cache to "No".
Answer : Set the sales table joins tank to 10 and the cache to "No" then set the customer table join tank to 5 and cache to "yes".
C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 1
How do you verify you can launch a batch job?
Options are :
- Check the Job Server Status icon
- Check the Profile Server icon
- Run the Job Server Test Tool
- Run the Profile Server Test Tool
Answer : Check the Job Server Status icon
You are using an oracle 10G database for the source and target tables in your data flow. In which circumstance will data integrator optimize the SQL to use the oracle "merge" command
Options are :
- The Map_Operation is used to map all items from " normal " to" update now operations
- A table comparison is used to compare the source with the target
- The "Use input Keys" option is selected on the target table editor
- The "Auto Correct load" option is selected on the Target table
Answer : The "Auto Correct load" option is selected on the Target table
Where is the data stored for a template table?
Options are :
- Job Server memory during and after Job execution
- Underlying database table only during execution
- Job Server memory during Job execution
- Underlying database table during and after execution
Answer : Underlying database table during and after execution
C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 2
Which function must you use to retrieve the current row number of your data set?
Options are :
- Current_Row
- Gen_Row_Num
- Key_Generation
- . @@row
Answer : Gen_Row_Num
Your data contains errors and some rows fail to load. How do you ensure that valid data continues to be written
Options are :
- Select ?Auto Connect Load"
- Specify a Post-Load Command
- Select ?Use Overflow File
- Specify a Pre-Load Command
Answer : Select ?Auto Connect Load"
Which three functions can you perform using the Validation transform? (Choose three)
A. To capture Data Quality statistics that can be viewed on the Data Validation dashboard
B. To check the incoming data for duplicate rows
C. To define a business rule to validate each record and column
D. To substitute invalid values with a default value
Answer: A,C,D
Options are :
Answer : C,D,A
Which three types of group level permissions are available in a Secured Central Object Library?(Choose three)
A. Full
B. Hidden
C. None
D. Read
E. Write
Options are :
Answer : A,C,D
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 4
Which SQL statement displays when the ?Trace SQL Readers" option is set to ?Yes"?
Options are :
- SQL from the Lookup_ext function
- SQL from the source tables
- SQL to the target tables
- SQL from the Table_Comparison transform
Answer : SQL from the source tables
Your sales order fact table load contains a reference to a customer _id not found in the customerdimension table. How can you replace the customer_id with a default value and preserve theoriginal record using the Validation transform?
Options are :
- Select ?In" option and ?Action On Failure I Send to Fail", select ?For pass, substitute with".
- Select ?In" option and ?Action On Failure I Send to Both", 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".
Answer : Select ?Exists in table" and ?Action On Failure I Send to Both", select ?For Pass, substitute
with".
What is the correct sequence of transforms to populate a Type || Slowly Changing Dimension(SCD ||)?
Options are :
- Table_Comparison.Key_Generation, History_Preserving
- Key_Generation, Table_Comparison.History_Preserving
- History_Preserving, Table_Comparison.Key_Generation
- Table_Comparison.History_Preserving, Key_Generation
Answer : Table_Comparison.History_Preserving, Key_Generation
C_BODI_20 SAP Certified Application Associate SAP BO Test Set 5
How do you create a global variable?
Options are :
- Select Global Variables in the Job properties
- Select Tools |Variables|Global Variables in the Job workspace
- Select Tools | Options| Project | Variables
- Select Global Variables in the Work Flow properties
Answer : Select Tools |Variables|Global Variables in the Job workspace
Which three operations are available between a Local and Central Object Library?(Choose three)
A. Add
B. Check In
C. Export
D. Get
E. Import
Options are :
Answer : A,B,D
Which two operations can a user configured with the ?Monitor" role perform? (Choose two)
A. Examine Job Logs
B. Execute Jobs
C. Manage Job Schedules
D. View Job Schedules
E. View Server Group Status
Options are :
Answer : A,E
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 1
Which two steps are part of the profiling configuration process? (Choose two)
A. Use the Data Quality dashboard to review high level profiler result details
B. Use the Repository Manager to create/update/delete profiler users
C. Use the Repository Manager to create the profiler repository
D. Use the Server Manager to associate the profiler repository with the job server
Options are :
Answer : C,.D
When you read an XML schema into the Local Object Library, which three types of XM metadataare imported? (Choose three)
A. Attributes
B. Data Types
C. Elements
D. Styles
Options are :
Answer : A,B,C
Which three methods can you use to create a local variable? (Choose three)
A. Select the Variables tab in the Smart Editor of a custom function
B. Select Tools | Variables | Local Variables in the Job workspace
C. Select Tools | Variables | Local Variables in the Work Flow workspace
D. Select Tools | Variables | Local Variables in the Data Flow workspace
Options are :
Answer : A,B,C
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 2
You are unfamiliar with the data in the customer dimension and sales fact tables. The tables arerelated by the customer_id field. You execute a relationship profile on the tables. Which twoinsights will you gain from reviewing the relationship results? (Choose two)
A. Customers records in the sales table that have matching records in the customer table
B. Customers records in the customer table that have matching records in the sales table
C. Foreign key constraints that ensure customers in the dales table also have matching records in
the customer table
D. Foreign key constraints that ensure customers in the customers table also have matching
records in the sales table
Options are :
Answer : A,B
How do you create multiple instances of the same Data Flow?
Options are :
- None of the Above
- Right-click_Copy/Paste Data Flow in the Local Object Library
- 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 from the Job wrorkspace
Answer : Right-click+Replicate on the Data Flow in the Local Object Library
Which lookup caching method reduces the number of round trips to the translate table?
Options are :
- Pre_Load _Cache
- Smart_Cache
- Demand_Load_Cache
- No_Cache
Answer : Pre_Load _Cache
C_BOE_30 SAP BO Enterprise Certified Application Associate Set 3
Which two changes to your Source Table requires you to re-import the metadata?(Choose two)
A. Index changes
B. New records added
C. Table structure changes
D. Truncated table data
Options are :
Answer : A,C
You are developing a data warehouse as part of a large development team (ten plus developers)Way should you recommend a multi-user configuration? (Choose two)
A. Attach documentation based on object history
B. Ensure only one developer is working on a specific set of objects
C. Store table column and relationship profile data including history
D. Track the version history history of objects(audit trrail)
Options are :
Answer : B,D
Which three operations can a user configured with the ?Operator" role perform?(Choose three)
A. Execute Jobs
B. Manage Job Schedules
C. Manage Users
D. Manage Secured Central Object Library
E. Set Log Retention periods
Options are :
Answer : A,B,E
C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 1
Which two steps are part of the profiling configuration process? (Choose two)
A. Use the Designer to log into the profiler repository.
B. Use Metadata Reports to review the profiler results.
C. Use the Web Administrator to submit a column profiler job on a particular table.
D. Use the Web Administrator to associate the profiler repository with the Web Administrator.
Options are :
Answer : D,A
C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 2
Which two types of database metadata can be imported by browsing? (Choose two)
A. Function
B. Stored procedure
C. Table
D. Trigger
E. View
Options are :
Answer : C,E
In which object can you use audit points and rules?
Options are :
- Data Flow
- Work Flow
- Job
- Script
Answer : Data Flow
Under which two circumstances must you select ?Use Input Keys" when updating a Target Table?(Choose two)
A. No primary key is specified on the target table
B. No primary key is specified on the source table
C. To optimize the pushdown SQL
D. To specify an alternative key for the update
Options are :
Answer : D,A
C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 3
You have two related source tables (Department and Employees). Some employee records do notcontain values for Department _ID. Which method ensures all Employees records are selectedform 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 Department as outer source and Employees as inner source in the OUTER JOIN
- Specify the Employees. Department _ID (+) = Department. Department _ID in the WHERE
clause.
Answer : Specify Employees as outer source and Department as inner source in the OUTER JOIN
Which three expressions convert a null value to 0? (Choose three)
A. Case (field is NULL, 0, field)
B. Decode (field is NULL, 0, field)
C. If then else (field is NULL,0,field)
D. Nvl (field,0)
Options are :
Answer : B,C,D
Which three objects does the Management Condole ?Iplact and Lineage analysis" capture?(Choose three)
A. BusinessObjects universes
B. SQL transform tables
C. Source tables
D. Target files
Options are :
Answer : C,D,A
C_BODI_20 SAP Business Objects Data Integrator XI R2 Test Set 4
Which are the three types of Data Integrator repositories? (Choose three)
A. Batch
B. Central
C. Job
D. Local
E. Profiler
F. Shared
Options are :
Answer : B,D,E
What transform must you use to join two source tables?
Options are :
- Case
- Map_Operation
- Query
- Table_Comparison
Answer : Query
Which two tasks can you perform using Data Integrator Designer? (Choose two)
A. Create Auto Documentation
B. Launch Data Integrator Jobs
C. Iplort Metadata
D. Schedule Data Integrator Jobs
Options are :
Answer : B,C
What are the three possible row operation codes for input to the History_ Preserving transform?(Choose three)
A. Delete
B. Discard
C. Insert
D. Normal
E. Update
Options are :
Answer : A,C,E
Which three elements can be contained in the output schema of a query? (Choose three)
A. Columns
B. Filters
C. Functions
D. Group By
E. Order By
F. Nested Schemas
Options are :
Answer : A,C,F
Where do imported stored procedures appear in the Local Object Library?
Options are :
- Custom Functions
- Datastore Functions
- Built-in Functions
- External Functions
Answer : Datastore Functions
