SAP Bo - Objective 2
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 and analyze data in a more structured and organized manner, enabling them to easily drill down from one object to another within the hierarchy. By creating custom hierarchies, users can gain deeper insights and perform more detailed analysis on their data.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. 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 explains that a chasm trap can be solved using two methods. 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 and provide accurate results. The second method suggests putting the two joins in two different contexts. This will generate two synchronized queries, effectively resolving the problem.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
In order to solve a fan trap, an alias of the 2nd table is created and contexts are defined. This means that the normal table is only joined with the first table, while the alias is joined with both the 1st and the 3rd table. By doing this, the measures of the 2nd table are taken only from the normal table, while the other dimensions of the 2nd table are taken from the alias table. This approach helps to resolve the fan trap issue and ensures accurate data analysis.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
Aggregate awareness function is used in scenarios where we have the same fact tables in different grains. This means that the fact tables contain data at different levels of detail or granularity. The aggregate awareness function allows the query to intelligently choose the appropriate aggregate table based on the level of detail required in the query. By using the aggregate tables, the query can be optimized and improved performance can be achieved.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 given correct answer is true. The aggregate awareness function allows us to define only one object for the measures in the fact tables. This function helps in optimizing the performance of queries by selecting the appropriate level of aggregation based on the query conditions. By specifying the highest level and lower level in the aggregate awareness function, we can ensure that the query retrieves the necessary data at the desired level of detail.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 at the database level. The result of this query is then used as a temporary table within the universe. This allows for more flexibility and efficiency in data retrieval and analysis, as the derived table can be customized based on the specific needs of the report or analysis being performed.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
The statement is incorrect. A derived table can be used for complex calculations in a report. Derived tables are created by combining data from multiple tables or applying complex calculations on existing tables. They are a useful tool for performing advanced calculations and aggregations in a report. Therefore, the correct answer 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 in the context of data modeling and business intelligence. It refers to the ability of the universe to utilize indexes, which are data structures that improve the performance of querying and retrieving data from databases. By being index aware, the universe can optimize its queries by leveraging the indexes present in the underlying database, resulting in faster and more efficient data retrieval.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 property that allows filter conditions in queries or data providers to be replaced with their corresponding indexes or surrogate keys. This means that instead of using the actual values in the filter conditions, the indexes or surrogate keys are used. This can improve the performance of the queries or data providers as it can utilize the indexes more efficiently. Therefore, the statement "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" 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 at the Universe Level. The Universe Level refers to the semantic layer of a business intelligence tool where the data is modeled and organized. Conditions are created in the Universe Level to define filters or restrictions on the data that will be retrieved from the underlying database. These conditions help in narrowing down the data set to meet specific criteria and improve the efficiency of reporting and analysis.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, it means that a filter condition is being applied to the query. This filter condition is then reflected in the query SQL, which is the language used to retrieve data from a database. Therefore, the statement that the filter condition appears in the query SQL when a condition object is dragged in the Query Panel is true.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 using a report, you have the ability to apply a filter to the data being displayed. This filter allows you to narrow down the results based on specific criteria, such as a date range or specific values. In contrast, a universe, database, or table does not have this built-in functionality for applying filters to the data.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 certain conditions or criteria that the query results must meet. This filter is an integral part of the query and is included in the query SQL. Therefore, the statement that a query filter does not appear in the query SQL is incorrect. Hence, 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 share common components such as objects, classes, and joins. This means that these universes have interconnected elements, allowing for data integration and analysis across different universes. By sharing objects, classes, and joins, users can access and combine data from multiple universes, enabling them to gain a comprehensive view of the data and make more informed decisions.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
In this statement, it is mentioned that when two universes are linked, the source universe is referred to as the core universe, while the destination universe is called the derived universe. This implies that the statement is true.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 means that an input control provides the functionality to filter data in a report based on a specific dimension, such as a category or attribute. It allows users to select a dimension value and filter the report to show only the data related to that value.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 input controls do support multiselection of values. Input controls allow users to select multiple values from a list, which can be used to filter data in a report. This feature is commonly used in reporting tools to provide users with more flexibility in analyzing and viewing data. Therefore, the given 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.
False
- B.
True
Correct Answer
A. FalseExplanation
If the scope of analysis is set to 2 levels, it means that the report will only show data up to the second level of the hierarchy. Therefore, it will not be able to drill down to the third level, as the scope of analysis overrides any deeper levels in the hierarchy. Hence, 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 the user to manually select specific objects from existing hierarchies and drag them into the scope of the analysis panel. This means that the user can choose which objects they want to include in the drilldown scope for the report. Therefore, the statement "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
In a report with multiple tabs and different objects requiring the same or different filter conditions, the query filter should be used. This allows for the application of specific filter conditions to each tab and object, ensuring accurate and relevant data is displayed in the report. By using the query filter, the report can effectively handle the varying filter requirements of different objects within the report.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 more efficient to fetch all the data in one query and then apply report filters to each tab. This approach avoids the need to make separate queries for each tab, which can be time-consuming and resource-intensive. By fetching the whole data and applying filters, it ensures that the desired data is obtained for each tab without unnecessary duplication of queries. Therefore, it is advisable to follow this approach to optimize performance and resource utilization.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 include dimension objects that are directly involved in the calculation process. These dimension objects are necessary for performing the calculation accurately and should be included in the input context.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 applied to the data before performing calculations or aggregations. It determines the subset of data that is used for the calculation, not the display format or structure. Table objects, on the other hand, are used to organize and present the data in a tabular format for better understanding and analysis.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, the user 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 correct answer is Swf Loader and Slideshow. These components can be used to link multiple dashboard flash outputs (swf files). The Swf Loader component allows loading and displaying external swf files within the dashboard, while the Slideshow component enables the creation of a slideshow by displaying multiple swf files in a sequential manner. These components provide the functionality to connect and present multiple dashboard flash outputs effectively.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 Xcelcius component 'Slideshow' is the only feasible option for a complete presentation because it allows users to create dynamic and interactive presentations with the ability to incorporate various data visualizations, charts, and graphs. It offers a wide range of customization options and interactive features that make it an ideal choice for presenting complex data in a visually appealing and engaging manner. Other components may have limitations or lack the necessary features to create a comprehensive presentation, making the Slideshow component the most suitable option.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
An Xcelcius dashboard can access data from a BO universe through various methods. One way is by using Query as a Web Service, which allows the dashboard to send queries to the BO universe and retrieve the data. Another method is through Business Intelligence Web Service, which provides a set of web services that can be used to access and manipulate data from the BO universe. Additionally, LiveOffice can be used to directly integrate BO universe data into Microsoft Office applications. 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 are 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 involves the creation and management of data models and queries. The document domain deals with storing and organizing various types of documents within the repository. These domains are essential for effectively managing and organizing business objects within a repository.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 dimensions provide additional context or details about a certain attribute. Structural dimensions define the hierarchical relationships between different attributes. Categorical dimensions classify data into distinct categories or groups. Partitioning dimensions divide data into subsets based on certain 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 is a feature that can be used to detect various types of errors or issues in a database. It can identify invalid syntax in the SQL definition of an object, condition, or join, which means it can catch any mistakes or typos in the SQL code that could lead to errors or unexpected results. Additionally, it can also detect isolated tables and joins, which are tables or joins that are not connected to the rest of the database structure. Lastly, it can identify missing or incorrect cardinalities, which refers to the relationship between tables and the number of records they can have.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 explanation for the given correct answer is that the Business Intelligence Web Service does not have its own connection. Instead, it is accessed through a Query as a Web Service connection. This means that in order to interact with the Business Intelligence Web Service, we need to establish a connection through a Query as a Web Service connection. Therefore, the statement "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" is true.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 is stating that the Xcelcius component 'Swf Loader' 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 with a dimension object of a specific granularity, the measure column from the Fact table that matches that granularity is automatically selected in the BusinessObjects default Query. This is possible due to the use of aggregate awareness. If we didn't use aggregate awareness, we would have to define separate objects for each fact table, which would make it more challenging for users to understand and navigate the report. Therefore, the statement "True" is correct.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 exists only for the duration of that query. It can be used to access tables from a different schema through a database link (dblink). This allows the query to retrieve data from tables that are not directly accessible in the current schema. Therefore, the statement "Derived table can be used to access tables from a different schema through a dblink" 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 18, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 05, 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