单选题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？（）AMSAS 2005：CacheBMSAS 2005：MemoryCMSAS 2005：Proactive CachingDSQLServer：Buffer Manager
单选题
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
参考解析
解析：
暂无解析
相关考题：
Your company has a domain controller named Server1 that runs Windows Server 2008 R2. Server1 has the DNS Server server role installed.You need to configure the DNS server to resolve IP addresses to host names.Which record should you create？（）A. Pointer (PTR)B. Host Info (HINFO)C. Service Location (SRV)D. Canonical Name (CNAME)
Your company has a domain controller named Server1 that runs Windows Server 2008 R2 and the DNS Server server role. A server named Server2 runs a custom application.You need to configure DNS to include the following parameters for the custom application: Service Priority Weight Protocol Port number Host offering this service Which record should you create？（）A. Host Info (HINFO)B. Service Location (SRV)C. Canonical Name (CNAME)D. Well-Known Service (WKS)
Your company has a domain controller named Server1 that runs Windows Server 2008 and the DNS server role. A server named Server2 runs a custom application. You need to configure DNS to include the following parameters for the custom application： Service Priority Weight Protocol Port Number Host offering this service Which record should you create？（）A、 Host Info （HINFO）B、 Service Locator （SRV）C、 Canonical Name （CNAME）D、 Well-Known Service （WKS）
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
公司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实用工具连接到SQL1B、使用专用管理员连接的sqlcmd实用工具连接到SQL1C、用SQL Server Management Studio连接到SQL1。打开一个查询窗口并执行以下语句：DBCC TRACEON 1244D、在SQL Server Management Studio中，在工具栏上，点击数据库引擎查询以打开连接到数据库引擎对话框。在服务器名称文本框内，敲入ADMIN：SQL1。选择SQL Server身份认证并提供你的sa身份。点击连接按钮
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.
Your company has a server named Server1 that runs Windows Server 2008. The Windows Backup and Restore utility is installed on Server1. Server1 fails. You install a new server named Server2 that runs Windows Server 2008. You need to restore the companys Windows SharePoint Services （WSS） site to Server2 What should you do？（）A、 Use Wbadmin to restore the system state from backupB、 Run Wbadmin with the Get Versions option. Install WSSC、 Run Wbadmin with the Start Recovery option. Install WSSD、 Use Wbadmin to restore the application and the sites from backup
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. 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 ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator
单选题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?（）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.
单选题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.
单选题Your company has a server named Server1 that runs Windows Server 2008. Server1 runs the DHCP server role and the DNS server role. You also have a server named ServerCore that runs a ServerCore installation of Windows Server 2008. All computers are configured to use only Server1 for DNS resolution. The IP address of Server1 is 192.168.0.1. The network interface on all the computers is named LAN. Server1 is temporarily office. A new DNS server named Server2 has been configured to use the IP address 192.168.0.254. You need to configure ServerCore to use Server2 as the preferred DNS server. What should you do？（）A Run the netsh interface ipv4 add dnsserver LAN static 192.168.0.254 index=1 commandB Run the netsh interface ipv4 set dnsserver LAN static 192.168.0.254 192.168.0.1 both commandC Run the netsh interfface ipv4 set dnsserver LAN static 192.168.0.254 primary command and the netsh interface ipv4 set dnsserver LAN static 192.168.0.1 both command.D Run the netsh interface ipv4 set dnsserver LAN static 192.168.0.254 primary command and the netsh interface ipv4 add dnsserver LAN static 192.168.0.1 index=1 command
单选题你有一台名为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的计算机文件中
单选题Your company has a server named Server1 that runs Windows Server 2008. The Windows Backup and Restore utility is installed on Server1. Server1 fails. You install a new server named Server2 that runs Windows Server 2008. You need to restore the companys Windows SharePoint Services （WSS） site to Server2 What should you do？（）A Use Wbadmin to restore the system state from backupB Run Wbadmin with the Get Versions option. Install WSSC Run Wbadmin with the Start Recovery option. Install WSSD Use Wbadmin to restore the application and the sites from backup
单选题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.
单选题Your company has a domain controller named Server1 that runs Windows Server 2008 R2.Server1 has the DNS Server server role installed.You need to configure the DNS server to resolve IP addresses to host names.Which record should you create？（）APointer (PTR)BHost Info (HINFO)CService Location (SRV)DCanonical Name (CNAME)
单选题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.
单选题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? （）AYou should install SQL Server 2008 as the default instance, and configure the new application to use the default instance BYou should upgrade the SQL Server 2005 application to use SQL Server 2008 CYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance DYou should install SQL Server 2008 as a named instance, and make the new application use the new instance.
单选题Your company has a domain controller named Server1 that runs Windows Server 2008 R2. Server1 has the DNS Server server role installed.You need to configure the DNS server to resolve IP addresses to host names. Which record should you create？（）APointer (PTR)BHost Info (HINFO)CService Location (SRV)DCanonical Name (CNAME)
单选题Your company has a server named Server1 that runs Windows Server 2008 R2. The Windows Server Backup feature is installed on Server1.Server1 fails. You install a new server named Server2 that runs Windows Server 2008 R2.You need to restore the companyˉ Windows SharePoint Services (WSS) site to Server2. What should you do?（）AUse Wbadmin to restore the system state from backup.BRun Wbadmin with the Get Versions option. Install WSS.CRun Wbadmin with the Start Recovery option. Install WSS.DUse Wbadmin to restore the application and the sites from backup.
单选题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 work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （）AYou should use local Service accountBYou should use network Service accountCYou should use domain accountDYou should use local System account
单选题Your company has a domain controller named Server1 that runs Windows Server 2008 R2 and the DNS Server server role. A server named Server2 runs a custom application. You need to configure DNS to include the following parameters for the custom application: ?¤Servic ?¤Priorit ?¤Weigh ?¤Protoco ?¤Port numbe ?¤Host offering this servic Which record should you create？（）AHost Info (HINFO)BService Location (SRV)CCanonical Name (CNAME)DWell-Known Service (WKS)
单选题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.
单选题Your company has a domain controller named Server1 that runs Windows Server 2008 and the DNS server role. A server named Server2 runs a custom application. You need to configure DNS to include the following parameters for the custom application： Service Priority Weight Protocol Port Number Host offering this service Which record should you create？（）A Host Info （HINFO）B Service Locator （SRV）C Canonical Name （CNAME）D Well-Known Service （WKS）
多选题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？（）AInternet Information ServicesBSQL Server BrowserCSQL Server AgentDMicrosoft Distributed Transaction Coordinator