[2026] IBM Cognos 10 BI Data Warehouse Developer

문제1

A JobStream has been created that, when executed, will write status messages to the log file that indicate whether nodes have completed or failed to run. What type of node should be added to the JobStream?

A. Condition

B. Email

C. Procedure

D. Alert

정답: C

문제2

A developer has created a hierarchy that uses multiple data sources. The developer wants to know if there are multiple parents or children without parents. What tool should the administrator use?

A. Reference Explorer

B. SQLTerm

C. Navigator

D. SQLTXT Designer

E. Hierachy wizard

정답: A

문제3

A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?

A. Attribute

B. Derived dimension

C. Derivation

D. Measure

E. User-defined function

정답: E

문제4

Below, what does Unknown Class (?Class) represent?

A. Recursive level

B. Manual level

C. Literal

D. Foster parent

정답: D

문제5

Which of the following is are characteristics of surrogate keys? (choose three)

A. Are text-based.

B. Tend to be larger than keys from operational systems.

C. Are numbers.

D. Are unique.

E. Are replaced by business keys in the data warehouse.

F. Have no intrinsic meaning.

정답: C,D,F

문제6

A fact build has been created that includes a Product Code dimension element. Each incoming product code must match a corresponding row in the Product dimension. What should the developer do?

A. Create a lookup to the dimension and reference the lookup in the Product Code element.

B. Create an output filter and reference the output filter in the Product Code element.

C. Create a second dimension element in the transformation model that will check for valid product codes.

D. Create a template and reference the template in the Product Code element.

E. Create an attribute element in the transformation model that will check for valid product codes.

정답: A

문제7

Which of the following is an advantage of using conformed dimensions in a data warehouse?

A. Conformed dimensions do not require the use of lookups.

B. Conformed dimensions enable database views to be reused across the data warehouse.

C. Conformed dimensions do not require the use of surrogate keys.

D. Conformed dimensions enable users to drill from one area of their business to another.

정답: D

문제8

Which of the following is true of conformed dimensions? (choose two)

A. Conformed dimensions are created using the Hierarchy wizard.

B. Conformed dimensions are created using the Fact Build wizard.

C. A conformed dimension is specific to a single fact table.

D. A conformed dimension is used by multiple fact tables.

E. A conformed dimension uses surrogate keys.

정답: D,E

문제9

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. Add tables (such as INTERNAL) to the Inventory_Fact_Data database.

C. Execute a JobStream called Inventory_Fact_Data.

D. Create a database called Inventory_Fact_Data and add a connection to it.

정답: C

IBM Cognos 10 BI Data Warehouse Developer - COG-625무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트