SAP BIBW Quiz

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

  1. Are used to Display data in tree structures
  2. Can have arranged in multiple levels with nodes and leaves arranged in parent-child relationships
  3. can be time dependent
  4. all of the above

Answer : D

 
 
2) Hierarchy Variables

  1. are used in a query to restrict a characterstic
  2. are used to display query results using a Hierarchy
  3. are context dependent
  4. all of the above

Answer : D

 
 
3) Temporal Join is made available when an infoset is created with one of the infoprovider’s that is included as infoobject with

  1. time -independent attributes
  2. time-dependent attributes
  3. Version dependent attributes
  4. all of the above

Answer : B

 
 
4) Which of the following is not true about Hierarchy node variable

  1. Hierarchy node Variable can be used whenver a characterstic is restricted using a specific node of a hierarchy
  2. Hierarchy node variable are context dependent
  3. Hierarchy node variable is different from Hierarchy Variable
  4. none of the above

Answer : D

 
 
5) Which of the following is not true about structures

  1. Key Figure Structures can be created
  2. Characterstic Structures can be created
  3. Used to Define the layout of Query for row or column
  4. Cannot reuse Structures

Answer : D

 
 
6) Whch of the following is not true about Write Optimized DSO:

  1. Data is loaded directly into Active data table
  2. No Activation Process is required
  3. Data is first loaded into Activation Queue table
  4. One of the DSO

Answer : C

 
 
7) Types of DSOs

  1. Standard DSO
  2. Write-Optimized DSO
  3. Direct Update DSO
  4. all of the above

Answer : D

 
 
8) Types of Info Cubes

  1. Standard Infocube
  2. Real-Time InfoCube
  3. Virtual Provider InfoCube
  4. all of the above

Answer : D

 
 
9) Which of the following is used to extract data from source system into PSA system

  1. Infopackage
  2. Transformation
  3. DataTransfer process
  4. all of the above

Answer : A

 
 
10) Which of the following components of load process will automate the ETL process

  1. Process Chain
  2. Infopackage
  3. DataTransfer process
  4. all of the above

Answer : A

 
 
11) Which of the following types of datasources that can be created?

  1. Transaction Data
  2. Master Data attributes
  3. Master Data Texts
  4. all of the above

Answer : D

 
 
12) An infoSet is

  1. Only Logical definition
  2. Physical Storage of data
  3. Union Operator
  4. all of the above

Answer : A

 
 
13) Which of the following are InfoProviders

  1. MultiProviders
  2. InfoSets
  3. Virtual Providers
  4. all of the above

Answer : D

 
 
14) Which of the following is not true about BEX Analyzer

  1. One can run queries and perform adhoc analysis in an excel environment
  2. BEX Analyzer is interated with Excel by using an Excel Add-in
  3. Web Application
  4. Standalone application

Answer : C

 
 
15) Exceptions in Query Designer

  1. HighLight cells in query output if the value is beyond the threshold mentioned in the exception definition
  2. Can be used by Business Analysts to quickly focus on values that are highlighted in Query Output
  3. can accelerate Analysis Process
  4. all of the above

Answer : D

 
 
16) which of the following is not true about Conditions in BEX Query Designer

  1. allows to filter data
  2. doesn’t allow how the condition should be applied to query result
  3. allow to hide numbers that are not relevant
  4. allows to define multiple conditions for a query

Answer : B

 
 
17) Which of the following is not true about Filters in BEX Query Designer

  1. used to restrict the query execution to a specific dataset
  2. used to save the filter defined in one query as a resuable object that is available for all queries built on that infoprovider
  3. restrictions cant be applied on characterstics
  4. Saved Filters are used as selection Objects in SAP BW Metadata

Answer : C

 
 
18) Which of the following is a transparent PSA table that stores erroneous records

  1. ActiveTable
  2. Change Log
  3. error stack
  4. all of the above

Answer : C

 
 
19) Which one of the following is not true about Extended Star Schema

  1. Improved Version of Classic Star Schema
  2. System generated numeric values are stored in the dimension table
  3. Dimension Id is not system generated value for each unique combination of SID’s in Dimension table
  4. all of the above

Answer : C

 
 
20) Which of the following infoproviders store data

  1. MultiProviders
  2. InfoSets
  3. Virtualproviders
  4. Infocube

Answer : D

 
 
21) Which of the following cant be used as DataTarget

  1. InfoObjects with MasterData
  2. DSO’s
  3. Infocubes
  4. InfoSets

Answer : D

 
 
22) How many total dimensions are possible in a infocube?

  1. 12
  2. 11
  3. Ans) 16
  4. 15

Answer : C

 
 
23) Which of the following dimensions are already available when we create a infocube?

  1. time
  2. date
  3. unit
  4. all of the above

Answer : D

 
 
24) Which of the following is True about DSO?

  1. used to store consolidated and cleansed data
  2. stored in transparent, flat database tables
  3. describes a consolidated dataset from one or more InfoSources
  4. all of the above

Answer : D

 
 
25) ________  cube is a type of Infocube

  1. Ans) SAP Remote
  2. write optimized
  3. standard datastore object
  4. None of the above

Answer : A

 
 
26) ________ gets its data supply from API’s

  1. Standard DSO
  2. write optimized DSO
  3. Ans) direct Update DSO
  4. all of the above

Answer : C

 
 
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.

  1. only I
  2. Ans) both I and II are TRUE
  3. Only II
  4. none of the above

Answer : B

 
 
28) In standard DSO data is deleted from ________ table after the records have been activated

  1. Ans) Activation queue
  2. active data
  3. change log
  4. all of the above

Answer : A

 
 
29) Which of the following is True about line item Dimension?                                                                     I)  No other characteristics can be assigned to a dimension

  1. Ans) only I
  2. both I and II are TRUE
  3. Only II
  4. none of the above

Answer : A

 
 
30) Do not use SAP Remote Cubes if _____________

  1. Only a few users execute queries simultaneously on the database.
  2. The user only access a small amount of data from time to time
  3. Ans) A lot of users execute queries simultaneously
  4. The user need very up-to-date data from an SAP source system

Answer : C

 
 
31) In which of the following case(s) remote cubes are recommended?

  1. when only a few users execute queries simultaneously on the database
  2. The user need very up-to-date data from an SAP source system
  3. The user only access to a small amount of data from time to time
  4. all of the above

Answer : D

 
 
32) Which of the following is a type of  infoobject?

  1. Key Figure
  2. Characterstic
  3. Time characteristics
  4. all of the above

Answer : D

 
 
33) Request ID (0REQUID) is a example of __________ infoobject

  1. Time characteristics
  2. Unit
  3. Technical Characteristics
  4. key figure

Answer : C

 
 
34) Attribute table /BIO/Q<technical name of characteristics>       is generated for which of the following option?

  1. for SAP standard characteristics that have attributes which are time-dependent
  2. for SAP standard characteristics that have attributes which are NOT time-dependent
  3. for customer-defined characteristics that have attributes which are NOT time-dependent
  4. for customer-defined characteristics that have attributes which are time-dependent

Answer : A

 
 
35) Attribute table /BIC/P<technical name of characteristics>       is generated for which of the following option?

  1. for SAP standard characteristics that have attributes which are NOT time-dependent
  2. Ans) for customer-defined characteristics that have attributes which are NOT time-dependent
  3. for customer-defined characteristics that have attributes which are time-dependent
  4. for SAP standard characteristics that have attributes which are time-dependent

Answer : B

 
 
36) ______ fact table is optimized for data loading

  1. E table
  2. F table
  3. Both E table and F table
  4. none of the above

Answer : B

 
 
37) ______ fact table is optimized for data requests/retrieval

  1. E table
  2. F table
  3. Both E table and F table
  4. none of the above

Answer : A

 
 
38) Standard  cube can contain max of __________ key figures.

  1. 64
  2. 233
  3. 128
  4. 256

Answer : B

 
 
39) suppose  you have created a infoobject. In order to use the infobject what you need to do?

  1. save infoobject
  2. activate infoobject
  3. infoobects are activated automatically
  4. store infoobject in to infoarea

Answer : B

 
 
40) DTP can be used to load data from

  1. DSO to DSO
  2. cube to cube
  3. DSO to cube
  4. all of the above

Answer : D

 
 
