SAP Bi Quiz (Tbw42 Part 2)
Quiz for TBW42 Part 2 unit 4
Questions and Answers
- 1.
On activation of an Info Cube the how many technical tables are generated for the fact table
- A.
1
- B.
2
- C.
3
- D.
4
- E.
None
Correct Answer
B. 2Explanation
When an Info Cube is activated, two technical tables are generated for the fact table. These technical tables are used to store and manage the data in the Info Cube. The fact table contains the actual data values for the measures and key figures in the Info Cube. The two technical tables are necessary to efficiently store and process the data in the Info Cube.Rate this question:
-
- 2.
Regarding Info Cubes : The F Table is optimized for loading data and the E table is optimized for data Requests
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true. In SAP BW, an InfoCube is a data storage structure that holds data for reporting purposes. The F Table, also known as the Fact Table, is optimized for loading data into the InfoCube. It stores the actual data values along with key figures and dimensions. On the other hand, the E Table, also known as the Extended Table, is optimized for data requests. It contains aggregated data that is pre-calculated and summarized for faster retrieval during reporting. Therefore, the F Table is designed for efficient data loading, while the E Table is designed for efficient data retrieval.Rate this question:
-
- 3.
On activation of info Cubes the "D" table (/BIC/D...) is generated for each Dimension
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When info Cubes are activated, a table called "D" is generated for each dimension. This table is used to store the dimension data associated with the info Cube. Therefore, the statement "On activation of info Cubes the 'D' table is generated for each dimension" is true.Rate this question:
-
- 4.
The dimension tables contains the data for each Characteristic with a DIM ID as the primary key of the Table
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The explanation for the given correct answer, which is False, is that dimension tables do not necessarily need to have a DIM ID as the primary key. While it is common for dimension tables to have a primary key, it can be any other suitable attribute or combination of attributes that uniquely identifies each row in the table. The primary key could be a natural key, such as a customer ID or a product code, or it could be a surrogate key generated specifically for the dimension table. Therefore, the statement that all dimension tables have a DIM ID as the primary key is incorrect.Rate this question:
-
- 5.
In a ________ all descriptive attributes are located in other dimensions
- A.
Degenerated Dimension
- B.
Optimized Dimension
- C.
Line item Dimension
- D.
Non-Attribute Dimension
Correct Answer(s)
A. Degenerated Dimension
C. Line item DimensionExplanation
A degenerated dimension is a dimension that is created from a fact table's attribute, such as an order number or transaction ID. In this case, all descriptive attributes are located in other dimensions, and the degenerated dimension only contains a single attribute. A line item dimension, on the other hand, is used to store details about individual line items in a transaction, such as product name, quantity, and price. Therefore, the correct answer is Degenerated Dimension, Line item Dimension.Rate this question:
-
- 6.
The setting _________ is used to change the method for dimention indexing in Oracle DB Only
- A.
Optimized Indexing
- B.
Low Indexing
- C.
High Cardinality
Correct Answer
C. High CardinalityExplanation
High Cardinality is the correct answer because it refers to a setting used to change the method for dimension indexing in Oracle DB Only. High Cardinality indexing is used when the dimension contains a large number of distinct values, allowing for more efficient indexing and query performance. This setting is particularly useful in scenarios where the dimension has a high level of uniqueness and variability in its values.Rate this question:
-
- 7.
Characteristics with an N:M relationship can be combined in the same dimension if the Maximum number of records are clearly defined and the Cartesian product of the Characteristic results only in a small dimension table
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Characteristics with an N:M relationship can be combined in the same dimension if the maximum number of records are clearly defined and the Cartesian product of the characteristic results only in a small dimension table. This means that if the number of records is limited and the resulting dimension table is not too large, it is possible to combine the characteristics. This allows for more efficient and organized data representation, making it easier to analyze and interpret the information.Rate this question:
-
- 8.
The MultiProvider does not contain any data itself. Its data comes exclusively from the InfoProviders on which it is based, which are grouped together in a join operation.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The MultiProvider does not contain any data itself, but rather acts as a virtual InfoProvider that combines data from multiple InfoProviders. It does not perform a join operation to retrieve data from the underlying InfoProviders. Instead, it uses a union operation to aggregate data from the different InfoProviders. Therefore, the statement that the data in a MultiProvider comes exclusively from the InfoProviders on which it is based is false.Rate this question:
-
- 9.
A MultiProvider can be made up of various combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A MultiProvider is a type of InfoProvider in SAP BW that allows combining data from different InfoProviders such as InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level. This allows users to create a single unified view of data from multiple sources, enabling more comprehensive reporting and analysis. Therefore, the given statement is true.Rate this question:
-
- 10.
Since MultiProviders do not save any data, performance aspects do not affect the way dimensions of the MultiProvider are modeled.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because MultiProviders in SAP BW do not store any data themselves. They are virtual objects that combine data from different InfoProviders. As a result, the modeling of dimensions in a MultiProvider does not have any impact on performance since the data is not stored within the MultiProvider itself. The performance aspects are instead determined by the underlying InfoProviders that contain the actual data.Rate this question:
-
- 11.
The MultiProvider also optimizes read access since _________ subqueries are executed on every InfoProvider involved in the MultiProvider.
- A.
Optimized
- B.
Parallel
- C.
Smaller
Correct Answer
B. ParallelExplanation
The MultiProvider optimizes read access by executing parallel subqueries on every InfoProvider involved. This means that instead of sequentially accessing each InfoProvider, the MultiProvider can simultaneously access multiple InfoProviders, improving the efficiency and speed of the read operations.Rate this question:
-
- 12.
You can include the __________ characteristic in the query selection criteria and specify the basic InfoProvider against which the query is executed.
- A.
0SOURCE
- B.
0INFOPROVIDER
- C.
0INFOPROV
- D.
0SUBSET
Correct Answer
C. 0INFOPROVExplanation
In a query, you can include the "INFOPROV" characteristic in the query selection criteria to specify the basic InfoProvider against which the query is executed. This allows you to filter the data based on the specific InfoProvider you want to retrieve information from.Rate this question:
-
- 13.
Do not use more than one InfoCube with non-cumulative key figures in a MultiProvider, otherwise the numbers in the query may be incorrect.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Using multiple InfoCubes with non-cumulative key figures in a MultiProvider can lead to incorrect numbers in the query. This is because non-cumulative key figures do not aggregate correctly across multiple InfoCubes. Therefore, it is recommended to avoid using more than one InfoCube with non-cumulative key figures in a MultiProvider to ensure accurate results in the query.Rate this question:
-
- 14.
The tools of the OLAP for performance optimization (such as caching and aggregation) can be used for a MultiProvider even if the InfoProviders involved does not support these tools.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because the tools of OLAP for performance optimization, such as caching and aggregation, cannot be used for a MultiProvider if the InfoProviders involved do not support these tools. In order to utilize these tools, the InfoProviders must have the necessary capabilities and functionality.Rate this question:
-
- 15.
Parallel processing is not possible with InfoSets.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
InfoSets are a feature in SAP BW (Business Warehouse) that allow for data extraction and reporting. However, InfoSets do not support parallel processing. Parallel processing refers to the ability to execute multiple tasks simultaneously, which can improve performance and efficiency. Since InfoSets do not have this capability, the statement that parallel processing is not possible with InfoSets is true.Rate this question:
-
- 16.
Infosets can be based on which of the following Info providers.
- A.
Data Store Object
- B.
Master data Charateristics
- C.
Multiprovidors
- D.
Infosource
- E.
Infocubes
Correct Answer(s)
A. Data Store Object
B. Master data Charateristics
E. InfocubesExplanation
Infosets can be based on Data Store Objects, Master Data Characteristics, and Infocubes. Infosets are virtual InfoProviders that allow users to combine data from different sources and create a unified view for reporting and analysis. Data Store Objects store detailed data at a granular level, Master Data Characteristics provide information about key attributes, and Infocubes store aggregated data for reporting purposes. By including these three InfoProviders, users can create comprehensive and meaningful Infosets that meet their reporting requirements.Rate this question:
-
- 17.
Wich of the following are joins supported by InfoSets
- A.
Temporal Join
- B.
Union
- C.
Inner join
- D.
Outer join
- E.
Key join
Correct Answer(s)
A. Temporal Join
C. Inner join
D. Outer joinExplanation
InfoSets are used in SAP systems to define data sources for reporting purposes. They provide a way to combine data from different tables or views. Temporal Join, Inner Join, and Outer Join are all types of joins supported by InfoSets.
A Temporal Join is used to join tables based on a time period, allowing for analysis of historical data.
An Inner Join combines records from two tables based on a matching condition, resulting in only the matching records being included in the result set.
An Outer Join includes all records from one table and the matching records from another table, even if there is no match.
Key Join is not supported by InfoSets and therefore not included in the correct answer.Rate this question:
-
- 18.
When creating an InfoSet from several characteristics, you can map transitive attributes and use these to report on master data
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When creating an InfoSet from several characteristics, it is possible to map transitive attributes. These transitive attributes can be used to report on master data. This means that the InfoSet can include additional attributes that are derived from the original characteristics, allowing for more comprehensive reporting and analysis. Therefore, the statement "When creating an InfoSet from several characteristics, you can map transitive attributes and use these to report on master data" is true.Rate this question:
-
- 19.
A dimension for the valid time interval (VALIDTIMEINTERVAL) exists for each InfoSet that represents a temporal join. This is only visible in the Query Designer and only used for the time selection.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given statement is true. In the Query Designer, a dimension called VALIDTIMEINTERVAL exists for each InfoSet that represents a temporal join. This dimension is used for time selection and is only visible in the Query Designer.Rate this question:
-
- 20.
The term qualok refers to
- A.
Quantity correct
- B.
Quantity Unit conversion ok
- C.
Qualitatively correct
- D.
Quality of data model is correct/ok
Correct Answer
C. Qualitatively correctExplanation
The term "qualok" refers to something being qualitatively correct, meaning that it is correct in terms of quality or characteristics. This suggests that the answer is not focusing on quantity or unit conversion, but rather on the overall quality or accuracy of something.Rate this question:
-
- 21.
Within an InfoSet, it is possible to access BI accelerator indexes.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Within an InfoSet, it is not possible to access BI accelerator indexes. BI accelerator indexes are used to improve the performance of queries in SAP Business Warehouse (BW) systems, but they are not available within InfoSets. Therefore, the correct answer is False.Rate this question:
-
- 22.
For InfoSets it is possible to define an InfoCube as a right operand of a left outer join.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
It is not possible to define an InfoCube as a right operand of a left outer join. In SAP BW, an InfoCube is a multi-dimensional data structure that stores consolidated and aggregated data for reporting and analysis. It cannot be used as a right operand in a join operation as it does not have the necessary characteristics and structure for joining with other tables or cubes.Rate this question:
-
- 23.
What is the Maximum amount of infocubes permitted in an Infoset?
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
B. 2Explanation
The maximum amount of infocubes permitted in an Infoset is 2. This means that an Infoset can contain up to 2 infocubes, which are used for storing and analyzing data in SAP Business Warehouse (BW). Having a limit on the number of infocubes helps to organize and manage data effectively within the Infoset, preventing it from becoming too complex or overwhelming.Rate this question:
-
- 24.
Which of the following is not yet possible to remodel
- A.
InfoCubes
- B.
InfoObjects
- C.
DataStore objects
Correct Answer(s)
B. InfoObjects
C. DataStore objectsExplanation
The question asks which of the given options is not yet possible to remodel. The correct answer is "InfoObjects, DataStore objects." This means that InfoObjects and DataStore objects can be remodeled, while InfoCubes can be remodeled.Rate this question:
-
- 25.
In remodeling, you can use a customer exit to fill added or replaced characteristics and key figures with initial values. The interface _______ Should be used in such a case.
- A.
IF_RSCNV_EXIT
- B.
IF_RSCUST_EXIT
- C.
IF_REMOD_CUST_EXIT
- D.
IF_REMODEL
Correct Answer
A. IF_RSCNV_EXITExplanation
In remodeling, when you want to fill added or replaced characteristics and key figures with initial values, you should use the interface IF_RSCNV_EXIT. This interface allows you to customize the behavior of the remodeling process and define the initial values for the characteristics and key figures. It provides the necessary methods and functionality to implement this customization.Rate this question:
-
- 26.
You cannot use the remodeling toolbox if:
- A.
You want to use more than one characteristic in line item dimensions.
- B.
You want to completely remove an existing dimension from an InfoCube or create a new dimension.
- C.
Replace exsisting charateristics
- D.
Delete key figures
- E.
You want to change the granularity of the fact table for your InfoCube by adding or deleting characteristics.
Correct Answer(s)
A. You want to use more than one characteristic in line item dimensions.
B. You want to completely remove an existing dimension from an InfoCube or create a new dimension.
E. You want to change the granularity of the fact table for your InfoCube by adding or deleting characteristics.Explanation
The remodeling toolbox cannot be used if you want to use more than one characteristic in line item dimensions, if you want to completely remove an existing dimension from an InfoCube or create a new dimension, or if you want to change the granularity of the fact table for your InfoCube by adding or deleting characteristics.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 26, 2010Quiz Created by
Wneedham
SAP Material Management (ERP Certification) Prep Test
SAP Material Management (ERP Certification) Prep Test
SAP S/4HANA ERP (1709, 1809, and 1909) Certification Exam Prep Test
SAP S/4HANA ERP (1709, 1809, and 1909) Certification Exam Prep Test
Back to top