Data Modeling
1. Which of the following statements refer to a Remote Cube?
a. InfoCube that gathers data from several Basic Cubes
b. Transaction data that are not managed in SAP BW but are available to SAP BW users
c. Remote Cubes do not contain data
d. A cube built in a non-BW data warehouse
e. None of the above
ANSWER: b, c
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?
a. As a characteristic on the material dimension
b. As a time-dependent navigational attribute
c. As a time-dependent hierarchy of material
d. As a time-independent navigational attribute of material
e. None of the above
ANSWER: d
3. Which of the following refer to pointer tables that provide the technical link to the master data outside of the InfoCube?
a. Dimension tables
b. Set IDs
c. M tables
d. SID tables
e. ODS transparent tables
ANSWER: d
4. Which of the following Dimensions are delivered by SAP BW for each InfoCube?
This question has more than one answer.
a. Unit
b. Time
c. Transfer package
d. Currency unit
e. Info packet (Info package)
f. GIS
ANSWER: a, b, e
5. Which of the following statements describes a categorical dimension?
This question has only one answer.
a. An artificial dimension used to describe the status of another dimension
b. An artificial dimension/attribute used to categorize another dimension
c. An artificial dimension used in a reporting scenario where the comparison of the same key figure is needed
d. A dimension that is used across all cubes
e. None of the above
ANSWER: b
6. Which of the following is an example of a slowly changing dimension?
This question has only one answer.
a. Customer on a sales order
b. Date
c. Person responsible for a cost centre
d. Value of a purchase order
e. None of the above
ANSWER: c
7. Fact tables may be partitioned by which of the following characteristics?
a. 0CALDAY
b. 0CALMONTH
c. 0CALYEAR
d. 0CALPERIOD
e. 0CALWEEK
ANSWER: b
8. Which of the following statements is correct concerning the operational data store (ODS)?
a. The data in the ODS are compressed and do not have a Request ID attached
b. ODS can consolidate data from different source systems
c. Data in the ODS cannot be reported upon
d. The ODS is the inbound layer of the SAP BW system and data are written directly to it from the source system
e. The ODS generally holds transaction data only
ANSWER: b, e
9. A Fact table consists of which of the following elements?
a. Characteristic InfoObjects
b. Key figures InfoObjects
c. Calculated key figures InfoObjects
d. Hierarchies
e. DIM Ids
ANSWER: a, b
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.
a. In the master data table as an attribute
b. In the transaction table as a new characteristic
c. In the ODS to enhance performance
d. In the fact table
e. None of the above
ANSWER: b
11. Which of the following occurs as a result of degenerating dimensions?
This question has more than one answer.
a. The grain of the fact table represents actual working documents like order number or invoice number
b. All descriptive attributes of the grain are located in other dimensions
c. The InfoCube becomes very weak and performs poorly when it is run
d. The degenerating dimensions cannot be modeled using normal star schema
e. None of the above
ANSWER: a, b, c
12. What values can a key figure retain?
This question has only one answer.
a. Last value
b. Average value
c. First value
d. Sum
e. All of the above
f. None of the above
ANSWER: e
13. Which of the following describes an unbalanced hierarchy?
This question has only one answer.
a. A hierarchy with too many leaves within one branch
b. A hierarchy with fewer nodes within one or more branches
c. Hierarchy without leaves
d. The term used for data that are delivered from two or more sources on different aggregation
levels
f. None of the above
ANSWER: b
14. How many hierarchies can be created for a key figure?
This question has only one answer.
a. 10
b. 2
c. 5
d. More than 1
e. None
ANSWER: e
15. Which of the following represents a characteristic that spans an entire data model and
upon which all other entities are dependent?
This question has only one answer.
a. Many-to-many relationship
b. A degenerated characteristic
c. A strong entity
d. An attribute
e. A data model characteristic
ANSWER: e
16. Navigational attributes behave in a query like which of the following?
This question has only one answer.
a. Attributes
b. Variables
c. Characteristics
d. Filters
e. None of the above
ANSWER: c
17. When should an attribute be placed in a separate dimension?
This question has only one answer.
a. Always
b. If the attribute changes frequently
c. If the attributes have a large number of distinct values
d. Never
e. None of the above
ANSWER: b
18. Which of the following objects is not provided in business content?
This question has only one answer.
a. InfoCube
b. InfoSource
c. KPIs
d. Queries
e. SAP R/3 extractor program
f. None of the above
ANSWER: f
19. Which of the following objects keeps the aggregate and InfoCube in sync?
This question has only one answer.
a. Dim pointer
b. Read pointer
c. SID pointers
d. Surrogate pointer
e. None of the above
f. All of the above
ANSWER: b
20. A MultiCube joins numerous other InfoCubes via which of the following?
This question has only one answer.
a. A common set of characteristics
b. A common set of key figures
c. A common set of InfoSources
d. A common set of DataSource
e. None of the above
ANSWER: a
21. Why do we want to normalize a data model?
This question has only one answer.
a. To avoid redundancy
b. To make it look good
c. To increase performance
d. To comply with the multidimensional data modeling rules
e. None of the above
ANSWER: a
22. Hierarchy can be which of the following?
This question has more than one answer.
a. Time-dependent name
b. Version dependent
c. With intervals
d. Time-dependent structure
e. Used by multiple InfoCube
f. None of the above
ANSWER: b, c, d
23. If product price is a slowly changing dimension, how do you model product price if you
want to report the price at any point in time?
This question has more than one answer.
a. As a time-dependent navigational attribute
b. As a time-dependent navigational attribute of material
c. As a time-independent navigational attribute of material
d. As a characteristic on the material dimension
e. As a time-dependent hierarchy of material
ANSWER: b, e
24. Name the three differences between OLAP and OLTP systems?
This question has more than one answer.
a. Software used
b. Current data versus history required
c. One to two months of data versus two to seven years of data
d. Detailed transaction data versus summarized data
e. None of the above
ANSWER: b, c, d
25. Sometimes we have to combine unrelated characteristics into one dimension, due to
which of the following facts?
a. We run out of dimensions and we have to include the data in the same InfoCube
b. We are running out of space on the database
c. We are looking for higher performance
d. Lower number of dimensions is a way to optimize data staging
e. To reduce the number of joins
f. All of the above
ANSWER: a, e
26. Which of the following items refer to InfoObjects?
This question has more than one answer.
a. Characteristics
b. Key figures
c. Queries
d. Attributes
e. None of the above
ANSWER: a, b
27. What are the three predefined dimensions in SAP BW?
This question has more than one answer.
a. Date
b. InfoPackage
c. Time
d. Unit
e. None of the above
ANSWER: b, c, d
28. What are the advantages of a smaller dimension?
This question has more than one answer.
a. Available immediately after transaction data load
b. Improves query performance
c. Overhead during load time
d. It is not an advantage but a liability
e. None of the above
ANSWER: a, b, c
29. What are the limitations of a Remote Cube?
This question has more than one answer.
a. Additional requirements for extractors
b. Slow
c. System dependent
d. Only for transaction data
e. Small volume
ANSWER: a, b, d
30. Which of the following are examples of characteristics?
This question has more than one answer.
a. Monthly sales
b. Products
c. Cost centers
d. Company codes
e. Sales person
ANSWER: b, c, d, e
31. A conceptual description of data objects, their attributes, and the relationships between them is:
a) A data warehouse
b) A data model
c) An InfoCatalog
d) An InfoSet
e) An InfoSource
Answer: b.
32. Which of the following are types of SAP BW InfoCubes?
a) MultiCube
b) Inverted Cube
c) Remote Cube
d) Relational Cube
e) Basic Cube
Answer: a, c, and e.
No comments:
Post a Comment