<< Prev Question Next Question >>

Question 20/142

A systems administrator is diagnosing performance issues on a web application. The web application sends thousands of extremely complex SQL queries to a database server, which has trouble retrieving the information in time. The administrator checks the database server and notes the following resource utilization:
CPU: 64%
RAM: 97%
Network throughput: 384,100Kbps.
Disk throughput: 382,700Kbps
The administrator also looks at the storage for the database server and notices it is consistently near its OPS limit. Which of the following will BEST resolve these performance issues?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (142q)
Question 1: A systems administrator is deploying a new virtualized envir...
Question 2: A systems administrator is performing upgrades to all the hy...
Question 3: A resource pool in a cloud tenant has 90 GB of memory and 12...
Question 4: A systems administrator is deploying a new storage array for...
Question 5: A cloud engineer has deployed a virtual storage appliance in...
Question 6: Which of the following strategies will mitigate the risk of ...
Question 7: A system administrator supports an application in the cloud,...
Question 8: A company is using an laaS environment. Which of the followi...
Question 9: A technician is working with an American company that is usi...
Question 10: A systems administrator is helping to develop a disaster rec...
Question 11: A security audit related to confidentiality controls found t...
Question 12: A systems administrator needs to migrate email services to t...
Question 13: A company is utilizing a private cloud solution that is host...
Question 14: A systems administrator adds servers to a round-robin, load-...
Question 15: An organization is required to set a custom registry key on ...
Question 16: An organization is hosting a DNS domain with private and pub...
Question 17: A systems administrator is configuring a storage array. Whic...
Question 18: Which of the following definitions of serverless computing B...
Question 19: A vendor is installing a new retail store management applica...
Question 20: A systems administrator is diagnosing performance issues on ...
Question 21: An administrator has been informed that some requests are ta...
Question 22: A systems administrator is asked to implement a new three-ho...
Question 23: A cloud architect wants to minimize the risk of having syste...
Question 24: A highly regulated business is required to work remotely, an...
Question 25: A systems administrator needs to configure SSO authenticatio...
Question 26: An organization will be deploying a web application in a pub...
Question 27: A cloud administrator is managing an organization's infrastr...
Question 28: An OS administrator is reporting slow storage throughput on ...
Question 29: A developer is no longer able to access a public cloud API d...
Question 30: A cloud administrator has created a new asynchronous workflo...
Question 31: A cloud solutions architect has received guidance to migrate...
Question 32: An SQL injection vulnerability was reported on a web applica...
Question 33: A systems administrator would like to reduce the network del...
Question 34: A company wants to check its infrastructure and application ...
Question 35: An organization purchased new servers with GPUs for render f...
Question 36: A storage administrator is reviewing the storage consumption...
Question 37: Which of the following actions should a systems administrato...
Question 38: An organization has multiple VLANs configured to segregate t...
Question 39: After a few new web servers were deployed, the storage team ...
Question 40: A marketing team is using a SaaS-based service to send email...
Question 41: A DevOps administrator is building a new application slack i...
Question 42: A systems administrator disabled TLS 1.0 and 1.1, as well as...
Question 43: A cloud administrator has finished setting up an application...
Question 44: A company has two primary offices, one in the United States ...
Question 45: A storage array that is used exclusively for datastores is b...
Question 46: A company is considering consolidating a number of physical ...
Question 47: After announcing a big sales promotion, an e-commerce compan...
Question 48: A disaster situation has occurred, and the entire team needs...
Question 49: A cloud security analyst is implementing a vulnerability sca...
Question 50: A systems administrator is troubleshooting network throughpu...
Question 51: An organization is currently deploying a private cloud model...
Question 52: A systems administrator recently deployed a VDI solution in ...
Question 53: A cloud administrator is reviewing a new application impleme...
Question 54: Users currently access SaaS email with five-character passwo...
Question 55: A cloud architect is reviewing four deployment options for a...
Question 56: A system administrator is migrating a bare-metal server to t...
Question 57: A systems administrator has received an email from the virtu...
Question 58: Over the last couple of years, the growth of a company has r...
Question 59: A systems administrator wants the VMs on the hypervisor to s...
Question 60: A systems administrator is troubleshooting performance issue...
Question 61: A systems administrator is configuring network management bu...
Question 62: A company is currently running a website on site. However, b...
Question 63: Which of the following cloud services is fully managed?...
Question 64: A cloud administrator is upgrading a cloud environment and n...
Question 65: A cloud administrator recently noticed that a number of file...
Question 66: After accidentally uploading a password for an IAM user in p...
Question 67: An organization has a public-facing API that is hosted on a ...
Question 68: A cloud administrator is assigned to establish a connection ...
Question 69: A web-application company recently released some new marketi...
Question 70: A company is preparing a hypervisor environment to implement...
Question 71: A company is switching from one cloud provider to another an...
Question 72: A product-based company wants to transition to a method that...
Question 73: A cloud architect is designing the VPCs for a new hybrid clo...
Question 74: A systems administrator is deploying a solution that include...
Question 75: A cloud engineer recently used a deployment script template ...
Question 76: A cloud administrator is monitoring a database system and no...
Question 77: An organization is hosting its dedicated email infrastructur...
Question 78: A systems administrator must ensure confidential company inf...
Question 79: A cloud administrator has built a new private cloud environm...
Question 80: A systems administrator is creating a VM and wants to ensure...
Question 81: A production engineer is configuring a new application, whic...
Question 82: A systems administrator is responding to an outage in a clou...
Question 83: An administrator is securing a private cloud environment and...
Question 84: A cloud architect is deploying a web application that contai...
Question 85: An organization is hosting a cloud-based web server infrastr...
Question 86: A systems administrator is examining a managed hosting agree...
Question 87: An administrator recently provisioned a file server in the c...
Question 88: A cloud administrator is evaluating a solution that will lim...
Question 89: A database analyst reports it takes two hours to perform a s...
Question 90: An IaaS provider has numerous devices and services that are ...
Question 91: A systems administrator is working in a globally distributed...
Question 92: A large pharmaceutical company needs to ensure it is in comp...
Question 93: A cloud security engineer needs to ensure authentication to ...
Question 94: A media company has made the decision to migrate a physical,...
Question 95: A systems administrator is concerned about having two virtua...
Question 96: A financial industry services firm was the victim of an inte...
Question 97: A company has two identical environments (X and Y) running i...
Question 98: A systems administrator is provisioning VMs in a cloud envir...
Question 99: A systems administrator is troubleshooting a performance iss...
Question 100: A company has a cloud infrastructure service, and the cloud ...
Question 101: A systems administrator needs to implement a service to prot...
Question 102: A company needs to rehost its ERP system to complete a datac...
Question 103: A cloud administrator is troubleshooting a highly available ...
Question 104: A technician deployed a VM with NL-SAS storage to host a cri...
Question 105: A DevOps administrator is automating an existing software de...
Question 106: The human resources department was charged for a cloud servi...
Question 107: A systems administrator is configuring a cloud solution for ...
Question 108: A cloud administrator is configuring several security applia...
Question 109: A company is migrating workloads from on premises to the clo...
Question 110: A company needs a solution to find content in images. Which ...
Question 111: A systems administrator is configuring RAID for a new server...
Question 112: A systems administrator is planning a penetration test for c...
Question 113: A systems administrator has been asked to restore a VM from ...
Question 114: A cloud administrator needs to coordinate and automate the m...
Question 115: The QA team is testing a newly implemented clinical trial ma...
Question 116: Users of an enterprise application, which is configured to u...
Question 117: A cloud solutions architect needs to determine the best stra...
Question 118: A systems administrator in a large enterprise needs to alter...
Question 119: A company had a system compromise, and the engineering team ...
Question 120: An organization has two businesses that are developing diffe...
Question 121: An organization suffered a critical failure of its primary d...
Question 122: A systems administrator is troubleshooting performance issue...
Question 123: A SaaS provider wants to maintain maximum availability for i...
Question 124: Which of the following will mitigate the risk of users who h...
Question 125: A systems administrator received an email from a cloud provi...
Question 126: A cloud administrator implemented SSO and received a busines...
Question 127: A systems administrator needs to configure an email client t...
Question 128: A systems administrator is trying to reduce storage consumpt...
Question 129: An organization is using multiple SaaS-based business applic...
Question 130: All of a company's servers are currently hosted in one cloud...
Question 131: An integration application that communicates between differe...
Question 132: A systems administrator is configuring a storage system for ...
Question 133: An administrator manages a file server that has a lot of use...
Question 134: An enterprise recently upgraded the memory of its on-premise...
Question 135: A systems administrator is building a new virtualization clu...
Question 136: A company has hired a security firm to perform a vulnerabili...
Question 137: A systems administrator is trying to establish an RDP sessio...
Question 138: A systems administrator is reviewing two CPU models for a cl...
Question 139: A global web-hosting company is concerned about the availabi...
Question 140: A systems administrator is about to deploy a new VM to a clo...
Question 141: A company recently experienced a power outage that lasted 30...
Question 142: An administrator needs to back up all the data from each VM ...