SAP BODS Quiz

Posted on: | By: – Comments Off

SAP BODS Beginner Quiz

 



1) What is not a reason for job failure?

  1. Job Server not running
  2. port numbers for Designer and Job Server not matching
  3. Unconnected data flows in a work flow
  4. Source database is down

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
2) Shared object library allowing developers to check objects in and out of their local
repositories is

  1. Central repository
  2. Microsft Visual Sourcesafe
  3. IBM clear Case
  4. Design Studio

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) DataStore is

  1. Database
  2. Connection to database
  3. any structure that holds data
  4. Any directory

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

  1. count_rows
  2. total_rows
  3. sum_rows
  4. aggregate_rows

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
5) which function Sends a command to the operating system for execution

  1. exec
  2. Invoke
  3. Call
  4. kill

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) A project is

  1. a reusable object that allows you to group jobs
  2. the lowest level of organization
  3. offered by the software not listed in the object library
  4. contains many data flows

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
7) The Query transform cannot perform which of the following operations

  1. Join data from multiple sources
  2. Map columns from input to output schemas
  3. Perform transformations and functions on the data
  4. Use data base hints for performance

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
8) Chose what is not correct about the usage of embedded data flows?

  1. Simplify data flow display.
  2. Reuse data flow logic
  3. Debug data flow logic
  4. It needs at least one table to be present

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
9) Type of variables and parameters one can create using the Variables and
Parameters window when one selects Dataflow

  1. Local variables
  2. Global variables
  3. Parameters
  4. functions

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



 
10) which of the following is true about substitution parameter

  1. Defined at the job level
  2. Value can change during job execution
  3. Defined at the repository level
  4. Data-type specific

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
11) which of the following is true about Global Variables

  1. Cannot be shared across jobs
  2. Can be shared across jobs
  3. No data type
  4. Defined at the repository level

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
12) The following objects can be elements in work flows

  1. validation transform
  2. query Transform
  3. SQL Transform
  4. workflow

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
13) which of the following can be used to read a delimited or fixed-width flat file

  1. File
  2. Table
  3. template Table
  4. XML

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
14) 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. Merge Transform
  2. Union all transform
  3. Join transform
  4. Case Transform

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
15) which of the following returns multiple values based on single/multiple condition(s)

  1. lookup()
  2. lookup_seq()
  3. lookup_ext()
  4. exec()

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
16) What is not a platform transformations

  1. SQL
  2. Validation
  3. Table_Comparison
  4. XML_MAP

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
17) Which of the following is not correct about Merge Transform

  1. input datasets should have same number of columns
  2. input datasets should have same column names
  3. input datasets should have same data types of columns
  4. input datasets can have different column names

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
18) Which of the below transformations are used to push down operations to source database.

  1. Hierarchy Flattening
  2. XML_Pipeline
  3. Data_Transfer
  4. Map_CDC_Operation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
19) Table_comparision Transform Compares two data sets and produces the difference between them as a data set with rows flagged as except

  1. INSERT
  2. UPDATE
  3. DELETE
  4. DROP

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



 
20) The Audit data flow feature is used

  1. to notify you if your source does not contain correct data.
  2. to view profile statistics
  3. to invoke validation transform
  4. to invoke merger transform

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
21) Datastores are used except to

  1. Provide a logical channel (connection) to a database
  2. import metadata for source and target databases into the repository.
  3. to read data from source tables and load data to target tables
  4. to read from flat file

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
22) Which of the following components provide If/then/else logic

  1. Ans)Conditional
  2. workflow
  3. DataFlow
  4. none of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
23) You can create your own functions by writing which type of script functions using the smart editor

  1. Java Script
  2. SAP BusinessObjects Data Services scripting language
  3. VB script
  4. Unix Shell scripts

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
24) Which of the following is not correct

  1. Stored procedure can be called from script component
  2. Stored Procedure cannot be called from SQL transform
  3. Stored Procedure can be used with in an expression
  4. Stored procedure can be called in a shel scriot

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
25) An excel source has header data till 9th row and data set from 10th row, with which of the below way we can extract data from 10th row without considering the header data.

  1. By mentioning the worksheet name
  2. By providing worksheet custom range
  3. With code page checkbox
  4. Cannot extract without header

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
26) Which object tries an alternate work flow if an error occurs in a job?

  1. Catch
  2. Try
  3. while
  4. Script

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
27) Which of these objects is single-use?

  1. Job
  2. Ans)Project
  3. Workflow
  4. DataFlow

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

  1. Ans)File Format
  2. Database DataStore
  3. Application DataStore
  4. Adapter DataStore

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
29) Which of the following is not true about parallel workflow?

  1. flows are independent of each other
  2. flows are dependent on each other
  3. Whether or not the server can handle the processing requirements of flows running at the same time
  4. connected and un connected data flows can not be in same work flow

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



 
30) Which of the following is not true about embedded Dataflow

  1. An embedded data flow is a data flow that is called from inside another data flow.
  2. Data passes into or out of the embedded data flow from the parent flow through a single source or target.
  3. The embedded data flow can contain any number of sources or targets, but only one input or one output can pass data to or from the parent data flow.
  4. The embedded data flow can contain only one sources or targets, and only one input or one output can pass data to or from the parent data flow.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
