QUESTION: 1

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 trail)

Answer: B, D

QUESTION: 2
In which three objects can you include a try/catch block? (Choose three)

A. Data Flow
B. Job
C. Script
D. Work Flow

Answer: B,C,D

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

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

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

Answer: A

QUESTION: 4
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?

A. Select Exists in table and Action On Failure I Send to Both, select For
Pass, substitute with.
B. Select Exists in table and Action On Failure I Send to Fail, select For Pass,
substitute with.
C. Select In option and Action On Failure I Send to Both, select For pass,
substitute with.
D. Select In option and Action On Failure I Send to Fail, select For pass,
substitute with.

Answer: A

QUESTION: 5
When you read an XML schema into the Local Object Library, which three types
of XM metadata are imported? (Choose three)

A. Attributes
B. Data Types
C. Elements
D. Styles

Answer: A,B,C

QUESTION: 6
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

Answer: A,B,C

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

A. Demand_Load_Cache
B. No_Cache

C. Pre_Load _Cache
D. Smart_Cache

Answer: C

QUESTION: 8
Which SQL statement displays when the Trace SQL Readers option is set to
Yes?

A. SQL from the source tables

B. SQL to the target tables
C. SQL from the Lookup_ext function
D. SQL from the Table_Comparison transform

Answer: A

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

A. Key_Generation, Table_Comparison.History_Preserving
B. History_Preserving, Table_Comparison.Key_Generation
C. Table_Comparison.History_Preserving, Key_Generation
D. Table_Comparison.Key_Generation, History_Preserving

Answer: C

QUESTION: 10
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 a Case transform to create two conditions that 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 two Query transforms with different WHERE clauses to filter the invalid
records

Answer: C

QUESTION: 11
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

Answer: C,D

QUESTION: 12
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

Answer: A,C

QUESTION: 13
Which two functions can you use in a Query? (Choose two)

A. Count
B. Exec
C. Lookup_Ext
D. Sleep

Answer: A,C

QUESTION: 14
How do you create a global variable?

A. Select Global Variables in the Job properties

B. Select Global Variables in the Work Flow properties
C. Select Tools |Variables|Global Variables in the Job workspace
D. Select Tools | Options| Project | Variables

Answer: C

QUESTION: 15
Which three types of group level permissions are available in a Secured Central
Obje Library? (Choose three)

A. Full
B. Hidden
C. None
D. Read
E. Write

Answer: A,C,D

QUESTION: 16
How do you associate a repository with the Management Console?

A. Open the Server Manager and select Edit Job Server Config | Add Repository
B. Open the Server Manager and select Edit Server Group Config| Add
Repository
C. Open Web Administrator and select Management |Repositories | Add
D. Open the Web Administrator and select Server Groups| Server Group Config|
Add Repository

Answer: C

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

A. File Format Editor

B. Properties of the Data Flow

C. Server Manager Tool

D. Trace Options of the Job

Answer: A

QUESTION: 18
Which three operations can Data Integrator push down to the underlying database?
(Choose three)

A. Aggregation
B. Distinct Row
C. Ordering
D. Union

Answer: A,B,C

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

A. Metadata Manager B.
Repository Manager C.
Server Manager
D. Web Administrator

Answer: D

QUESTION: 20
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

Answer: A,B,D

QUESTION: 21
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

Answer: A,E

QUESTION: 22
Which three options are available for selecting when an audit rule fails? (Choose
three)

A. Email to List
B. Raise Exception
C. Script
D. Write Data to Error Table

Answer: A,B,C

QUESTION: 23
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

Answer: A,B,E

QUESTION: 24
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