41) which of the following is suitable to store transactional data ?

  1. cube
  2. DSO
  3. both
  4. none of the above

Answer : B

 
 
42) Amount(0AMOUNT) is a example of __________ infoobject

  1. Key Figure
  2. Characterstic
  3. Time characteristics
  4. unit

Answer : A

 
 
43) Long text can store up to

  1. 30 characters
  2. 40 characters
  3. 60 characters
  4. 45 characters

Answer : C

 
 
44) Business Explorer(BEx) Tab in maintainance menu of infoobject provides all the options to

  1. set the display defaults in the Business Explorer (BEx).
  2. to determine whether or not the characteristic is to appear as a textual description or as a key in BEx by default
  3. both the options are correct
  4. none of the above

Answer : C

 
 
45) Report to Report  Interface can  provide which of the following:

  1. Additional features to perform detailed level of analysis of data
  2. Enable analyst to jump to detailed information on selected value of report
  3. Different types of jump targets can be assigned to BEX query to make the analysis more flexible
  4. all of the above

Answer : D

 
 
46) Which of the following technical tables are  generated for FACT table on activation of an InfoCube ?

  1. F table
  2. E Table
  3. Both F table and E table
  4. none of the above

Answer : C

 
 
47) Business evaluations objects such as customer, product , revenue are called _________

  1. Info cube
  2. Info objects
  3. Info providers
  4. all of the above

Answer : B

 
 
48) In which catalog we create info objects like customer , product , employee?

  1. Key figure
  2. characteristics
  3. both key figure and characteristics
  4. none of the above

Answer : B

 
 
49) we can create infoarea inside another infoarea?

  1. TRUE
  2. FALSE

Answer : A

 
 
50) Transaction code to open the process chain is ______________

  1. RSA1
  2. RSPC
  3. RSA32
  4. none of the above

Answer : B

 
 
51) Transaction code to open the workbench is ______________

  1. RSA1
  2. RSPC
  3. RSA32
  4. none of the above

Answer : A

 
 
52) Which of the following is/are examples of key figure  infoobjects                                                                     a.  product                                                                              b.  revenue

  1. a & b
  2. a & c
  3. b & d
  4. all of the above

Answer : C

 
 
53) Which of the following is/are examples of characteristics infoobjects                                                                     a.  product

  1. a , c & d
  2. a & c only
  3. c & d only
  4. all of the above

Answer : A

 
 
54) Why do we need to normalise a data model?

  1. to make it look good
  2. to avoid redundancy
  3. to improve performance
  4. all of the above

Answer : B

 
 
55) We can create multiple aggregates against the same infocube ?

  1. TRUE
  2. FALSE

Answer : A

 
 
56) Dimension tables contain:

  1. Dim Key
  2. SID’s
  3. both Dim keys and SID’s
  4. none of the above

Answer : C

 
 
57) ___________is a flat structure with no extended star schema concept and which will have granular data

  1. DSO
  2. InfoCube
  3. both
  4. none of the above

Answer : A

 
 
58) to load the data from external file(.csv) to PSA we should run ____________

  1. DTP
  2. Infopackage
  3. both
  4. none of the above

Answer : B

 
 
59) to load the data from PSA  to Data Target we should run ____________

  1. DTP
  2. Infopackage
  3. both
  4. none of the above

Answer : A

 
 
60) What is the procedure to load the data to data target?

  1. Full load
  2. Delta Load
  3. Both Full load and delta
  4. none of the above

Answer : C

 
 
61) Which of the following option is/are TRUE about infocube?

  1. after compactions in Infocube data is loaded to E table and deleted from F table
  2. individual requests cannot be deleted after compaction
  3. compaction improves the retrieval performance
  4. all of the above

Answer : D

 
 
62) Which DSO is suitable for Layer1( A tier)?

  1. Direct update DSO
  2. Write optimized DSO
  3. Standard DSO
  4. all of the above

Answer : B

 
 
63) __________ join (join operation)  the information from two or more infoproviders

  1. MultiProviders
  2. Infosets
  3. Infocubes
  4. all of the above

Answer : B

 
 
64) __________ union (union operation)  the information from two or more infoproviders

  1. MultiProviders
  2. Infosets
  3. Infocubes
  4. all of the above

Answer : A