Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（

首页
问答
其他计算机考试
微软认证考试
Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（

题目

Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）

A、Implement horizontal partitioning.
B、Implement vertical partitioning.
C、Implement a raw partition.
D、Implement distributed partitioning.

更多“Your SQL Server ”相关问题

第1题

以下属于网络数据库SQL Server中常见的版本的是（）A、SQL Server 2000企业版B、SQL Server 2000标准版C、SQL Server 2000个人版D、SQL Server 2000企业版；SQL Server 2000标准版；SQL Server 2000个人版都是

点击查看答案
第2题

下列操作中，（）不是SQL Server服务管理器功能。A、启动SQL Server服务B、停止SQL Server服务C、执行SQL查询命令D、暂停SQL Server服务

点击查看答案
第3题

下列操作中，哪个不是SQL Server服务管理器功能（）？A、执行SQL查询命令B、停止SQL Server服务C、暂停SQL Server服务D、启动SQL Server服务

点击查看答案
第4题

You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）A、In Event Viewer， view the system log.B、In Event Viewer， view the application log.C、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.D、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.E、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.

点击查看答案
第5题

You are planning the deployment of a SQL Azure database. Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%. You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database. What should you recommend？（）A、 Add a processor license to the existing SQL Server licensing agreement.B、 Purchase a Windows Azure consumption platform subscription.C、 Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.D、 Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.

点击查看答案
第6题

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.

点击查看答案
第7题

You are a network administrator for your company. The network contains four Windows Server 2003 computers configured as a four-node server cluster. Each cluster node is the preferred owner of a clustered instance of Microsoft SQL Server 2000， and each cluster node is configured as a possible owner of all other instances of SQL Server. All nodes have identically configured hardware. All four nodes operate at a sustained 70 percent CPU average. You add a server that has identically configured hardware to the cluster as a fifth node. You want each SQL Server instance to continue operating at the same level of performance in the event of a single node failure. What should you do？（）A、 Clear the Affect group check box in the cluster resource properties for each SQL Server instance.B、 Configure the fifth node as the only possible owner other than the existing preferred owner of the cluster resources that are associated with each SQL Server instance.C、 Configure the fifth node as the preferred owner of each cluster group that contains an SQL Server instance.D、 Enable failback on each group that contains an SQL Server instance.

点击查看答案

Your SQL Server

题目

更多“Your SQL Server ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容