QUESTION: 25
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? (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

Answer: A,B

QUESTION: 26
Where is the data stored for a template table?

A. Job Server memory during Job execution

B. Job Server memory during and after Job execution
C. Underlying database table during and after execution
D. Underlying database table only during execution

Answer: C

QUESTION: 27
What three functions can you perform via the Web Administrator? (Choose three)

A. Adding and Removing Jobs

B. Adding and Removing Users
C. Create Repositories
D. Managing Central Object Library users and groups
E. Setting the Log Retention period

Answer: B,D,E

QUESTION: 28
Which two objects can be used in a Work Flow? (Choose two)

A. Custom Function
B. Datastore
C. Try/catch
D. Work Flow

Answer: C,D

QUESTION: 29
Where do you specify the columns for a template table?

A. Cut/Paste from an existing query output

B. In the output schema of the preceding transform
C. In the template table editor
D. Import from the underlying database structure

Answer: B

QUESTION: 30
Which three objects does the Management Console Impact and Lineage analysis
capture? (Choose three)

A. BusinessObjects reports
B. Lookup tables
C. SQL function tables
D. Source files

Answer: A,B,D

QUESTION: 31
Which two options can youve configure when using a file format as a source or
target I a Data Flow? (Choose two)

A. Column Delimiter
B. Default Date Format
C. Error File
D. File Name

Answer: C,D

QUESTION: 32
Which two components are required to execute a batch job? (Choose two)

A. Batch Server
B. Central Management Console
C. Designer
D. Job Server
E. Repository

Answer: D,E

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

A. Central Management Console

B. Designer
C. Management Console
D. Repository Manager
E. Server Manager

Answer: D

QUESTION: 34
Which two options must you set to capture your audit information to the Trace
Logs? (Choose two)

A. Select Enable Auditing in the Job parameters.

B. Select Edit Job Server Config I Enable Auditing in the Server Manager
C. Select Tools I Options I Designer I General I Capture Audit Data
D. Set Trace Audit Data to Yes

Answer: A,D

QUESTION: 35
Which two rules must you following to deploy a Server Group architecture?
(Choose two)

A. A maximum of four servers can be added to a server group

B. All Job servers in a server group must be active for the server group to function
C. All the Job servers in the server group must be associated with the same
repository
D. Each computer can only contribute one Job server to a server group

Answer: C,D

QUESTION: 36
You have a Job open in the workspace. Which two objects on the current Job
workspace are validated by selecting the Validate Current option? (Choose two)

A. Conditional
B. Data Flow
C. Script
D. Work Flow

Answer: A,C

QUESTION: 37
Which caching method reduces the amount of system memory used by the
Table_Comparison transform?

A. Cached comparison table

B. Pre_load cache
C. Row_by_row select
D. In memory

Answer: C

QUESTION: 38
What three types of errors can you catch in a try/catch block? (Choose three)

A. Database Access
B. File System Access
C. Repository Access Errors
D. Scripting Syntax

Answer: A,B,C

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

A. Create a file list .txt file

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

Answer: C,D

QUESTION: 40
What is the function of the Merge transform?

A. To apply a union all to the incoming data streams.

B. To apply an auto update to your target table

C. To append two column values together

D. To join incoming data sets based on a relationship

Answer: A

QUESTION: 41
What are three ways to view the push down SQL generated by a Data Flow?
(Choose three)

A. Right click on the Data Flow and select Audit I Store push-down SQL.
B. Right click on the Data Flow and select Display Optimized SQL
C. Select Display Optimized SQL from the Validation menu.
D. Select Trace SQL Readers from the Trace options when executing a Job.

Answer: B,C,D

QUESTION: 42
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? (Choose three)

A. Columns that contain only null data

B. Count of distinct values in a column
C. Distinct values in a column
D. SUM of the numeric column values

Answer: A,B,C

QUESTION: 43
What are the two required steps to make a database table available in a Data Flow?
(Choose two)

A. Add connection details to Data Flow properties

B. Create a datastore
C. Import table metadata
D. Profile database table

Answer: B,C

QUESTION: 44
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? (Choose two)

A. Restrict groups of developers from accessing specific objects

B. Restrict groups of developers from deleting specific objects C.
Restrict groups of developers from adding specific objects
D. Restrict groups of developers from viewing the history of specific objects

Answer: A,B

QUESTION: 45
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

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

Answer: A

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

A. Into a single target table

B. Map_Operation transform
C. Merge transform
D. Query transform

Answer: C

QUESTION: 47
How do you commit all rows in a single transaction?

A. Select Commit at the end of Insert Select

B. Select Include in transaction in the target table options
C. Specify Rows per commit equal to zero
D. Specify the Number of loaders equal to one.

Answer: B

QUESTION: 48
Which lookup caching method reduces system memory usage?

A. Demand_Load_Cache
B. No_Cache
C. Pre_Load_Cache
D. Smart_Cache

Answer: B

QUESTION: 49
Which two objects can be used in a Data Flow? (Choose two)

A. Conditional
B. Template Table
C. Work Flow
D. XML Schema

Answer: B,D

QUESTION: 50
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? (Choose two)

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

Answer: A,B

QUESTION: 51
Which two operations can Data Integrator push down to the underlying database?
(Choose two)

A. Custom Function
B. Filtering
C. Join
D. Key Generation

Answer: B,C

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

A. Permanently stored in the Job Server Logs

B. Until the Job is re-executed
C. While the Debug is active
D. While the Data Flow is active in the workspace

Answer: C

QUESTION: 53
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?

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

Answer: A

QUESTION: 54
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

Answer: A,D

QUESTION: 55
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

Answer: B,C

QUESTION: 56
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

Answer: A,C,F

QUESTION: 57
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)