31) Which of the following is not true about arrayfetch size

  1. Array fetch size indicates the number of rows retrieved in a single request to a source database
  2. Default value of array size is 1000
  3. Higher numbers reduce requests, increases network traffic, and possibly improve performance.
  4. Max value of array zise is 5000

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
32) What is the executable object in Data Services?

  1. DataFlow
  2. Jobs
  3. Workflows
  4. Project

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
33) Which of the following is not true about custom functions

  1. Functions cannot call other functions
  2. functions return a value
  3. functions cannot call themselves
  4. Functions cannot participate in a cycle of recursive calls

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
34) The Value that is constant in one environment, but may change when a job is migrated to another environment.

  1. Global Variable
  2. Local variable
  3. Substitution parameter
  4. Constant

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
35) Which of the following is not Job Design performance Option

  1. Load Only changed Data
  2. Minimizing DataType Conversion
  3. Ans)Maximizing locale conversion
  4. taking care of Precision in operations

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
36) After persistent cache table is created as a target in one data flow. Which of the following can not done?

  1. It can be used as a source in any data flow.
  2. It can be used as a lookup table
  3. It can be used as comparison table.
  4. It can not be used as a lookup table

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
37) Job fails to execute due to

  1. Ans)Incorrect syntax,Job Server not running, port numbers for Designer and Job Server not matching.
  2. Incorrect syntax,Job Server running, port numbers for Designer and Job Server not matching.
  3. Incorrect syntax,Job Server not running, port numbers for Designer and Job Server
  4. Incorrect syntax,Job Server not running, port numbers for Designer and Job Server not matching.

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



 
38) Which function Checks to see if a given file or directory exists.

  1. file_found
  2. Ans)file_exists
  3. file_wait
  4. none of the above

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

  1. Siebel
  2. Webservice REST
  3. Oracle Applications
  4. File format

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

  1. Ans)Creates a new row for each value in a column that you identify as a pivot column
  2. Creates a new column for each value in a column that you identify as a pivot column
  3. Creates a new row for specifed values in a column that you identify as a pivot column
  4. Creates one row of data from various tables.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
41) Reverse_Pivot Transform

  1. Ans)Creates one row of data from several columns of data
  2. Creates one row of data from several existing rows.
  3. Creates same number of rows of data from several existing rows.
  4. creates multiple work sheets in an excel sheet

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
42) Select the correct hierarchy of the objects

  1. Dataflow, Job, Workflow, Project.
  2. Job, Project, Workflow, Dataflow.
  3. Project, Job, Workflow, Dataflow.
  4. Job, Workflow, Dataflow, Project.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
43) Difference viewer can compare except

  1. two different objects
  2. an object in the local object library with its counterpart in the central object library
  3. different versions of the same object
  4. comparison of two tables in database

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
44) The local repository and the central repository

  1. can have different repositiory version
  2. Ans)should have same repository version
  3. retains history of object
  4. obejcts cannot be compared

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



 
45) With template tables

  1. It is required to initially create a new table in your DBMS and import the metadata into the software
  2. software automatically creates the table in the database with the schema defined by the data flow when you execute a job
  3. can be used as a target table in multiple data flows
  4. can be created in the database as soon as you save the data flow

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
46) Process of nesting data to a separate schema implicitly related to a single row and column of parent schema is called as

  1. New Relational Dimensional Modelling
  2. Nested Relational Data Modelling
  3. Relational Dimensional Modelling
  4. Operational Data Storing

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
47) Which of the below option is used to restrict the Dataflow should only execute once.

  1. Database links
  2. Execute only once
  3. Degree of Parallelism
  4. Cache Type

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
48) The property of a data flow that defines how many times each transform within a data flow replicates to process a parallel subset of data is?

  1. Degree Of Parallelism(DOP)
  2. XML Messaging
  3. Nested Schema
  4. Transparent Network Substrate

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
49) What is the default Cache type for Dataflow

  1. Pageabale
  2. In-memory
  3. Parallelism
  4. Push-down

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
50) Which of the below BODS function should be used to retrieve ‘GHI’ from string ‘ABD_EF_GHI_123’

  1. substring(‘ABD_EF_GHI_123’,1,7)
  2. right(‘ABD_EF_GHI_123’,-1,3)
  3. word_ext(‘ABD_EF_GHI_123’,3,’_’)
  4. ltrim( ‘ABD_EF_GHI_123’,’_’)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
51) Which of the below job error messages security levels

  1. Information
  2. Warning
  3. Error
  4. Information, Warning & Error

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



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz