Purchase IBM : COG-615 Exam Materials and then pass exam easily

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. Increase the invalidation schedule frequency.
• B. Add an index to the ProductTag field.
• C. Remove the Product_Description and UnitPrice fields from the lookup table query.
• D. Add an index to the Product_ID field.

A customer currently has the username and password specified in clear text on the JDBC URL for their JDBC agent. Their security team has identified this configuration as a security risk for their company. What do you tell the customer?

• A. Use an appserver configured data source instead of the JDBC URL.
• B. Create a separate database user account with limited access.
• C. Specifythe username and password in the corresponding username and password fields.
• D. Use database supported encryption to encode the username and password in the URL.

A user wants to build a dashboard for an operations manager who wants to monitor the number of unsatisfied customer calls which were not resolved by thecall center representative and had to be escalated. The operations manager wants to monitor this over five minute intervals, over one day, and compare them with a similar trend over the last ten years. Daily transactional data is stored in a database, andis loaded into a data warehouse nightly for historical analysis and purged weekly. Which two actions achieve this using the Cognos suite of products? (Choose two.)

• A. Use RTM to model both a five minute and a 10-year trend chart using the temporal windows functionality based on the database data for data streams and the data warehouse for a lookup table.
• B. Use Business Intelligence to model both the 10-year trending and the five-minute trend chart based on the data warehouse and display them in the Business Insight workspace.
• C. Use Business Intelligence to model a 10-year trend chart based on the data warehouse and RTM to model a five minute trend chart based on the database and display them together in the Business Insight workspace.
• D. Use Real-time Monitoring (RTM) to model both a five minute and a 10-year trend chart using the temporal windows functionality based on the database data only.

A user is complaining that the Real-time Monitoring objects on their BusinessInsight dashboard appear to have data that is more than 15 minutes old. What are two possible causes for this problem? (Choose two.)

• A. The dashboard refresh interval is too high.
• B. The lookup table invalidation cache is too frequent.
• C. The widget refresh interval is too high.
• D. The polling interval ofthe source JDBC data stream is too infrequent.

A small banking customer is using Real-time Monitoring (RTM) to monitor and notify customers if they are over drafting their checking accounts. Customer information like name and e-mail address are in a DB2database and joined to the data based on the account ID. The customers all have accounts in RTM and are members of the "Customers" role. The alert should only be sent to the primary e-mail account and not shown on the RTM dashboard. What must you do to accomplish this goal?

• A. Choose the "Account ID" column for a data-driven subscription.
• B. Subscribe the "Customers" role to the alert as a mandatory subscriber.
• C. Subscribe each user fromthe "Customers" role to the alert as an optional subscriber.
• D. Choose the "Email" column for a data-driven subscription.