Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Wneedham
W
Wneedham
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,126
| Attempts: 1,126 | Questions: 26
Please wait...
Question 1 / 26
0 %
0/100
Score 0/100
1. When creating an InfoSet from several characteristics, you can map transitive attributes and use these to report on master data

Explanation

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.

Submit
Please wait...
About This Quiz
SAP Quizzes & Trivia

This SAP BI Quiz, focusing on TBW42 Part 2, assesses knowledge on Info Cubes, including their activation, optimization, and technical table generation. Ideal for learners aiming to master SAP BI's data handling and optimization features.

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. A MultiProvider can be made up of various combinations of the following InfoProviders: InfoCube, DataStore object, InfoObject, InfoSet, VirtualProvider, and aggregation level.

Explanation

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.

Submit
3. On activation of info Cubes the "D" table (/BIC/D...) is generated for each Dimension 

Explanation

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.

Submit
4. 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.

Explanation

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.

Submit
5. Regarding Info Cubes : The F Table is optimized for loading data and the E table is optimized for data Requests

Explanation

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.

Submit
6. 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 

Explanation

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.

Submit
7. The MultiProvider also optimizes read access since _________ subqueries are executed on every InfoProvider involved in the MultiProvider.

Explanation

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.

Submit
8. Do not use more than one InfoCube with non-cumulative key figures in a MultiProvider, otherwise the numbers in the query may be incorrect.

Explanation

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.

Submit
9. On activation of an Info Cube the how many technical tables are generated for the fact table

Explanation

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.

Submit
10. Parallel processing is not possible with InfoSets.

Explanation

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.

Submit
11. Since MultiProviders do not save any data, performance aspects do not affect the way dimensions of the MultiProvider are modeled.

Explanation

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.

Submit
12. What is the Maximum amount of infocubes permitted in an Infoset?

Explanation

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.

Submit
13. The setting _________ is used to change the method for dimention indexing in Oracle DB Only

Explanation

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.

Submit
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.

Explanation

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.

Submit
15. Wich of the following are joins supported by InfoSets

Explanation

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.

Submit
16. You can include the __________ characteristic in the query selection criteria and specify the basic InfoProvider against which the query is executed.

Explanation

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.

Submit
17. Within an InfoSet, it is possible to access BI accelerator indexes.

Explanation

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.

Submit
18. Infosets can be based on which of the following Info providers.

Explanation

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.

Submit
19. 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.

Explanation

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.

Submit
20. The term qualok refers to

Explanation

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.

Submit
21. The dimension tables contains the data for each Characteristic with a DIM ID as the primary key of the Table

Explanation

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.

Submit
22. For InfoSets it is possible to define an InfoCube as a right operand of a left outer join.

Explanation

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.

Submit
23. Which of the following is not yet possible to remodel

Explanation

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.

Submit
24. 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.

Explanation

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.

Submit
25. In a ________ all descriptive attributes are located in other dimensions

Explanation

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.

Submit
26. You cannot use the remodeling toolbox if:

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.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 26, 2010
    Quiz Created by
    Wneedham
Cancel
  • All
    All (26)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
When creating an InfoSet from several characteristics, you can map...
A MultiProvider can be made up of various combinations of the...
On activation of info Cubes the "D" table (/BIC/D...) is...
A dimension for the valid time interval (VALIDTIMEINTERVAL) exists for...
Regarding Info Cubes : The F Table is optimized for loading data and...
Characteristics with an N:M relationship can be combined in the...
The MultiProvider also optimizes read access since _________...
Do not use more than one InfoCube with non-cumulative key figures in a...
On activation of an Info Cube the how many technical tables are...
Parallel processing is not possible with InfoSets.
Since MultiProviders do not save any data, performance aspects do not...
What is the Maximum amount of infocubes permitted in an Infoset?
The setting _________ is used to change the method for dimention...
The tools of the OLAP for performance optimization (such as caching...
Wich of the following are joins supported by InfoSets
You can include the __________ characteristic in the query...
Within an InfoSet, it is possible to access BI accelerator indexes.
Infosets can be based on which of the following Info providers.
The MultiProvider does not contain any data itself. Its data comes...
The term qualok refers to
The dimension tables contains the data for each Characteristic with a...
For InfoSets it is possible to define an InfoCube as a right...
Which of the following is not yet possible to remodel
In remodeling, you can use a customer exit to fill added or replaced...
In a ________ all descriptive attributes are located in other...
You cannot use the remodeling toolbox if:
Alert!

Advertisement