Online Access Free C2020-180 Practice Test

When following the Information Focused approach, what should the users bring to the initial interview?

• A.Job responsibilities, objectives, what information they need to get their work done, and copies of key reports
• B.Job responsibilities, objectives, and a list of reports they desire
• C.List of reports they desire, what information they need to get their work done, and structure of database tables
• D.Copies of key reports, structure of database tables, job responsibilities, and objectives

The partial diagram below is an example of what type of database schema design?

• A.de-normalized schema
• B.star schema
• C.snowflake schema
• D.normalized schema

Why should an application's performance be monitored on an ongoing basis after it goes into production?

• A.Initial performance tests are usually too optimistic.
• B.New releases of system and application software usually degrade performance.
• C.There is little value in performance tests before a system goes into production.
• D.Usage patterns on applications tend to change over time.

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.Data availability, ease of development, resource availability, and position of project sponsor in the organization
• B.Business impact, ease of development, resource availability, and number of target users
• C.Priority of IT, ease of development, resource availability, and data availability
• D.Business impact, data availability,ease of development, and resource availability

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

• A.enables creation of IQDs for creating Power Cubes
• B.eliminates the need for aggregate tables
• C.enables drill up/down functionality in reports and ad hoc queries
• D.reduces the time needed to fetch the required data