YourcompanysWindowsServer2003environmentconsistsofasingleActiveDirectorydirectoryserviceforest.TheforesthasmultipledomainsandthreesitesnamedSite1,Site2,andSite3.Site1isthemainofficeandhasfourdomaincontrollers.Twoofthedomaincontrollersareglobalcatalogservers.Site2isabranchofficewithtwodomaincontrollers.Site3isabranchofficewithaslowandunreliableWANlinkandtwodomaincontrollers.YouneedtoimproveuserlogonperformanceforusersinSite2andSite3.
Whichtwoactionsshouldyouperform?()
查看答案
YourcompanyhasofficesinTorontoandChicago.BothofficesbelongtoanActiveDirectorydirectoryservicesitenamedSite1.ThereisonlyonedomaincontrollerinSite1.UsersintheChicagoofficeareexperiencingslowlogontimes.YoucreateanewActiveDirectorysitefortheChicagoofficenamedSite2.YoupromoteanewdomaincontrollerandcreateasitelinkbetweenSite1andSite2.YouneedtoimprovelogontimesfortheChicagousersandenableActiveDirectoryreplicationbetweentheSite1andSite2domaincontrollers.
Whichtwoactionsshouldyouperform?()
TestKing.comusesSQLServer2005.Youareimplementingaseriesofviewsthatareusedinadhocqueries.TheviewsareusedtoenforceTestKing.comssecuritypolicyofabstractingdata.Someoftheseviewsperformslowly.Youcreateindexesonthoseviewstoincreaseperformance,whilestillmaintainingthecompany’ssecuritypolicy.Oneoftheviewsreturnsthecurrentdateasoneofthecolumns.TheviewreturnsthecurrentdatebyusingtheGETDATE()function.Thisviewdoesnotallowyoutocreateanindex.Youneedtocreateanindexontheview.
Whichtwoactionsshouldyouperform?()
Youarecreatinganewsecuritypolicyforanapplicationdomain.Youwritethefollowinglinesofcode.
PolicyLevelpolicy=PolicyLevel.CreateAppDomainLevel();
PolicyStatementnoTrustStatement=
newPolicyStatement(
policy.GetNamedPermissionSet("Nothing"));
PolicyStatementfullTrustStatement=
newPolicyStatement(
policy.GetNamedPermissionSet("FullTrust"));
YouneedtoarrangecodegroupsforthepolicysothatloadedassembliesdefaulttotheNothingpermissionset.Iftheassemblyoriginatesfromatrustedzone,thesecuritypolicymustgranttheassemblytheFullTrustpermissionset.
Whichcodesegmentshouldyouuse?()
YouareresponsibleformanagingthedatabaseschemaforanorderentryapplicationinaSQLServer2005database.Afteradesignreview,amemberofthedevelopmentstaffasksyoutoaddanewcolumnnamedCommissionRatetotheProducttable.Becausetheactualcommissionratesforallproductsarenotknownatthistime,eachproducthasadefaultcommissionrateof12percent.Theratecanbemodifiedasnecessary.Youaddthenewcolumn.Youneedtoconfigurethetabletoassignthedefaultvalueasefficientlyaspossible.
Whatshouldyoudo?()