Vcehome > IBM > IBM Certified Solution Expert > C2090-180 > C2090-180 Online Practice Questions and Answers

C2090-180 Online Practice Questions and Answers

Questions 4

Which of the following is correct regarding report execution requests?

A. A low affinity request is directed to the same process that served up the originating low affinityrequest if the process is available and there is an available high affinity connection.

B. A low affinity request can be processed using a high affinity connection when a low affinityconnection is not available.

C. An absolute affinity request does not require a connection because it has priority.

D. A high affinity request can be processed using a low affinity connection if there are no highaffinity connections available.

Browse 66 Q&As
Questions 5

Which service is required when a user views saved report output?

A. presentation service

B. report data service

C. report service

D. batch report service

Browse 66 Q&As
Questions 6

You are tasked with administering theCognos BIsystem to perform batch reporting in a waythat maximizes the use of available system resources. Given the following information, how manyjobs should be created to perform this task?

480 reports must run

6 report processes are available

Each process is configured to use 4 low affinity connections

A. 20

B. 24

C. 48

D. 12

Browse 66 Q&As
Questions 7

A consultant realizes after determining business requirements, that a complete solution willrequire several related but separate projects. The consultant must choose one project to deliverfirst. Which of the following describes the considerations that should govern that choice?

A. Priority of IT, ease of development, resource availability, and data availability

B. Business impact, ease of development, resource availability, and number of target users

C. Data availability, ease of development, resource availability, and position of project sponsor inthe organization

D. Business impact, data availability, ease of development, and resource availability

Browse 66 Q&As
Questions 8

A user makes the following request:"I need to see actual sales compared with projected sales,and margin range for branches within each division, by product line, sales rep by sales manager,and cost center over time." Based on the user's request, Actual Sales and Projected Sales havebeen identified as required measures.

Which of the following other measures would be includedin an initial dimension map?

A. Unit Cost

B. Average Sales

C. Discount Amount

D. Sales Variance

Browse 66 Q&As
Questions 9

Which of the following allows greatest flexibility in formatting but generally has the lowestinteractivity with the users?

A. Analysis

B. Query

C. Dashboards

D. Managed Reports

Browse 66 Q&As
Questions 10

When considering the differences between Analysis, Reporting, and Querying, which of thefollowing is NOT a user who needs Analysis?

A. A user who takes answers from one question as a starting point for other questions

B. A user who needs to understand multiple factors influencing performance

C. A user who needs to identify and understand trends from multiple perspectives

D. A user who views detailed data, which is optionally totaled and subtotaled

Browse 66 Q&As
Questions 11

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

A. does not allow access to all relational items in Query and Report Studio

B. may increase the time needed to fetch required data

C. does not allow access to member functions

D. may bypass aggregate aware tables

Browse 66 Q&As
Questions 12

All of the following describe design intent of an operational database EXCEPT:

A. record the day to day operations of the company

B. maximize the speed of inserts and updates to the database

C. enhance reporting through foreign keys and indexes

D. facilitate performing specific functional tasks

Browse 66 Q&As
Questions 13

Which of the following describes the models contained in the '24 Ways' book referenced in the BIProfessional Workshop course?

A. Framework Manager models that map over an example normalized database, which one mightfind in a manufacturing enterprise.

B. Physical, star schema data models for constructing data marts for the various departments in ageneric business enterprise.

C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.

D. Cognos 8 OLAP Modeler (Transformer) models that describe how to map data from amanufacturing database into a PowerCube.

Browse 66 Q&As
Exam Code: C2090-180
Exam Name: IBM Cognos BI Professional
Last Update: Apr 23, 2024
Questions: 66 Q&As

PDF

$49.99

VCE

$59.99

PDF + VCE

$67.99