Free IBM C2020-180 Exam Dumps Questions & Answers

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

• A.may increase the time needed to fetch required data
• B.does not allow access to all relational items in Query and Report Studio
• C.may bypass aggregate aware tables
• D.does not allow access to member functions

Which of the following statements describes the critical differences between a managed report and a query?

• A.A managed report is authored by trained developers whereas a query is authored by either trained developers or end users.
• B.A managed report is intended to be run on a regular execution schedule whereas a query is intended to be authored and run on-demand.
• C.A managed report is intended to be run on a regular execution schedule from a background batch process whereas a query is run interactively.
• D.A managed report prompts users for run-time parameters whereas a query does not.

Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?

• A.Drill down from summary to detailed information within individual subject areas.
• B.Drill across from one subject area to another through conformed dimensions.
• C.Star schema data marts designed to facilitate analysis and reporting.
• D.Event management designed to monitor the status of Key Performance Indicators.

Which of the following describes the benefits of Cognos Application Firewall (CAF)?

• A.It protects the application by monitoring all HTTP requests sent through the Web server to ensure the gateway is receiving valid requests.
• B.It monitors and validates all input requests to prevent parameter manipulation, SQL injection, and buffer overflow.
• C.It allowsCognos 8 BI to run over the Internet.
• D.It encrypts all input requests for validation before they are sent to the dispatcher.

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

• A.facilitate performing specific functional tasks
• B.record the day to day operations of the company
• C.maximize the speed of inserts and updates to the database
• D.enhance reporting through foreign keys and indexes