单选题Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of 

题目
单选题
Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）
A

Create a VLAN between the web server and database server.

B

Purchase APV and install the VIOS.

C

Increase the priority of the Web server.

D

Create separate LPARs for Web and database workloads.

相似考题

1.In a single-tier environment running WebSphere Commerce V5.6 Professional Edition， traffic has increased significantly over the last month.  It has been determined that load has increased throughout the system. Which is the BEST change to provide the largest increase in performance？（）A、Upgrade to WebSphere Commerce V5.6 Business EditionB、Create a two-tier environment by moving the database server to a new nodeC、Create a demilitarized zone （DMZ） between two firewallsD、Compile all the store JPSsE、Disable all caching of JSPs

2.Which components are installed on the middle tier in a WebSphere Commerce V 5.6 three-tier configuration （i.e. in a three-node topology）？（）A、WebSphere Commerce Server， WebSphere Application Server and Web server pluginB、WebSphere Application Server， Database Client and Web server pluginC、WebSphere Commerce Server， Database Server and WebSphere Application ServerD、WebSphere Commerce Server， WebSphere Application Server and Database ClientE、Web server， WebSphere Commerce Server and WebSphere Application Server

3. A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.

4.When WebSphere Commerce， WebSphere Application Server， the web server and the database server are all located on a single machine， which of the following statements are TRUE？ （）A、this is a multi-node installationB、this is a single node installation.C、each hardware and software component is a single point of failure.D、this is an example of load balancing.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of ”相关问题

  • 第1题：

    A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate？（）

    • A、Virtual SCSI
    • B、Virtual Ethernet
    • C、Virtual I/O Server
    • D、Micro-Partitioning

    正确答案:B

  • 第2题：

    ompany.com has a Micro-Partitioned p5-570 4-way with six application partitions and two VIO servers. Each VIO server has been allocated 0.5 CPU and the application servers have been allocated 0.4 CPUs. The marketing department wants to deploy a new Web server to support the release of a product. The systems architect has recommended that the Web server will require a whole CPU. Which of the following should the technical specialist suggest to provide the most cost-effective deployment？（）

    • A、Remove one application server partition and apply its CPU resources to the Web server.
    • B、Reassign the CPU from one of the VIO servers and create the new partition.
    • C、Add 0.6 CPU to one of the application servers and run the Web service with the application. 
    • D、Reassign a total of 0.4 CPUs from the application servers and create a new partition with awhole CPU for new deployment.

    正确答案:D

  • 第3题：

    A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）

    • A、The application server，firewall，and database server on the same VLAN
    • B、The application server and firewall on one VLAN，and the database server on a second VLAN
    • C、The application server on one VLAN，and the database server and firewall on a second VLAN
    • D、The application server and firewall on one VLAN，and the firewall and database server on a second VLAN

    正确答案:D

  • 第4题：

    A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）

    • A、The Query Cache is pruning queries due to an increased number of requests
    • B、Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
    • C、Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
    • D、The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution

    正确答案:C

  • 第5题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第6题：

    单选题
    Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）
    A

    Create a VLAN between the web server and database server.

    B

    Purchase APV and install the VIOS.

    C

    Increase the priority of the Web server.

    D

    Create separate LPARs for Web and database workloads.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    WebSphere Commerce has been successfully installed and tested.  WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator.  What could be the cause of this problem？（）
    A

    The WebSphere Commerce application server was not started

    B

    The web server was not started

    C

    SSL has not been configured on the web server

    D

    The appropriate listeners were not enabled in Configuration Manager

    E

    The database server was not started


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    In a single-tier environment running WebSphere Commerce V5.6 Professional Edition， traffic has increased significantly over the last month.  It has been determined that load has increased throughout the system. Which is the BEST change to provide the largest increase in performance？（）
    A

    Upgrade to WebSphere Commerce V5.6 Business Edition

    B

    Create a two-tier environment by moving the database server to a new node

    C

    Create a demilitarized zone （DMZ） between two firewalls

    D

    Compile all the store JPSs

    E

    Disable all caching of JSPs


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You are a systems administrator responsible for managing a Windows Server 2008 SMTP server.Recently， users have complained that a Web application running on the same server is experiencing performance problems at specific times of the day. You suspect that the problem might be related to loadplaced on the SMTP Server service. Which of the following methods should you use to monitor theperformance of an SMTP virtual server over time？（）
    A

    The Current Sessions section of IIS 6.0 Manager

    B

    SMTP Server counters collected by Performance Monitor

    C

    Windows Event Viewer： Application Log

    D

    Windows Event Viewer： System Log


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate？（）
    A

    Virtual SCSI

    B

    Virtual Ethernet

    C

    Virtual I/O Server

    D

    Micro-Partitioning


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）
    A

    The application server，firewall，and database server on the same VLAN

    B

    The application server and firewall on one VLAN，and the database server on a second VLAN

    C

    The application server on one VLAN，and the database server and firewall on a second VLAN

    D

    The application server and firewall on one VLAN，and the firewall and database server on a second VLAN


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Company.com has decided to use the FUBAR Application Server to host their web application. Unfortunately， the FUBAR Application Server uses the server machine’s file system for its JNDI namespace. Every JNDI lookup performed in the web application is translated into a file 1/0 operation， which results in very poor performance.  Which J2EE pattern can help with this performance issue？（）
    A

     Transfer Object

    B

     Service Locator

    C

     Intercepting Filter

    D

     Model-View-Controller


    正确答案： B
    解析： 暂无解析

  • 第13题：

    WebSphere Commerce has been successfully installed and tested.  WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator.  What could be the cause of this problem？（）

    • A、The WebSphere Commerce application server was not started
    • B、The web server was not started
    • C、SSL has not been configured on the web server
    • D、The appropriate listeners were not enabled in Configuration Manager
    • E、The database server was not started

    正确答案:D

  • 第14题：

    Company.com has a database application and a Web server application running on the same p5-570 server in a single partition. Recently there have been a number of instances where the increased load on the database server has impacted the performance of the Web server. What can the technical specialist recommend to keep the database application from impacting the performance of the Web server？（）

    • A、Create a VLAN between the web server and database server.
    • B、Purchase APV and install the VIOS.
    • C、Increase the priority of the Web server.
    • D、Create separate LPARs for Web and database workloads.

    正确答案:D

  • 第15题：

    Company.com has decided to use the FUBAR Application Server to host their web application. Unfortunately， the FUBAR Application Server uses the server machine’s file system for its JNDI namespace. Every JNDI lookup performed in the web application is translated into a file 1/0 operation， which results in very poor performance.  Which J2EE pattern can help with this performance issue？（）

    • A、 Transfer Object
    • B、 Service Locator
    • C、 Intercepting Filter
    • D、 Model-View-Controller

    正确答案:B

  • 第16题：

    You are a systems administrator responsible for managing a Windows Server 2008 SMTP server.Recently， users have complained that a Web application running on the same server is experiencing performance problems at specific times of the day. You suspect that the problem might be related to loadplaced on the SMTP Server service. Which of the following methods should you use to monitor theperformance of an SMTP virtual server over time？（）

    • A、The Current Sessions section of IIS 6.0 Manager
    • B、SMTP Server counters collected by Performance Monitor
    • C、Windows Event Viewer： Application Log
    • D、Windows Event Viewer： System Log

    正确答案:B

  • 第17题：

    In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）

    • A、Database client and database server
    • B、WebSphere Application Server and Database Server
    • C、WebSphere Commerce Server and WebSphere Application Server
    • D、Web server and WebSphere Application Server

    正确答案:A,B

  • 第18题：

    多选题
    A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）
    A

    Disabling connections from named pipes or socket files (depending on the operating system of the server)

    B

    Enabling and using SSL for connections to the Mysql database

    C

    Installing Mysql on the application server, and running the database and application on the same server

    D

    Starting the server with – bind- address=0.0.0.0 specified

    E

    Running the server with – skip-networking specified

    F

    Limiting logins to originate from the application server or the server's subnet'


    正确答案： A,E
    解析： 暂无解析

  • 第19题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    When WebSphere Commerce， WebSphere Application Server， the web server and the database server are all located on a single machine， which of the following statements are TRUE？ （）
    A

    this is a multi-node installation

    B

    this is a single node installation.

    C

    each hardware and software component is a single point of failure.

    D

    this is an example of load balancing.


    正确答案： D,A
    解析： 暂无解析

  • 第21题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server has a very large database named DB1. An application which is constantly available uses DB1. Now you get a report from users, in the report users complain that server has a poor performance. As the technical support, you have to improve the performance of the application by using the Database Engine Tuning Advisor. Besides this, you must make sure that the action of analyzing the workload will not affect the performance of the production server.So what should you do?（）
    A

    On the local server, enable the XP_MSVER stored procedure 

    B

    On the remote server, enable the XP_MSVER stored procedure. 

    C

    On the production server, use the dta.exe utility along with an XML input file. 

    D

    You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    ompany.com has a Micro-Partitioned p5-570 4-way with six application partitions and two VIO servers. Each VIO server has been allocated 0.5 CPU and the application servers have been allocated 0.4 CPUs. The marketing department wants to deploy a new Web server to support the release of a product. The systems architect has recommended that the Web server will require a whole CPU. Which of the following should the technical specialist suggest to provide the most cost-effective deployment？（）
    A

    Remove one application server partition and apply its CPU resources to the Web server.

    B

    Reassign the CPU from one of the VIO servers and create the new partition.

    C

    Add 0.6 CPU to one of the application servers and run the Web service with the application. 

    D

    Reassign a total of 0.4 CPUs from the application servers and create a new partition with awhole CPU for new deployment.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）
    A

    The Query Cache is pruning queries due to an increased number of requests

    B

    Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups

    C

    Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature

    D

    The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    Which components are installed on the middle tier in a WebSphere Commerce V 5.6 three-tier configuration （i.e. in a three-node topology）？（）
    A

    WebSphere Commerce Server， WebSphere Application Server and Web server plugin

    B

    WebSphere Application Server， Database Client and Web server plugin

    C

    WebSphere Commerce Server， Database Server and WebSphere Application Server

    D

    WebSphere Commerce Server， WebSphere Application Server and Database Client

    E

    Web server， WebSphere Commerce Server and WebSphere Application Server


    正确答案： A
    解析： 暂无解析

相关内容