IBM Cognos Real-time Monitoring Developer Sample Questions:

1. An analyst has been asked to build a rule, alert, and reportlet in Real-time Monitoring (RTM). The rule that triggers the alert fires when: ord_qty>1000. Areportlet should be attached to the alert containing relevant and supplemental information based on the exception information that the rule detected. The view on which the reportlet is based is grouped by product and defines Average_Quantity as: AVERAGE(ord_qty). When attaching the reportlet the analyst created a rule filter based on the data in the data stream. The rule filter is defined as: ord_qty > 3000.When attaching a reportlet to an alert, which two descriptions are true? (Choose two.)

A) The reportlet will never include rows where the Average_Quantity is less than 3000.
B) The reportlet may be attached without any rows of data.
C) The reportlet will always include a row for the product that was in the event that triggered the alert.
D) The reportlet may include a row where an ord_qty column included in the average is between 1000 and 3000.

2. A banking customer needs to monitor transactions and determinewhen processing is out of normal operating ranges. The metrics will compare transaction rates processed in a 10 minute window to other rates measured in that same 10 minute window (same day of week and time interval), averaged over the previous 30 days. Transaction data is distributed over MQ Series middleware and an Oracle database is available for historical trending analysis. Alerts need to be sent when the latest 10 minute window is over 1000 percent of the previous 30-day average. Which statement is correct about Real-time Monitoring (RTM)?

A) RTM can perform all of the requirements described.
B) RTM can perform all of requirements exceptfor the alert conditions.
C) RTM can aggregate the transaction data by 10 minute windows, but cannot do the historical data comparisons.
D) RTM can only access data stored in the Oracle database.

3. Acustomer has built a lookup table named "Prods" on a database with the following query: SELECT Product_ID, 'D' || cast(Product_ID as VARCHAR) as ProductTag, Product_Name, Product_Description, UnitPrice FROM PRODUCTS.They have built a dimension named "Prod_dim" on this lookup table with the following structure: Hierarchy: Product_Name, Product_ID Key Field: ProductTag. What are two ways to improve performance, assuming there are no other objects using Prods? (Choose two.)

A) Remove the Product_Description and UnitPrice fields from the lookup table query.
B) Add an index to the ProductTag field.
C) Increase the invalidation schedule frequency.
D) Add an index to the Product_ID field.

4. Auser wants to set up an escalation rule for an alert which was still in an exception condition for more than two hours. Which function should be used in the rule?

A) IS_ACKED
B) HOLDS_FOR
C) IS_RAISED
D) ESCALATE

5. A data stream uses a query that returns a data set that contains the following fields: Order_id -- a unique row ID Num_Ordered -- the quantity of items contained in the orders Order_Timestamp -- time that the order was placed in the source systemA view containing a column measure named Order_Count is defined to be "mov_count(Order_ID, HOUR, 3, Order_Timestamp)" is created using this data stream. Which records from the data stream result set will be included in the Order_Count calculation?

A) order records processed where the Order_Timestamp of the record is within three hours of the most recent Order_Timestamp record in the view
B) order records processed where the Order Timestamp of the record is within three hours of the current system time for any order record in the view
C) order records processed within three hours of the current system time
D) order records processed where the Order_Timestamp of the record is within three hours of the current system time

Solutions: