BI0-132試験無料問題集（53題）「COGNOS Cognos 8 BI Metadata Model Developer 認定」

出題：1

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?

A. Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.

B. Define both Month and Day determinant levels in the Time Dimension and Group By Day.

C. Define both Month and Day determinant levels in the Time Dimension and Group By Month.

D. Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.

正解：C 解答を投票する

出題：2

Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

A. query item

B. query subject

C. namespace

D. model

正解：C 解答を投票する

出題：3

In Framework Manager, which of the following is a correct technique for maintaining packages?

A. Edit the contents of a package by including or excluding model objects such as namespaces, folders, and query subjects.

B. Perform an impact analysis on a package to identify the impact of changing the cardinality of a relationship between two query subjects included in the package.

C. Publish packages to the network as well as to the content store in order to maintain model versioning and prevent report errors.

D. When publishing packages, use file system version control so that reports created based on one version of a model will always run against that same version of the model regardless of how many times the package is published.

正解：A 解答を投票する

出題：4

Which of the following join types does the generated SQL below illustrate? select Manager.Manager as Manager, Product.Product as Product from
datasource_name.database_name.schema.Manager Manager datasource_name.database_name.schema.Product Product

A. Cross join

B. Union join

C. Outer join

D. Inner join

正解：A 解答を投票する

出題：5

Which of the following is true of the generated native SQL below? select
"RETURNED_ITEM"."RETURN_QUANTITY" AS
"RETURN_QUANTITY",
"RETURN_REASON"."REASON_DESCRIPTION_EN" AS "REASON_DESCRIPTION_EN"
from
(select "RETURNED_ITEM"."RETURN_REASON_CODE",
"RETURNED_ITEM"."RETURN_QUANTITY" from
"GOSL"."dbo"."RETURNED_ITEM",
"GOSL"."dbo"."ORDER_HEADER"
"ORDER_HEADER", "GOSL"."dbo"."ORDER_DETAILS" "ORDER_DETAILS"
where
"RETURNED_ITEM"."ORDER_DETAIL_CODE" =
"ORDER_DETAILS"."ORDER_DETAIL_CODE" and "ORDER_HEADER"."ORDER_NUMBER" =
"ORDER_DETAILS"."ORDER_NUMBER")
"RETURNED_ITEM"
inner join
"GOSL"."dbo"."RETURN_REASON" "RETURN_REASON"
on
"RETURN_REASON"."RETURN_REASON_CODE" =
"RETURNED_ITEM"."RETURN_REASON_CODE"

A. The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.

B. The derived table is executed independently, using Pass-Through SQL, and then processed locally.

C. The parent select statement uses an inner join to directly match columns from physical tables in the database.

D. The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set.

正解：D 解答を投票する

BI0-132試験無料問題集「COGNOS Cognos 8 BI Metadata Model Developer 認定」