MCITPMCITP(70-443)章节练习(2019.05.04)

多项选择题
You need to review the current storage system and decide on the best configuration for the tempdb database on SQL1 to improve tempdb performance. Your solution must ensure that company requirements and policies are fulfilled.Which two actions should you perform？（）
A.Create a RAID-1 set， and move tempdb to this drive set.
B.Create a RAID-0 set， and move tempdb to this drive set.
C.Set the starting size of tempdb to 3 GB
D.Create a RAID-0 set， and move tempdb and the user database with the largest index to this drive set.
E.Disable automatic file growth on tempdb.
单项选择题
You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）
A.SQL3 with the OnlineReadOnly and HR databases
B.SQL4 with the TravelOnline and Storefront databases
C.SQL2 with the Storefront and TravelOnline databases
D.SQL2 with the Storefront and HR databases
多项选择题
You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new R&D configuration， which will include the Research， Parts， and Engineering databases.Which two combinations will be the most appropriate？（）
A.Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise Edition
B.Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise Edition
C.Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise Edition
D.Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition
单项选择题
You need to implement an authentication method on SQL4. The TravelOnline database will be accessed through a Web services application. You need to make the authentication method as secure as possible.What should you do？（）
A.Create an HTTP endpoint with NTLM authentication， and create a service principal name （SPN）.
B.Create an HTTP endpoint with digest authentication， and create a service principal name （SPN）.
C.Create an HTTP endpoint with integrated authentication， and create a service principal name （SPN）.
D.Create an HTTP endpoint with Kerberos authentication.
单项选择题
You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）
A.a domain user account
B.a local user account
C.the NETWORK SERVICE account
D.the LOCAL SYSTEM account
单项选择题
You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）
A.Place each database in a separate instance running on SQL2.
B.Place each database in a separate instance running on SQL3.
C.Place both databases in a single instance running on SQL2.
D.Place both databases in a single instance running on SQL3.
单项选择题
You need to specify the changes to the existing firewall configuration settings that are required by the HTTP endpoint that will be used by the proseware_projects database. What should you do？（）
A.Create a Web publishing rule on ISA2 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
B.Create a Web publishing rule on ISA1 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
C.Create a Web publishing rule on ISA2 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
D.Create a Web publishing rule on ISA1 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
单项选择题
You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support. What should you do？（）
A.Specify that each server must have one instance for each customer.
B.Specify that each server must each have only one instance.
C.Specify that each server must have one instance for each database that is hosted on that server.
D.Specify that each server must have one instance for each customer who has one or more databases that are hosted on that server.
单项选择题
You need to configure Active Directory to implement the new password policy for the HR department. What should you do？（）
A.Create a new child domain named hr.ad.margiestravel.com in the existing forest. Move the resources from the HR OU to this new domain. Add the appropriate security settings in the Default Domain Policy for this new domain.
B.Add the appropriate security settings to the current Default Domain Policy.
C.Add the appropriate security settings to the local security policy of SQL1.
D.Set the SQL server check_policy and check_expiration options to On when creating all user accounts.
单项选择题
You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard disks for this server. What should you do？（）
A.Configure the hard disks as a RAID-0 array， and store the backups on this new array.
B.Configure the hard disks as a RAID-5 array， and store the backups on this new array.
C.Configure the hard disks as a RAID-10 array， and store the backups on this new array.
D.Configure the hard disks as a spanned volume， and store the backups on this new volume.
E.Use the hard disks to extend the volume that currently holds SQL Server backups.