SAP BO Quiz

SAP BO Expert Quiz

 



Topic : BO Architecture
1) While sending crystal report to a destination with the help of ‘Send To’ option in Infoview, which server performs the job.

  1. Crystal report Job Server
  2. Crystal report processing Server
  3. Destination Job Server
  4. Report Application Server

Answer : C

 
 
Topic : BO Architecture
2) Default port of Web Application Container Server (WACS)

  1. 8005
  2. 6410
  3. 6400
  4. 6405

Answer : D

 
 
Topic : BO Architecture
3) Which type of event is managed by event server

  1. Custom Based
  2. File Based
  3. Schedule Based
  4. All of the above

Answer : A

 
 
Topic : BO Architecture
4) What service can be hosted by the Adaptive job server?

  1. Destination Configuration Service
  2. Web Intelligence scheduling and Publishing Service
  3. Replication service
  4. All of the above

Answer : D

 
 
Topic : BO Architecture
5) Which one is NOT is an output location for reports instance

  1. FTP
  2. SMTP
  3. Inbox
  4. Personal Folder

Answer : D

 
 
Topic : BO Architecture
6) Which of the server does NOT comes under storage tier

  1. Crystal Cache Server
  2. Deski Cache server
  3. LOV server
  4. Input file server

Answer : C

 
 
Topic : BO Architecture
7) Which task LOV Job server is responsible for

  1. Creating Dynamic Cascading Parameters
  2. Running Scheduled LOV objects
  3. Creating Business Views
  4. Creating the report to hold LOV objects

Answer : B

 
 
Topic : BO Architecture
8) If a BOE system has multiple Input/Output File Repository servers, how to determine the active set of servers

  1. Active FRS are the ones that were register with CMS
  2. The active FRS change depending on the location of reporting DB
  3. The active FRS are the ones that have the active switch set in their command line
  4. The activ FRS were the first ones installed in the Initial BOE deployment.

Answer : A

 
 
Topic : BO Architecture
9) Which of the server does NOT interact with Reporting Database

  1. Crystal report job server
  2. Desktop Intelligence Job server
  3. Crystal report page server
  4. Web Intelligence Job server

Answer : D

 
 
Topic : BO Architecture
10) Which of the job CMS does NOT performs

  1. Manages Auditing
  2. Maintain a list of servers and IP addresses
  3. Manages files during File events
  4. Manages files during schedule event

Answer : C




 
Topic : BO Architecture
11) Which of the files are NOT stored in Input File Repository Store

  1. Universe
  2. Business Views
  3. List of Values
  4. Reports

Answer : B

 
 
Topic : BO Architecture
12) Which server is required to copy contents between systems when using federation

  1. Program Job server
  2. Adaptive Job server
  3. Server Intelligence Agent
  4. Adaptive Processing server

Answer : B

 
 
Topic : BO Architecture
13) Which service needs to be selected in the Adaptive Job Server to allow webi documents to schedule

  1. Web Intelligence Scheduling and Publishing Service
  2. Web Intelligence Job Service
  3. Destination Configuration Service
  4. Web Intelligence Scheduling and Replication service

Answer : A

 
 
Topic : BO Architecture
14) All services register themselves with name server or can be called as

  1. Server Intelligence Agent
  2. Tomcat
  3. WACS
  4. Central Management server

Answer : D

 
 
Topic : BO Architecture
15) If auditing is enabled for webi processing server, which server is responsible to push the audit information in audit database

  1. Webi Job Server
  2. CMS
  3. Webi processing server
  4. SIA

Answer : B

 
 
Topic : Report Design/Dev
16) A report can be forced to display duplicate rows by
1) Unchecking the ‘donot fetch duplicate rows’ option in query panel
2) Checking the ‘do not fetch duplicate rows’ option in query panel
3) By uncheking the avoid duplicate rows aggregation’ in table for

  1. 1)
  2. 2)
  3. 3)
  4. 4)

