Youare adatabase developer.YouplantodesignadatabasesolutionbyusingSQLServer2008.You are creating adataba seto supportthe office manager.Your database modelhasthe following structure.
Thedatabasedesignhasthefollowing businessrequirements:Anemployeecanbeassignedmorethanone task.Uponcompletion,thetaskisdeleted.Whenataskisdeleted,theassociatedassignmentisdeleted.When an employee isnolonger availabletocomple tea task,theemployee linkto the assignmentisreplacedwithaNULLvalue.Youneed toimplementthebusinessrequirementstomaintaindataintegrity.
Whatshouldyoudo?()
第1题
rosoftMessagingandSecurityFeaturePack.Themessaginginfrastructureisconfiguredtosupporttheremotewipefeature.WhenanadministratorattemptstoperformaremotewipeofaWindowsMobilebaseddevice,theadministratorreceivesa401errormessage.Youneedtoensurethattheadministratorisauthorizedtoperformremotewipesonly.Whatshouldyoudo?()
A.GranttheadministratormembershipintheDomainAdministratorsgroup.
B.GranttheadministratormembershipintheExchangeAdministratorsgroup.
C.AddthenewadministratoraccounttotheDiscretionaryAccessControlList(DACL)oftheMicrosoftExchangeActiveSyncAdministrationfolder.
D.SelecttheDirectorySecuritytaboftheExchangeServeradministrationWebsite,andthenconfigureRead,Write,andDirectoryBrowsingpermissions.
第2题
xchangeServer2003servershowanexcessivenumberof401errors.Youneedtoreducethenumberof401errorsidentifiedinthelogs.Whatshouldyoudo?()
A.A
B.B
C.C
D.D
第3题
susemobiledevicesthatrunMicrosoftWindowsMobile5.0withMicrosoftMessagingandSecurityFeaturePack(MSFP).AremoteuserreportsthelossofaWindowsMobilebaseddevice.YouneedtoensurethattheinformationfromtheMicrosoftExchangeActiveSync(EAS)serverisnolongeravailableontheWindowsMobilebaseddevice.Whatshouldyoudo?()
A.RecreatetheActiveDirectoryremoteuseraccount.
B.PerformaremotewipeontheWindowsMobilebaseddeviceoftheremoteuser.
C.OnthePropertiestaboftheremoteuseraccount,disabletheuser-initiatedsynchronizationoption.
D.OntheDeviceSecuritySettingstab,configuretheWipedeviceafterfailedattemptsoptiontoavalueofzero.
第4题
ertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?()
A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)
B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)
C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘
D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE
第5题
nc. Active Directory InformationThe company has a main office and a branch office. The main office hosts all of the companys servers. The main office connects to the branch office by using a WAN link. The network contains a single Active Directory domain that has 500 users. The domain contains three domain controllers and an enterprise root certification authority (CA). All servers run Windows Server 2008 R2. All user accounts are in an organizational unit (OU) named Employees. The computer accounts for all desktop computers are in an OU named Desktops. The computer accounts for all portable computers are in an OU named Laptops. A startup script is deployed to all computers by using Group Policy objects (GPOs). Client ConfigurationsAll client computers run Windows 7 Enterprise. All users have desktop computers. All computers are members of the domain. All desktop computers use wired connections to connect to the network. All portable computers use wireless connections to connect to the network. The wireless network is secured by using EAP-TLS. Company policy states that all client computers must be configured by using DHCP. The company has an internal Web site. The Web site is configured to useSSL encryption and to require client certificates. All company users can access the internal Web site. End of repeated scenario Users in the branch office report slow network performance when they connect to the file shares in the main office. You need to recommend a solution to improve performance when users access the file shares from the branch office. The solution must minimize hardware costs. What should you recommend implementing?()
第6题
dows 7. Employees use Internet Explorer 8. Each time employees access a Web application, they are prompted to install an add-on. After each installation, the application restarts and prompts the employees to install the add-on again. You need to ensure that employees can run the application. What should you do?()
A.Use a script to install the add-on in Windows XP Mode.
B.Use a script to run the application in Windows XP Compatibility Mode.
C.Add the class identifier of the add-on to the Add-on list in Group Policy.
D.Set the Deny all add-ons unless specifically allowed in the Add-on list Group Policy setting to Disabled.
第7题
ngandSecurityFeaturePack.Youdeploythesolutionbyusingfront-endandback-endservers.MicrosoftExchangeServer2003ServicePack2isinstalledonthefront-endserver.Youneedtousetheremotewipefeature.Whatshouldyoudo?()
A.InstallMicrosoftWindowsServer2003ServicePack2onalldomaincontrollers.
B.InstallMicrosoftExchangeServer2003ServicePack2ontheback-endserver.
C.InstallMicrosoftExchangeServerActiveSyncWebAdministrationToolonthefront-endserver.
D.InstallMicrosoftExchangeServerActiveSyncWebAdministrationToolontheback-endserver.ResetInstructionsCalculator.
第8题
ecanbepurchased.Youneedtoidentifywhichoftheservers,initscurrentconfiguration,cansupportadditionaldatabases.Youneedtoensurethatyoursolutionfulfillsthecompany’ssecuriyrequirementswhileallowingforfuturedatabasegrowthrequirements.Whichserveranddatabasecombinationcanbeused?()
A.SQL3withtheOnlineReadOnlyandHRdatabases
B.SQL4withtheTravelOnlineandStorefrontdatabases
C.SQL2withtheStorefrontandTravelOnlinedatabases
D.SQL2withtheStorefrontandHRdatabases
第9题
servers.BothservershaveServicePack2installed.CompanysecuritypolicyrequiresthatallinformationfromtheExchangeServer2003serversmustbeencrypted.Youneedtoauditthemobilemessaginginfrastructuretoverifythatitcomplieswithcompanysecuritypolicy.Whatshouldyoudo?()
A.A
B.B
C.C
D.D
第10题
uritypolicyrequirescomplexpasswordsonalltheMicrosoftWindowsMobilebaseddevices.YouprovideaMicrosoftWindowsMobile5.0smartphonebaseddevicetoanewuser.Thefirsttimetheuserusesthedevice,theuserisnotpromptedforapassword.Youneedtoensurethattheuserispromptedforapassword.Whatshouldyoudo?()
A.InstructtheusertosetaPINonthemobiledevice.
B.InstructtheusertoperformMicrosoftExchangeActiveSyncsynchronizationOver-The-Air(OTA).
C.OntheDeviceSecuritySettingstab,selecttheRequirebothnumbersandlettersoption.
D.AddtheuseraccountoftheusertotheExceptionslistontheDeviceSecuritySettingstab.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!