SAP BIBW Beginner Quiz
SAP BIBW Quiz contain set of 64 MCQ questions for SAP BIBW MCQ which will help you to clear beginner level quiz.
1) Hierachies
- Are used to Display data in tree structures
- Can have arranged in multiple levels with nodes and leaves arranged in parent-child relationships
- can be time dependent
- all of the above
2) Hierarchy Variables
- are used in a query to restrict a characterstic
- are used to display query results using a Hierarchy
- are context dependent
- all of the above
3) Temporal Join is made available when an infoset is created with one of the infoprovider’s that is included as infoobject with
- time -independent attributes
- time-dependent attributes
- Version dependent attributes
- all of the above
4) Which of the following is not true about Hierarchy node variable
- Hierarchy node Variable can be used whenver a characterstic is restricted using a specific node of a hierarchy
- Hierarchy node variable are context dependent
- Hierarchy node variable is different from Hierarchy Variable
- none of the above
5) Which of the following is not true about structures
- Key Figure Structures can be created
- Characterstic Structures can be created
- Used to Define the layout of Query for row or column
- Cannot reuse Structures
6) Whch of the following is not true about Write Optimized DSO:
- Data is loaded directly into Active data table
- No Activation Process is required
- Data is first loaded into Activation Queue table
- One of the DSO
7) Types of DSOs
- Standard DSO
- Write-Optimized DSO
- Direct Update DSO
- all of the above
8) Types of Info Cubes
- Standard Infocube
- Real-Time InfoCube
- Virtual Provider InfoCube
- all of the above
9) Which of the following is used to extract data from source system into PSA system
- Infopackage
- Transformation
- DataTransfer process
- all of the above
10) Which of the following components of load process will automate the ETL process
- Process Chain
- Infopackage
- DataTransfer process
- all of the above
11) Which of the following types of datasources that can be created?
- Transaction Data
- Master Data attributes
- Master Data Texts
- all of the above
12) An infoSet is
- Only Logical definition
- Physical Storage of data
- Union Operator
- all of the above
13) Which of the following are InfoProviders
- MultiProviders
- InfoSets
- Virtual Providers
- all of the above
14) Which of the following is not true about BEX Analyzer
- One can run queries and perform adhoc analysis in an excel environment
- BEX Analyzer is interated with Excel by using an Excel Add-in
- Web Application
- Standalone application
15) Exceptions in Query Designer
- HighLight cells in query output if the value is beyond the threshold mentioned in the exception definition
- Can be used by Business Analysts to quickly focus on values that are highlighted in Query Output
- can accelerate Analysis Process
- all of the above
16) which of the following is not true about Conditions in BEX Query Designer
- allows to filter data
- doesn’t allow how the condition should be applied to query result
- allow to hide numbers that are not relevant
- allows to define multiple conditions for a query
17) Which of the following is not true about Filters in BEX Query Designer
- used to restrict the query execution to a specific dataset
- used to save the filter defined in one query as a resuable object that is available for all queries built on that infoprovider
- restrictions cant be applied on characterstics
- Saved Filters are used as selection Objects in SAP BW Metadata
18) Which of the following is a transparent PSA table that stores erroneous records
- ActiveTable
- Change Log
- error stack
- all of the above
19) Which one of the following is not true about Extended Star Schema
- Improved Version of Classic Star Schema
- System generated numeric values are stored in the dimension table
- Dimension Id is not system generated value for each unique combination of SID’s in Dimension table
- all of the above
20) Which of the following infoproviders store data
- MultiProviders
- InfoSets
- Virtualproviders
- Infocube
21) Which of the following cant be used as DataTarget
- InfoObjects with MasterData
- DSO’s
- Infocubes
- InfoSets
22) How many total dimensions are possible in a infocube?
- 12
- 11
- Ans) 16
- 15
23) Which of the following dimensions are already available when we create a infocube?
- time
- date
- unit
- all of the above
24) Which of the following is True about DSO?
- used to store consolidated and cleansed data
- stored in transparent, flat database tables
- describes a consolidated dataset from one or more InfoSources
- all of the above
25) ________ cube is a type of Infocube
- Ans) SAP Remote
- write optimized
- standard datastore object
- None of the above
26) ________ gets its data supply from API’s
- Standard DSO
- write optimized DSO
- Ans) direct Update DSO
- all of the above
27) Which of the following option is/are TRUE? I) We can built Aggregates on top of Info cube. II) DSO support change/add/delete operations.
- only I
- Ans) both I and II are TRUE
- Only II
- none of the above
28) In standard DSO data is deleted from ________ table after the records have been activated
- Ans) Activation queue
- active data
- change log
- all of the above
29) Which of the following is True about line item Dimension? I) No other characteristics can be assigned to a dimension
- Ans) only I
- both I and II are TRUE
- Only II
- none of the above
30) Do not use SAP Remote Cubes if _____________
- Only a few users execute queries simultaneously on the database.
- The user only access a small amount of data from time to time
- Ans) A lot of users execute queries simultaneously
- The user need very up-to-date data from an SAP source system
31) In which of the following case(s) remote cubes are recommended?
- when only a few users execute queries simultaneously on the database
- The user need very up-to-date data from an SAP source system
- The user only access to a small amount of data from time to time
- all of the above
32) Which of the following is a type of infoobject?
- Key Figure
- Characterstic
- Time characteristics
- all of the above
33) Request ID (0REQUID) is a example of __________ infoobject
- Time characteristics
- Unit
- Technical Characteristics
- key figure
34) Attribute table /BIO/Q<technical name of characteristics> is generated for which of the following option?
- for SAP standard characteristics that have attributes which are time-dependent
- for SAP standard characteristics that have attributes which are NOT time-dependent
- for customer-defined characteristics that have attributes which are NOT time-dependent
- for customer-defined characteristics that have attributes which are time-dependent
35) Attribute table /BIC/P<technical name of characteristics> is generated for which of the following option?
- for SAP standard characteristics that have attributes which are NOT time-dependent
- Ans) for customer-defined characteristics that have attributes which are NOT time-dependent
- for customer-defined characteristics that have attributes which are time-dependent
- for SAP standard characteristics that have attributes which are time-dependent
36) ______ fact table is optimized for data loading
- E table
- F table
- Both E table and F table
- none of the above
37) ______ fact table is optimized for data requests/retrieval
- E table
- F table
- Both E table and F table
- none of the above
38) Standard cube can contain max of __________ key figures.
- 64
- 233
- 128
- 256
39) suppose you have created a infoobject. In order to use the infobject what you need to do?
- save infoobject
- activate infoobject
- infoobects are activated automatically
- store infoobject in to infoarea
40) DTP can be used to load data from
- DSO to DSO
- cube to cube
- DSO to cube
- all of the above
41) which of the following is suitable to store transactional data ?
- cube
- DSO
- both
- none of the above
42) Amount(0AMOUNT) is a example of __________ infoobject
- Key Figure
- Characterstic
- Time characteristics
- unit
43) Long text can store up to
- 30 characters
- 40 characters
- 60 characters
- 45 characters
44) Business Explorer(BEx) Tab in maintainance menu of infoobject provides all the options to
- set the display defaults in the Business Explorer (BEx).
- to determine whether or not the characteristic is to appear as a textual description or as a key in BEx by default
- both the options are correct
- none of the above
45) Report to Report Interface can provide which of the following:
- Additional features to perform detailed level of analysis of data
- Enable analyst to jump to detailed information on selected value of report
- Different types of jump targets can be assigned to BEX query to make the analysis more flexible
- all of the above
46) Which of the following technical tables are generated for FACT table on activation of an InfoCube ?
- F table
- E Table
- Both F table and E table
- none of the above
47) Business evaluations objects such as customer, product , revenue are called _________
- Info cube
- Info objects
- Info providers
- all of the above
48) In which catalog we create info objects like customer , product , employee?
- Key figure
- characteristics
- both key figure and characteristics
- none of the above
49) we can create infoarea inside another infoarea?
- TRUE
- FALSE
50) Transaction code to open the process chain is ______________
- RSA1
- RSPC
- RSA32
- none of the above
51) Transaction code to open the workbench is ______________
- RSA1
- RSPC
- RSA32
- none of the above
52) Which of the following is/are examples of key figure infoobjects a. product b. revenue
- a & b
- a & c
- b & d
- all of the above
53) Which of the following is/are examples of characteristics infoobjects a. product
- a , c & d
- a & c only
- c & d only
- all of the above
54) Why do we need to normalise a data model?
- to make it look good
- to avoid redundancy
- to improve performance
- all of the above
55) We can create multiple aggregates against the same infocube ?
- TRUE
- FALSE
56) Dimension tables contain:
- Dim Key
- SID’s
- both Dim keys and SID’s
- none of the above
57) ___________is a flat structure with no extended star schema concept and which will have granular data
- DSO
- InfoCube
- both
- none of the above
58) to load the data from external file(.csv) to PSA we should run ____________
- DTP
- Infopackage
- both
- none of the above
59) to load the data from PSA to Data Target we should run ____________
- DTP
- Infopackage
- both
- none of the above
60) What is the procedure to load the data to data target?
- Full load
- Delta Load
- Both Full load and delta
- none of the above
61) Which of the following option is/are TRUE about infocube?
- after compactions in Infocube data is loaded to E table and deleted from F table
- individual requests cannot be deleted after compaction
- compaction improves the retrieval performance
- all of the above
62) Which DSO is suitable for Layer1( A tier)?
- Direct update DSO
- Write optimized DSO
- Standard DSO
- all of the above
63) __________ join (join operation) the information from two or more infoproviders
- MultiProviders
- Infosets
- Infocubes
- all of the above
64) __________ union (union operation) the information from two or more infoproviders
- MultiProviders
- Infosets
- Infocubes
- all of the above