SAP BO Beginner Quiz
1
IDT Supports which of the below types of projects
- Local
- Shared
- Common
- A&B
2
Folders in IDT are synonymous to
- Classes in Designer
- Objects in Designer
- Measures in designer
- None of the above
3
Which of the following forms of aggregates are involved in measure Objects
- Projection Aggregate and SQL Aggregate
- SQL Aggregate and Cumulative aggregate
- Cumulative aggregate and Projection aggregate
- all of the above
4
Risk of overloading servers, network, and client PCs can be avoided by using
- SQL Aggregate
- Projection aggregate
- Cumulative aggregate
- all of the above
5
In a multisource universe, which server routes the request?
- File InPut Server
- Data federation server
- Linked Server
- None of the above
6
It is good to disable LOV’s for Attrributes as
- Rarely will users want to use attributes as conditions in queries
- Attributes cannot be used as conditions in queries
- Attributes cannot be used for drill down
- all of the above
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
- @ Select
- @where
- @prompt
- None of the above
8
Which of the following is true about Universe Object with prompt
- Designer builds into Universe
- Centralized
- error proof
- all of the above
9
Which of the following Joins create an alternative fast join path between 2 tables
- Isolated Join
- ShortCut Join
- Theta Join
- None of the above
10
Which of the following is not a benefit of IDT over Universe design tool
- It allows for multiple data sources
- New versions of the client tools such as Crystal Reports Enterprise and Dashboard Design require a .unx and cannot access 3.x universes
- It has better support for multidimensional data sources, such as BW, Essbase, and Microsoft Analysis Services
- Universes can’t be organized into views to make subsets of objects for targeted groups of users
11
DataFoundation Views in IDT
- Allows hundreds of tables to be divided by subject area
- has the use on what user ultimately views
- is similar to views created by DBA in DataWareshouse
- None of the above
12
When one publishes a Business Layer to the repository, IDT Compiles which of the following into single UNX file
- Connection
- Data Foundation
- Business Layer
- All of the above
13
Universe Design tool should be used only when
- Linked Universes are involved
- Stored procedures to be used as datasource
- Web Intelligence 3.x and Live office are used
- All of the above
14
New in SAP BO BI 4.0 is
- Parameters and LOV’s are not connected by default when a business Object is created
- Ability to divide one business layer into multiple views
- One universe access multiple datasources
- all of the above
15
which of the following is true about connections
- Connection definitions are initially stored in file called .cnx
- Connection changes to .cns when published to repositoty
- when you use secured connection while creating a universe . A shortcut to Secured connection is created on local desktop
- all of the above
16
Which of the following is true ?
- Input File Repository Server maintains target report instances
- Output File Repository Server maintains target report instances
- Input File Repository Server maintains report and program objects
- Both B & C
17
What is the extension of WebI report ?
- .rep
- .wid
- .wic
- .wir
18
How do you highlight a record based on a condition in Web Intelligence 4.0 ?
- By applying Conditional Format Rules
- Using display properties
- Using Highlighters
- Using Hyperlinks
19
How do you perform union of 2 queries in WebIntelligence ?
- Using SET Operator button
- Using Combine queries button
- Using UNION clause to join two queries
- None of the above
20
RANK function cannot be used to compute the following
- Get the TOP 10 Stores by revenue
- Get the BOTTOM 10 Stores by Revenue
- Get the TOP 20% Stores by Revenue
- None of the above
21
Which of the following is not true in WebIntelligence?
- Section divides the table into multiple blocks
- Break divides the data within a block
- Section divides data within a block
- Break allows you to provide sub totals within a block
22
Which of the following is not valid for Drill Analysis in WebI reports ?
- Drill mode must be enabled in the report
- Drill mode allows you to drill from one report to another
- Using Drill Up and Drill Down, you can move through a hierarchy one dimension at a time
- You can only Drill By a dimensions defined in Scope of analysis
23
Which of the following is not True regarding Dilling in reports ?
- You can drill down into a table after enabling drill
- You can drill down into a chart after enabling drill
- To drill down into chart, scope of analysis need not be set
- All the above
24
What is the use of OpenDocument in WebIntelligence ?
- OpenDocument is used to open a WebI report from command line
- OpenDocument is used to link two WebI documents
- OpenDocument saves session Information of WebI document
- None of the above
25
Which of the following is applicable to filters used in Web Intelligence document ?
- Query Filters limit data retrieved from data source
- Report Filters limit data retrieved from datasource
- Both Query filters and report filters are used to filter data retireved in a report.
- All the above
26
Which of the following is not true regarding Input controls in WebIntelligence ?
- Input controls can be used to filter data in a report
- Input controls can be applied to specific sections in a report
- Input controls cannot be applied to specific sections in a report
- Input controls can be applied to the whole report
27
Following option is used to synchronize data from two different data sources within a Web Intelligence report
- Group Data option
- Merge data based on similar dimensions
- Synchronize data option
- Copy data option
28
Calculation Mode for Rank function can be
- Count
- Sum
- Cumulative Sum
- All the above
29
Following client tool is not part of BO 4.0
- Web Intelligence Rich Client
- BI Launchpad
- Desktop Intelligence
- CCM
30
Following operator is not part of combined query in Web Intelligence 4.0
- UNION
- JOIN
- INTERSECTION
- MINUS
31
Following operator is not part of combined query in Web Intelligence 4.0
- UNION
- JOIN
- INTERSECTION
- MINUS
32
BO Dashboard is a tool for
- Query and Analysis
- Data Visualization
- Data Mining
- A & C
33
Type of chart useful to visualize data that changes over a period of time
- Line chart
- Pie chart
- radar chart
- None of the above
34
XY chart is also called as
- bubble chart
- combination chart
- Scatter plot chart
- bar chart
35
Dashboard visual model is compiled to which file format?
- SWF
- AIR
- PPT
36
Saved dashboard file will have following extension
- XLF
- XLS
- DOC
- XLC
37
the feature that allows you to control when a component is visible based on the contents of a spreadsheet cell is called
- show/ hide option
- interactive display
- Dynamic visibility
- this feature is not available in Dashboard
38
Dynamic visibilty option is available in which tab of property window
- general
- alert
- appearance
- behaviour
39
Templates can be added to the existing charts in Dashboard
- No
- yes
40
_________provide an easy way to customize your model and maintain a consistent look throughout the model
- templates
- Themes
- components
- charts
41
A circular chart divided into one or more slices
- bubble chart
- trend chart
- Pie chart
- scatter plot chart
42
The component used for displaying the charts in a slide show format
- Canvas container
- tabset container
- panel container
- templates
43
For highlighting the values at a particular threshold, we must use___________
- Alerts
- scorecards
- gauge
- theme
44
dashboards are oraganized in __________ tool
- BO Analyzer
- Web Intelligence
- BO explorer
- Dashboard Builder
45
which tab in not available in the homepage of Dashboard design
- component tab
- object browser
- explorer
- query browser
46
Data Visualization is the key feature of which BO tool
- Web intelligence
- Data Explorer
- Dashboard Builder
- Crystal report
47
which of the following is true about Access Levels
- Schedule access level can shedule report and refresh report in real time
- View access level can see folder and report but not universe
- view on demand access level can refresh report in real time
- all of the above
48
If your company does not have a centralized system for assigning user IDs and passwords
- You can use External Authentication with windows AD
- you can use the built-in security within SAP BusinessObjects, referred to as Enterprise authentication
- You can use LDAP for authentication
- all of the above
49
Which of the tasks are involved in migrating content:
- Create a job that specifies the source and destination.
- Select the repository content that you wish to migrate, such as universes and reports.
- Identify and select dependent objects and execute the job
- all of the above
50
which of the following is true about CMC
- It is web based application
- allows for control of users
- allows for control of repository Objects
- all of the above
51
what happens when inheritance from multiple groups overlap :Grant + Deny + Not Specified
- Deny
- Grant
- Not Specified
- all of the above
52
Which of the following is not true about BIAR file
- does not allow to move content from one environment to another
- It is a type of zip or archive file
- It contains XML files for documents, universes, and other repository content
- all of the above
53
When you use object-level security, if a user does not have access to the object which of the following is true:
- When a user creates a new query, the user sees the object in the universe.
- When a user tries to refresh a query that contains the private object, the user receives an error message.
- When a user accesses a report that contains the private object, the user doesnot see the object in the report,
- all of the above
54
what happens when inheritance from multiple groups overlap: Grant + Not Specified
- Deny
- Grant
- Not Specified
- all of the above
55
what happens when inheritance from multiple groups overlap: Not Specified
- Deny
- Grant
- Not Specified
- all of the above
56
Import wizard is now called as
- Central Configuration Manager import wizard
- Life Cycle Manager
- Migration Wizard
- all of the above
57
When working with a repository, the IDT allows universe development and maintenance to be distributed across several designers through a
- IBM clear Case tool
- locking mechanism
- Microsoft Virsual sourceSafe
- all of the above
58
Which of the following is not true about auditing
- Historical usage information can be captured to a log file
- Historical usage information can be captured to a relational database
- Auditing information is Real time
- all of the above
59
For the group everyone the default access to all universes and universe connections is
- View
- Schedule
- Full Control
- all of the above
60
Business Security Profile allows to
- grant access to business layer views
- deny access to business layer views
- individual dimensions, measures, and filter objects available in the business layer
- all of the above
61
Data Security Allows to
- remap connections and tables
- set SQL control
- filter rows of data
- all of the above