SAP BO Beginner Quiz

SAP BO Beginner Quiz




1
IDT Supports which of the below types of projects

  1. Local
  2. Shared
  3. Common
  4. A&B

Answer : A&B

 
2
Folders in IDT are synonymous to

  1. Classes in Designer
  2. Objects in Designer
  3. Measures in designer
  4. None of the above

Answer : Classes in Designer

 
3
Which of the following forms of aggregates are involved in measure Objects

  1. Projection Aggregate and SQL Aggregate
  2. SQL Aggregate and Cumulative aggregate
  3. Cumulative aggregate and Projection aggregate
  4. all of the above

Answer : Projection Aggregate and SQL Aggregate

 
4
Risk of overloading  servers, network, and client PCs can be avoided by using

  1. SQL Aggregate
  2. Projection aggregate
  3. Cumulative aggregate
  4. all of the above

Answer : SQL Aggregate

 
5
In a multisource universe, which server routes the request?

  1. File InPut Server
  2. Data federation server
  3. Linked Server
  4. None of the above

Answer : Data federation server

 
6
It is good to disable LOV’s for Attrributes as

  1. Rarely will users want to use attributes as conditions in queries
  2. Attributes cannot be used as conditions in queries
  3. Attributes cannot be used for drill down
  4. all of the above

Answer : Rarely will users want to use attributes as conditions in queries

 
7
Which of the following function is an internal function that allows you, as the designer, to reuse business layer objects without forcing you to repeat the entire SQL syntax

  1. @ Select
  2. @where
  3. @prompt
  4. None of the above

Answer : @ Select

 
8
Which of the following is true about Universe Object with prompt

  1. Designer builds into Universe
  2. Centralized
  3. error proof
  4. all of the above

Answer : all of the above

 
9
Which of the following Joins create an alternative fast join path between  2 tables

  1. Isolated Join
  2. ShortCut Join
  3. Theta Join
  4. None of the above

Answer : ShortCut Join




10
Which of  the following is not a benefit of IDT over Universe design tool

  1. It allows for multiple data sources
  2. New versions of the client tools such as Crystal Reports Enterprise and Dashboard Design require a .unx and cannot access 3.x universes
  3. It has better support for multidimensional data sources, such as BW, Essbase, and Microsoft Analysis Services
  4. Universes can’t be organized into views to make subsets of objects for targeted groups of users

Answer : Universes can’t be organized into views to make subsets of objects for targeted groups of users

 
11
DataFoundation Views in IDT

  1. Allows hundreds of tables to be divided by subject area
  2. has the use on what user ultimately views
  3. is similar to views created by DBA in DataWareshouse
  4. None of the above

Answer : Allows hundreds of tables to be divided by subject area

 
12
When one publishes a Business Layer to the repository, IDT Compiles which of the following into single UNX file

  1. Connection
  2. Data Foundation
  3. Business Layer
  4. All of the above

Answer : All of the above

 
13
Universe Design tool should be used only when

  1. Linked Universes are involved
  2. Stored procedures to be used as datasource
  3. Web Intelligence 3.x and Live office are used
  4. All of the above

Answer : All of the above

 
14
New in SAP BO BI 4.0 is

  1. Parameters and LOV’s are not connected by default when a business Object is created
  2. Ability to divide one business layer into multiple views
  3. One universe access multiple datasources
  4. all of the above

Answer : all of the above

 
15
which of the following is true about connections

  1. Connection definitions are initially stored in file called .cnx
  2. Connection changes to .cns when published to repositoty
  3. when you use secured connection while creating a universe . A shortcut to Secured connection is created on local desktop
  4. all of the above

Answer : all of the above

 
16
Which of the following is true ?

  1. Input File Repository Server maintains target report instances
  2. Output File Repository Server maintains target report instances
  3. Input File Repository Server maintains report and program objects
  4. Both B & C

Answer : Both B & C

 
17
What is the extension of WebI report ?

  1. .rep
  2. .wid
  3. .wic
  4. .wir

Answer : .wid

 
18
How do you highlight a record based on a condition in Web Intelligence 4.0 ?

  1. By applying Conditional Format Rules
  2. Using display properties
  3. Using Highlighters
  4. Using Hyperlinks

Answer : By applying Conditional Format Rules

 
19
How do you perform union of 2 queries in WebIntelligence ?

  1. Using SET Operator button
  2. Using Combine queries button
  3. Using UNION clause to join two queries
  4. None of the above

