单选题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 databa

题目
单选题
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.

相似考题

1.You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.The net-libraries on SQL2000 are configured as shown in the exhibit.SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．On SQL2000, enable the multiprotocol net library.B．On SQL2000, select the force protocol encryption check box.C．On SQL7, select the force protocol encryption check box.D．On SQL2000, install a secure sockets layer (SSL) encryption certificate.E．On SQL2000 and SQL7, enable multiprotocol encryption.

2. 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：CacheB、MSAS 2005：MemoryC、MSAS 2005：Proactive CachingD、SQLServer：Buffer Manager

3.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 instanceB、two SQL Server 2005 computers， each with two instancesC、two SQL Server computers， one with one instance and one with three instancesD、one SQL Server 2005 computer with two instances

4. You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal？（）A、Named PipesB、TCP/IPC、Shared MemoryD、Virtual Interface Adapter （VIA）E、Multiprotocol

更多“TestKing.com has two SQL Server 2005 computers named SQL1 an”相关问题

  • 第1题：

    公司A有一个名为SQL1的SQL Server 2005服务器。SQL1设置为SQL Server和Windows身份认证模式。使用Windows认证，在SQL1上你有sysadmin权限。使用SQL1工作的所有用户都反映说：使用SQL1的所有应用程序均停止响应。你的上司让你去调查此问题。在任务管理器中，你注意到CPU使用率为100%。你试图用SQL Server Management Studio连接到SQL1。但SQL1没有响应。你需要连接到SQL1才能诊断问题。哪两种方法可能让你达成此目标？（）

    • A、用osql实用工具连接到SQL1
    • B、使用专用管理员连接的sqlcmd实用工具连接到SQL1
    • C、用SQL Server Management Studio连接到SQL1。打开一个查询窗口并执行以下语句：DBCC TRACEON 1244
    • D、在SQL Server Management Studio中，在工具栏上，点击数据库引擎查询以打开连接到数据库引擎对话框。在服务器名称文本框内，敲入ADMIN：SQL1。选择SQL Server身份认证并提供你的sa身份。点击连接按钮

    正确答案:B,D

  • 第2题：

    You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new R&D configuration， which will include the Research， Parts， and Engineering databases.Which two combinations will be the most appropriate？（）

    • A、Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise Edition
    • B、Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise Edition
    • C、Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise Edition
    • D、Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition

    正确答案:A,B

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However， you have been granted membership in the local Administrators group on SQL1. You perform most of the management of SQL1 from your administrative workstation. However， for security reasons， you want to track all attempts for interactive logons and network connections to SQL1. What should you do？（）

    • A、Create a Group Policy object （GPO） that is configured for success and failure auditing of the Audit account logon events setting. Ask the domain administrator to link the GPO to the object containing SQL1.
    • B、Configure the SQL Server service on SQL1 to audit all successful and failed logon attempts.
    • C、Edit the local security policy of SQL1. Then， configure success and failure auditing on the Audit logon events setting.
    • D、Run the SQL Server Profiler and use a standard default template.

    正确答案:C

  • 第5题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第6题：

    多选题
    You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）
    A

    Set the appropriate local password policies for all computers on which SQL Server is installed.

    B

    Set the server authentication mode of all SQL Server instances to Windows Authentication mode.

    C

    Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.

    D

    Create SQL Server logins that have CHECK_POLICY enabled.


    正确答案： A,C
    解析： 暂无解析

  • 第7题：

    单选题
    You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）
    A

    Microsoft SQL Server 2005 Mobile Edition

    B

    Microsoft SQL Server 2005 Express Edition

    C

    Microsoft SQL Server 2005 Standard Edition

    D

    Microsoft SQL Server 2005 Workgroup Edition


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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. 


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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? （）
    A

    You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 

    B

    You should upgrade the SQL Server 2005 application to use SQL Server 2008 

    C

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 

    D

    You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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 the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.

    B

    To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.

    C

    To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.

    D

    To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）

    • A、 Named Pipes 
    • B、 TCP/IP 
    • C、 Shared Memory 
    • D、 Virtual Interface Adapter (VIA) 
    • E、 Multiprotocol 

    正确答案:A,B

  • 第15题：

    You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）

    • A、Internet Information Services
    • B、SQL Server Browser
    • C、SQL Server Agent
    • D、Microsoft Distributed Transaction Coordinator

    正确答案:B,D

  • 第16题：

    单选题
    Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company 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. 


    正确答案： C
    解析： 暂无解析

  • 第17题：

    单选题
    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 the administrator of a SQL Server 2005 computer， and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy， strong passwords are mandated for all domain， local， and application accounts. The company utilizes a Group Policy object （GPO） to deploy the proper domain password policy. MS-DOS-based or UNIX-based operating systems are run by many of the company’s computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator， you are required to confirm that the Services database can be accessed by these computers. And the company’s written security policy should not be violated.  Which action should be performed by you？（）
    A

    A domain account should be created for each of the company’s users. And then， each domain account should be offered with access to SQL1 and the Services database.

    B

    A local logon account should be created on SQL1 for each of the company’s users. And then， each logon account should be offered with access to SQL1 and the Services database.

    C

    One SQL Server logon account should be created for all of the company’s computers running MS-DOS or UNIX-based operating systems. And then， the Enforce password policy option should be enabled for users’ accounts. At last， the logon accounts should be provided with access to the Services database.

    D

    A SQL Server logon account should be created for each of the company’s users. And then， the Enforce password policy option should be enabled for each logon account. At last， each logon account should be offered with access to the Services database.

    E

    A virtual directory should be configured through Internet Information Services （IIS） for access to SQL1. And then， users should be directed to the virtual directory for data access.


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    You are the administrator of a SQL Server 2005 computer named SQL1. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain， local， and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object （GPO）. Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on SQL1. You need to ensure that these computers can access the Services database without violating the company’s written security policy.  What should you do？（）
    A

    Create a domain account for each of the company’s users. Provide each domain account with access to SQL1 and the Services database.

    B

    Create a local logon account on SQL1 for each of the company’s users. Provide each logon account with access to SQL1 and the Services database.

    C

    Create a SQL Server logon account for each of the company’s users. Enable the Enforce password policy option for each logon account. Provide each logon account with access to the Services database.

    D

    Configure a virtual directory through Internet Information Services （IIS） for access to SQL1. Direct users to the virtual directory for data access.

    E

    Create one SQL Server logon account for all of the company’s computers running MS-DOS or UNIX-based operating systems. Enable the Enforce password policy option for users’ accounts. Provide the logon accounts with access to the Services database.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    你有一台名为SQL1的SQL Server 2005服务器。用户反映运行在SQL1上的查询所需要的时间正稳步增长。你想用SQL Server Profiler追踪所有用户查询以调查此问题。你要决定在哪一个计算机上运行SQL Server Profiler，并且在这个计算机上存储相应的跟踪文件。要求，你的操作必须对SQL1性能的影响降到最低。你会如何做？（）
    A

    从SQL1控制台运行SQL Server Profiler。将跟踪信息存储到SQL1上的表中

    B

    从连接到SQL1的远程桌面运行SQL Server Profiler。将跟踪信息存储到另一台计算机的文件中

    C

    连接到SQL1的一台独立计算机中运行SQL Server Profiler。将跟踪信息存储到SQL1上的表中

    D

    从连接到SQL1的一台独立计算机中运行SQL Server Profiler。将跟踪信息存储到运行SQL Server Profiler的计算机文件中


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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？（）
    A

    Change the .NET application to define a new server connection to SQL2.

    B

    Configure a linked server on SQL1 to point to SQL2.

    C

    Configure a linked server on SQL2 to point to SQL1.

    D

    Change the stored procedures called by the .NET application to include the OPENXML command.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）
    A

    Internet Information Services

    B

    SQL Server Browser

    C

    SQL Server Agent

    D

    Microsoft Distributed Transaction Coordinator


    正确答案： B,D
    解析： 暂无解析

相关内容