Software Performance Testing and Optimization

Questions about performance testing, troubleshooting, optimization, capacity planning, and performance metrics for software systems

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

A DBMS has a data cache hit ratio of 10%. What will you do to improve performance?

  1. Change the application code
  2. Do nothing
  3. Run every query twice
  4. Increase cache size significantly
Question 2 Multiple Choice (Single Answer)

A database of personal contacts is best implemented on

  1. A mainframe
  2. A Unix workstation
  3. A personal computer
  4. A massively parallel supercomputer
Question 3 Multiple Choice (Single Answer)

A claims processing system has had 5,000 requests made in the first hour and 4,900 requests have completed in the first hour. What is the number of requests pending in the claims processing system at the end of the first hour?

  1. 5000
  2. 100
  3. 4900
  4. 5
Question 4 Multiple Choice (Single Answer)

Approximately how much time does it take to transfer a 1 GB file over a 10 Mbps Ethernet LAN? Assume 20% degradation in bandwidth because of Ethernet overheads ?

  1. 1 hour
  2. 30 minutes
  3. 15 minutes
  4. 5 minutes
Question 5 Multiple Choice (Single Answer)

A customer's test server has 50% resources (Memory, CPU) compared to production server. What is your recommendation to carry out a performance test on a test server

  1. No need to do a performance test as test and production servers are not similar
  2. Recommend the customer to upgrade the test server equivalent to production server proir to the performance test
  3. Carry out the performance test with 50% anticipated production load
  4. Carry out the performance test with 100% anticipated production load
Question 6 Multiple Choice (Single Answer)

An application discovered performance issues though it was performance tested proir going live. Pick probable reason(s) why the performance issues were not discovered during testing

  1. Concurrent users defination unclear
  2. Test data not suffeciently populated
  3. Test & prod environments differ significantly
  4. Network bandwidth not simulated
  5. All of the above
Question 7 Multiple Choice (Single Answer)

Which of the below cannot remediate a performance problem associated with system memory (RAM)

  1. Cache frequently accessed data in system memory
  2. Dedicate system memory to specific tasks
  3. Add additional memory
  4. Create additional instances for parallel processing and load balancing
Question 8 Multiple Choice (Single Answer)

All of the below are potential to remediate oerformance problems associated with Network interface except

  1. Increase bandwidth
  2. Reduce packet size
  3. Add accelerator hardware when transporting secure data
  4. Improve performance on nodes within the network so the data is more readily available
Question 9 Multiple Choice (Single Answer)

1000 records of New India Insurance need to be transferred over a remote link from Jamnagar to Mumbai. Which of the following will deliver best performance?

  1. Transfer all records in one batch send
  2. Send one record at a time
  3. Compress all 1000 records into one message and send
  4. Compress one record at a time and send
Question 10 Multiple Choice (Single Answer)

An internet trading system with 64 Kbps lines to end users has been web enabled. The average web page size is 40 KB. Users are complaining about response times exceeding 2 seconds. What would you recommend as an immediate possibility to improve performance?

  1. Tuning of DBMS
  2. Tuning of web server
  3. Ask users to work at nights
  4. Use of a web booster such as Citrix or NetScaler
Question 11 Multiple Choice (Single Answer)

Rise in page reads per sec indicates

  1. Disk bottleneck
  2. Memory bottleneck
  3. Processor bottleneck
  4. Network bottleneck
Question 12 Multiple Choice (Single Answer)

Rise in percentage of disk time indicates

  1. I/O bottleneck
  2. Memory bottleneck
  3. Disk bottleneck
  4. Network bottleneck
Question 13 Multiple Choice (Single Answer)

A sustained increase in memory utilization of a process after start up signals

  1. Insufficient memory
  2. Hardware issue
  3. Leak
  4. Improper configuration
Question 14 Multiple Choice (Single Answer)

If an application is running slowly, which of the following is true?

  1. You can always improve performance by using more CPUs
  2. You can always improve performance by using more RAM
  3. You can always improve performance by using more disks
  4. None of the above
Question 15 Multiple Choice (Single Answer)

Once a system has been tested and tuned for performance

  1. It will never face a performance problem again
  2. It will have a performance problem if system grows
  3. It can have a performance problem if system grows
  4. It will have a performance problem only if application changes
Question 16 Multiple Choice (Single Answer)

You are approached to review an application code having performance issues. It is estimated that the code review will take 1 person year to go through all the code line by line. What is your recommendation in this scenario

  1. Take up the work and complete the review in estimated time
  2. Ask the customer to find exactly which part of the code has performance issue
  3. Take customers help to identify the portion(s) of the code that potentially have performance issues
  4. Recommned to use an automated tool to review the code to complete in quick amount of time
Question 17 Multiple Choice (Single Answer)

Performance problems are more likely in

  1. OS & HW
  2. Database
  3. Program
  4. Design
Question 18 Multiple Choice (Single Answer)

An end user of an online car dealer is facing poor response. The car dealer checks with the system administrator and is told that there is no problem in the web or DBMS servers. Which of the following is likely to be true?

  1. The system administrator is telling a lie
  2. There is a delay either at network or client PC or both
  3. The problem will get solved upon reboot
  4. Network capacity will need to be upgraded
Question 19 Multiple Choice (Single Answer)

A batch program in SQL Server 6.5 takes 3 days to complete, even though management would like it to finish in 3 hours. What is a very likely cause of poor performance?

  1. Bad index management
  2. Network delay
  3. Use of SQL Server 6.5 instead of 7.0
  4. Limitations of Microsoft technology
Question 20 Multiple Choice (Single Answer)

A load testing tool consumes 2MB per virtual user. In a benchmark with 1000 virtual users how many machines would you require. Assume 50MB for OS and other utilities (per machine).

  1. 10 machines of 256 MB
  2. 5 machines of 256 MB
  3. 10 machines of 128 MB
  4. 15 machines of 128 MB