Exam Prep Questions


You would like to set up log shipping. Currently, no backups exist. The recovery mode is set to full on both the primary and secondary databases. The secondary database will be used as a read-only machine once it is set up. You make a full backup of the primary database. What else do you need to do?

  • A. Restore the full backup on the secondary database by using Recovery.

  • B. Restore the full backup on the secondary database by using NO RECOVERY.

  • C. Restore the full backup on the secondary database by using STAND BY.

  • D. Restore the full backup on the secondary database by using STOPAT.


Transactional replication offers low site autonomy, and merge replication offers high site autonomy. What is meant by site autonomy?

  • A. The measuring of the consistency of transactions

  • B. How long data in the subscriber can stay without being renewed

  • C. The independence of one site in relationship to others

  • D. How many subscribers and publishers are involved in a replication process


You work in a finance company where changes to the values in the Finance table are made quickly, and you want these incremental changes to be propagated to subscribers as they occur. The subscribers are always connected to the publisher with a reliable connection. Which type of replication do you use when you want updated changes at the server in almost real-time?

  • A. Snapshot replication

  • B. Snapshot replication with updating subscribers

  • C. Transactional replication

  • D. Merge replication


You and Josh are replicating data to multiple subscribers who need to update data at various times and propagate those changes to the publisher and to other subscribers. These subscribers need to be able to make changes offline and later synchronize data. They therefore need a replication strategy that offers high autonomy. Which type of replication offers almost complete site autonomy?

  • A. Snapshot replication

  • B. Snapshot replication and transactional replication

  • C. Merge replication

  • D. Transactional replication

  • E. Transactional replication with updating subscribers


Your company has just purchased an accounting application from a vendor. The application stores its data in a database named Accounting. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used. You need to replicate data from this database to another SQL Server computer. That server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.

You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Select two answers, with each correct answer representing part of the solution.)

  • A. Implement merge replication.

  • B. Implement snapshot replication.

  • C. Implement transactional replication.

  • D. Schedule replication to run continuously.

  • E. Schedule replication to run during off-peak hours.


You want to implement a high-availability solution on your support database. You need to do so as inexpensively as possible, but you also need the server to continue automatically upon failure. Which of the following is the best solution?

  • A. Use log shipping to configure a monitor to implement failover.

  • B. Use database mirroring with a witness configured to implement failover.

  • C. Use merge replication.

  • D. Use failover clustering.


You would like to test database mirroring. You configure an endpoint on each machine and assign the endpoint to its partner. You make a full backup and you restore it to the mirror database. You would like to synchronize the databases to begin processing. What must you do?

  • A. Configure a witness to synchronize the machines.

  • B. Perform a log backup on the principal and restore it to the mirror.

  • C. Configure failover on the principal database.

  • D. Configure security on both databases.

MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net