Advertise
     Here
Home   Contact     Site Map
Request Information   
(732) 248-1900   1-877-85-eTeam(38326)
About Us Clients Experts Resources Training News Press Releases Success stories Help/FAQ
 
Test My Skills
 
SAP
Author : Saqib Khan
Name: *  
1. Which of the following statements refer to a Remote Cube?
This question has more than one answer.
InfoCube that gathers data from several Basic Cubes
Transaction data that are not managed in SAP BW but are available to SAP BW users
Remote Cubes do not contain data
A cube built in a non-BW data warehouse
None of the above
2. If product price is a slowly changing dimension, how do you model product price if you want to report on the price at the time of the query?
This question has more than one answer.
As a characteristic on the material dimension
As a time-dependent navigational attribute
As a time-dependent hierarchy of material
As a time-independent navigational attribute of material
None of the above
3. Which of the following refer to pointer tables that provide the technical link to the master data outside of the InfoCube?
This question has only one answer.
Dimension tables
Set IDs
M tables
SID tables
ODS transparent tables
4. Which of the following Dimensions are delivered by SAP BW for each InfoCube?
This question has more than one answer.
Unit
Time
Transfer package
Currency Unit
Info packet (Info package)
GIS
5. Which of the following statements describes a categorical dimension?
This question has only one answer.
An artificial dimension used to describe the status of another dimension
An artificial dimension/attribute used to categorize another dimension
An artificial dimension used in a reporting scenario where the comparison of the same key figure is needed
A dimension that is used across all cubes
None of the above
6. Which of the following is an example of a slowly changing dimension?
This question has only one answer.
Customer on a sales order
Date
Person responsible for a cost center
Value of a purchase order
None of the above
7. Fact tables may be partitioned by which of the following characteristics?
This question has only one answer.
0CALDAY
0CALMONTH
0CALYEAR
0CALPERIOD
0CALWEEK
8. Which of the following statements are correct concerning the operational data store (ODS)?
This question has more than one answer.
The data in the ODS are compressed and do not have a Request ID attached
ODS can consolidate data from different source systems
Data in the ODS cannot be reported upon
The ODS is the inbound layer of the SAP BW system and data are written directly to it from the source system
The ODS generally holds transaction data only
9. A Fact table consists of which of the following elements?
This question has more than one answer.
Characteristic InfoObjects
Key figures InfoObjects
Calculated key figures InfoObjects
Hierarchies
DIM IDs
10. If you worked for a retail company that changed prices on a very frequent basis, how would you model the price?
This question has only one answer.
In the master data table as an attribute
In the transaction table as a new characteristic
In the ODS to enhance performance
In the fact table
None of the above
11. Which of the following occurs as a result of degenerating dimensions?
This question has more than one answer.
The grain of the fact table represents actual working documents like order number or invoice number
All descriptive attributes of the grain are located in other dimensions
The InfoCube becomes very weak and performs poorly when it is run
The degenerating dimensions cannot be modeled using normal star schema
None of the above
12. What values can a key figure retain?
This question has only one answer.
Last value
Average value
First value
Sum
All of the above
None of the above
13. Which of the following describes an unbalanced hierarchy?
This question has only one answer.
A hierarchy with too many leaves within one branch
A hierarchy with fewer nodes within one or more branches
Hierarchy without leaves
The term used for data that are delivered from two or more sources on different aggregation levels
None of the above
 
eTeam, Inc. provides process and technology subject matter expertise in the areas of Analytics to a large manufacturing company.
eTeam, Inc. provides training in Siebel ePharma to a sales workforce of an international pharmaceutical company.
eTeam, Inc. provides Ascential Datastage and QualityStage expertise to a healthcare provider.
  More news...
"eTeam believes in partnering itself in the whole process of the projects, which gives them an edge over other consulting organizations."
Partial client list...
 Privacy Policy Legal Join our Team  

Copyright © 2005. All rights reservered. CRM and DW ExpertsTM is owned and operated by eTeam Inc.
Site designed and developed by Ravidhu Inc.