A. Named Pipes B. TCP IP C. Shared Memory D. Virtual In……

单项选择题YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.TransactionlogshippingoccursfromSQL1toSQL2byusingdefaultSQLServerAgentschedulesettings.YouneedtoreconfiguretransactionlogshippingtoprovideminimumlatencyonSQL2.Whatshouldyoudo?（）

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. 

单项选择题AfullbackupofyourdatabasenamedDB1iscreatedautomaticallyatmidnighteveryday.DifferentialbackupsofDB1occurtwiceeachdayat10:00andat16:00.Adatabasesnapshotiscreatedeverydayatnoon.AdeveloperreportsthatheaccidentallydroppedthePricelisttableinDB1at12:30.ThelastupdatetoPricelistoccurredoneweekago.YouneedtorecoverthePricelisttable.Youwanttoachievethisgoalbyusingtheminimumamountofadministrativeeffort.Youmustalsominimizetheamountofdatathatislost.Whatshouldyoudo?（）

A. Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1. 
B. Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot. 
C. Recover DB1 from the most recent backup. Apply the most recent differential backup. 
D. Copy the Pricelist table from the most recent database snapshot into DB1.

多项选择题Yourcompanyusesamission-criticaldatabasenamedDB1,whichislocatedonaservernamedSQL1.YouwanttomirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversformirroring.Whichthreeactionsshouldyouperform?（）

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.

单项选择题YourcompanyusesaSQLServer2005database.CustomerdatafromyourtradingpartnersisimportedintotheCustomerstableeverynight.YouneedtoensurethatthecustomerrecordisupdatedifitalreadyexistsintheCustomerstable.Iftherecorddoesnotexist,thedataneedstobeinsertedintotheCustomerstable.Whatshouldyoudo?（）

A. Create a FOR trigger. 
B. Create an INSTEAD OF trigger. 
C. Create an AFTER trigger. 
D. Create a DDL trigger.

单项选择题YouarecreatingaviewtojointheCustomersandOrderstablesinaSQLServer2005database.Youneedtoensurethattheviewcannotbeaffectedbymodificationstounderlyingtableschemas.Youwanttoaccomplishthisgoalbyusingtheleastpossibleamountofoverhead.Whatshouldyoudo?（）

A.Create CHECK constraints on the tables. 
B.Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
C.Create the view, specifying the WITH SCHEMABINDING option. 
D.Create the view, specifying the WITH CHECK option.