单选题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 — si

题目
单选题
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

相似考题

1.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

2. 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.

3. 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.

4.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.

更多“单选题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 — si”相关问题

  • 第1题：

    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 speeds
    • B、It ensures that unique indexes have no conflicts when the data is dumped
    • C、It orders by primary key to assist in speeding up importing to InnoDB tables
    • D、It must be specified so index data is dumped correctly when  –on-create-info is used

    正确答案:C

  • 第2题：

    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 Viewer
    • B、Task Manager
    • C、Query Process
    • D、System Configuration Utility

    正确答案:B

  • 第3题：

    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 Space
    • B、Memory : Pages Faults/sec
    • C、Memory : Free System Page Table Entries
    • D、Server Work Queues : Queue Length

    正确答案:B

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    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.

    正确答案:B,D

  • 第6题：

    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.

    正确答案:C

  • 第7题：

    多选题
    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.


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

  • 第8题：

    单选题
    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.


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

  • 第9题：

    单选题
    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.


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

  • 第10题：

    单选题
    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.


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

  • 第11题：

    单选题
    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 Viewer

    B

    Task Manager

    C

    Query Process

    D

    System Configuration Utility


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

  • 第12题：

    单选题
    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


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

  • 第13题：

    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

    正确答案:A

  • 第14题：

    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 mask
    • B、affinity I/O mask 
    • C、max degree of parallelism
    • D、optimize for ad hoc workloads

    正确答案:C

  • 第15题：

    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 Space
    • B、Memory : Pages Faults/sec
    • C、Memory : Free System Page Table Entries
    • D、Server Work Queues : Queue Length

    正确答案:B

  • 第16题：

    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.

    正确答案:B

  • 第17题：

    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.

    正确答案:D

  • 第18题：

    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.

    正确答案:D

  • 第19题：

    单选题
    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.


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

  • 第20题：

    单选题
    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


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

  • 第21题：

    单选题
    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.


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

  • 第22题：

    单选题
    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 speeds

    B

    It ensures that unique indexes have no conflicts when the data is dumped

    C

    It orders by primary key to assist in speeding up importing to InnoDB tables

    D

    It must be specified so index data is dumped correctly when  –on-create-info is used


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

  • 第23题：

    单选题
    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 mask

    B

    affinity I/O mask 

    C

    max degree of parallelism

    D

    optimize for ad hoc workloads


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

相关内容