Answer : A

 
 
Topic : Report Design/Dev
17) Duplicate Rows Aggregation in the table format dialog box in DeskI is available for which of the below report formats
1) Tabular
2) Cross-tab
3) Charts

  1. 1)
  2. 1),2)
  3. 1),2),3)
  4. 3)

Answer : A

 
 
Topic : Report Design/Dev
18) With respect to UNDOING of a drill action in a report, which of the below is TRUE
1) In DeskI – There is no limit on the number of action that can be UNDONE
2) In DeskI – Last 10 actions can be UNDONE and in WebI – Last 1 action can be undone
3) In DeskI

  1. 1)
  2. 2)
  3. 3)
  4. 4)

Answer : B

 
 
Topic : Report Design/Dev
19) You need to change date format to british format for all you reports. Which approach you follow

  1. Change the date format manually for all reports at report level
  2. Change the date format in Designer for a specific objects
  3. Change the date format in Database
  4. None

Answer : B

 
 
Topic : Report Design/Dev
20) If we have an Hierarchy defined. The Drill will be based on which Hierarchy

  1. Default Hierarchy
  2. Custom Hierarchy
  3. None

Answer : B




 
Topic : Report Design/Dev
22) if you want to filter, sort, add simple calculations, or drill on the values displayed in the web intelligence reports which view format will be good to choose

  1. HTML
  2. interactive
  3. pdf
  4. any of the above

Answer : B

 
 
Topic : Report Design/Dev
23) Which statement below is true about the difference between master-detail and Breaks?

  1. In break common fields are deleted without changing the table format of the report where as in master-detail we declare certain entity as a master to get the detailed information or report in this case the table format is changed.
  2. In break common fields are grouped where as in master-detail we declare certain entity as a master to get the detailed information or report in this case the table format is changed.
  3. In break common fields are deleted without changing the table format of the report where as in master-detail break common fields are not deleted
  4. None of the above

Answer : A

 
 
Topic : Report Design/Dev
24) How can we improve Report performance?

  1. Use of Indexes in database tables
  2. use of Aggregate tables in database.
  3. Use of Aggregate Awareness feature
  4. All of the above

Answer : D

 
 
Topic : Report Design/Dev
25) The tool used in BO to interact with excel online is called

  1. Rich Client
  2. Deski
  3. Designer
  4. Liveoffice

Answer : D

 
 
Topic : Universe Designer
26) Which of the below is correct
1) Universe and Report Folders are physical storage components
2) Universe and Report Folders are logical storage components
3) Categories are logical storage components
4) Categories are physical storage components

  1. 1), 3)
  2. 2), 3)
  3. 1) , 4)
  4. None

Answer : A

 
 
Topic : Universe Designer
27) In the Universe for a measure object

  1. A) Specifying SUM in ‘select’ under the ‘definition’ tab of properties window
  2. B) Specifying SUM in ‘aggregation’ selection under ‘properties’ tab

Please choose the correct one from below
1) ‘A’ and ‘B’ are synonymous t

  1. 1)
  2. 2)
  3. both 1) and 2)
  4. None of the above

Answer : B

 
 
Topic : Universe Designer
28) What are the Join path problems in BO Designer

  1. Loops
  2. Fan Trap
  3. Chasm Trap
  4. All of the above

Answer : D

 
 
Topic : Universe Designer
29) How to export list of values to the universe

  1. Check the “Export to universe” option in Object Properties page
  2. The list of values is maintained as local copy and cannot be exported
  3. Go to Tools->List of Values-> Export Lov to Universe
  4. None

Answer : A

 
 
Topic : Universe Designer
30) What are the different Strategies available in Designer Universe Parameters

  1. Built-in Strategy
  2. Internal Strategy
  3. External Strategy
  4. A & C

Answer : D




 
Topic : Universe Designer
31) In @prompt function which parameter must be set so that more than one value can be selected from given List of values

  1. MONO
  2. MANY
  3. MULTI
  4. CONSTRAINED

