IBM Cognos 10 BI Metadata Model Developer Set 1

1.

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

Create regular and measure dimensions and set scope. Create shortcuts to regular dimensions and fact query subjects. Create star schema groupings for dimension and fact query subjects. Create relationships between regular dimensions and measure dimensions.

2.

Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the month grain in the Sales Target Fact table. In Framework Manager, which technique will best prevent Sales Target values from being double- counted in Query Studio reports?

Define both Month and Day determinant levels in the Time Dimension and Group By Day. Define both Month and Day determinant levels in the Time Dimension and Group By Month. Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain. Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.

3.

To ensure a query subject is recognized as a fact by the Cognos 10 query engine in all query scenarios, the query subject requires which cardinality rule?

One instance of attached cardinality must be 1..1. One instance of attached cardinality must be 1..n. All instances of attached cardinality must be either 1..n or 0..n. All instances of attached cardinality must be either 1..1 or 0..n.

4.

The generated Cognos SQL below contains which one of the following joins?

Inner join on RETURN_REASON_KEY. Outer join on RETURN_REASON_KEY. Left inner join on RETURN_REASON_KEY. Left outer join on RETURN_REASON_KEY.

5.

Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

Resolve conflicting keys and indexes and generate minimized SQL. Combine facts and dimensions for intuitive ad hoc business views. Resolve reporting traps and simplify snowflake tables through consolidation. Provide dimensional information through the use of determinants.

6.

In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?

Import the stored procedure, add it as a model calculation, and then publish it as part of a package. Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package. Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package. Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish itas part of a package.

7.

In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?

To generate the most efficient SQL at run time and simplify model maintenance. To prevent the exclusion of columns from a table that may be required in future reports. To prevent improperly constructed SQL and reduce issues with model documentation and readability. To provide authors with access to all columns in a databasetable which reduces requests to the modeler?

8.

In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

Open the Relationship Definition dialog, and then edit the join expression as required. Select the relationship, and then from the Actions menu, select Merge in New Query Subject. Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1. Right-click a relationship in the Object diagram or Context Explorer, and then select Create Compound Join.

9.

What does a star schema database structure typically consist of?

De-normalized hierarchy of dimension tables and fact tables. Normalized dimension tables and detailed fact tables. Normalized dimension tables and summarized fact tables. De-normalized dimension tables and fact tables.

10.

In a transitive relationship scenario, what problems exist when reporting from the tables below?

The Order table must be included in each query. The Order Detail table has conflicting cardinalities. The priority path must be defined. There is more than one possible path between the tables.

IBM Cognos 10 BI Metadata Model Developer Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Cognos 10 BI Metadata Model Developer Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner