Which of the following can result in poor report performance?
A. reports with filters
B. models with outer joins and cross joins
C. queries with database only processing
D. an optimized metadata model
A developer can make a Cognos PowerCube available to end users by creating a package and publishing it. From which three components is this possible?
A. Administration console
B. PowerPlay Client
C. PowerPlay Studio
D. Framework Manager
E. Transformer
F. Microsoft Studio
A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating dat
A. Which of the following statements is valid when designing DMR structures in Framework Manager?
B. Measures and Dimensions can reside in the same query subject.
C. The DMR structures need to resemble the objects in the star schema.
D. The order of the Determinants drives the hierarchy levels.
E. Each level in a hierarchy must reference a text-based attribute for its caption.
What advantage does multidimensional report writing have on query maintenance for complex queries?
A. There is no need to use calculations as the data source contains all the required data items.
B. Fewer queries are required and the need for unions of queries is reduced due to the flexibility of MDX.
C. Unions and Joins are always required for queries making it easier for a developer to understand the query intent.
D. There is no advantage and multidimensional query constructs should be avoided.
Which dashboard formatting option would be used to take several images and text objects and combine them into one object to enable ease of movement and/or alignment?
A. Group objects
B. Layer objects
C. Combine objects
D. Pack objects
What is a Compare card in a Cognos Analytics Exploration?
A. A static view/card used to compare and view data across visualizations with different filters.
B. A view/card that uses a specialized algorithm (XGCompare) to analyse data and generate a driver
C. A view/card used to allow the interactive comparison of data across two visualizations with different filters.
D. A view/card used to compare data from one database with a different set of data from another database.
What is a Layout component reference intended to do in a report?
A. Allow pinned objects to be displayed in a report.
B. Allow reuse of Active Report components with other Active Reports.
C. Allow consumers to use report objects in Dashboards and Explorations.
D. Allow for the reuse of report objects between and within reports for consistency and efficiency.
Which two types of saved report outputs can be used when the Drill-through target type is set to Bookmark?
A. Excel Data
B. HTML
C. XML
D. CSV
E. PDF
What is a Cognos Analytics data set?
A. The data that is returned from the datasource and displayed within a report, dashboard or exploration.
B. The Cognos Analytics name for a Python DataFrame in a Jupyter Notebook.
C. An extract from a package or data module compressed, locally stored and refreshed periodically or manually.
D. A realtime set of data held in a streaming cache on the Cognos Analytics server.
To optimize the user experience for dashboards and explorations. Framework Manager packages must be enriched. Which statement is true about enriching Framework Manager packages?
A. A developer can't enrich a package that includes dimensionally modeled (DMR) relational objects.
B. Framework Manager packages are automatically enriched when published to Cognos Analytics.
C. To access the enrich package functionality, you need read/execute/traverse permissions for the package.
D. In order to have enough data to support the Al-functions in your dashboards and explorations, the entire Framework Manager package must be enriched.
