SAP BODS Intermediate Quiz

 



1) What is the executable object in the SAP BODS?

1. Workflow
2. Data flow
3. Scripts
4. Ans) Jobs

Show Answer

 
 
2) Arrange these objects in order by their hierarchy: Dataflow, Job, Project and Workflow.

1. Project, Job, Dataflow, workflow
2. Project, Work flow, Job, Dataflow
3. Project, Job, Workflow, Dataflow
4. Job, Workflow, Project, Data flow

Show Answer

 
 
3) In which objects can you create parameter variables?

1. Custom functions
2. Workflow
3. Job
4. Datastore

Show Answer

 
 
4) Which is NOT a datastore type?

1. Siebel
2. Peoplesoft
3. JDE World
4. File format

Show Answer

 
 
5) Which is NOT a datastore type?

1. File Format
2. Webservice Adapters
3. SAP R/3
4. Oracle Data store

Show Answer

 
 
6) What are reusable objects in DataServices?

1. Job, Workflow, Dataflow, Script
2. Job, Workflow, Dataflow
3. Job, Workflow, Dataflow, Try Catch
4. Job, Workflow, Dataflow, Conditional

Show Answer

 
 
7) Name the transform that you would use to combine incoming data sets to produce a single output data set with the same schema as the input data sets.

1. The script
2. The Try Catch
3. The Merge transform
4. The SQL transform

Show Answer

 
 
8) XML_Pipeline is what kind of transformation?

1. data integrator
2. data quality
3. platform
4. functions

Show Answer

 
 
9) Which conditional function lets you specify multiple conditional statements in one?

1. Cond
2. Decode
3. If then else
4. select ….. Case

Show Answer

 
10) What is the default commit size for a table?

1. 1000
2. 4000
3. 5000
4. 10000

Show Answer

 
 
11) Checkout object without replacement is used to:

1. retain the version you have already modified
2. change the object you have modified
3. overwrite the object you have modified
4. check out object and dependants without overwritting

Show Answer

 
 
12) What is the use of Data Transfer Transformation?

1. To transfer data onto target SAP
2. To transfer data onto target Oracle Tables
3. To perform push down operation
4. To transfer data onto target Oracle ERP system

Show Answer

 
 
13) What is the pre-requisites for the function gen_row_num_by_group(field1, field2)?

1. field1 & field2 should be sorted first
2. field1 & field2 should grouped by first
3. Only field2 should be sorted & grouped by first
4. Only field1 should be sorted first

Show Answer

 
 
14) For the function to_char( field1, field2),

1. Field1 should be char and field2 char
2. Field2 should be date and field1 char
3. Field2 should be char and field1 date
4. Both field1 & feild2 should be date

Show Answer

 
 
15) What is Idoc?

1. intermediate data structure in SAP
2. hierarchical data structure in SAP ERP
3. Intermediate document in Oracle ERP
4. Intermediate document in Salesforce

Show Answer

 
 
16) How many cache Options are available in Lookup function?

1. Two
2. Three
3. Four
4. Five

Show Answer

 
 
17) What is the  “Named Pipe Error”?

1. It means the table does not exists in the database
2. it means the file is not present in the file path
3. There is no specific reason for named pipe error
4. It means Idocs are not present in the SAP system

Show Answer

 
 
18) What should be maximum value for number of loaders?

1. 2
2. 3
3. 4
4. 5

Show Answer

 
 
19) Name the transform that you would use to combine incoming data sets to produce a single output data set with the same schema as the input data sets.

1. The Data Transfer transform
2. The Pivot transform
3. The Map Operation transform
4. The Merge transform.

Show Answer

 
20) In which object can you include a try/catch block?

1. dataflow
2. custom function
3. Work flow
4. Table

Show Answer

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

1. Right-click+Replicate on the Data Flow in the Local Object Library
2. Right-click_Copy/Paste Data Flow from the Job wrorkspace
3. Right-click_Copy/Paste Data Flow in the Local Object Library
4. Right-click+Replicate Data Flow from the Job

Show Answer

 
 
22) 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?

1. Select “Exists in table” and “Action On Failure I Send to Both”, select “For Pass, substitute with”.
2. Select “Exists in table” and “Action On Failure I Send to Fail”, select “For Pass, substitute with”.
3. Select “In” Option and “Action On Failure I Send to Both”, select “For pass, substitute with”.
4. Select “In” Option and “Action On Failure I Send to Fail”, select “For pass, substitute with”.

Show Answer

 
 
