IBM Cognos BI Professional - COG-180 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Companies often create a collection of summary tables as their first attempt at a data warehouse. While there are several drawbacks to this approach, there are also some advantages. Which of
the following is an advantage of this approach over reporting from an operational database?

A. Over time summary tables often naturally group into business subject areas. B. It is easier to understand because there are fewer summary tables. C. Specific reports for which the summary tables were created will run faster. D. It is easy to leverage many new reports from the summary tables.

Discussion 0

Correct Answer: C Vote an answer

Question 2

A user makes the following request:"I need to see the number of flights throughout the year that arrived or departed more than 15 minutes early or late by origin and destination airport, by carrier, and by time of day. I want to see if the number of flights delayed is greater for large carriers or small carriers."This request requires clarification to make the user's intention clear. Which of the following will NOT further clarify the user's request?

A. Determine the definition of a large and small carrier. B. Determine if 15 minutes is the only significant grouping of late or early departures or arrivals. C. Determine if Date and Time of Day should be split into separate dimensions. D. Determine if origin and destination airports should be considered joined pairs (for example, from DFW to ORD) or as separate dimensions.

Discussion 0

Correct Answer: C Vote an answer

Question 3

A consultant realizes after determining business requirements, that a complete solution will require several related but separate projects. The consultant must choose one project to deliver first. 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. Business impact, data availability,ease of development, and resource availability D. Data availability, ease of development, resource availability, and position of project sponsor in the organization

Discussion 0

Correct Answer: C Vote an answer

Question 4

Using the diagram below to install and configure Cognos 8 BI, which of the following components will NOT address automatic failover?

A. Cognos 8 BI Gateway B. Cognos 8 BI Report Server C. Cognos 8 BI Content Manager (Active) D. Cognos 8 BI Content Manager (Passive)

Discussion 0

Correct Answer: A Vote an answer

Question 5

A table is in Third Normal Form if it is already in Second Normal Form, plus:

A. All surrogate keys are determined by the primary key B. All foreign keys are determined by the primary key C. All attributes are determined by all segments of the primary key D. All attributes are determined only by the primary key

Discussion 0

Correct Answer: D Vote an answer

Question 6

Which of the following is correct regarding the processing of a PageDown high affinity request?

A. The request is automatically queued and is processed by the first available low affinity connection in the system. B. The request is given priority and is always processed by the same process that served up the originating low affinity request. C. The request is routed to the same process that served up the originating low affinity request if the process is available and if there is an available high affinity connection. D. The request is load-balanced and is sent to any available dispatcher in the system.

Discussion 0

Correct Answer: C Vote an answer

Question 7

Which of the following is a key difference between MDX and SQL?

A. MDX is used for dimensional style reporting while SQL is incapable of dimensional style reporting. B. MDX can reference metadata that SQL cannot. C. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL. D. MDX has built in functions to support relative date calculations while SQL cannot perform relative date calculations.

Discussion 0

Correct Answer: B Vote an answer