微软认证考试

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 Subscrib

题目

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？（）

  • A、Select the Subscription Watch List tab for SQL1. View the Latency column for the SQL2 subscription.
  • B、Select the All Subscriptions tab for the Pub1 publication. View the Latency column for the SQL2 subscription.
  • C、Select 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.
  • D、Select 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.
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

公司A在分布式环境下有多个服务器。你正在使用名为SQL1和SQL2的两个安装有SQLSERVER2005的计算机进行工作。这两个服务器都采用SQLSERVER身份验证,但是他们使用不同的登录。现在,你需要写一个联合SQL1和SQL2数据的分布式查询,你应该怎么做?()

A.确信SQL1和SQL2在彼此的安全上下文采用相同的登录名

B.配置SQL2为SQL1的远程服务器。在SQL1上写查询

C.配置SQL2为SQL1的连接服务器并且去模拟远程登录

D.配置SQL2为分布式服务器.用pass-throughauthentication.（传递认证）


参考答案：C

第2题：

Your company 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 toreconfigure 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 Agent 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. 

正确答案:D

第3题：

公司A有两个名为SQL1和SQL2的SQLSERVER2005数据库服务器。公司员工Eric依据公司的数据库写了许多adhoc查询(即席分布式查询)。Eric有访问SQL1上客户数据库的权限,但是没有访问SQL2上销售数据库的权限。你需要保证Eric能在这两个服务器之间进行联合(join)信息查询,你首先应该怎么做?()

A.在SQL1上创建连接服务器SQL2.配置连接服务器采用模拟登录。

B.在SQL1上创建连接服务器SQL2.配置连接服务器采用登录映射。

C.通知Eric在SQL2上使用OPENQUERY语句写查询并且指定SQL1作为服务器名。

D.通知Eric通过四个部分组成的名称（server.database.schema.table）指定SQLSERVER对象名。


参考答案：B

第4题：

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？（）

  • A、Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
  • B、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for a standard subscription.
  • C、Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.
  • D、Transactional replication should be set on SQL1. And then， SQL2 should be set as a standard subscriber for an updateable subscription.

正确答案:B

第5题：

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？（）

  • A、Join the two servers by using the four-part syntax of server.database.schema.table.
  • B、Reference SQL2 by using an alias.
  • C、Add SQL2 as a remote server to SQL1.
  • D、Add SQL2 as a linked server to SQL1.

正确答案:D

第6题：

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.


正确答案：C
解析：Explanation:WeshouldsetupSQL2asalinkedserver.Thiswouldenabletoissuedistributedqueriestoit.WeshouldalsoselectRemoteCollationoptiontousethecollationontheremoteserver.Note:SQLServer2000allowsthecreationoflinkstoOLEDBdatasourcescalledlinkedservers.AfteralinkhasbeencreateditispossibletoreferencerowsetsfromtheOLEDBdatasourcesastablesinTransact-SQLstatementsandpasscommandstotheOLEDBdatasourcesandincludetheresultingrowsetsastablesinTransact-SQLstatements.Eachdistributedquerycanreferencemultiplelinkedserversandcanperform.eitherupdateorreadoperationsagainsteachindividuallinkedserver.Asingledistributedquerycanperform.readoperationsagainstsomelinkedserversandupdateoperationsagainstotherlinkedservers.Thelinkedserveroptionsdefinedbyusingthesp_serveroptionstoredprocedurecontrolhowSQLServerusescollationsfromlinkedservers.WhentheUseRemoteCollationoptionissettoTRUE,itspecifiesthatthecollationofremotecolumnsisusedforSQLServerdatasources,andthecollationspecifiedinCollationNameisusedfordatasourcesotherthanSQLServer.WhenFALSE,distributedqueriesalwaysusethedefaultcollationofthelocalserverinstance,andCollationNameandthecollationofremotecolumnsareignored.IftheUseRemoteCollationoptionissettoTRUE,wecanspecifythenameofthecollationusedbytheremotedatasourceintheCollationNameoption.Thecollationmust,however,besupportedbySQLServer.ThisoptionshouldbeusedwhenaccessinganOLEDBdatasourceotherthanSQLServer,butwhosecollationmatchesoneoftheSQLServercollationsIncorrectAnswers:A:TheCOLLATEclauseoftheALTERDATABASEstatementcanbeusedtochangethecollationusedbythedatabase.However,thissolutionisinappropriateastheSQL2servercontainsseveraldatabases,eachofwhichusesadifferentcollation.Wewouldthusnotbeabletospecifyallthecollations.B:Remoteserversaresetupinpairswithbothserversconfiguredtorecognizeeachotherasremoteservers.TheconfigurationoptionsforbothserversshouldbesetsothateachinstanceofSQLServerallowsremoteuserstoexecuteprocedurecalls.However,supportforremoteserversisprovidedforbackwardcompatibilityonly.ApplicationsthatmustexecuteproceduresagainstremoteinstancesofSQLServer2000shoulduselinkedserversinstead.D:InthisscenariowecannotspecifythecollationnameasSQL2containsseveraldatabases,eachofwhichuseadifferentcollation.

第7题：

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？（）

  • A、Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
  • B、Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
  • C、Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.
  • D、Instruct Eric to specify SQL Server object names by using four-part notation.

正确答案:B

第8题：

公司A有两台名为SQL1和SQL2的SQLSERVER2005数据库服务器。这两个服务器之间进行数据复制。SQL1即是发布服务器也是分发服务器，SQL2只作为订阅服务器。在SQL1上只有一个名为Pub1的发布，并且由SQL1自己担任分发者。现在，管理者需要一个复制滞后时间状态报表。因此，你需要在SQL1上使用复制监视器找出当前在发布服务器到分发服务器、分发服务器到订阅服务器之间的滞后时间是否在正常范围之内，你应该怎么做？（）

A.选择SQL1节点，然后选择订阅监视列表页，查看列表中SQL2订阅的滞后时间列。

B.选择Pub1节点，然后选择所有发布页，查看列表中SQL2订阅的滞后时间列。

C.选择Pub1节点，然后选择跟踪令牌页，选择插入跟踪器，然后在出现的列表中查看订阅的滞后时间值。

D.选择SQL1节点，然后选择订阅监视列表页，然后双击SQL2订阅，查看发布服务器到分发服务器历史记录页和分发服务器到订阅服务器的历史记录页中持续时间值否正常。


参考答案：C

第9题：

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？（）

  • A、Configure an HTTP endpoint for SQL2 on SQL1.
  • B、Configure SQL2 as a linked server on SQL1.
  • C、Configure an HTTP endpoint for SQL1 on SQL2.
  • D、Configure SQL1 as a linked server on SQL2.

正确答案:B

第10题：

TestKing.com has a server named SQL1 that runs SQL Server 2005 Enterprise Edition.SQL1 has 2 GB of RAM， 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log？（）

  • A、MSAS 2005：Cache
  • B、MSAS 2005：Memory
  • C、MSAS 2005：Proactive Caching
  • D、SQLServer：Buffer Manager

正确答案:D

更多相关问题
相关内容