Answer : C

 
 
Topic : Universe Designer
32) The following is the way to link universe

  1. Kernal Approach
  2. Component Approach
  3. Master Approach
  4. All of the above

Answer : D

 
 
Topic : Universe Designer
33) Allocating weight to a table is a way to optimize an universe

  1. Yes
  2. No

Answer : A

 
 
Topic : Universe Designer
34) You cannot create derived universes from a universe which is itself derived.

  1. TRUE
  2. FALSE
  3. Possible through sdk
  4. None of the above

Answer : A

 
 
Topic : Universe Designer
35) Choose the correct statement

  1. Linked universes can have separate connection strings pointing to different databases.
  2. Linked universes can have separate connection strings pointing to same database
  3. None of the above
  4. All of the above

Answer : B

 
 
Topic : Universe Designer
36) If the same universe object is to be used for two aliases on the same table lying in different contexts, which is the best way

  1. Use @Aggregate_Aware function
  2. Use @Prompt function
  3. Use @Where function
  4. None of the above

Answer : A

 
 
Topic : Universe Designer
37) If a common measure object between two linked data providers is to be displayed in the report, which function will ensure correct results

  1. Average
  2. Sum
  3. Multicube
  4. None of the above

Answer : C

 
 
Topic : Universe Designer
38) If a universe file is sent by email to another user, what type of connection should be used to ensure the recipient can open the file

  1. Personal connection
  2. Shared connection
  3. Secured connection
  4. None of the above

Answer : B

 
 
Topic : Universe Designer
39) Row level and Object level security can be enforced in which module of BO XI

  1. BO XI Designer
  2. Central Management Console
  3. Central Configuration Manager
  4. All of the above

Answer : A

 
 
Topic : Universe Designer
40) How do you restrict access to rows of a database in BO Xi?

  1. by using row-level security in designer module
  2. by using row-level security in Security module
  3. Cant be provided
  4. can be done only at database table level

Answer : A




 
Topic : Universe Designer
41) What below are true about Object qualification?

  1. Object qualification represents only the Measure objects
  2. we have three types of object qualifiers they are measure, dimension and detailed.
  3. Object qualification is needed for defining Aggregate Awareness in the Universe
  4. None of the above

Answer : B

 
 
Topic : Universe Designer
42) While creating a Universe one does not have the option to control

  1. Limiting the size of result set
  2. Limiting the execution time
  3. Limiting the number of users
  4. Limiting size of Long texts

Answer : C

 
 
Topic : Universe Designer
46) A detail object always need to be associated with

  1. another Detail Object
  2. Dimension
  3. Measure
  4. None of the above

Answer : B

 
 
Topic : Universe Designer
47) In BO, custom hierarchy is defined by

  1. The order of columns in the database table
  2. BO doesn’t have custom hierarchy
  3. In the top down order of objects in a class
  4. All the above

Answer : C

 
 
Topic : Universe Designer
48) Universe based on XML can be built from

  1. Universe Designer
  2. WebI rich client
  3. Universe Builder
  4. Cant create universe on XML

Answer : C

 
 
Topic : Universe Designer
49) Which of the following is TRUE about  Integrity checks?

  1. It detects whether there are any loops in the joins
  2. It detects whether any context are necessary.
  3. It detects any errors in the objects, joins, conditions, and cardinalities of your universe
  4. All of the above

Answer : D

 
 
Topic : Universe Designer
50) Disadvantages of creating a measure as dimension

  1. While creation, It will throw an error
  2. Can not perform aggregation
  3. Won’t be able to apply section
  4. All the above

Answer : B

 
 
Topic : Universe Designer
51) This are defined in a universe in order to facilitate custom drill down between objects from same or different classes according to user requirement

  1. Custom Hierarchies
  2. Input control
  3. @prompt
  4. Derived tables

Answer : A