SAP BODS Quiz

Posted on: | By: – 2 Comments

SAP BODS Intermediate Quiz

 



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
3) In which objects can you create parameter variables?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
4) Which is NOT a datastore type?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
5) Which is NOT a datastore type?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
8) XML_Pipeline is what kind of transformation?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
9) Which conditional function lets you specify multiple conditional statements in one?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
16) How many cache Options are available in Lookup function?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
18) What should be maximum value for number of loaders?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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”.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
34) Which object can not be used in a Work Flow?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
35) What one is the valid data type for Substitution Parameter?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
36) Which lookup caching method reduces system memory usage?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
38) Which one is not a Data Integrator repository?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
39) Which Data Integrator objects are reusable?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
40) Which object can not be used in a Data Flow?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
41) Which one is the OP code not used for input to the History_Preserving transform?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
42) Which two transforms can you use to unnest XML source data?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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’

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
47) Which type of group level permission is not available in a Secured Central Object Library?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz

2 Replies to “SAP BODS Quiz”

  1. Question no 30. in intermediate quiz and same question in expert quiz no. 50 has 2 different answers.

Comments are closed.