CMS专题
单选题You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify you
题目
Schedule the full backups to run after the nightly index is rebuilt.
Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
Schedule an additional transaction log backup to run after the nightly index is rebuilt.
Schedule a marker to be added to the transaction log before the nightly index is rebuilt.
参考答案和解析
相似问题和答案
第1题：
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
- A、Database Control
- B、Management Server
- C、Management Repository
- D、Application Server Control
- E、Oracle Management Agent
正确答案:E
第2题：
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）
- A、Configure a Linked Server connection to the application database.
- B、Write a query that uses an OPENDATASOURCE command.
- C、Write a query that uses an OPENQUERY command.
- D、Configure a Remote Server connection to the application database.
正确答案:B
第3题：
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.
解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.
第4题：
You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）
- A、Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.
- B、Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.
- C、Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.
- D、Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.
正确答案:D
第5题：
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.
正确答案:D
第6题：
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
- A、Hot backup
- B、Online backup
- C、consistent backup
- D、incremental backup
- E、inconsistent backup
正确答案:C
第7题：
You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）
- A、Use the Lock Waits/sec performance counter.
- B、Use the Number of Deadlocks/sec performance counter.
- C、Use the Transactions/sec performance counter.
- D、Use the Full Scans/sec performance counter.
- E、Use the Batches/sec performance counter.
正确答案:D,E
第8题：
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.
The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.
How should you configure the database?
A．Configure the database on the two servers as a SQL Server 2000 cluster.
B．Configure the database on one server, and then configure a standby database on the second server.
C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
D．Configure the database as a federated database, and then partition half the data on each server.
解析：Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS).
In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.
Incorrect Answers:
B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.
Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server's copies of databases must be restored back to the primary server.
C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.
Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.
An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.
D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.
第9题：
You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases. What should you include in your naming convention（）？
- A、For each mailbox database， provide a database name that is unique within the organization.
- B、For each mailbox database， provide a database name that is unique within the Mailbox server.
- C、For each mailbox database file， provide a file name that is unique within the organization.
- D、For each mailbox database file， provide a file name that is unique within the Mailbox server.
正确答案:A
第10题：
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators. Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers. Which action will you perform to achieve the goal?（）
- A、To achieve the goal, the Import and Export Wizard should be utilized to save packages.
- B、To achieve the goal, a direct package configuration should be created for each package.
- C、To achieve the goal, a deployment utility should be created for the SSIS project.
- D、To achieve the goal, an indirect package configuration should be created for all packages.
正确答案:C