网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 recently completely creating a new application for Certkiller .com.This new application has to load an instance of the Inventory class from a large file named Inventory.dat.You need to ensure that the application executes the loading process in as little time as possible.What should you do?（）A.B.C.D.
考题
Your company has an Active Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2. All client computers run Windows 7. You run Remote Desktop Services and Microsoft Virtual Desktop Infrastructure (VDI). You have the servers shown in the following table. Name Server role Server1 RD Session Host Server2 RD Virtualization Host Server3 RD Connection Broker Server4 RD Web Access You are configuring Remote Desktop Web Access (RD Web Access) to publish VDI desktops and remote applications on the RD Web Access server. You need to ensure that when remote users log on to the RD Web Access server they are presented with all remote applications and only their assigned VDI desktop. Which two actions should you perform on Server4？（）A、Set the source name to Server3.B、Set the source name to Server1;Server2.C、Select the option to use to one or more RemoteApp sources.D、Select the option to use a Remote Desktop Connection Broker server as the source.
考题
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. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. So what action should you perform to achieve this goal？（） A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
考题
You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）A、It exports tables with the most indexes first to assist with import speedsB、It ensures that unique indexes have no conflicts when the data is dumpedC、It orders by primary key to assist in speeding up importing to InnoDB tablesD、It must be specified so index data is dumped correctly when –on-create-info is used
考题
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 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 administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?（）A、affinity maskB、affinity I/O mask C、max degree of parallelismD、optimize for ad hoc workloads
考题
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 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 network contains a Windows Server 2008 server that has the Web Server （IIS） server role installed. You have a Web application that uses a custom application pool. The application pool is set to recycle every 1，440 minutes. The Web application does not support multiple worker processes. You need to configure the application pool to ensure that users can access the Web application after the application pool is recycled. What should you do？（）A、Set the Shutdown Executable option to True.B、Set the Process Orphaning Enabled option to True.C、Set the Disable Overlapped Recycling option to True.D、Set the Disable Recycling for Configuration Changes option to True.
考题
You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.Company.com makes use of an exchange server 2010 edge transport server named -sr18.You have configured the other exchange server 2003 servers to forward the e-mails for external recipients to -sr18.You have received instructions from the cio to make sure that -sr18 can send and receive e-mail messages from the internet. What should you do？（）A、The best option is to set up and configure a sharing policy.B、the best option is to set up and configure a send connector on -sr18.thereafter you should set up and configure a receive connector on -sr18.C、The best option is to make use of the Exchange Server 2010 schema extensions.D、The best option is to set up an Edge Subscription file and duplicate the file to the Exchange Server 2003 servers.
考题
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？（）A、Configure the resource-allocation policy and set the maximum working set limit option to half theavailable memory on the server.B、Configure the resource-allocation policy and set the maximum committed memory option to half theavailable memory on the server.C、Set the new policy as a Profiling Policy.D、Set the new policy as a Managing Policy.
考题
You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）A、Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.B、Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.C、Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.D、Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.
考题
You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services，and configuring aweb services infrastructure. You are in charge of a server that runs Windows Server 2008. The TerminalServices server role is installed on the server. A Terminal Services application runs on the server. Now youreceive report from users saying that that the application stops responding. You monitor the memory usageon the server for a week and find that the application has a memory leak. A patch is not currently available.You create a new resource-allocation policy in Microsoft Windows System Resource Manager （WSRM）.You configure a Process Matching Criteria named TrackShip and choose the application. You have toterminate the application when the application consumes more than half of the available memory on theserver. What action should you perform？（）A、The resource-allocation policy and the maximum working set limit option should be set to half the available memory on the server. The new policy should be set as a Managing Policy.B、The resource-allocation policy and the maximum committed memory option should be set to half the available memory on the server. The new policy should be set as a Profiling Policy.C、The resource-allocation policy and the maximum committed memory option should be set to half the available memory on the server. The new policy should be set as a Managing Policy.D、The resource-allocation policy should be configured and the maximum working set limit option should be set to half the available memory on the server. The new policy should be set as a Profiling Policy.
考题
Terminal Services application runs on the server. Users report that the application stops responding. You monitor the memory usage on the server for a week. You discover that the application has a memory leak. A patch is not currently available. You create a new resource-allocation policy in Microsoft Windows Server Resource Manager. You configure a Process Matching Criteria named TrackShip and select the application. You need to terminate the application when the application consumes more than half of the available memory on the server. What should you do？（）A、Configure the resource-allocation policy and set the maximum working set limit option to half the available memory on the server. Set the new policy as a Profiling Policy.B、Configure the resource-allocation policy and set the maximum working set limit option to half the available memory on the server. Set the new policy as a Managing Policy.C、Configure the resource-allocation policy and set the maximum committed memory option to half the available memory on the server. Set the new policy as a Profiling Policy.D、Configure the resource-allocation policy and set the maximum committed memory option to half the available memory on the server. Set the new policy as a Managing Policy.
考题
多选题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 need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）A
Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.B
Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.C
Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.D
Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.
考题
单选题Terminal Services application runs on the server. Users report that the application stops responding. You monitor the memory usage on the server for a week. You discover that the application has a memory leak. A patch is not currently available. You create a new resource-allocation policy in Microsoft Windows Server Resource Manager. You configure a Process Matching Criteria named TrackShip and select the application. You need to terminate the application when the application consumes more than half of the available memory on the server. What should you do？（）A
Configure the resource-allocation policy and set the maximum working set limit option to half the available memory on the server. Set the new policy as a Profiling Policy.B
Configure the resource-allocation policy and set the maximum working set limit option to half the available memory on the server. Set the new policy as a Managing Policy.C
Configure the resource-allocation policy and set the maximum committed memory option to half the available memory on the server. Set the new policy as a Profiling Policy.D
Configure the resource-allocation policy and set the maximum committed memory option to half the available memory on the server. Set the new policy as a Managing Policy.
考题
单选题An administrator notices that every time a particular server is restarted it requires a password in order for the server to begin the start up process. Which of the following is the reason this is happening？（）A
The server needs to have the password service verified and reconfigured.B
The server administrator has set a password policy in Group Policy.C
The server has the BIOS setting configured incorrectly.D
The server is set with a boot password before accessing the OS
考题
单选题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. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key. So what action should you perform to achieve this goal？（）A
You should drop the XML index on the table. Modify the primary key. Recreate the XML index B
You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. C
You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. D
You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.
考题
单选题You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services，and configuring aweb services infrastructure. You are in charge of a server that runs Windows Server 2008. The TerminalServices server role is installed on the server. A Terminal Services application runs on the server. Now youreceive report from users saying that that the application stops responding. You monitor the memory usageon the server for a week and find that the application has a memory leak. A patch is not currently available.You create a new resource-allocation policy in Microsoft Windows System Resource Manager （WSRM）.You configure a Process Matching Criteria named TrackShip and choose the application. You have toterminate the application when the application consumes more than half of the available memory on theserver. What action should you perform？（）A
The resource-allocation policy and the maximum working set limit option should be set to half the available memory on the server. The new policy should be set as a Managing Policy.B
The resource-allocation policy and the maximum committed memory option should be set to half the available memory on the server. The new policy should be set as a Profiling Policy.C
The resource-allocation policy and the maximum committed memory option should be set to half the available memory on the server. The new policy should be set as a Managing Policy.D
The resource-allocation policy should be configured and the maximum working set limit option should be set to half the available memory on the server. The new policy should be set as a Profiling Policy.
考题
单选题You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.Company.com makes use of an exchange server 2010 edge transport server named -sr18.You have configured the other exchange server 2003 servers to forward the e-mails for external recipients to -sr18.You have received instructions from the cio to make sure that -sr18 can send and receive e-mail messages from the internet. What should you do？（）A
The best option is to set up and configure a sharing policy.B
the best option is to set up and configure a send connector on -sr18.thereafter you should set up and configure a receive connector on -sr18.C
The best option is to make use of the Exchange Server 2010 schema extensions.D
The best option is to set up an Edge Subscription file and duplicate the file to the Exchange Server 2003 servers.
考题
单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）A
It exports tables with the most indexes first to assist with import speedsB
It ensures that unique indexes have no conflicts when the data is dumpedC
It orders by primary key to assist in speeding up importing to InnoDB tablesD
It must be specified so index data is dumped correctly when –on-create-info is used
考题
单选题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 administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?（）A
affinity maskB
affinity I/O mask C
max degree of parallelismD
optimize for ad hoc workloads
考题
单选题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
热门标签
最新试卷
