CIS Performance Optimization & Monitoring 3

Question 1

Which practice is MOST important when optimizing database performance in a large enterprise system implementation?

Accepted Answer

Regularly analyzing query performance, maintaining indexes, and archiving obsolete data

Answer

Storing all data in a single flat table for simplicity

Answer

Limiting all queries to return no more than 10 records

Answer

Disabling database logging to reduce overhead

Question 2

A CIS specialist discovers that a third-party integration is introducing a 5-second delay in every transaction. What is the recommended approach to diagnose this?

Accepted Answer

Use API monitoring and logging to isolate whether the delay originates in the request, the third-party response, or the processing of the response

Answer

Immediately terminate the integration

Answer

Increase the transaction timeout threshold

Answer

Remove all third-party integrations from the system

Question 3

In performance optimization, what does 'throughput' measure?

Accepted Answer

The number of transactions or operations the system can process within a given time period

Answer

The maximum number of users allowed in the system at once

Answer

The disk space consumed per transaction

Answer

The number of errors encountered per hour

Question 4

Which technique helps reduce server response time by offloading static asset delivery (images, scripts, stylesheets) to geographically distributed servers?

Accepted Answer

Content Delivery Network (CDN) implementation

Answer

Data encryption at rest

Answer

Multi-factor authentication

Answer

Role-based access control

Question 5

What is 'vertical scaling' in the context of system performance optimization?

Accepted Answer

Increasing the resources (CPU, RAM, storage) of an existing server to handle greater demand

Answer

Adding more servers to distribute the workload

Answer

Rewriting the application in a more efficient programming language

Answer

Splitting a monolithic application into microservices

Question 6

A CIS professional is tasked with reducing end-user perceived latency in a web-based ERP system. Which front-end optimization is MOST impactful?

Accepted Answer

Minimizing and compressing JavaScript and CSS files, and enabling browser caching

Answer

Increasing the number of database administrators

Answer

Adding more menu items for user navigation

Answer

Expanding the color scheme of the UI

Question 7

During a performance review, you find that CPU utilization on the application server consistently spikes to 95% between 9–10 AM. What is the recommended next step?

Accepted Answer

Profile the application to identify the specific processes or jobs consuming CPU during that window, then optimize or reschedule them

Answer

Shut down the server and restart it each morning at 8:55 AM

Answer

Warn users not to log in during that hour

Answer

Immediately purchase a new server without further investigation