Free IBM COG-625 Practice Test & Real Exam Questions
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
Correct Answer: C
Vote an answer
When creating a Data Manager catalog which of the following must be specified? (choose two)
Correct Answer: A,E
Vote an answer
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?
Correct Answer: B
Vote an answer
A fact build is being manually created. What must the developer do to deliver the fact data to a relational table?
Correct Answer: D
Vote an answer
Over time, an employee may move from one office to another. The dimension table tracks these types of changes. What is this dimension an example of?
Correct Answer: C
Vote an answer
A developer wants to deliver fact data to a relational table. When the fact build is executed, any new rows must be added to this table. However, if an incoming row has the same key as a row that already exists in this table, the existing row must be updated accordingly. What should the developer do?
Correct Answer: B
Vote an answer
A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?
Correct Answer: B
Vote an answer
When delivering fact data to a text file, what can be specified?
Correct Answer: B
Vote an answer
A developer wants to ensure that each incoming row of fact data has a corresponding location code from a dimension table. What should the developer create?
Correct Answer: A
Vote an answer