Answer: B,C,D

QUESTION: 58
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

Answer: A,C,E

QUESTION: 59
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? (Choose three)

A. Count of distinct values in a column

B. Distinct values in a column

C. Maximum string length for a varchar column

D. Number of rows that have every column duplicated

Answer: A,B,C

QUESTION: 60
Which two syntactical items can you check by selecting Validate All? (Choose
two)

A. Contents of SQL transform

B. Contents of SQL function calls
C. Existence of variables
D. Job structure

Answer: C,D

QUESTION: 61
Which function must you use to retrieve the current row number of your data set?

A. @@row
B. Current_Row
C. Gen_Row_Num
D. Key_Generation

Answer: C

QUESTION: 62
Which two transforms can you use to unnest XML source data? (Choose two)

A. Hierarchy_Fattening
B. Pivot
C. Query
D. XML_Pipeline

Answer: C,D

QUESTION: 63
Which are the three types of Data Integrator repositories? (Choose three)

A. Batch
B. Central
C. Job
D. Local
E. Profiler
F. Shared

Answer: B,D,E

QUESTION: 64
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.

Answer: A,D

QUESTION: 65
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?

A. Specify Department as outer source and Employees as inner source in the

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

Answer: B

QUESTION: 66
In which object can you use audit points and rules?

A. Data Flow
B. Job
C. Script
D. Work Flow

Answer: A

QUESTION: 67
Which two Data Integrator objects are reusable? (Choose two)

A. Flat File Format

B. Script
C. While Loop
D. Work Flow

Answer: A,D

QUESTION: 68
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

Answer: A,C,D

QUESTION: 69
In which three objects can you create parameter variables? (Choose three)

A. Custom functions
B. Data Flow

C. Job
D. Query
E. Script
F. Work Flow

Answer: A,B,F

QUESTION: 70
Which two types of database metadata can be imported by browsing? (Choose two)

A. Function
B. Stored procedure
C. Table
D. Trigger
E. View

Answer: C,E

QUESTION: 71
Where do imported stored procedures appear in the Local Object Library?

A. Built-in Functions B.
Custom Functions C.
Datastore Functions D.
External Functions

Answer: C

QUESTION: 72
What transform must you use to join two source tables?

A. Case
B. Map_Operation
C. Query
D. Table_Comparison

Answer: C

QUESTION: 73
You are developing a data warehouse as part of a large development team (ten plus
developers). Why should you recommended a multi-user configuration? (Choose
two)

A. Assign object rights by development group

B. Enable developers to evert to previous versions of objects
C. Generate data lineage and impact analysis for the development project
D. Notify development teams when changes occur automatically

Answer: A,B

QUESTION: 74
You have declared a local variable in a Work Flow. Which three objects in the
Work Flow can use the variable? (Choose three)

A. Conditional
B. Data Flow
C. Script
D. While
E. Work Flow

Answer: A,C,D

QUESTION: 75
In which three places can you set a global variable?(Choose three)

