EnsurePass
2017 Oct IBM Official New Released C2020-625 V13
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2020-625 V13.html

IBM Cognos 10 BI Data Warehouse Developer

Question No: 41

Where can a variable be declared?

  1. In a build specification.

  2. In a hierarchy.

  3. In a data source connection.

  4. In a Data Manager folder.

Answer: A

Question No: 42

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?

  1. Derived dimension

  2. Lookup

  3. Derivation

  4. Hierarchy

  5. Dimension

Answer: D

Question No: 43

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?

  1. Accept unmatched member identifiers in the measure element properties.

  2. Modify the SQL for the reference structure to exclude the missing product codes.

  3. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.

  4. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.

Answer: C

Question No: 44

In this JobStream, the action on failure setting for the SiteDim node has been set to

TERMINATE.

Ensurepass 2017 PDF and VCE

What will happen if this node fails while the JobStream is executing?

  1. Data Manager will immediately stop processing the remaining dimension build nodes, and process the fact build node instead.

  2. Data Manager will stop processing the SiteDim node, but will continue to process the remaining dimension build nodes.

  3. Data Manager will stop all processing of all nodes in the JobStream, even if they are currently running.

  4. Data Manager will remove the SiteDim node from the JobStream and restart the execution process.

Answer: B

Question No: 45

Which of the following is true of the Navigator?

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

  2. When a component is selected, dependent components are shown.

  3. Library components (such as hierarchies) cannot be navigated.

  4. Components from different catalogs can be compared.

Answer: B

Question No: 46

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?

  1. Set the refresh type for the relational table delivery module to UPDATE.

  2. Set the refresh type for the relational table delivery module to TRUNCATE.

  3. Set the refresh type for the relational table delivery module to UPDATE/INSERT.

  4. Set the refresh type for the relational table delivery module to REPLACE.

  5. Set the refresh type for the relational table delivery module to APPEND.

  6. Set the refresh type for the relational table delivery module to INSERT.

Answer: C

Question No: 47

Why would an index be created on a fact table?

  1. To enable the rejecting of duplicate rows.

  2. To make it easier to drop and recreate the fact table.

  3. To enable the merging of duplicate rows.

  4. To improve update performance on a relational delivery.

Answer: D

Question No: 48

The following hierarchy has been created:

Ensurepass 2017 PDF and VCE

Before executing the dimension build, the developer wants to ensure that duplicate rows are excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?

  1. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.

  2. Specify that duplicate rows are to be rejected on the Audit tab of the dimension build#39;s properties.

  3. Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.

  4. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy#39;s properties.

Answer: D

Question No: 49

A developer has created a date hierarchy using the Date Hierarchy wizard. Which of the following is true of all the members in this hierarchy?

  1. All are retrieved from a database table using SQL.

  2. All are static and are physically stored in the catalog.

  3. All are retrieved from a flat file using SQL.

  4. All are dynamic and are physically stored in the catalog.

Answer: B

Question No: 50

In which Data Manager object does a developer specify the attributes of a conformed dimension, such as the surrogate keys that it contains?

  1. Reference dimension

  2. Connection

  3. Transformation model

  4. Template

Answer: D

100% Free Download!
Download Free Demo:C2020-625 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2020-625 V13 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE