[2026] IBM Cognos 10 BI Data Warehouse Developer - C2020-625 무료 시험 문제

문제1

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

문제2

A developer has added a data source connection to a Data Manager catalog. This connection points to a relational database. The developer wants to view the contents of this database, such as the number of tables that it contains. What tool could the administrator use?

A. ODBC Administrator

B. Reference Explorer

C. SQLTerm

D. SQLTXT Designer

정답: C

문제3

A developer wants to ensure that the business keys in incoming source data are replaced with surrogate keys in the fact tables. To do this, what must be modified?

A. Connection properties

B. Fact build properties

C. Template properties

D. Hierarchy properties

정답: C

문제4

What can be done to minimize memory consumption?

A. Disable fact build logging.

B. Enable auditing on the fact build.

C. Disable dimension breaking on the fact build.

D. Enable dimension breaking on the fact build.

정답: D

문제5

Which would be reasons for modifying a hierarchy that was previously created using the Hierarchy wizard? (Choosetwo)

A. To specify a metadata dimension for the hierarchy.

B. To add a measure element to the hierarchy.

C. To add an attribute to a hierarchy level.

D. To add a level to the hierarchy.

E. To add a derived dimension element to the hierarchy.

F. To specify a fact build for the hierarchy.

정답: C,D

문제6

A developer has created a lookup using a template (not a data source) for data access. Why would the developer do this?

A. A derivation has been added to the lookup.

B. The lookup attribute names are different from the source column names.

C. Data must be accessed from more than one table.

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 a component is selected, dependent components are shown.

D. When searching for components, wildcards are not supported.

정답: C

문제8

A developer has created a fact build to process the incoming data shown in the table: The build has been set to merge records with duplicate keys. Both the Customer and Date columns represent dimension elements. If the merge behavior for the Amount column is set to SUM, what will be the value of Amount for the first row delivered for customer 2?

A. 700

B. 500

C. 1200

D. 200

정답: B

문제9

The data in the Product dimension table appears as follows:

What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?

A. In the properties of the underlying hierarchy, set the Unbalanced Hierarchy feature to Accept.

B. In the properties of the template that is used to deliver the dimension build, include an attribute with effective start date behavior.

C. In the properties of the underlying hierarchy, set the Multiple Parents feature to Accept.

D. In the properties of the dimension table, specify that late arriving dimension details are to be written to a table.

정답: B

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

우리와 연락하기

유용한 링크

최신 업데이트