单选题You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）AConfigure the database to use the bulk-logged recovery model.BEach night， rebuild only those indexes that require it.CDisable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.DIncrease the time between transaction log backups.
单选题
You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）
A
Configure the database to use the bulk-logged recovery model.
B
Each night， rebuild only those indexes that require it.
C
Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D
Increase the time between transaction log backups.
参考解析
解析：
暂无解析
相关考题：
You are the administrator of two Microsoft Windows 2000 computers. One computer is running Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)A．Configure the IIS virtual directory to allow URL queries.B．Configure the IIS virtual directory to allow template queries.C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.
You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.You cancel the SQL Server upgrade wizard.You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.Which three actions should you take? (Each correct answer presents part of the solution. Choose three)A. Install SQL Server 2000 as a named instance.B. Install SQL Server 2000 as the default instance.C. Configure the new instance for Mixed Mode Authentication.D. Configure the new instance for Windows Authentication.E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.F. Configure the server to use the Multiprotocol Net-Library.
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.
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
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 your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.B、In a query execution plan， you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.D、In a query execution plan， you should look for queries with a large number of table scans.
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? （） A、You should use local Service accountB、You should use network Service accountC、You should use domain accountD、You should use local System account
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 your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
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 your company. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least. Which action should be performed to achieve the goal？（）A、To achieve the goal， the UPDATE STATISTICS command should be excuted.B、To achieve the goal， the SQL Server Service should be restarted.C、To achieve the goal， the SQL Server computer should be restarted.D、To achieve the goal， the statistics in the dynamic management view （DMV） should be reset.
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.
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
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances. Which service should you start?（） A、Server B、SQL Server Agent C、SQL Server Browser D、SQL Active Directory Helper
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
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.
单选题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?（）AMicrosoft SQL Server 2005 Mobile EditionBMicrosoft SQL Server 2005 Express EditionCMicrosoft SQL Server 2005 Standard EditionDMicrosoft SQL Server 2005 Workgroup Edition
单选题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 your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）ATo achieve the goal， DBCC DBREINDEX should be utilized.BTo achieve the goal， SELECT * FROM sys.indexes should be utilized.CTo achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.DTo achieve the goal， DBCC INDEXDEFRAG should be utilized.
单选题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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）AThe SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.BThe SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.CThe SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.DThe SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）AYou should install SQL Server 2008 as a named instance, and make the new application to use the new instance. BYou should install SQL Server 2008 as the default instance, and make the new application to use the default instance. CYou should upgrade the SQL Server 2005 application to use SQL Server 2008. DYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances. Which service should you start?（）AServer BSQL Server Agent CSQL Server Browser DSQL Active Directory Helper
单选题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.
单选题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 the administrator of a SQL Server 2005 computer， and the computer is called SQL01. The users complain the slow response of all client applications which connect to SQL01. You find that the CPU and memory utilization of SQL01 is low. In addition， the disk activity is low. The cause of the performance problem should be identified. Which action should be performed？（）ASystem Monitor should be utilized to have SQL1s cache hit ratio examined.BThe sys.dm_db_index_physical_stats dynamic management function （DMF） should be examined.CThe sys.dm_db_partition_stats dynamic management view （DMV） should be examined.DTask Manager should be utilized to have utilization of SQL1s network adapter examined.
单选题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
单选题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？（）ATo achieve the goal， a DML trigger on each table should be created to prevent deletion of data.BTo achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.CTo achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.DTo achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
多选题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.
单选题You are the administrator of a Windows 2000 network. You install Windows 2000 Professional on a new computer and configure the TCP/IP settings to have a static IP address. While testing network connectivity from the new computer, you discover an error in the DNS server address that is configured in the TCP/IP settings. You configure the correct DNS server address, which is 10.1.1.5. However, you are still unable to successfully connect to network resources by name. You run the IPconfig/all command. The results indicate that the DNS server address is now configured as 0.0.0.0 You need to ensure that the computer can connect to network resources by name. What should you do?（）AStop and restart the DNS Client service.BAdd 10.1.1.5 to the DNS server list on the TCP/IP Advanced Properties tab.CAdd an A （host） record for the computer to the DNS server’s zone file.DConfigure your DHCP server to have a DNS server address of 10.1.1.5.
多选题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