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

Answer : C

 
 
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

Answer : A

 
 
3) DataStore is

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

Answer : B

 
 
4) DataStore is

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

Answer : B

 
 
5) which function Sends a command to the operating system for execution

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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : D

 
 
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

Answer : D

 
 
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

Answer : C




 
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

Answer : C

 
 
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

Answer : A

 
 
12) The following objects can be elements in work flows

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

Answer : D

 
 
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

Answer : A

 
 
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

Answer : A

 
 
15) which of the following returns multiple values based on single/multiple condition(s)

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

Answer : C

 
 
16) What is not a platform transformations

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

Answer : C

 
 
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

Answer : D

 
 
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

Answer : C

 
 
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

Answer : D




 
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

Answer : A

 
 
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

Answer : D

 
 
22) Which of the following components provide If/then/else logic

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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : B

 
 
26) Which object tries an alternate work flow if an error occurs in a job?

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

Answer : B

 
 
27) Which of these objects is single-use?

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

Answer : B

 
 
28) Which of the following is NOT a datastore type?

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

Answer : A

 
 
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

Answer : B




 
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.

Answer : D

 
 
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

Answer : C

 
 
32) What is the executable object in Data Services?

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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : C

 
 
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

Answer : C

 
 
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

Answer : D

 
 
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.

Answer : A




 
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

Answer : B

 
 
39) Which is NOT a datastore type?

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

Answer : D

 
 
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.

Answer : A

 
 
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

Answer : A

 
 
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.

Answer : C

 
 
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

Answer : D

 
 
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

Answer : B




 
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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : B

 
 
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

Answer : D

 
 
49) What is the default Cache type for Dataflow

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

Answer : A

 
 
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’,’_’)

Answer : C

 
 
51) Which of the below job error messages security levels

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

Answer : D




 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz