one SQL Server 2005 computer with one instance
two SQL Server 2005 computers, each with two instances
two SQL Server computers, one with one instance and one with three instances
one SQL Server 2005 computer with two instances
第1题:
Which of these correctly identifies the six phases of the Cisco Lifecycle Services framework? ()
第2题:
TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do?()
第3题:
此题为判断题(对,错)。
第4题:
公司A在分布式环境下有多个服务器。你正在使用名为SQL1和SQL2的两个安装有SQL SERVER 2005的计算机进行工作。这两个服务器都采用SQL SERVER 身份验证,但是他们使用不同的登录。现在,你需要写一个联合SQL1和SQL2数据的分布式查询,你应该怎么做?()
第5题:
Your virtual environment includes Windows Server 2008 R2 Hyper-V servers. You plan to deploy Microsoft Virtual Desktop Infrastructure. You plan to scale both static and dynamic deployments across several servers. You need to design a plan that supports static and dynamic deployments and that allows for capacity growth without outages. What should you include in your plan?()
第6题:
You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do?()
第7题:
You are developing a Windows Forms Application by using the .NET Framework 3.5.You plan to design a composite custom control for the application. You include a ListBox control has a property that provides the item count of the ListBox control. You need to ensure that the property cannot be accessed at design time. Which attribute should you use?()
第8题:
You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.
You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
How should you configure SQL1?
A.Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
B.Add SQL2 as remote server.
C.Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
D.Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
第9题:
You need to configure the power settings of your portable computer so that the display turns off when it is inactive and running on battery power. You also need to ensure that the power settings of the hard disk remain unaffected. What should you do?()
第10题:
You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers, in its current configuration, can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used?()