A. Job properties
B. Script
C. Web Administrator
D. Work Flow properties

Answer: A,B,C

QUESTION: 76

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?

A. Use the Data_Transfer transform to stage the tables in the same database before
applying the join conditions
B. Use the Merge transform to merge the data into a single Table before applying
the join conditions
C. Use the Query transform to join the two tables by applying the join conditions.
D. Use Multiple Flat Files to stage the tables, then join the flat files using a Query
transform.

Answer: A

QUESTION: 77
What are two techniques you can use when recovering a Job to avoid duplicate data
loading? (Choose two)

A. Run the Job in Recover mode

B. Select Auto Correct Load on the Target Table options
C. Use the Table_Comparison transform
D. Use the Map_CDC_Operation transform

Answer: B,C

QUESTION: 78
Which three objects can you use as a source in a Data Flow?(Choose three)

A. Excel file
B. Pivot transform
C. Row_Generation transform
D. Template table

Answer: A,C,D

QUESTION: 79
When is a template table created in the database?

A. You create a template table on the Data Flow

B. You execute a Job
C. You right-click and select Import a template table to a permanent table
D. You right-click and select Create on a template table

Answer: B

QUESTION: 80
Which three functions can you use in a script? (Choose three)

A. Count
B. Sleep
C. Sysdate
D. To_Char

Answer: B,C,D

QUESTION: 81
What are the three possible row operation codes for output from the
Table_Comparison transform? (Choose three)

A. Delete
B. Discard
C. Insert
D. Normal
E. Update

Answer: A,C,E

QUESTION: 82
How do you verify you can launch a batch job?

A. Check the Job Server Status lcon

B. Check the Profile Server lcon
C. Run the Job Server Test Tool
D. Run the Profile Server Test Tool

Answer: A

QUESTION: 83
Your data contains errors and some rows fail to load. How do you ensure that valid
data continues to be written?

A. Select Auto Connect Load

B. Select Use Overflow File
C. Specify a Pre-Load Command
D. Specify a Post-Load Command

Answer: B

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

A. Cond
B. Decode
C. If then else
D. Select..case

Answer: B

QUESTION: 85
You want to print the Employees name string to the trace log. Which expression
is correct?

