CMU-CS445PIS_Midterm

(0.2 point) When should presentation integration be chosen over data or functional integration?

• When cost and time are limited, and only the user interface needs unification

• When direct API access to core logic is needed

• When databases must be synchronized in real time

• When cloud-native microservices are required

(0.2 point) A database system using ODBC or JDBC connectors represents which integration model?

• Presentation Integration

• Functional Integration

• Data Integration

• Event-driven Integration

(0.2 point) Evaluating a system’s compliance with standards like GDPR, ISO 27001, or NIST is part of which IT governance activity?

• System Deployment

• Change Management

• Risk and Compliance Assessment

• Performance Optimization

(0.2 point) Which action most effectively improves system reliability in an integrated environment?

• Scaling up server hardware

• Implementing data redundancy and failover clusters

• Reducing concurrent users

• Using a faster front-end framework

(0.2 point) How does a security service contribute to compliance with security regulations?

• By ensuring access control, logging, and authentication

• By increasing system throughput

• By simplifying development

• By reducing data replication

(0.2 point) Which integration style can cause a “ripple effect” when database schema changes occur?

• File Transfer

• Shared Database

• Messaging

• API Gateway

(0.2 point) Which method is used to send notifications between applications via message queues (e.g., RabbitMQ, Kafka)?

• File Transfer

• Shared Database

• Messaging

• Remote Procedure Invocation

(0.2 point) What is a main disadvantage of file transfer-based integration?

• Real-time synchronization difficulty

• Excessive API overhead

• Complex message routing

• Requires database triggers

(0.2 point) What is the primary goal of database normalization?

• Reduce redundancy and update anomalies

• Improve UI response speed

• Simplify backup procedures

• Minimize server storage cost

(0.2 point) What does Second Normal Form (2NF) require?

• Remove repeating groups

• Remove partial dependencies on a composite key

• Eliminate all transitive dependencies

• Introduce surrogate primary keys