IBM C2090-625 問題集

質問 1：
When executed, what will the following command line string do?"c:\program files\cognos\c8\bin\rundsjob.exe" -P "ODBC" "DSN=DS_Advanced;DBMS=(other)" "Inventory_Fact_Data" VTRACE_VALUES=PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDSQL,USER,VARIABLE
A. Execute a fact build called Inventory_Fact_Data.
B. Execute a JobStream called Inventory_Fact_Data.
C. Add tables (such as INTERNAL) to the Inventory_Fact_Data database.
D. Create a database called Inventory_Fact_Data and add a connection to it.
正解：B

質問 2：
A fact build is being manually created. What must the developer do to deliver the fact data to a relational table?
A. Add a relational table delivery module to the fact build.
B. Add a relational table delivery module to the Connections folder.
C. Modify the fact build DataStream to include a relational table delivery.
D. Create a relational table delivery using SQLTerm.
正解：A

質問 3：
Why has the developer selected the Output box for the ProductLine row?

A. To merge duplicate rows of incoming data at the ProductLine level.
B. To create summary level rows.
C. To create detail level rows.
D. To allow duplicate rows of incoming data at the ProductLine level.
正解：B

質問 4：
Which of the following is true of a derivation that has been created in the transformation model?
A. The derivation can be added to a dimension build delivery.
B. The derivation cannot be disabled once it has been added to the transformation model.
C. The derivation can be added to a fact build delivery.
D. The derivation can be used to perform calculations in the SQL statement of a data source.
正解：C

質問 5：
Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?
A. Accept unmatched member identifiers in the measure element properties.
B. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
C. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
D. Modify the SQL for the reference structure to exclude the missing product codes.
正解：C

質問 6：
A developer has created a lookup using a template (not a data source) for data access. Why would the developer do this?
A. Data must be accessed from more than one table.
B. A derivation has been added to the lookup.
C. The lookup attribute names are different from the source column names.
D. The build will perform automatic surrogate key substitution.
正解：D

質問 7：
Which of the following is true of the Navigator?
A. Components from different catalogs can be compared.
B. Library components (such as hierarchies) cannot be navigated.
C. When searching for components, wildcards are not supported.
D. When a component is selected, dependent components are shown.
正解：D

質問 8：
When creating a lookup, what must be specified?
A. Derived dimension
B. Metadata dimension
C. Template
D. Derivation
正解：C