Online Access Free C2020-180 Practice Test

Which Cognos 8 BI architectural component is written in C++?

• A.Batch report service
• B.Monitoring service
• C.Presentation service
• D.Job service

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

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 member functions
• B.may increase the time needed to fetch required data
• C.does not allow access to all relational items in Query and Report Studio
• D.may bypass aggregate aware tables

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."Based on this request, the following metrics have been identified: Flight count, and minutes early or late. Large carriers operate signifigantly more flights than small carriers. Which of the following additional metrics or calculations would provide the MOST value to the user?

• A.Origin/Departure airport count
• B.Average minutes early or late
• C.Percentage of flights 15 minutes early or late
• D.Average number of flights 15 minutes early or late

Which of the following describes common methods for enriching an initial dimension map?

• A.Include additional metrics and calculations and core metrics and dimensions from related business areas.
• B.Add exception and range band dimensions and include additional metrics and calculations.
• C.Merge dimensions andinclude additional metrics and calculations.
• D.Include additional metrics, calculations, and hierarchy levels, and dimensions from related subject areas.