0

architecture Online Quiz - 25

Description: architecture Online Quiz - 25
Number of Questions: 20
Created by:
Tags: architecture
Attempted 0/20 Correct 0 Score 0

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


Correct Option: D

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


Correct Option: C

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


Correct Option: B

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


Correct Option: C

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


Correct Option: B
  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


Correct Option: E

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


Correct Option: B
  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


Correct Option: B

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


Correct Option: C

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


Correct Option: D

Rise in page reads per sec indicates

  1. Disk bottleneck

  2. Memory bottleneck

  3. Processor bottleneck

  4. Network bottleneck


Correct Option: B

Rise in percentage of disk time indicates

  1. I/O bottleneck

  2. Memory bottleneck

  3. Disk bottleneck

  4. Network bottleneck


Correct Option: C
  1. Insufficient memory

  2. Hardware issue

  3. Leak

  4. Improper configuration


Correct Option: C

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


Correct Option: D
  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


Correct Option: C
Explanation:

To answer this question, the user needs to have knowledge about system performance and its behavior.

Option A is incorrect because it is impossible to guarantee that a system will never face a performance problem again, even if it has been tested and tuned. There are various factors that can affect system performance, such as changes in workload, hardware failures, and network issues.

Option B is partially correct. If the system grows, it can lead to performance problems. As the workload increases, the system may not be able to handle the increased demand, resulting in poor performance. However, it is important to note that the growth of the system is not the only factor that can affect performance.

Option C is the most appropriate answer. A system can have a performance problem if it grows or if there are changes in the workload, hardware, or software. Even if a system has been tested and tuned, it may not be able to handle the increased demand or changes in the environment, resulting in performance problems.

Option D is incorrect because application changes are not the only factor that can lead to performance problems. While changes in the application can impact performance, other factors such as workload and hardware failures can also cause performance issues.

Therefore, the correct answer is:

The Answer is: C. It can have a performance problem if the system grows.

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


Correct Option: C

Performance problems are more likely in

  1. OS & HW

  2. Database

  3. Program

  4. Design


Correct Option: C

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


Correct Option: B
Explanation:

To solve this question, the user needs to understand the possible reasons for poor response from an online car dealer.

Option A: This option is unlikely to be true. Assuming the system administrator is competent, they would have checked the web or DBMS servers before giving an answer. It is also unprofessional to lie about a technical issue.

Option B: This option is likely to be true. Poor response from an online car dealer could be due to a network delay or an issue with the client PC. It is possible that the client PC is not powerful enough to handle the website's requirements, or that there is a delay in the network connection.

Option C: This option is unlikely to be true. Rebooting the system may fix some issues, but it is unlikely to solve a delay issue caused by a network or client PC.

Option D: This option is possible, but it is not the most likely scenario. Upgrading network capacity may be necessary if the website is receiving a large amount of traffic, but it is not the first solution to consider when facing poor response.

Therefore, the most likely answer is:

The Answer is: B. There is a delay either at network or client PC or both.

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


Correct Option: A

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


Correct Option: A

AI Explanation

To determine the number of machines required, we need to consider the memory consumed by the virtual users and the additional memory required for the operating system and other utilities.

Given: Memory consumed per virtual user = 2MB Number of virtual users = 1000 Additional memory per machine = 50MB

Total memory required for virtual users = Memory consumed per user * Number of users = 2MB * 1000 = 2000MB

Total memory required for the operating system and utilities per machine = 50MB

Total memory required per machine = Total memory required for virtual users + Total memory required for operating system and utilities = 2000MB + 50MB = 2050MB

Now, let's check the options:

A) 10 machines of 256MB Total memory available = 10 * 256MB = 2560MB Total memory required = 10 * 2050MB = 20500MB Since the total memory required is greater than the total memory available, this option is not sufficient.

B) 5 machines of 256MB Total memory available = 5 * 256MB = 1280MB Total memory required = 5 * 2050MB = 10250MB Since the total memory required is greater than the total memory available, this option is not sufficient.

C) 10 machines of 128MB Total memory available = 10 * 128MB = 1280MB Total memory required = 10 * 2050MB = 20500MB Since the total memory required is greater than the total memory available, this option is not sufficient.

D) 15 machines of 128MB Total memory available = 15 * 128MB = 1920MB Total memory required = 15 * 2050MB = 30750MB Since the total memory required is greater than the total memory available, this option is not sufficient.

Therefore, the correct answer is option A) 10 machines of 256MB.

- Hide questions