23) What is a Script?

1. A script is a single-use object that is used to call functions and assign values in a workflow.
2. A script is a multi-use object that is used to call functions and assign values in a workflow.
3. A script is a single-use object that is used to call data flows and assign values in a workflow.
4. A script is a single-use object that is used to call DB functions and another script and assign values in a workflow.

Show Answer

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

1. Immediately after an XML source file
2. Immediately after a data flow
3. Immediately after an XML template

Show Answer

 
 
25) Which two data integrator objects/operations support load balancing in a server Group based architecture?

1. Custom functions
2. Lookup_ext
3. While Loop
4. Scripts

Show Answer

 
 
26) What one is a required step to make a database table available in a Data Flow?

1. Add connection details to Data Flow properties
2. Add script to a data flow
3. Import table metadata
4. Add work flow to the data flow

Show Answer

 
 
27) 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”

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

Show Answer

 
 
28) Which is not on eof the property of Management Console “Impact and Lineage analysis” capture?

1. BusinessObjects reports
2. Lookup tables
3. Source files
4. Scripts

Show Answer

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

1. Central Management Console
2. Designer
3. Management Console
4. Repository Manager

Show Answer

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

1. Key_Generation, Table_Comparison.History_Preserving
2. History_Preserving, Table_Comparison.Key_Generation
3. Table_Comparison.History_Preserving, Key_Generation
4. Key_Generation, History_Preserving

Show Answer

 
 
31) Which SQL statement displays when the “Trace SQL Readers” Option is set to “Yes”?

1. SQL from the source tables
2. SQL to the target tables
3. SQL from the Lookup_ext function
4. SQL from the Table_Comparison transform

Show Answer

 
 
32) Name the transform that you would use to combine incoming data sets to produce a single output data set with the same schema as the input data sets.

1. Conditional
2. Merge
3. Scrpit
4. Map Operation

Show Answer

 
 
33) Which caching method reduces the amount of system memory used by the
Table_Comparison transoform?

1. Cached comparison table
2. Pre_load cache
3. Row_by_row select
4. In memory

Show Answer

 
 
34) Which object can not be used in a Work Flow?

1. Custom Function
2. Workflow
3. Try/Catch
4. Job

Show Answer

 
 
35) What one is the valid data type for Substitution Parameter?

1. Int
2. Long
3. blob
4. No data type

Show Answer

 
 
36) Which lookup caching method reduces system memory usage?

1. Demand_Load_Cache
2. No_Cache
3. Pre_Load_Cache
4. Smart_Cache

Show Answer

 
 
37) Which methods can not be used to create a local variable?

1. Select the Variables tab in the Smart Editor of a custom function
2. Select Tools | Variables | Local Variables in the Job workspace
3. Select Tools | Variables | Local Variables in the Work Flow workspace
4. Tools–> Substitution Parameter Editor

Show Answer

 
 
38) Which one is not a Data Integrator repository?

1. Local
2. Central
3. Profiler
4. Shared

Show Answer

 
39) Which Data Integrator objects are reusable?

1. Script
2. Work flow
3. While loop
4. Query transformation

Show Answer

 
 
40) Which object can not be used in a Data Flow?

1. Conditional
2. Template Table
3. XML Schema
4. Excel Workbook

Show Answer

 
 
41) Which one is the OP code not used for input to the History_Preserving transform?

1. Delete
2. Update
3. Insert
4. Drop

Show Answer

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

1. Hierarchy_Fattening
2. Workflow
3. Query
4. Merge

Show Answer

 
 
43) Which of the below function cannot be performed via the Web Administrator?

1. Managing Central Object Library users and groups
2. Adding and Removing Users
3. Create data flow
4. Applying security features

Show Answer

 
 
44) Which of the expression convert a null value to 0?

1. Decode (field= NULL, 0)
2. If(field is NULL,0,field)
3. Nvl (field,0)
4. Null = ‘0’

Show Answer

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

1. No primary key is specified on the target table
2. To specify an alternative key for the update
3. To optimize the pushdown SQL
4. When doing a group by

Show Answer

 
 
46) How do you create a global variable?

1. Select Global Variables in the Job properties
2. Select Global Variables in the Work Flow properties
3. Select Tools |Variables|Global Variables in the Job workspace
4. Select Tools | Options| Project | Variables

Show Answer

 
 
47) Which type of group level permission is not available in a Secured Central Object Library?

1. Full
2. Hidden
3. Write
4. Read

Show Answer