SAP BO Beginner Quiz

Posted on: | By: – Comments Off

SAP BO Beginner Quiz




1
IDT Supports which of the below types of projects

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A&B[/bg_collapse]
 
2
Folders in IDT are synonymous to

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Classes in Designer[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Projection Aggregate and SQL Aggregate[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : SQL Aggregate[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data federation server[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Rarely will users want to use attributes as conditions in queries[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : @ Select[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
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

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Universes can’t be organized into views to make subsets of objects for targeted groups of users[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Allows hundreds of tables to be divided by subject area[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both B & C[/bg_collapse]
 
17
What is the extension of WebI report ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : .wid[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : By applying Conditional Format Rules[/bg_collapse]
 
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

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : None of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Section divides data within a block[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Drill mode allows you to drill from one report to another[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : To drill down into chart, scope of analysis need not be set[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : OpenDocument is used to link two WebI documents[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Query Filters limit data retrieved from data source[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Input controls cannot be applied to specific sections in a report[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Merge data based on similar dimensions[/bg_collapse]
 
28
Calculation Mode for Rank function can be

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All the above[/bg_collapse]
 
29
Following client tool is not part of BO 4.0

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

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



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : JOIN[/bg_collapse]
 
31
Following operator is not part of combined query in Web Intelligence 4.0

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : JOIN[/bg_collapse]
 
32
BO Dashboard is a tool for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data Visualization[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Line chart[/bg_collapse]
 
34
XY chart is also called as

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Scatter plot chart[/bg_collapse]
 
35
Dashboard visual model is compiled to which file format?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : SWF[/bg_collapse]
 
36
Saved dashboard file will have following extension

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : XLF[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dynamic visibility[/bg_collapse]
 
38
Dynamic visibilty option is available in which tab of property window

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : behaviour[/bg_collapse]
 
39
Templates can be added to the existing charts in Dashboard

  1. No
  2. yes

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Themes[/bg_collapse]
 
41
A circular chart divided into one or more slices

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Pie chart[/bg_collapse]
 
42
The component used for displaying the charts in a slide show format

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : panel container[/bg_collapse]
 
43
For highlighting the values at a particular threshold, we must use___________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Alerts[/bg_collapse]
 
44
dashboards are oraganized in __________ tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dashboard Builder[/bg_collapse]
 
45
which tab in not available in the homepage of Dashboard design

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : explorer[/bg_collapse]
 
46
Data Visualization is the key feature of which BO tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dashboard Builder[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : view on demand access level can refresh report in real time[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : you can use the built-in security within SAP BusinessObjects, referred to as Enterprise authentication[/bg_collapse]
 
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

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Deny, [/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : does not allow to move content from one environment to another[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : When a user tries to refresh a query that contains the private object, the user receives an error message.[/bg_collapse]
 
54
what happens when inheritance from multiple groups overlap: Grant + Not Specified

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Grant[/bg_collapse]
 
55
what happens when inheritance from multiple groups overlap: Not Specified

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Deny[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Life Cycle Manager[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : locking mechanism[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Auditing information is Real time[/bg_collapse]
 
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

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



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
61
Data Security Allows to

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

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



 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz