Online Access Free C2020-632 Practice Test

An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column?

• A.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2
• B.XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
• C.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
• D.XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

• A.Add performance indicators to functions.
• B.For a query item having an integer data type, set the Display Item Reference property to display an integer value.
• C.Configure data sources in a project pointing to the same database instance to use the same connection.
• D.Create stand-alone filters.

In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons?

• A.Creates an easy-to-read data dictionary for end users.
• B.Ensures inner joins between data source query subjects.
• C.Provides stability to the underlying data structure.
• D.Helps to remove ambiguity and provide predictable results.

Which of the following is correct regarding the Cognos 10 security environment?

• A.In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.
• B.To perform authentication of users, a connection to the Cognos namespace must be defined.
• C.Cognos 10 must be configured to use only one authentication provider at a time.
• D.In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.

In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following?

• A.Viewing the properties of the query subjects in Report Studio.
• B.Viewing the properties of the query subjects in Framework Manager.
• C.Using the same name for the dimension in each star schema grouping.
• D.Using a different query subject icon for display in the studios.