A. Print(Enployee\s name);
B. Print(Enployees name);
C. Print(Enployees name);
D. Print(Employee"s name);

Answer: A

QUESTION: 86

Which lookup function returns multiple columns?

A. Lookup
B. Lookup _Adv
C. Lookup_Ext
D. Lookup_Seq

Answer: C

QUESTION: 87
Where is the data stored for a template table?

A. Job Server memory during Job execution

B. Job Server memory during and after Job execution
C. Underlying database table during and after execution
D. Underlying database table only during execution

Answer: C

QUESTION: 88
Which two engines process jobs on the Application server? (Choose two)

A. Access Server
B. Batch Server
C. Designer
D. Job Server
E. Web Administrator

Answer: A,D

QUESTION: 89
Which two items are included on the Operational Dashboards? (Choose two)

A. Job Execution Statistics History

B. Job Execution Duration History
C. Job Schedule History
D. Job Server Resource Utilization History

Answer: A,B

QUESTION: 90
Which function must you use to call an external program?

A. Call
B. Exec
C. Run
D. System

Answer: B

QUESTION: 91
Which two items are included on the Operational Dashboard? (Choose two)
A. Job Execution Statistics
B. Job Execution Duration
C. Job Schedules
D. Job Server Resource Utilization

Answer: A,B

QUESTION: 92
Which three applications can you use to schedule Data Integrator batch jobs?
(Choose three)

A. Third party scheduling applications

B. BusinessObjects Enterprise Scheduler
C. Data Integrator Scheduler
D. Data Integrator Designer

Answer: A,B,C

QUESTION: 93
What is the function of the Case transform?

A. To join data sets from separate streams based on conditional logic.

B. To map a column value based on multiple conditions.
C. To select a Job path based on conditional logic.
D. To split data sets based on conditional logic into separate streams.

Answer: D

QUESTION: 94
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? (Choose three)

A. Data
B. Data Flow
C. Script
D. WorkFlow

Answer: B, C, D

QUESTION: 95
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?

A. 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.
B. Data Integrator renames the individual object owner.
C. 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.
D. Data Integrator renames the owner of all 0bjects within the selected data store.

Answer: A

QUESTION: 96
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?

A. In the HEADER schema use the order headers for from and leave where empt y
in the detail schema use the order details for From and Where clause put
order_header_id =order_details order_id.
B. 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.
C. 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.
D. 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.

Answer: A

QUESTION: 97
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?

A. Enter the value"1" in the single element schema mapping.

B. Leave the form clause of the single element schema empty.
C. Place the source table that contains your source rows into the form clause of the
single element schema.
D. Use a row_Generation transform and select one row then map the transform into
the from clause of the single element schema.

Answer: D

QUESTION: 98
Data integrator conations "Execute only once" logic on which two objects?(Choose
two)

A. Conditionals
B. Data flows
C. Scripts
D. Work flows

Answer: B, D

QUESTION: 99
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? (Choose two).

A. Adapter instance
B. File on shared server
C. E-mail
D. Web service call

Answer: A, D

QUESTION: 100
You are sourcing COBOL data from a Mainframe. Which three COBOL features
does native data integrator support? (Choose three).

A. OCCURS DEPENDING
B. REDEFINES
C. RECORD OCCURS
D. ISAM

Answer: A, B, C

QUESTION: 101
Which two interfaces requires an adapter data store? (Choose two).

A. COBOL copybook
B. MQ series
C. Sap R/3
D. Web service

Answer: B, D

QUESTION: 102
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?

A. The "Auto Correct load" option is selected on the Target table.

B. The Map_Operation is used to map all items from " normal " to" update now
operations
C. A table comparison is used to compare the source with the target
D. The "Use input Keys" option is selected on the target table editor

Answer: A

QUESTION: 103
How do you set the degree of parallelism value at which a data flown use?

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

Answer: A

QUESTION: 104
Which three column level metadata attributes are transferred to the semantic
universe layer of business objects Enterprise via the business objects universe
builder? (Choose three)

A. Business Name
B. Business Description
C. Column_Usage
D. Default values

Answer: A, B, C

QUESTION: 105
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?

A. 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".
B. 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".
C. 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".
D. 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".

Answer: A

QUESTION: 106
Which three combinations of input and output schemas are permitted in on
embedded data flow? (Choose three)

A. 1 input and 0 outputs

B. 0 input and 1 outputs
C. 1 input and 1 outputs
D. 1 input and multiple outputs
E. Multiple input and multiple outputs

Answer: A, B, C

QUESTION: 107
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?

A. Document Type definition (DTD)

B. XML schema definition (XSD)

C. Web Service Definition Language (WSDL)

D. Web service URL

Answer: C

QUESTION: 108
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? (Choose two).

A. parse_ext(employee_name,2,' ')
B. parse(employee_name,2,' ')
C. word_ext(employee_name,2,' ')
D. word(employee_name,2,' ')

Answer: C, D

QUESTION: 109
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.

A. 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.
B. 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.
C. Create one format template and three data flows to configure the "ignore row
markers" option to interpret the different parts of the file.
D. 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.

Answer: A

QUESTION: 110
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?

A. match_pattern( value.'[12]9999') B.
match_pattern( value.'[112]9999') C.
match_pattern( value.'?[12]9999') D.
match_pattern( value.'?[112]9999')

Answer: A

QUESTION: 111
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?

A. 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
C. Use the SQL contained in the error log file in the "BusinessObject/data
integration/logs"directory.
D. In the data flow properties, select "SQL Exception file" and enter the filename.

Answer: A

QUESTION: 112
A system configuration allows you to group data store configurations together in
the following setup?

A. Multiple data store configurations for multiple data stores.

B. Single configuration from multiple data store.
C. Multiple data store configurations for single data stores.
D. Single configuration for a single data store.

Answer: B

QUESTION: 113
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?

A. Four
B. One
C. Six
D. Two

Answer: A,

QUESTION: 114
Which two object must you use to create a valid real_time job? (Choose two)

A. Data flow that contains an XML-Source-message.

B. Data flow that contains an XML-Target-message.
C. Data flow that contains an XML-Source file and has the "Make Port" option
selected
D. Data flow that contains an XML-Target file and has the "Make Port" option
selected.

Answer: A,B

QUESTION: 115
How long is the table data within a persistent cache data store retained?

A. Until the execution of the batch job.

B. Until the job server is restarted.
C. Until the table is reloaded
D. Until the real-time service is restarted

Answer: C

QUESTION: 116

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. Add the variable to a script inside a print statement

B. Use the debugger to view the variable value being set.
C. View the job monitor log for the variable value
D. Place the data-flow in a try catch block

Answer: A,B

QUESTION: 117
Which two tasks must you perform to ensure the businessObject universe Bolder
transfers the correct metadata lineage information? (Choose two)

A. Calculate usage dependencies

B. Calculate column mappings
C. Calculate column dependencies
D. Calculate table mappings

Answer: A,B

QUESTION: 118
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?
A. to_data(sales_datell' 'll sales_time.'dd_mon-yyyy hh24:mi:ss')
B. to_data(sales_date &' '& sales_time.'dd_mon-yyyy hh24:mi:ss')
C. to_data(sales_datell' 'll sales_time.'dd_mmm-yyyy hh24:mi:ss')
D. to_data(sales_date&' '& sales_time.'dd_mmmm-yyyy hh24:mi:ss')

Answer: A

QUESTION: 119
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?

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

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

Answer: A,B

QUESTION: 120
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?

A. Log into the designer and select tools l Options l data l General and modify the
"Century change year" to 90.
B. Open the server manger and select edit job server config and modify the
"Century change year to 90".
C. Open the web administration tool and select management l requisiteness edit the
production requsitury and modify the "Century change year to 90".
D. 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.
E. Configure the source database to interpret the two digit dates appropriately.

Answer: A

QUESTION: 121
You load over 10,000.000 records from the "customer" source table into a staging
area. 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? (Choose two.)

A. Use a Query transform to order the incoming data set an use the previous_rowvalue in the where clause to filter any duplicate row.
B. 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.

C. Use the table_ comparison transform with the "input contains duplicates" and
"cached comparison table" selected.
D. Use the lookup_ext function. With the Pre_load_cache" option selected to test
each row for duplicates.

Answer: A,B

QUESTION: 122
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?

A. 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".
B. 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".
C. 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".
D. 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: A

QUESTION: 123
Where can the XML_Pipeline transform be used within a data flow? (Choose two)

A. Immediately after an XML source file.

B. Immediately after an XML source message.
C. Immediately after a Query containing nested data.
D. Immediately after an XML template.

Answer: A,B

QUESTION: 124
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?

A. Create two data flows the first extracting the data from the source system the
second transferring the data to the target data warehouse.
B. 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.
C. 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.
D. Create one data flow which extracts from the source system and populates both
the staging area and the target data warehouse.

Answer: A

QUESTION: 125
Which two data integrator objects/operations support load balancing in a server
Group based architecture? (Choose two.)

A. Job
B. Lookup_ext
C. Script
D. While loop

Answer: A,B

QUESTION: 126
You have a data flow the read multiple XML files form a directory by specifying
wildcard in the file name. which method can use to link the XML file name to the
records being read?

A. Select "include file name column" in the XML source file.

B. Use the function get_xml file name in the query mapping
C. Use the column "XML_fileNAME" listed at the top of the XML file structure.
D. Use the variable$ current_XML_file in the query mapping

Answer: A

QUESTION: 127
You are trying to improve the performance of a simple data flow that loads data
from a source table into a staging area and only applies some simple remapping
using a Query transform. The source database is located on the wan. The network
administrator has told you that you can improve performance if you reduce the
number or round trips that occur between the data integrator job server and the
source database. What can you do in your data flow to achieve this?

A. increase the array reach size parameter in the source table editor
B. Increase the commit size in the target table editor.
C. Increase the commit size in the source table editor.
D. Replace the source table with the SQL transform.

Answer: A