Test your basic knowledge on SAP B&W, SAP B&W Simulated Certification Exam

Which of the following objects are connected by update rules? a. Communication structures b. Extract structure c. InfoCube d. InfoStructure e. Transfer structure f. None of the above
a,b
b,c
d,e
a,c
How can the business content be extended? a. SAP BW provides function exits b. Extend the standard extraction structures c. Function exit must be programmed to enrich data d. New fields must be assigned e. None of the above
a,b,c,d
a,b
a,b,c
e
Which of the following is correct about Pro.le Generator? a. It is a tool to automatically generate Authorization Pro.le b. It is a tool existing in OLTP systems only c. Complete the Administrator work with extra tasks to set up authorization d. A tool that can be used by end users to modify their authorizations e. None of the above
a
b
c
d
Which of the following applications in SAP support delta update? This question has more than one answer. a. CO/PA (time stamp) b. MM c. LIS (based on separate delta tables) d. FI/SL e. None of the above
a,c
a,b
b,c
None of the above
Which of the following describes a Result Set query? a. A nested query where the results of a first query are used as entry values for a second query b. A query using at tables (ODS object or InfoObject) c. A prequery d. There is no such thing in SAP BW e. None of the above
a
b
c
d
Which of the following can be extended in SAP BW? a. Transaction data b. Master data c. Texts d. Metadata e. All of the above
a,b,c
b,c,d
c,d
None of the above
What do the SAP BW content extractors provide? a. Generic extractors b. Custom extractors c. There is no such thing in SAP BW content d. Data sources that can be activated for all applications e. None of the above
a
b
c
d
Which of the following is usually the largest table in the star schema? a. None—they are all equal b. The fact table c. The rst dimension table d. The metadata table e. The SID table
a
b
c
d
For which of the following objects can authorization be created? a. Characteristic values b. Hierarchy leaves c. Hierarchy levels d. Hierarchy modes e. None of the above
a,b,c,d
a,b
c,d
None of the above
Where are customer-speci.c documents stored? a. DNS b. BDS c. ITS d. AWB e. None of the above
a
b
c
d
What does an extract structure represent? a. Data from the target system b. Data from the source system c. Transport process d. Communication process e. None of the above
a
b
c
d
What method is used in CO/PA (SAP R/3 side) to manage delta updating? a. Several new tables are created to manage the delta upload b. A V3 delta management setup table is created c. A person manually monitors the data as they come to SAP BW d. Based on the time stamp that is attached to each line item e. None of the above
a
b
c
d
Where can data be .ltered in BEx Analyzer? a. By the end user in a report b. During query execution c. In the query builder d. When checking users’ authorizations e. None of the above
a
b
c
d
Using PSA as a loading process, which of the following methodologies can be used? a. To PSA, then to the data target b. To PSA only c. To data target only d. To PSA and data target in parallel e. All of the above
d
c
d
e
What is a MultiCube query? a. A query using .at tables (ODS object or InfoObject) b. A nested query where the results of a .rst query are used as entry values for a second query c. It is a query divided using the relevant Basic Cubes into several queries that can be processed in parallel d. All of the above e. None of the above
a
b
c
None of the above
Which of the following objects contains transactional data? a. Query b. InfoSources c. InfoCube d. Report e. Templates f. None of the above
a
b
c
d
Which of the following objects keeps the aggregate and InfoCube in sync? a. DIM pointer b. Read pointer c. SID pointers d. Surrogate pointer e. None of the above f. All of the above
a
b
c
d
What is the scheduler? a. A tool that manages data requests to the source system b. A tool that provides a view of data loading activities and their status c. A tool that automates the data transfer using InfoPackages and InfoPackages groups d. A tool to display all SAP BW elements (source system, DataSources, transfer rules, InfoSource, update rules, and InfoCubes) from the source system up e. None of the above
a,c
a,b
c,d
None of the above
Which of the following data extractions is possible with SAP BW? a. Provider b. SAP R/3 c. Flat .le d. SAP R/2 e. All of the above f. None of the above
a
b
c
d
Which of the following statements are true regarding authorization in BW? a. Each authorization refers to one InfoCube b. Authorization is data concerning the user that remain unchanged over a reasonably long period of time c. Each authorization refers to an authorization object d. Each authorization de.nes one or more values for each .eld that is contained in the authorization object e. None of the above
a,b
c,d
b,d
e
Which of the following elements refers to objects that deliver data in a Web report? a. Data deliverers b. Data providers c. Data suppliers d. Web providers e. Web suppliers
a
b
c
d
Which of the following characterize a Remote Cube? a. All of the characteristics are in one dimension b. It is attached to an InfoSource c. It has a physical table d. It stores OLAP data e. You can see updated data immediately from the source system
a,b
c,d
a,c
None of the above
Which of the following is a supply of workbooks in SAP BW arranged according to topic areas? a. An InfoSource b. A channel c. An InfoArea d. An InfoCatalog e. An InfoObject
a
b
c
d
Which of the following are correct concerning SAP BW InfoSources? a. An InfoSource is comprised of InfoObjects b. Each time an InfoSource is generated a new extract structure is created on the OLTP system c. Only key .gures are contained in the Info Source d. The InfoSource allows the system to transfer data to the communication structure e. The InfoSource helps prepare data to be stored in InfoCubes
a,d,e
a,b,c
a,d
None of the above
What tables do ODS objects consist of? a. Active table b. Extended table c. Change log table d. Modified and new table e. None of the above
a,c,d
a,b,c
b,c,d
None of the above
How can the business content be activated in SAP BW? a. No need to activate—it is automatically activated on installation of SAP BW b. The business content for one SAP module can be activated in one step c. Single business content objects can be activated d. After the activation a complete scenario can be used e. None of the above
b,c,d
a,b,c
a,b,d
None of the above
What step do CO/PA, LO extraction, and LIS extraction methods have in common when Setting up delta management of uploads? a. On the scheduler you activate a full upload b. On the scheduler you initialize the delta upload c. Setup of delta tables d. The delta is managed in the service API e. The InfoStructure tables are used f. VBDATA and ARFCSDATA tables
a
b
c
d
In which of the following objects can data transformation take place? a. Extract structures b. ODS c. Transfer routines d. Transfer rules e. Update rules f. None of the above
a,c,d,e
a,b,c,d
b,c,d
None of the above
When translating the ERM to MDM/star schema, which of the following guidelines applies? a. N:M relationships are broken into smaller 1:N relationships b. The central intersection entity becomes the fact table c. The ERM is divided over BSIP rollout schedule d. The foreign-primary key relationship becomes the dimensions e. Dimensions are summarized into aggregates
a,b
a,c
b,c
c,d
Which of the following are InfoCube types in SAP BW? a. Aggregate b. B—Basic c. R—Remote d. T—Temp e. V—Virtual f. All of the above
a,b,c
b,c,d
c,d,e
A,d,e
What is the recommended way to increase the speed of loading? a. Increase the size of number range buffer b. Delete secondary indexes c. Load master data before transaction data d. Create multiple jobs to run in parallel e. All of the above
a
b
c
e
What extractor types are available in SAP BW 2.0? a. Application speci.c b. Object speci.c c. Cross application d. InfoCube speci.c e. None of the above
a,c
a,b
d,e
None of the above
On top of which of the following objects can an InfoSet query be built? a. Tables b. Logical database c. Views d. Transaction data e. ABAP programs
a,b,c,e
a,b,c
a,c,e
None of the above
What is the maximum number of key .gures in an InfoCube? a. 13 b. 85 c. 322 d. 233 e. None of the above
a
b
c
d
In order to report on data without any key.gure (e.g., employee names), which of the following would one introduce? a. An ABAP program to count the master data table entries b. An arti.cial key .gure (counter) .lled with a “1” for each employee c. Reports that count with Visual Basic functions the number of records d. A categorical dimension e. None of the above
a
b
c
d
What is a reporting object? a. A folder used to store related InfoObjects b. A generic term for business evaluation objects c. A record layout of InfoObjects d. An authorization object with an additional relationship to InfoCubes e. None of the above
a
b
c
d
How does SAP BW support geocoding? a. SAP BW does not support geocoding b. Choose geo-info objects to be geocoded c. Generate geocoordinates with external tool d. Upload geocoordinates via SAP BW InfoSource e. None of the above
b,c,d
a,b,c
a,c,d
B,d
Where are data stored during the execution of a query? a. An aggregate cube b. A cache (temp) cube in the application server c. A virtual cube d. A view cube e. None of the above
a
b
c
d
What are the characteristics of the ODS? a. Data available for reporting b. Denormalized data structure c. Merge data from different InfoSources d. Potential to create external .les e. Technical and data changes f. Transaction data only g. All of the above
a
e
f
g
How many communication structures can be part of a master data InfoSource? a. None b. One c. Two d. Three e. None of the above
a
b
c
d
In FI/SL we can create a ledger based on what type of tables? a. Aggregate tables b. InfoCube level tables c. Line-item level tables d. Summarization level tables e. Total tables
a
b
c
e
According to which of the following levels can the DataSource replication occur? a. Application component b. DataSource c. Extract routines d. Hierarchies e. Source system
a,b,d
a,b,c
a,c,d
None of the above
Which of the following are advantages of using MultiCubes? a. Fast reporting on multiple Basic Cubes b. A large amount of dataset aggregation takes place by uploading c. Avoid redundancies d. The data can be substituted when uploading into the MultiCube e. A MultiCube report can make selections using a maximum of 10 Basic Cubes
a,b
a,c
b,c
None of the above
Which statements are not correct about the PSA? a. Created for each communication structure b. Transfer rules have been applied c. You can load from the PSA to an InfoCube d. Queries can be generated from the PSA e. None of the above
a,b,d
a,b,c
a,b,d
None of the above
Which of the following tools helps in the Web reporting area? a. The Web agent b. The front-page tool c. The Web wizard d. The query view e. None of the above
a
b
c
d
In which of the following can data be altered in the BEx Analyzer? a. In the query builder b. During query execution c. By the end user in a report d. When checking users’ authorizations e. None of the above
a,b
a,c
d,e
None of the above
From which of the following can a multprovider get its data? a. Remote cubes b. Multiproviders c. ODS objects with BEx indicator d. PSA e. All of the above
a,b,c
a,c,d
b,c,d
None of the above
What are Metadata? a. Data from the BDS b. Data from the ITS c. Data about the data d. Data that do not change often e. None of the above
a
b
c
None of the above
How do OLTP applications communicate with SAP BW? a. Via ODBO b. Via SAPI c. Via communication structure d. Via BAPI e. None of the above
a
b
c
d
When are aggregates useful? a. Always b. They are useful only for key .gures with aggregation SUM, MIN, or MAX c. For reorganizations and realignments d. To increase the speed of loading during data update e. None of the above
a
b
c
d
What are the statuses in the monitor in SAP BW? a. There is no status in the monitor in SAP BW b. Green light c. Yellow light d. Red light e. None of the above
a,b,c
b,c,d
a,b,d
None of the above
Which of the following is correct about SAP BW Statistics? a. Data volume of the SAP BW Statistics cannot be anticipated, as it is very strongly dependent on the usage of the SAP BW b. SAP BW Statistics are delivered as a part of the technical content c. All SAP BW Statistics query objects start with OSAP d. All SAP BW Statistics InfoObject catalogues start with OSAP e. SAP BW Statistics is automatically activated f. SAP BW Statistics is loaded in the InfoCube via an internal InfoSource
a
b
c
d
Which of the following is included in SAP BW business content? a. SAP R/3 extractors, InfoSource, and queries b. SAP R/3 extractors, InfoSource, and InfoCubes c. SAP R/3 extractors, InfoSource, InfoCubes, and queries d. SAP R/3 extractors, InfoSource, InfoCubes, queries, and workbooks e. None of the above
a
b
c
d
Which of the following describes business content? a. Role based b. Internet based c. Industry speci.c d. De.ned only by SAP e. None of the above
a,c,d
c,d
d,b
None of the above
Non-SAP data sources can load data into SAP BW via which of the following elements? a. Flat .les b. Third-party extraction and load tools c. ACCESS database .les d. CSV .les only e. None of the above
a,b
b,c
c,d
None of the above
Which of the following statements are not correct about PSA? a. It is created for each communication structure b. Queries can be generated from the PSA c. Transfer rules have been applied d. You can load from the PSA to an InfoCube e. None of the above
a,b
b,c
c,d
None of the above
What is the procedure for the LIS delta update? a. There is no delta update in LIS b. “Generate updating” regenerates the update program and ensures that a delta update is possible c. Activate “delta updating in the LIS” setting in the report “RMCSBIWC” d. The active delta table is defined in “TMCBIW” e. None of the above
a,b,c
b,c,d
a,c,d
None of the above
How many dimension tables can the SAP BW system administrator creates per InfoCube? a. 13 b. 16 c. 233 d. 248 e. None of the above
a
b
c
d
Which of the following are parts of an InfoSource? a. Communication structure b. Transfer rules c. Update rules d. Transfer structure e. Extractor
a,b,c,d,e
a,b,c
c,d,e
None of the above
Which of the following is correct about Request ID (RNSID)? a. It represents the chronological update history b. A unique key is created by the system c. Administrator can use RNSIDs to identify certain upload sequences in case of wrong data d. Only requests that have “green traf.c lights” will update the related InfoCube e. Once an InfoCube is compressed, the SAP BW Administrator loses the capability of deleting a single request
a,b,c
b,c
c,d
None of the above
Description:

In this test, you had the opportunity to take a simulated certification test and read the test-taking tips to help you assess your readiness to pass the SAP BW certification exam. This test is a very interesting collection of questions in the form of MCQ where the test-takers get an opportunity to help you assess your readiness to pass the SAP BW certification exam.
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction.

Discussion

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 532 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 1823 Attempts

An ASP.NET Application
10 Questions | 356 Attempts

Explore Similar Courses

SAP ABAP Training for Beginners

Price:$349

No Hidden Cost

SAP Webdynpro ABAP Training

Price:$299

Batch Size of 5 students