Youworkattheregionalsalesoffice.YouareresponsibleforimportingandexportingdatainSQLServer2005databases.Themainofficeasksyoutosendthematextfilethatcontainsupdatedcontactinformationforthecustomersinyourregion.Thedatabaseadministratorinthemainofficeasksthatth

Youworkattheregionalsalesoffice.YouareresponsibleforimportingandexportingdatainSQLServer2005databases.Themainofficeasksyoutosendthematextfilethatcontainsupdatedcontactinformationforthecustomersinyourregion.ThedatabaseadministratorinthemainofficeasksthatthedatabesortedbytheStateProvince，Surname，andFirstNamecolumns.Youneedtosatisfytheserequirementsbyusingtheleastamountofeffort.Whatshouldyoudo？（）

A.SpecifyStateProvince，Surname，andFirstNameintheORDERhintinthebcpoutcommand.

B.Createaformatfilefortheexportoperation.

C.SpecifyStateProvince，Surname，andFirstNameintheORDERBYclauseinthebcpqueryoutcommand.

D.CopythedataintoanewtablethathasaclusteredindexonStateProvince，Surname，andFirstName.Exportthedata.