单项选择题
单项选择题 YouareresponsibleforimportingdataintoSQLServer2005databases.Yourdepartmentisstartingtoreceivetextfilesthatcontainsalestransactionsfromstoresacrossthecountry.Columnsinthedataareseparatedbysemicolons.Youneedtoimportthefilesintothesalesdatabase.Whatshouldyoudo?()A.Createacustomformatfile,specifyingasemicolonastherowterminator.B.Usethebcpcommand,specifyingasemicolonasthefieldterminator.C.Usethebcpcommandwiththedefaultarguments.D.UsetheBULKINSERTstatementwiththedefaultarguments.
单项选择题 AnapplicationusesWindowsAzureTablestorage.Theapplicationusesfivetables.Onetableusedbytheapplicationisapproachingthelimitforstoragerequestspersecond.Youneedtorecommendanapproachforavoidingdataaccessthrottling.Whatshouldyourecommend?()A.Useasinglepartitionkeyforthetable.B.Compressdatabeforestoringitinthetable.C.Createadditionalpartitionkeysforthetable.D.Continuallyremoveunnecessarydatafromthetable.
单项选择题 AWindowsAzureapplicationretrievesdatafromSQLAzure.Youneedtorecommendanapproachforimprovingapplicationqueryperformance.Whatshouldyourecommend?()