IBM C2090 180 Cognos BI Professional

Question - 21 Maximum mark : - 39

Home
All Exams
IBM C2090 180 Cognos BI Professional Online Mock Tests
IBM C2090 180 Cognos BI Professional

Which of the following describes an advantage of using the dimensionally modeled relational (DMR) technique to access a normalized data structure?

eliminates the need for aggregate tables ✘ reduces the time needed to fetch the required data ✘ enables drill up/down functionality in reports and ad hoc queries ✘ enables creation of IQDs for creating Power Cubes ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

When examining an operational (transactional) database, which of the following is considered a good indicator as to which tables contain fact data?

Tables with the fewest number of columns ✘ Tables with the greatest number of rows ✘ Tables with the greatest number of foreign keys ✘ Tables with the fewest number of foreign keys ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following requires additional configuration for installing Cognos BI in a development and production environment?

The application in the development environment and in the production environment will use the Tomcat servlet container as the application server. ✘ The development environment will include workstations hosting Framework Managerand Cognos 8 OLAP Modeling, while the production environment will not. ✘ The environment contains customized port and firewall settings for the default http andapplication server port. ✘ The development and production environment will use data sources that are in Unicode. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A developer has specified a maximum of two report processes for the application. While monitoring the application, the developer notices that only one report process is running. Which of the following would account for this?

The number of affinity connections per BI Bus is set too high. ✘ The configuration size for the application is set too low. ✘ The number of low affinity connections has been exceeded. ✘ The number of report requests is too high. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following statements best describes the Iterative Approach of application development?

A prototype solution is developed after the initial user interviews. This prototype is then used as a basis for refining specific design requirements. ✘ The design step is repeated multiple times before proceeding to the development step.Each pass through the design step further refines the eventual solution. ✘ The solution is developed and delivered to the users. After approximately 2 weeks, theusers are interviewed for any missing requirements and any new requirements form the

basis for the next iteration. ✘ A prototype is created that addresses 80 to 90% of the business requirements. This isdemonstrated to the users and their feedback is used to refine the prototype in subsequent

iterations. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following statements describes the critical differences between a managed report and a query?

A managed report is intended to be run on a regular execution schedule from a background batch process whereas a query is run interactively. ✘ A managed report is authored by trained developers whereas a query is authored by eithertrained developers or end users. ✘ A managed report is intended to be run on a regular execution schedule whereas a queryis intended to be authored and run on-demand. ✘ A managed report prompts users for run-time parameters whereas a query does not. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

If anonymous access is disabled, when a user accesses Cognos BI, what is the correct flow of the request?

To Cognos Access Manager which queries the content store for user information and displays the log on page through the dispatcher and the gateway ✘ To the monitoring service which monitors the user authentication request and displaysthe log on page through the dispatcher and the gateway ✘ To the presentation service which displays the log on page through the dispatcher and thegateway ✘ To Cognos Application Firewall which monitors the user authentication request anddisplays the log on page through the dispatcher and the gateway ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following MOST clearly states the value of using a methodology?

It provides a philosophy of development that maximizes return on investment. ✘ It helps consultants progress in a systematic way to insure all critical steps are addressed. ✘ It helps project managers estimate the cost and effort in developing a solution. ✘ It ensures that early mistakes are avoided in developing a solution. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following describes how Cognos 8 works with aggregate aware tables in relational data sources?

Cognos 8 can create aggregate aware tables within the database. ✘ Cognos 8 redirects its generated SQL to take advantage of aggregate aware tables. ✘ Cognos 8 does not make any specific adjustments for aggregate aware tables. ✘ Cognos 8 can monitor reports that are run and suggest aggregate aware tables. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

The partial diagram below is an example of what type of database schema design?

star schema ✘ snowflake schema ✘ normalized schema ✘ de-normalized schema ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM C2090 180 Cognos BI Professional

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