网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 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 database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.
考题
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 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 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 the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.What should you do?A．Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.B．Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.C．Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.D．Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
考题
You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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 designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A、 Use the bcp utility.B、 Use the dta utility.C、 Use the SQL Server Import and Export Wizard.D、 Attach each SQL Server database to SQL Azure.
考题
You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）A、Create a new performance alert to monitor the Current Bandwidth counter.B、Create a new performance alert to monitor the Bytes Total/sec counter.C、Configure the new performance alert to start a SQL Server Profiler trace.D、Configure the new performance alert to start a Network Monitor capture.
考题
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.
考题
You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）A、SQL3 with the OnlineReadOnly and HR databasesB、SQL4 with the TravelOnline and Storefront databasesC、SQL2 with the Storefront and TravelOnline databasesD、SQL2 with the Storefront and HR databases
考题
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 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.
考题
You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）A、Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.B、Query the sys.server_permissions table on Server1.C、Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.D、Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
考题
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 uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?（）A、 Set the recovery model of DB1 on SQL1 to bulk-logged recovery. B、 Set the recovery model of DB1 on SQL1 to full recovery. C、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option. D、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option. E、 Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.F、 Create endpoints on all participating servers. G、 Set the AutoShrink property of DB1 on SQL1 to false.
考题
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 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.
考题
单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）A
Use the bcp utility.B
Use the dta utility.C
Use the SQL Server Import and Export Wizard.D
Attach each SQL Server database to SQL Azure.
考题
单选题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 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 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
热门标签
最新试卷