Answer : Using Combine queries button




20
RANK function cannot be used to compute the following

  1. Get the TOP 10 Stores by revenue
  2. Get the BOTTOM 10 Stores by Revenue
  3. Get the TOP 20% Stores by Revenue
  4. None of the above

Answer : None of the above

 
21
Which of the following is not true in WebIntelligence?

  1. Section divides the table into multiple blocks
  2. Break divides the data within a block
  3. Section divides data within a block
  4. Break allows you to provide sub totals within a block

Answer : Section divides data within a block

 
22
Which of the following is not valid for Drill Analysis in WebI reports ?

  1. Drill mode must be enabled in the report
  2. Drill mode allows you to drill from one report to another
  3. Using Drill Up and Drill Down, you can move through a hierarchy one dimension at a time
  4. You can only Drill By a dimensions defined in Scope of analysis

Answer : Drill mode allows you to drill from one report to another

 
23
Which of the following is not True regarding Dilling in reports ?

  1. You can drill down into a table after enabling drill
  2. You can drill down into a chart after enabling drill
  3. To drill down into chart, scope of analysis need not be set
  4. All the above

Answer : To drill down into chart, scope of analysis need not be set

 
24
What is the use of OpenDocument in WebIntelligence ?

  1. OpenDocument is used to open a WebI report from command line
  2. OpenDocument is used to link two WebI documents
  3. OpenDocument saves session Information of WebI document
  4. None of the above

Answer : OpenDocument is used to link two WebI documents

 
25
Which of the following is applicable to filters used in Web Intelligence document ?

  1. Query Filters limit data retrieved from data source
  2. Report Filters limit data retrieved from datasource
  3. Both Query filters and report filters are used to filter data retireved in a report.
  4. All the above

Answer : Query Filters limit data retrieved from data source

 
26
Which of the following is not true regarding Input controls in WebIntelligence ?

  1. Input controls can be used to filter data in a report
  2. Input controls can be applied to specific sections in a report
  3. Input controls cannot be applied to specific sections in a report
  4. Input controls can be applied to the whole report

Answer : Input controls cannot be applied to specific sections in a report

 
27
Following option is used to synchronize data from two different data sources within a Web Intelligence report

  1. Group Data option
  2. Merge data based on similar dimensions
  3. Synchronize data option
  4. Copy data option

Answer : Merge data based on similar dimensions

 
28
Calculation Mode for Rank function can be

  1. Count
  2. Sum
  3. Cumulative Sum
  4. All the above

Answer : All the above

 
29
Following client tool is not part of BO 4.0

  1. Web Intelligence Rich Client
  2. BI Launchpad
  3. Desktop Intelligence
  4. CCM

Answer : Desktop Intelligence




30
Following operator is not part of combined query in Web Intelligence 4.0

  1. UNION
  2. JOIN
  3. INTERSECTION
  4. MINUS

Answer : JOIN

 
31
Following operator is not part of combined query in Web Intelligence 4.0

  1. UNION
  2. JOIN
  3. INTERSECTION
  4. MINUS

Answer : JOIN

 
32
BO Dashboard is a tool for

  1. Query and Analysis
  2. Data Visualization
  3. Data Mining
  4. A & C

Answer : Data Visualization

 
33
Type of chart useful to visualize data that changes over a period of time

  1. Line chart
  2. Pie chart
  3. radar chart
  4. None of the above

Answer : Line chart

 
34
XY chart is also called as

  1. bubble chart
  2. combination chart
  3. Scatter plot chart
  4. bar chart

Answer : Scatter plot chart

 
35
Dashboard visual model is compiled to which file format?

  1. PDF
  2. SWF
  3. AIR
  4. PPT

Answer : SWF

 
36
Saved dashboard file will have following extension

  1. XLF
  2. XLS
  3. DOC
  4. XLC

Answer : XLF

 
37
the feature that allows you to control when a component is visible based on the contents of a spreadsheet  cell is called

  1. show/ hide option
  2. interactive display
  3. Dynamic visibility
  4. this feature is not available in Dashboard

Answer : Dynamic visibility

 
38
Dynamic visibilty option is available in which tab of property window

  1. general
  2. alert
  3. appearance
  4. behaviour

Answer : behaviour

 
39
Templates can be added to the existing charts in Dashboard

  1. No
  2. yes

Answer : No




40
_________provide an easy way to customize your model and maintain a consistent look throughout the model

  1. templates
  2. Themes
  3. components
  4. charts

