IBM C2090-625 問題集

質問 1：
What distinguishes an OLTP system from a data warehouse? (choose two)
A. A data warehouse captures and processes original business transactions, while an OLTP system does not.
B. An OLTP system captures and processes original business transactions, while a data warehouse does not.
C. An OLTP system is used to transform, clean, and combine operational data, while a data warehouse is not.
D. A data warehouse is fully normalized, while an OLTP system is fully denormalized.
E. A data warehouse is fully denormalized, while an OLTP system is fully normalized.
正解：B,E

質問 2：
Which of the following is true of pivoting?
A. Each data source column in the array must be mapped to a corresponding pivot value.
B. It decreases the number of output rows.
C. Each data source column in the array must be mapped to a pivot derivation element.
D. It increases the number of output columns.
正解：A

質問 3：
A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data Manager to aggregate fact data to the region level?
A. Dimension
B. Hierarchy
C. Lookup
D. Derived dimension
E. Derivation
正解：B

質問 4：
When delivering fact data to a text file, what can be specified?
A. Line and field delimiters
B. Maximum number of rows to be stored in the file
C. Default text editor to use with the file
D. Whether the file is in ASCII or EBCDIC format
正解：A

質問 5：
Which of the following tasks can be completed with the Dimension Build wizard?
A. Adding a custom schema to use for the dimension tables.
B. Creating a connection to hold the dimension tables.
C. Specifying the folder in which the dimension build will be stored.
D. Specifying surrogates and change tracking behaviors.
正解：D