网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）
A
— quick
B
— skip-buffer
C
— single-transaction
D
— tab
参考答案
参考解析
解析：
暂无解析
更多 “单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A — quickB — skip-bufferC — single-transactionD — tab” 相关考题
考题
Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2(SP2). The server has 1 GB of RAM and a single hard disk.Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active.You are evaluating whether to add RAM to the server.You need to use System Monitor to find out whether adding RAM will decrease disk activity.Which performance counter should you monitor? （）A. LogicalDisk : % Free SpaceB. Memory : Pages Faults/secC. Memory : Free System Page Table EntriesD. Server Work Queues : Queue Length
考题
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 runs acustom application.Users report that the performance of Server1 has dropped significantly during the last month. You monitor the server and obtain the data shown in the exhibit. (Click the Exhibit button.)You need to increase the performance of Server1.What should you do?（）A. Increase the server memory.B. Install an additional processor.C. Install a high performance disk.D. Install an additional network adapter.
考题
—David has made great progress recently. —_______， and _______. A. So he has；so you have B. So he has；so have you C. So he has；so do you D. So has he；so you have
考题
You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 768 MB of memory and multiple cores. You need to recommend the smallest compute instance size that is equivalent to the existing server. Which size should you recommend？（）A、 SmallB、 MediumC、 LargeD、 ExtraSmall
考题
An administrator is adding additional memory into a server that registers 1GB of memory in the OS and notices that the system has 2GB of memory physically installed； however， the server only shows 1GB of memory during POST. Which of the following is the MOST likely reason for this？（）A、 The OS does not support more than 1GB of memory.B、 The system memory has different manufacture dates.C、 Two of the memory sticks are defective.D、 The server is using memory interleaving.
考题
A technician has to populate a server motherboard with memory. The board has a memory bus speed of 800 MHz. Which of the following memory types should be used？（）A、DDR3B、SDRAMC、DDRD、DDR2
考题
An administrator recently installed a new array controller into a server. When the server is running POST the controller does not appear as present. Which of the following could be the reason for this?（）A、The server BIOS firmware is out-of-date.B、The server does not have the correct drivers.C、The server hard drives have not begun to spin.D、The server has too little memory installed.
考题
Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）A、On Wednesday， the statistics have been purged.B、On Wednesday， the retention period has been set to zero.C、On Wednesday， the collection interval has been set to zero.D、On Wednesday， the collection level has been changed to All.E、On Wednesday， the retention period has been set to one day.F、On Wednesday， the retention period has been set to two daysG、On Wednesday, the collection level has been changed to Typical.H、On Wednesday, the collection interval has been set to 1440 minutes.
考题
You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A、— quickB、— skip-bufferC、— single-transactionD、— tab
考题
Your company has a network that has 100 servers. You install a new server that runs Windows Server 2008. The server has the Web Server （IIS） role installed. You discover that the Reliability Monitor has no data， and that the system stablitiy chare has never been updated. You nede to configure the server to collect the reliability monitor data. What should you do（）？ A、Run the perfmon.exe /sys command on the serverB、Configure the Task schduler service to start automaticallyC、configuyre the Remote Registry serice to start automaticallyD、configure the Secondary Login service to start automatically.
考题
Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2 (SP2). The server has 1 GB of RAM and a single hard disk. Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active. You are evaluating whether to add RAM to the server. You need to use System Monitor to find out whether adding RAM will decrease disk activity. Which performance counter should you monitor? （）A、LogicalDisk : % Free SpaceB、Memory : Pages Faults/secC、Memory : Free System Page Table EntriesD、Server Work Queues : Queue Length
考题
Your company has a server that runs Windows Server 2008 R2. The server is configured as a remoteaccess server. The external firewall has TCP port 80 and TCP port 443 open for remoteconnections. You have a home computer that runs Windows 7. You need to establish secure remote accessconnection from the home computer to the remote access server. Which type of connection should you configure? （）A、IPSECB、L2TPC、PPTPD、SSTP
考题
Your network contains a database server that runs Windows Server 2003 Standard Edition Service Pack 2 (SP2). The server has 1 GB of RAM and a single hard disk. Queries against the databases on the server are very slow. You discover that the hard disk on the server is very active. You are evaluating whether to add RAM to the server. You need to use System Monitor to find out whether adding RAM will decrease disk activity. Which performance counter should you monitor? （）A、LogicalDisk : % Free SpaceB、Memory : Pages Faults/secC、Memory : Free System Page Table EntriesD、Server Work Queues : Queue Length
考题
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 runs a custom application. Users report that the performance of Server1 has decreased significantly during the last 30 minutes. You need to identify the current processor and memory usage for each process running on Server1. Which tool should you use? （）A、Event ViewerB、Task ManagerC、Query ProcessD、System Configuration Utility
考题
You have a server that runs Windows Server 2008. The server has the Web Server （IIS） server role installed and all the Web Server role services installed. You need to provide a user the ability to administer a Web site. Which feature should you configure？（）A、Net RolesB、Net UsersC、AuthenticationD、IIS Manager Permissions
考题
You have a new server named Server1 that runs Windows Server 2012 R2. Server1 has two dualcore processors and 32 GB of RAM.You install the Hyper-V server role on Server1.You create two virtual machines on Server1 that each have 8 GB of memory.You need to minimize the amount of time it takes for both virtual machines to access memory. What should you configure on each virtual machine？（）A、Resource controlB、Dynamic MemoryC、NUMA topologyD、Memory weight
考题
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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） A、You should use SQLServer:Buffer ManagerB、You should use SQLServer:Memory Manager C、You should use SQLServer:Databases D、You should use SQLServer:Access Methods
考题
单选题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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （）A
You should use SQLServer:Buffer ManagerB
You should use SQLServer:Memory Manager C
You should use SQLServer:Databases D
You should use SQLServer:Access Methods
考题
单选题You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 768 MB of memory and multiple cores. You need to recommend the smallest compute instance size that is equivalent to the existing server. Which size should you recommend？（）A
SmallB
MediumC
LargeD
ExtraSmall
考题
单选题A technician has to populate a server motherboard with memory. The board has a memory bus speed of 800 MHz. Which of the following memory types should be used？（）A
DDR3B
SDRAMC
DDRD
DDR2
考题
单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A
— quickB
— skip-bufferC
— single-transactionD
— tab
考题
单选题You have a new server named Server1 that runs Windows Server 2012 R2. Server1 has two dualcore processors and 32 GB of RAM.You install the Hyper-V server role on Server1.You create two virtual machines on Server1 that each have 8 GB of memory.You need to minimize the amount of time it takes for both virtual machines to access memory. What should you configure on each virtual machine？（）A
Resource controlB
Dynamic MemoryC
NUMA topologyD
Memory weight
考题
单选题An administrator recently installed a new array controller into a server. When the server is running POST the controller does not appear as present. Which of the following could be the reason for this？（）A
The server BIOS firmware is out-of-date.B
The server does not have the correct drivers.C
The server hard drives have not begun to spin.D
The server has too little memory installed.
考题
单选题Your company has a network that has 100 servers. You install a new server that runs Windows Server 2008. The server has the Web Server （IIS） server role installed.After a week， you discover that the Reliability Monitor has no data， and that the Systems Stability chart has never been updated.You need to configure the server to collect the Reliability Monitor data. What should you do？（）A
Run the perfmon.exe /sys command on the server.B
Configure the Task Scheduler service to start automatically.C
Configure the Remote Registry service to start automatically.D
Configure the Secondary Logon service to start automatically.
考题
多选题You are an enterprise administrator for Cer-tech .com. The corporate network of the company consists ofan Active Directory domain. All the servers on the network run Windows Server 2008. The network runs aTerminal services role on a server to enable remote users to run commonly required applications from theirterminal. A Terminal Services application called App1 that runs on the server has suddenly stopped responding. Todiagnose the problem， you monitored the memory usage on the server for a week and discover that App1application has a memory leak. To resolve the problem， you first looked for a patch but that was not currently available. So you created a new resource-allocation policy in Microsoft Windows Server ResourceManager and configured a Process Matching Criteria named TrackMem for the application. Which of the following options would you choose to terminate the application when the application consumes more than half of the available memory on the server？（）AConfigure the resource-allocation policy and set the maximum working set limit option to half theavailable memory on the server.BConfigure the resource-allocation policy and set the maximum committed memory option to half theavailable memory on the server.CSet the new policy as a Profiling Policy.DSet the new policy as a Managing Policy.
考题
单选题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
考题
单选题Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）A
On Wednesday， the statistics have been purged.B
On Wednesday， the retention period has been set to zero.C
On Wednesday， the collection interval has been set to zero.D
On Wednesday， the collection level has been changed to All.E
On Wednesday， the retention period has been set to one day.F
On Wednesday， the retention period has been set to two daysG
On Wednesday, the collection level has been changed to Typical.H
On Wednesday, the collection interval has been set to 1440 minutes.
考题
单选题An administrator is adding additional memory into a server that registers 1GB of memory in the OS and notices that the system has 2GB of memory physically installed; however, the server only shows 1GB of memory during POST. Which of the following is the MOST likely reason for this?（）A
The OS does not support more than 1GB of memory.B
The system memory has different manufacture dates.C
Two of the memory sticks are defective.D
The server is using memory interleaving.
热门标签
最新试卷
