SAP Bo - Objective
Questions and Answers
- 1.
Custom Hierarchies are defined in a universe in order :-
- A.
To facilitate custom drill down between objects from same or different classes
- B.
They can be created from Tools -> Hierarchies in the BO Designer
- C.
To prevent Fan Trap
- D.
None of the Above
Correct Answer(s)
A. To facilitate custom drill down between objects from same or different classes
B. They can be created from Tools -> Hierarchies in the BO DesignerExplanation
Custom Hierarchies are defined in a universe in order to facilitate custom drill down between objects from same or different classes. They can be created from Tools -> Hierarchies in the BO Designer. This allows users to navigate through different levels of data in a structured manner, enabling them to analyze and explore data in a more detailed and organized way. By creating custom hierarchies, users can easily drill down and analyze data at different levels of granularity, helping them gain deeper insights and make more informed decisions.Rate this question:
-
- 2.
What all statements below are true about contexts ?
- A.
Contexts may be created using detect contexts feature or manually
- B.
For a universe contexts should be created in a way that all joins(except shortcut joins) do not fall in the same context
- C.
When objects from two or more contexts are used, separate SQL is generated and results are then merged in a micro cube.
- D.
Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.
Correct Answer(s)
A. Contexts may be created using detect contexts feature or manually
C. When objects from two or more contexts are used, separate SQL is generated and results are then merged in a micro cube.
D. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.Explanation
Contexts can be created either using the detect contexts feature or manually. When objects from multiple contexts are used, separate SQL is generated and the results are merged in a micro cube. Additionally, any objects created on a table column that belong to specific contexts are naturally compatible with all other objects from the same contexts.Rate this question:
-
- 3.
A chasm trap can be solved using 2 methods , they are :-
- A.
In the universe SQL parameters, the option, generate multiple queries for each measure needs to be selected. This will generate separate SQL statement for each measure and give the correct results.
- B.
A better approach is to put the two joins in two different contexts. This will generate two synchronized queries, thus solving the problem
- C.
Linked Universe
- D.
None of the Above
Correct Answer(s)
A. In the universe SQL parameters, the option, generate multiple queries for each measure needs to be selected. This will generate separate SQL statement for each measure and give the correct results.
B. A better approach is to put the two joins in two different contexts. This will generate two synchronized queries, thus solving the problemExplanation
The correct answer suggests two methods to solve a chasm trap. The first method is to select the option "generate multiple queries for each measure" in the universe SQL parameters. This will generate separate SQL statements for each measure, resulting in correct results. The second method is to put the two joins in two different contexts. This approach will generate two synchronized queries, effectively solving the problem of the chasm trap.Rate this question:
-
- 4.
A fan trap is solved by creating an alias of the 2nd table and defining contexts such that, the normal table is joined only with the first table, while the alias is joined with both the 1st and the 3rd table. We would take 2nd table’s measure only from the normal table and other dimensions of the 2nd table from the alias table
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
This statement is true because a fan trap is a situation in a database where multiple paths exist between two tables, causing data duplication and incorrect results. To solve a fan trap, an alias of the second table is created and joined with both the first and third tables. This allows for the correct association of dimensions and measures from the second table, ensuring accurate results. The alias table is used for dimensions from the second table, while the normal table is used for measures from the second table.Rate this question:
-
- 5.
Aggregate awareness function is used in scenarios :-
- A.
Where we have same fact tables in different grains
- B.
Where we have same fact tables in same grains
- C.
Where we have different fact tables in same grains
- D.
Where we have different fact tables in different grains
Correct Answer
A. Where we have same fact tables in different grainsExplanation
The correct answer is where we have same fact tables in different grains. In this scenario, the aggregate awareness function is used to optimize query performance by selecting the appropriate level of aggregation based on the grain of the data. By using the same fact tables but at different levels of granularity, the function can determine which level of aggregation to use for a given query, improving the efficiency of the query execution.Rate this question:
-
- 6.
Using Aggregate awareness function we can define only one object for the measures in the fact tables as @aggregate_aware(highest_level,lower level)
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the aggregate awareness function allows us to define only one object for the measures in the fact tables. This function helps optimize queries by selecting the appropriate level of aggregation based on the query conditions. By specifying the highest and lowest levels of aggregation, we can ensure that the function selects the most appropriate level for the query. Therefore, the correct answer is true.Rate this question:
-
- 7.
A derived table is a table :-
- A.
Created in the universe using an SQL Query from database level
- B.
Created in the database using an SQL Query from database level
- C.
Created in the universe using an SQL Query from table level
- D.
Created in the universe using an SQL Query from report level
Correct Answer
A. Created in the universe using an SQL Query from database levelExplanation
A derived table is created in the universe using an SQL Query from the database level. This means that the table is not physically stored in the database, but rather it is created on the fly using a query that is executed against the database. The derived table is then available for use within the universe and can be used in queries and reports.Rate this question:
-
- 8.
A derived table cannot be used for complex calculations, which are difficult to achieve in report level.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A derived table can be used for complex calculations that are difficult to achieve at the report level. Derived tables are created within the query itself and can perform calculations, join multiple tables, or filter data before being used in the main query. This allows for more complex calculations to be performed and simplifies the reporting process. Therefore, the statement that a derived table cannot be used for complex calculations is false.Rate this question:
-
- 9.
Index awareness is a property of the :-
- A.
Universe
- B.
Database
- C.
Table
- D.
None of the Above
Correct Answer
A. UniverseExplanation
Index awareness is a property of the Universe. This means that the Universe is capable of utilizing indexes to improve query performance. Indexes are data structures that allow for faster retrieval of data from a database. By being index aware, the Universe can take advantage of these indexes to optimize queries and improve overall performance.Rate this question:
-
- 10.
Index awareness is a property , by means of which values in the filter conditions of the queries/data providers , are substituted by their corresponding indexes or surrogate keys.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Index awareness is a feature that allows the values in filter conditions of queries or data providers to be replaced with their corresponding indexes or surrogate keys. This means that instead of using the actual values, the queries or data providers can use the indexes or surrogate keys to retrieve the desired data. This can improve the performance of the queries or data retrieval operations, as accessing data through indexes is typically faster than using the actual values. Therefore, the given statement is true.Rate this question:
-
- 11.
A condition object is a filter condition created in the :-
- A.
Universe Level
- B.
Database Level
- C.
Report
- D.
Table
Correct Answer
A. Universe LevelExplanation
A condition object is created in the Universe Level. In a business intelligence system, a universe acts as a semantic layer between the database and the end user. It defines the structure and relationships of the data, allowing users to query and analyze the data without needing to understand the underlying database schema. Conditions are used in the universe to filter the data based on specific criteria, such as date ranges or product categories. By creating a condition object at the Universe Level, it can be applied to multiple reports and queries, ensuring consistent filtering across the system.Rate this question:
-
- 12.
When condition object is dragged in the Query Panel, the filter condition appears in the query SQL.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When a condition object is dragged in the Query Panel, the filter condition is automatically added to the query SQL. This means that the query will only retrieve data that meets the specified condition. Therefore, the statement "True" is correct.Rate this question:
-
- 13.
A query filter exists in the __________ only
- A.
Universe
- B.
Database
- C.
Report
- D.
Table
Correct Answer
C. ReportExplanation
A query filter exists in the report only. This means that when querying data, the filter can be applied specifically within the report to narrow down the results. It is not available in the universe, database, or table, indicating that the filtering capability is limited to the report itself.Rate this question:
-
- 14.
A query filter is added during building a query. This does not appear in the query SQL
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
During the process of building a query, a query filter is added to specify the criteria for retrieving data. This filter is an essential component of the query and is included in the query SQL. Therefore, the statement "A query filter is added during building a query. This does not appear in the query SQL" is incorrect. The correct answer is False.Rate this question:
-
- 15.
Linked universe are universes which share common component such as :-
- A.
Objects
- B.
Classes
- C.
Joins
- D.
None of the above
Correct Answer(s)
A. Objects
B. Classes
C. JoinsExplanation
Linked universes are universes that have a common component, such as objects, classes, and joins. This means that these universes are connected and can share data and information through these shared components. By having common objects, classes, and joins, it allows for easier integration and analysis of data across multiple universes.Rate this question:
-
- 16.
When two universes are linked, the source universe is called core universe while the destination is called derived universe.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The explanation for the given correct answer is that when two universes are linked, one universe serves as the source or core universe, while the other universe is the destination or derived universe. This implies that there is a connection or relationship between the two universes, with one being the original or primary universe and the other being derived or created from the source universe.Rate this question:
-
- 17.
Input Control
- A.
Allows filtering of data based on a dimension in the report.
- B.
Allows filtering of data based on a column in the report.
- C.
Allows filtering of data based on a row in the report.
- D.
None of the Above
Correct Answer
A. Allows filtering of data based on a dimension in the report.Explanation
The correct answer is "allows filtering of data based on a dimension in the report." This is because an input control is a feature in reporting tools that allows users to filter data based on specific dimensions or attributes. By selecting a dimension, users can narrow down the data displayed in the report to focus on specific criteria or categories. This helps in analyzing and understanding the data more effectively.Rate this question:
-
- 18.
Input control does not allow multiselection of values which a report filter does support
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because the input control does allow multiselection of values, which means that a user can select multiple values from a list. However, a report filter also supports multiselection of values, so both the input control and report filter can support this functionality. Therefore, the statement is incorrect.Rate this question:
-
- 19.
Suppose we have a hierarchy defined in 3 levels, but if we set the scope of analysis is set to 2 levels, the report will be able to drill down to the 3rd level overriding the scope of analysis.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
If the scope of analysis is set to 2 levels, the report will only be able to drill down to the 2nd level and will not be able to override the scope to reach the 3rd level. Therefore, the statement is false.Rate this question:
-
- 20.
If the analysis level is set to custom, the objects from existing hierarchies can be dragged in the scope of analysis panel to set the scope for drilldown in the report.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When the analysis level is set to custom, it allows users to manually select specific objects from existing hierarchies and drag them into the scope of analysis panel. This enables users to define the scope for drilldown in the report, focusing on the specific data they want to analyze in more detail. Therefore, the given statement that "If the analysis level is set to custom, the objects from existing hierarchies can be dragged in the scope of analysis panel to set the scope for drilldown in the report" is true.Rate this question:
-
- 21.
Query Filter should be used
- A.
In report having multiple tabs having different objects requiring same or different filter conditions
- B.
In report having single tab having different objects requiring same or different filter conditions
- C.
In report having multiple tabs having same object requiring same or different filter conditions
- D.
None of the Above
Correct Answer
A. In report having multiple tabs having different objects requiring same or different filter conditionsExplanation
The query filter should be used in a report that has multiple tabs with different objects requiring the same or different filter conditions. This is because the query filter allows you to apply specific filter conditions to each tab, ensuring that the data displayed is relevant and accurate for each object. By using the query filter, you can customize the filter conditions for each tab based on the specific requirements of the objects on that tab.Rate this question:
-
- 22.
In case where there are multiple tabs having same objects, but with slightly differing filter conditions, it is advisable to fetch the whole data in the query and then apply report filters to the various tabs to get the desired data instead of using separate queries for each tab.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When there are multiple tabs with similar objects but different filter conditions, it is recommended to retrieve all the data in the query and then apply report filters to each tab. This approach eliminates the need for separate queries for each tab, which can be time-consuming and inefficient. By fetching the whole data and applying filters, it ensures that the desired data is obtained accurately for each tab. Therefore, the statement is true.Rate this question:
-
- 23.
Input context consists of
- A.
Any dimension objects that need to be included directly in the calculation itself.
- B.
Any dimension objects that need to be included indirectly in the calculation itself.
- C.
Any table objects that need to be included directly in the calculation itself.
- D.
None of the Above
Correct Answer
A. Any dimension objects that need to be included directly in the calculation itself.Explanation
The correct answer is "any dimension objects that need to be included directly in the calculation itself." This means that the input context should consist of dimension objects that are directly involved in the calculation process. These dimension objects could be variables, parameters, or any other elements that are necessary for performing the calculation accurately. It is important to include these dimension objects in the input context to ensure that the calculation is carried out correctly and produces the desired result.Rate this question:
-
- 24.
Output context consists of one or more table objects that determine the aggregation level at which the calculation is displayed
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because the output context does not consist of table objects. The output context refers to the filters or conditions that determine which data is included in the calculation. Table objects, on the other hand, are used to display the calculation results in a tabular format.Rate this question:
-
- 25.
To display the total sum of a measure in row level of the report block , we have to use the expression
- A.
Add(Measure In Report)
- B.
Total(Measure In Report)
- C.
Sum(Measure In Report)
- D.
TotalSum(Measure In Report)
Correct Answer
C. Sum(Measure In Report)Explanation
The correct answer is "Sum(Measure In Report)". This expression is used to calculate the total sum of a measure in the row level of a report block. It adds up all the values of the measure in each row and displays the total sum.Rate this question:
-
- 26.
Which selector gives the option of multiple selection in Xcelcius Dashboard? How do we make the multiple selection?
- A.
DropDown List Builder
- B.
List Builder
- C.
Multiple selector
- D.
None of the Above
Correct Answer
B. List BuilderExplanation
The correct answer is List Builder. The List Builder selector in Xcelcius Dashboard allows for multiple selection. To make multiple selections, users can simply hold down the Ctrl key while clicking on the desired options in the list.Rate this question:
-
- 27.
Which Xcelcius components can we use for linking multiple dashboard flash outputs(swf files)?
- A.
Swf Loader
- B.
Slideshow
- C.
Swf displayer
- D.
Swf Link
Correct Answer(s)
A. Swf Loader
B. SlideshowExplanation
The Xcelcius components that can be used for linking multiple dashboard flash outputs (swf files) are Swf Loader and Slideshow. Swf Loader allows loading and displaying external swf files within the dashboard, while Slideshow enables the creation of a slideshow by linking multiple swf files together. Swf displayer and Swf Link are not mentioned as available components for this purpose.Rate this question:
-
- 28.
The Xcelcius component ‘Slideshow’ is the only feasible option for a complete presentation
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement suggests that the Xcelcius component "Slideshow" is the most suitable option for creating a comprehensive presentation. This implies that other components might not offer the same level of functionality or features as the Slideshow component. Therefore, the answer is true, indicating that the Slideshow component is indeed the only feasible option for a complete presentation.Rate this question:
-
- 29.
What are the ways in which an Xcelcius dashboard can access data from a BO universe
- A.
Query as a Web Service
- B.
Business Intelligence Web Service
- C.
LiveOffice
- D.
None of the Above
Correct Answer(s)
A. Query as a Web Service
B. Business Intelligence Web Service
C. LiveOfficeExplanation
Xcelcius dashboard can access data from a BO universe through three ways: Query as a Web Service, Business Intelligence Web Service, and LiveOffice. Query as a Web Service allows the dashboard to retrieve data by sending queries to a web service. Business Intelligence Web Service enables the dashboard to access data through a web service that provides business intelligence functionality. LiveOffice allows the dashboard to integrate data from various sources including BO universe. Therefore, the correct answer is Query as a Web Service, Business Intelligence Web Service, and LiveOffice.Rate this question:
-
- 30.
What are the types of business objects repository domain?
- A.
The security domain
- B.
The universe domain
- C.
The document domain
- D.
The Report Domain
Correct Answer(s)
A. The security domain
B. The universe domain
C. The document domainExplanation
The types of business objects repository domain include the security domain, the universe domain, and the document domain. The security domain refers to the management of user access and permissions within the repository. The universe domain is responsible for defining the structure and relationships of the data in the repository. The document domain involves storing and managing documents within the repository. These domains are essential for organizing and managing business objects effectively.Rate this question:
-
- 31.
What are the types of dimensions?
- A.
Informational Dimension
- B.
Structural Dimension
- C.
Categorical Dimension
- D.
Partitioning Dimension
Correct Answer(s)
A. Informational Dimension
B. Structural Dimension
C. Categorical Dimension
D. Partitioning DimensionExplanation
The types of dimensions are informational, structural, categorical, and partitioning. Informational dimension refers to the data that provides additional context or details about the main data. Structural dimension represents the hierarchical structure or relationships within the data. Categorical dimension categorizes the data into distinct groups or categories. Partitioning dimension divides the data into subsets or partitions based on specific criteria.Rate this question:
-
- 32.
Check Integrity can detect :
- A.
Invalid syntax in the SQL definition of an object, condition, or join.
- B.
Isolated tables
- C.
Isolated joins
- D.
Missing or incorrect cardinalities
Correct Answer(s)
A. Invalid syntax in the SQL definition of an object, condition, or join.
B. Isolated tables
C. Isolated joins
D. Missing or incorrect cardinalitiesExplanation
Check Integrity can detect various types of errors in the SQL definition, including invalid syntax in the SQL definition of an object, condition, or join. It can also detect isolated tables, which are tables that are not connected to any other tables in the database schema. Additionally, it can detect isolated joins, which are join operations that do not involve any other tables. Lastly, Check Integrity can identify missing or incorrect cardinalities, which refer to the number of rows in a table that can be related to the number of rows in another table.Rate this question:
-
- 33.
Business Intelligence Web Service does not have a connection of its own. We access this Business Intelligence Web Service through a Query as a Web Service connection only.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the Business Intelligence Web Service does not have its own connection. Instead, we access it through a Query as a Web Service connection. This means that we use the Query as a Web Service connection to interact with the Business Intelligence Web Service and retrieve the necessary data or perform other operations.Rate this question:
-
- 34.
Xcelcius component ‘Swf Loader’ can only open swf through ‘Push Button’ or selector components, whereas ‘Slideshow’ has a feature of automatic slide transition, which loads the image and swf files in the specified sequence.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The explanation for the correct answer is that the statement provided clearly states that the "Swf Loader" component can only open swf files through "Push Button" or selector components. On the other hand, the "Slideshow" component has a feature of automatic slide transition, which means it can load both image and swf files in a specified sequence. Therefore, the statement is true.Rate this question:
-
- 35.
In a Webi or Deski report when one drags the measure object with the dimension object of a particular granularity, the measure column from the Fact table of the corresponding granularity is selected in the BO default Query. If we did not use aggregate awareness, we would need to define separate objects for each of the fact tables which would be difficult to understand from a user’s point of view.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
When creating a Webi or Deski report, if we drag a measure object along with a dimension object of a specific granularity, the measure column from the Fact table with the corresponding granularity will be selected in the BO default Query. By using aggregate awareness, we can avoid the need to define separate objects for each fact table, which would be confusing for users. This allows for a more streamlined and user-friendly reporting experience.Rate this question:
-
- 36.
Derived table can be to access tables from a different schema through a dblink.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A derived table is a temporary table that is created within a query and is not stored in the database. It is used to perform complex calculations or transformations on data before it is used in a query. In this case, a derived table can be used to access tables from a different schema through a database link (dblink). The dblink allows a user to connect to a remote database and access its tables as if they were part of the local database. Therefore, the statement is true.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 -
May 30, 2013Quiz Created by
Amehta
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