You are configuring SQL1 so that the distributed query in th

题目
多选题
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?()
A

Add the user account that is used by the SQL Server service to the local Administrators group.

B

Enable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.

C

Create a Service Principal Name (SPN) for the user account that is used by the SQL Server service.

D

Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

She was happy,()

  • A、So are you
  • B、So you are
  • C、So you were
  • D、So were you

正确答案:D

第2题:

You are configuring a JMS server with a need for load balancing the messages. To achieve the  load balance you should ().

  • A、use regular queues and topics  
  • B、use distributed queues and topics
  • C、not use subdeployments
  • D、disable server affinity
  • E、use message paging

正确答案:B,C

第3题:

You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.

A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.

You want to ensure that the journalists can query the database. What should you do?

A.Create a new full-text catalog for the Articles database

B.Rebuild the full-text catalog for the Articles database

C.Create a new full-text index on the table that holds the text for the articles

D.Repopulate the full-text index on the table that holds the text for the articles


正确答案:D
解析:Explanation: Backing up a database does not back up full-text index data in full-text catalogs. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. However, if full-text indexes have been defined for tables, the metadata for the full-text index definitions are stored in the system tables in the database containing the full-text indexes. After a database backup is restored, the full-text index catalogs can be re-created and repopulated.

Note 1:
Setting up a full-text search is a three-step procedure:

1. Make sure that the full-text indexing feature has been installed with your SQL Server.
The full-text index is installed as a service in the system. It would not have to be reinstalled after restoring a database.

2. Create a catalog in the operating system to store the full-text indexes.
A catalog can contain the indexes from one or more tables, and it is treated as a unit for maintenance purposes. In general, you shouldn't need more than one catalog per database.
The catalog is saved outside the database on separate files

3. Before you can implement a full-text search in a given database, you must ensure that the full-text search indexes are populated regularly.
In this scenario we must recreate the index by repopulating the full-text catalog.

Note 2: A SQL Server 2000 full-text index provides support for sophisticated word searches in character string data. The full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words. The full-text indexes are contained in full-text catalogs. Full-text catalogs and indexes are not stored in the database to which they belong. The catalogs and indexes are managed separately by the Microsoft Search service. Backing up a database does not back up full-text index data in full-text catalogs. However, if full-text indexes have been defined for tables, the meta. data is backed up when a database backup is created.

Incorrect Answers:
A: The catalog already exists. The catalog is stored outside SQL server and would not be affected by the failure and restoration of the database.

B: Rebuildning the full text catalog will not enable the Journalist to run the full-text queries. The catalogs would have to be repopulated as well.

C: The index should be repopulated since it already exists from the backup. There is no need to recreate it.

第4题:

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.

正确答案:C

第5题:

You need to recommend changes to the environment that meet the company’s user requirements.   What should you include in the recommendation?()

  • A、a BranchCache in Distributed Cache mode
  • B、a BranchCache in Hosted Cache mode
  • C、Distributed File System (DFS) namespaces
  • D、Distributed File System (DFS) Replication

正确答案:C

第6题:

Which two EIGRP options will limit a query domain?()

  • A、configuring EIGRP stubs
  • B、configuring a second EIGRP AS and redistributing
  • C、configuring summary addresses
  • D、configuring an offset-list
  • E、configuring a prefix-list
  • F、configuring unicast neighbors

正确答案:A,C

第7题:

You work as the exchange administrator at Company.com.the Company.com network contains an exchange server 2010 organization.Company.com has its headquarters in stockholm where you are located.you are responsible for an exchange 2010 edge transport server named -ex01.during the course of the week you receive an instruction from the cio to make sure that e-mail messages sent to unknown addresses in the organization is rejected automatically.What should you do?()

  • A、You should consider configuring recipient filtering.
  • B、You should consider configuring sender reputation.
  • C、You should consider configuring content filtering.
  • D、You should consider configuring sender filtering.

正确答案:A

第8题:

You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?()

A.

B.

C.

D.


参考答案:B

第9题:

You work as the IT professional in an international company which is named wiikigo. You are experienced in implementing and administering a network operating system. You are specialized in configuring IP addressing and services, configuring name resolution and network access and so on. You are in charge of a domain controller that runs windows server 2008 and the DNS server role. The dns server hosts an active directory-integrated zone for your domain. You need to provide a user with the ability to manage records in the zone. But the user must not so what action should you perform?()

  • A、The user permissions on the zone should be granted.
  • B、The user permissions on the DNS zone should be granted.
  • C、The user should be added to the DNSUpdateProxy Global security group.
  • D、The user should be added to the DNSAdmins domain local security group.

正确答案:A

第10题:

You have a DNS server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You create a primary zone on Server1 for contoso.com.You run the DNS simple query test and recursive query test. The simple query test completes successfully, but the recursive query test fails.You need to ensure that the recursive query test can complete successfully.  What should you do on Server1?()

  • A、Clear the cache.
  • B、Disable recursion.
  • C、Enable access to the Internet.
  • D、Configure a reverse lookup zone.

正确答案:C

更多相关问题