Download Business Objects Certified Professional – Business Objects Web Intelligence XI – Practice and more Exams Nursing in PDF only on Docsity!
Business Objects Certified Professional –
Business Objects Web Intelligence XI – Practice
Exam
Total Questions: 250 Question Type: Multiple Choice (A, B, C, D) Target Audience: Candidates preparing for the Business Objects Web Intelligence XI certification exam Answer Format: Correct answer + explanation immediately following each question This practice exam covers Web Intelligence core concepts: universes, reports, queries, formulas, functions, variables, tables, charts, breaks, sorts, filters, drilling, merging dimensions, and performance optimization.
Topic 1: Web Intelligence Core Concepts & Architecture
(Questions 1-35)
- What is a “Universe” in SAP BusinessObjects Web Intelligence? A) A physical database B) A semantic layer that abstracts database complexity into business-friendly objects C) A report template D) A type of chart Answer: B Explanation: A universe is a semantic layer that maps database structures (tables, columns, joins) into business objects (dimensions, measures, details) that users can understand without SQL knowledge.
- Which component is responsible for converting Web Intelligence requests into SQL queries? A) The Web Intelligence Rich Client B) The Query Engine (Query Builder) C) The Report Panel D) The Central Management Console (CMC) Answer: B
B) .unv file C) .rep file D) .lbi file Answer: A Explanation: Web Intelligence Rich Client allows you to open .wid files locally, edit reports, and refresh data when a connection is available.
- What is the primary function of the “Query Panel” in Web Intelligence? A) To format report tables and charts B) To select objects from a universe, apply filters, and generate the dataset for the report C) To manage user security D) To create formulas and variables Answer: B Explanation: The Query Panel is where users select data objects, define filters (pre-query), and specify query properties before generating the report data.
- Which of the following is NOT a valid data source for a Web Intelligence document? A) A Universe (.unx or .unv) B) A BEx query (SAP BW) C) A text file (.csv) D) A Microsoft PowerPoint presentation Answer: D Explanation: Web Intelligence supports universes, BEx queries (via BICS connection), Excel files (via personal data provider), and text files, but not PowerPoint.
- What is the purpose of the “Data Manager” in Web Intelligence? A) To design charts B) To display metadata about the current data set (number of rows, last refresh date, query filters) C) To manage user accounts D) To create universe joins Answer: B
Answer: B Explanation: The Central Management Console (CMC) is the administration tool for managing users, groups, folders, security, and server settings.
- What is the “InfoView” (now BI Launch Pad) used for? A) Designing universes B) Creating and viewing Web Intelligence documents via a web browser C) Managing the database server D) Writing Java code Answer: B Explanation: BI Launch Pad (formerly InfoView) is the web-based portal where users access, create, schedule, and view Web Intelligence reports.
- What file extension is used for a Web Intelligence document saved on the BI platform? A) .unv B) .wid
C) .rep D) .rpt Answer: B Explanation: .wid is the file extension for Web Intelligence documents. .unv/.unx are universe files.
- Which of the following best describes a “Derived Table” in a universe context? A) A table created in the report B) A pre-defined SQL query stored in the universe that can be used as a data source C) A chart in the report D) A variable in Web Intelligence Answer: B Explanation: A derived table is a custom SQL SELECT statement defined in the universe that acts like a table, allowing complex logic to be encapsulated.
- What is the purpose of “Personal Data Providers” in Web Intelligence?
Explanation: If universe objects are renamed or removed, existing reports may fail when refreshed. Reports store object references, not the universe structure.
- Which of the following is a valid data refresh option in Web Intelligence? A) Refresh only the current report tab B) Refresh all queries in the document C) Refresh a specific query only D) All of the above Answer: D Explanation: Web Intelligence allows granular refresh: all queries, current report only (using data from other reports), or individual queries.
- What does the “Scope of Analysis” feature control in a Web Intelligence report? A) The number of rows returned by the query B) Which users can see the report C) The set of data available for drill-down after the query is run D) The chart type
Answer: C Explanation: Scope of Analysis defines a superset of data (additional dimensions) that can be used for drill-down without re-querying the database.
- In Web Intelligence, what is a “Document” in the platform context? A) A single report file (.wid) that can contain multiple report tabs B) A universe file C) A PDF export D) A server log file Answer: A Explanation: A Web Intelligence document (.wid) is a container that can hold multiple report tabs, variables, data providers, and formatting.
- What is the difference between a “Local” and a “Shared” Web Intelligence document on the BI platform? A) Local is stored on user's hard drive; Shared is stored in the CMC repository with access controls
A) Stores query results to improve performance for subsequent refreshes B) Deletes old data C) Encrypts the database connection D) Formats charts Answer: A Explanation: Caching stores query results on the server so that if the same query is run again (by any user with same universe and filters), the cached result is returned quickly.
- Which of the following is NOT a valid Web Intelligence data provider type? A) Universe (UNX/UNV) B) BEx (SAP BW) C) Web Service (WSDL) D) XML file Answer: D Explanation: Web Intelligence does not natively support XML files as a data provider. It supports universes, BEx queries, Excel, text (CSV), and web services (via universe).
- What is the purpose of the “Report Filter” vs. “Query Filter”? A) Report filter filters data from the database; Query filter filters data already in the report B) Query filter filters data at the database level (before data is returned); Report filter filters data after it is in the report C) There is no difference D) Report filters are permanent; Query filters are temporary Answer: B Explanation: Query filters are applied in the SQL sent to the database, reducing the data returned. Report filters are applied to the data already in the report and can be changed without re- querying.
- In Web Intelligence Rich Client, when working offline, what happens when you try to refresh data? A) It refreshes normally B) It prompts for a connection and then refreshes C) It cannot refresh until you connect to the BI platform D) It uses cached data automatically
D) All of the above Answer: D Explanation: Web Intelligence supports many aggregation functions: Sum, Average, Count, Min, Max, StdDev, Var, etc.
- What is the difference between Count() and CountAll() in Web Intelligence? A) Count() counts non-null values; CountAll() counts all rows including nulls B) Count() counts rows; CountAll() counts columns C) There is no difference D) CountAll() is for measures only Answer: A Explanation: Count() by default counts non-null values for a dimension/measure. CountAll() counts all rows regardless of nulls.
- Which function would you use to concatenate two string columns in a Web Intelligence formula? A) Combine()
B) Concatenate() or the + operator C) Join() D) Append() Answer: B Explanation: You can use the + operator (e.g., [First Name] + " " + [Last Name]) or the Concatenate() function.
- What is the “Report Structure” panel used for? A) To modify the universe B) To view the hierarchy of blocks (tables/charts), sections, and cells in the report C) To change the font color D) To manage user permissions Answer: B Explanation: The Report Structure panel (or Document Structure) shows a tree view of report elements for navigation and selection.
- Which of the following is true about Web Intelligence HTML output format?
- What does the “Translate” function do in Web Intelligence? A) Converts text to a different language B) Converts numbers to text C) Converts dates to text D) Converts a measure to a dimension Answer: A Explanation: The Translate function is used for multilingual reports, translating text from one language to another based on a translation table.
- Which type of chart is best suited for showing trends over time? A) Pie chart B) Bar chart C) Line chart D) Scatter plot Answer: C Explanation: Line charts are ideal for trends over continuous intervals (time, sequence). Bar charts compare categories.
- What is the purpose of “Scheduling” a Web Intelligence document in the CMC? A) To run the report at a specified time and deliver results (e.g., email, FTP, repository) B) To delete the report automatically C) To compress the report D) To encrypt the report Answer: A Explanation: Scheduling allows reports to be refreshed automatically on a calendar or event basis, with results delivered to specified destinations.
- In Web Intelligence, what does “Merged Dimension” allow you to do? A) Combine two different data providers based on a common dimension B) Merge two columns into one C) Combine two universes D) Merge two charts
