8-way x445 with Microsoft Windows Server 2003 Standard Edition
8-way x445 with Microsoft Windows Server 2003 Datacenter Edition
8-way x445 with Microsoft Windows Server 2003 Enterprise Edition
16-way x445 with VMWare ESX with SMP and Windows Server 2003 Standard Edition VMs
第1题:
A company wants to replace an existing UNIX database server with a new application running on Microsoft SQL Server. Sizing analysis shows that a system with at least eight Xeon MP processors and 24GB RAM will be required for the central database server. Which of the following will meet the requirements at the lowest cost?()
第2题:
A customer needs a new Microsoft Windows 2003 Server. They are running an application that requires substantial memory. They would like a rack mountable system, which will support four Xeon processors with 2MB of L3 cache. Which of the following is the minimum configuration to satisfy the customer’s requirements?()
第3题:
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.
However, the existing SQL server computers in your office are configured to use the
SQL_Latin1_General_CP1_CI_AS collation.
You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.
What should you do?
A.Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.
B.Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.
C.Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.
D.Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
第4题:
You are planning the migration of an existing application to Windows Azure and SQL Azure. The original application includes a Microsoft SQL Server 2008 database. You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure. Which two actions should you recommend?()
第5题:
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()
第6题:
A customer needs a new database server. Their third-party application requires Microsoft SQL Server. They have 100 users who will login to the network and store their data files on the network server. They will also require the server to be an email server and to deploy a central antivirus solution. Which of the following network operating systems would satisfy these requirements?()
第7题:
A customer needs a new database server. The database application has a high memory overhead but does not benefit from 8-way processing. They would like a rack mountable system, which will support four Xeon processors with 512KB of L2 cache and 16GB of main system memory. Which of the following will satisfy the customer’s requirements?()
第8题:
第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 DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1, and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you. So what action should you perform to achieve this goal?()
第10题:
ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? ()