默认题库 - MCITP(70-443)

单选题

You need to design a hosting service option for customers who want to access their databases by using their own Active Directory domain accounts. What should you do？（）

A. Design a hosting service option that duplicates each customer’s domain user account as SQL Serverlogin account.
B. Design a hosting service option that provides VPN-based connectivity from each customer’s network tothe SQL Server computer that hosts that customer’s daabase or databases.
C. Design a hosting service option that provides a dedicated server to each customer.Join that server to that customer’s Active Directory domain
Design a hosting service option that configures a unique instance of SQL Server 2005 for each customer.Configure that instance to use Integrated Windows authentication.

查看答案

单选题

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 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 database

查看答案

单选题

You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）

A. Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.
B. Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.
Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.
D. Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.

查看答案

单选题

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 design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）

A. one SQL Server 2005 computer with one instance
B. two SQL Server 2005 computers， each with two instances
C. two SQL Server computers， one with one instance and one with three instances
D. one SQL Server 2005 computer with two instance

查看答案

多选题

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 Editio

查看答案

多选题

You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）

A. Set the appropriate local password policies for all computers on which SQL Server is installed.
B. Set the server authentication mode of all SQL Server instances to Windows Authentication mode.
C. Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.
D. Create SQL Server logins that have CHECK_POLICY enabled.

查看答案

单选题

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.

查看答案