Answer : Themes

 
41
A circular chart divided into one or more slices

  1. bubble chart
  2. trend chart
  3. Pie chart
  4. scatter plot chart

Answer : Pie chart

 
42
The component used for displaying the charts in a slide show format

  1. Canvas container
  2. tabset container
  3. panel container
  4. templates

Answer : panel container

 
43
For highlighting the values at a particular threshold, we must use___________

  1. Alerts
  2. scorecards
  3. gauge
  4. theme

Answer : Alerts

 
44
dashboards are oraganized in __________ tool

  1. BO Analyzer
  2. Web Intelligence
  3. BO explorer
  4. Dashboard Builder

Answer : Dashboard Builder

 
45
which tab in not available in the homepage of Dashboard design

  1. component tab
  2. object browser
  3. explorer
  4. query browser

Answer : explorer

 
46
Data Visualization is the key feature of which BO tool

  1. Web intelligence
  2. Data Explorer
  3. Dashboard Builder
  4. Crystal report

Answer : Dashboard Builder

 
47
which of the following is true about Access Levels

  1. Schedule access level can shedule report and refresh report in real time
  2. View access level can see folder and report but not universe
  3. view on demand access level can refresh report in real time
  4. all of the above

Answer : view on demand access level can refresh report in real time

 
48
If your company does not have a centralized system for assigning user IDs and passwords

  1. You can use External Authentication with windows AD
  2. you can use the built-in security within SAP BusinessObjects, referred to as Enterprise authentication
  3. You can use LDAP for authentication
  4. all of the above

Answer : you can use the built-in security within SAP BusinessObjects, referred to as Enterprise authentication

 
49
Which of the tasks are involved in migrating content:

  1. Create a job that specifies the source and destination.
  2. Select the repository content that you wish to migrate, such as universes and reports.
  3. Identify and select dependent objects and execute the job
  4. all of the above

Answer : all of the above




50
which of the following is true about CMC

  1. It is web based application
  2. allows for control of users
  3. allows for control of repository Objects
  4. all of the above

Answer : all of the above

 
51
what happens when inheritance from multiple groups overlap :Grant + Deny + Not Specified

  1. Deny
  2. Grant
  3. Not Specified
  4. all of the above

Answer : Deny,

 
52
Which of the following is not true about BIAR file

  1. does not allow to move content from one environment to another
  2. It is a type of zip or archive file
  3. It contains XML files for documents, universes, and other repository content
  4. all of the above

Answer : does not allow to move content from one environment to another

 
53
When you use object-level security, if a user does not have access to the object which of the following is true:
 

  1. When a user creates a new query, the user sees the object in the universe.
  2. When a user tries to refresh a query that contains the private object, the user receives an error message.
  3. When a user accesses a report that contains the private object, the user doesnot see the object in the report,
  4. all of the above

Answer : When a user tries to refresh a query that contains the private object, the user receives an error message.

 
54
what happens when inheritance from multiple groups overlap: Grant + Not Specified

  1. Deny
  2. Grant
  3. Not Specified
  4. all of the above

Answer : Grant

 
55
what happens when inheritance from multiple groups overlap: Not Specified

  1. Deny
  2. Grant
  3. Not Specified
  4. all of the above

Answer : Deny

 
56
Import wizard is now called as

  1. Central Configuration Manager import wizard
  2. Life Cycle Manager
  3. Migration Wizard
  4. all of the above

Answer : Life Cycle Manager

 
57
When working with a repository, the IDT allows universe development and maintenance to be distributed across several designers through a

  1. IBM clear Case tool
  2. locking mechanism
  3. Microsoft Virsual sourceSafe
  4. all of the above

Answer : locking mechanism

 
58
Which of the following is not true about auditing

  1. Historical usage information can be captured to a log file
  2. Historical usage information can be captured to a relational database
  3. Auditing information is Real time
  4. all of the above

Answer : Auditing information is Real time

 
59
For the group everyone the default access to all universes and universe connections is

  1. View
  2. Schedule
  3. Full Control
  4. all of the above

Answer : View




60
Business Security Profile allows to

  1. grant access to business layer views
  2. deny access to business layer views
  3. individual dimensions, measures, and filter objects available in the business layer
  4. all of the above

Answer : all of the above

 
61
Data Security Allows to

  1. remap connections and tables
  2. set SQL control
  3. filter rows of data
  4. all of the above

Answer : all of the above