单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）Aone SQL Server 2005 computer with one instanceBtwo SQL Server 2005 computers， each with two instancesCtwo SQL Server computers， one with one instance and one with three instancesDone SQL Server 2005 computer with two instances
单选题
You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）
A
one SQL Server 2005 computer with one instance
B
two SQL Server 2005 computers， each with two instances
C
two SQL Server computers， one with one instance and one with three instances
D
one SQL Server 2005 computer with two instances
参考解析
解析：
暂无解析
相关考题：
Before launching any sales program, you should design an attractive promotion plan。() 此题为判断题(对，错)。
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.
Which of these correctly identifies the six phases of the Cisco Lifecycle Services framework? （）A、Prepare, Plan, Create, Implement, Operate, and ImproveB、Prepare, Plan, Design, Implement, Operate, and OptimizeC、Prepare, Plan, Design, Apply, Operate, and ManageD、Prepare, Plan, Design, Implement, Operate and Manage
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？（）A、 Add a reference to the assemblies in the Report Properties References tab. B、 Write the calculation logic used by the calculations by using T-SQL functions. C、 Write the code of the calculation logic into the Report Properties Custom Code tab.D、 Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.
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？（）A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.B、Configure SQL2 as a remote server. Write the query on SQL1.C、Configure SQL2 as a linked server to impersonate the remote login.D、Configure SQL2 as a distributed server. Use pass-through authentication.
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？（）A、[Bindable（false）]B、[DesignOnly（false）]C、[EditorBrowsable（EditorBrowsableState.Never）]D、[Browsable（false）]
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？（）A、Use the Remote Desktop Connection Broker and failover clusteringB、Use the Remote Desktop Gateway and network load balancingC、Use network load balancing and failover clusteringD、Use DNS round-robin and network load balancing
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？（）A、Change the advanced power settings of the Balanced power plan.B、Configure the portable computer to use the Power saver power plan.C、Configure the portable computer to use the High performance power plan.D、Restore the Power Saver power plan to the default settings.
公司A在分布式环境下有多个服务器。你正在使用名为SQL1和SQL2的两个安装有SQL SERVER 2005的计算机进行工作。这两个服务器都采用SQL SERVER 身份验证，但是他们使用不同的登录。现在，你需要写一个联合SQL1和SQL2数据的分布式查询，你应该怎么做？（）A、确信SQL1和SQL2在彼此的安全上下文采用相同的登录名B、配置SQL2为SQL1的远程服务器。在SQL1上写查询C、配置SQL2为SQL1的连接服务器并且去模拟远程登录D、配置SQL2为分布式服务器.用 pass-through authentication.（传递认证）
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？（）A、SQL3 with the OnlineReadOnly and HR databasesB、SQL4 with the TravelOnline and Storefront databasesC、SQL2 with the Storefront and TravelOnline databasesD、SQL2 with the Storefront and HR databases
TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do？（）A、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.B、On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.C、On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.D、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.
单选题You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional， you must configure access to the vendors site. What should you do？（）AConfigure an HTTP endpoint for SQL2 on SQL1.BConfigure SQL2 as a linked server on SQL1.CConfigure an HTTP endpoint for SQL1 on SQL2.DConfigure SQL1 as a linked server on SQL2.
单选题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？（）A[Bindable（false）]B[DesignOnly（false）]C[EditorBrowsable（EditorBrowsableState.Never）]D[Browsable（false）]
单选题公司A在分布式环境下有多个服务器。你正在使用名为SQL1和SQL2的两个安装有SQL SERVER 2005的计算机进行工作。这两个服务器都采用SQL SERVER 身份验证，但是他们使用不同的登录。现在，你需要写一个联合SQL1和SQL2数据的分布式查询，你应该怎么做？（）A确信SQL1和SQL2在彼此的安全上下文采用相同的登录名B配置SQL2为SQL1的远程服务器。在SQL1上写查询C配置SQL2为SQL1的连接服务器并且去模拟远程登录D配置SQL2为分布式服务器.用 pass-through authentication.（传递认证）
单选题公司A在分布式环境下有多个服务器。目前，你正在使用名为SQL1和SQL2的两个安装有SQL SERVER 2005的计算机进行工作。这两个服务器都采用SQL SERVER 身份验证，但是他们使用不同的登录。现在，你需要写一个联合SQL1和SQL2数据的分布式查询，你应该怎么做？（）A确信SQL1和SQL2在彼此的安全上下文采用相同的登录名B配置SQL2为远程服务器。在SQL1上写查询C配置SQL2为连接服务器去模拟远程登录D配置SQL2为分布式服务器.用 pass-through authentication.（传递认证）
单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）APlace each database in a separate instance running on SQL2.BPlace each database in a separate instance running on SQL3.CPlace both databases in a single instance running on SQL2.DPlace both databases in a single instance running on SQL3.
单选题You are a database administrator of two SQL Server 2005 computers named SQL1 and SQL2. You have a Microsoft .NET application that has been modified so that it now accesses a database on SQL2 in addition to SQL1. You do not want the user application to connect directly to SQL2. You need to enable the data retrieval from SQL2 while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do？（）AChange the .NET application to define a new server connection to SQL2.BConfigure a linked server on SQL1 to point to SQL2.CConfigure a linked server on SQL2 to point to SQL1.DChange the stored procedures called by the .NET application to include the OPENXML command.
多选题Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?（）ASet the recovery model of DB1 on SQL1 to bulk-logged recovery.BSet the recovery model of DB1 on SQL1 to full recovery.CBack up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option.DBack up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option.EBack up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.FCreate endpoints on all participating servers.GSet the AutoShrink property of DB1 on SQL1 to false.
单选题You are creating a Windows Forms application by using the .Net Framework 3.5.You plan to design a composite control for the application.You need to derive the control from a base class that supports templates.What should you do？（）ADerive from the Control class.BDerive from the UserControl class.CDerive from the ScrollableControl class.DDerive from the ContainerControl class.
单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）Aone SQL Server 2005 computer with one instanceBtwo SQL Server 2005 computers， each with two instancesCtwo SQL Server computers， one with one instance and one with three instancesDone SQL Server 2005 computer with two instances
单选题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 a financial services company. Replication is configured between two SQL Server 2005 computers， and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator， you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition， you need to make sure that this data is replicated securely. Which action should be performed？（）ASnapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.BTransactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.CMerge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.DTransactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.
单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）AJoin the two servers by using the four-part syntax of server.database.schema.table.BReference SQL2 by using an alias.CAdd SQL2 as a remote server to SQL1.DAdd SQL2 as a linked server to SQL1.
多选题You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2， and you create a linked server login that uses impersonation.Now， you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform？（）AAdd the user account that is used by the SQL Server service to the local Administrators group.BEnable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.CCreate a Service Principal Name （SPN） for the user account that is used by the SQL Server service.DEnable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.
单选题TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A user in TestKing.com named Eric writes many ad hoc queries against the company databases.Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first？（）ACreate a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.BCreate a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.CInstruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.DInstruct Eric to specify SQL Server object names by using four-part notation.
单选题TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Both servers take part in replication. SQL1 is both the Publisher and its own Distributor of a publication named Pub1. Pub1 is the only publication on SQL1， and SQL2 is the only Subscriber. Your supervisor requests a status report about the replication latencies. Using Replication Monitor on SQL1， you need to find out the current latencies between the Publisher and Distributor as well as between the Distributor and Subscriber. What should you do？（）ASelect the Subscription Watch List tab for SQL1. View the Latency column for the SQL2 subscription.BSelect the All Subscriptions tab for the Pub1 publication. View the Latency column for the SQL2 subscription.CSelect the Tracer Tokens tab for the Pub1 publication. Select the Insert Tracer Option and wait for the requested latency values for the SQL2 subscription to appear.DSelect the Subscription Watch List tab for SQL1. Double-click the SQL2 subscription.View the duration details on the Publisher to Distributor History tab as well as on the Distributor to Subscriber History tab.