Question 1.
You need to set up the Bid_Archive database. What should you do?

A. Configure merge replication to move the data between the Bids and Bid_Archive databases.
B. Set up DML triggers to move rows from the Bids database to the Bid_Archive database when the Completed column in the Bid_Tracking table is set to 1 and the Successful column is set to 0.
C. Configure snapshot replication to move all data from the Bids to the Bid_Archive database.
D. Create a job that is scheduled to run every hour to check for rows in the Bid_Tracking table where the Completed column is set to 1 and the Successful column is set to 0.

Answer: B

Question 2.
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? (Each correct answer presents a complete solution. Choose two.)

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

Answer: A, D

Question 3.
Your account name is Pat and you are a member of the db_owner database role. You have the permissions that are required to create the assembly for the new custom application that manages the replication for the Customer database. You need to minimize the attack surface on the server, while creating the assembly for the CLR to use. You need to ensure that your solution fulfills the companys security requirements. 

Which two options should you use? (Each correct answer presents part of the solution. Choose two.)

A. WITH PERMISSION_SET = External_Access
B. WITH PERMISSION_SET = Unsafe
C. WITH PERMISSION_SET = Safe
D. AUTHORIZATION dbo
E. AUTHORIZATION Pat

Answer: A, D

Explanation:
D: Case study text: All assemblies should be created with dbo as the owner.

Question 4.
You are a member of the DBAdmins group. You need to configure the HTTP endpoints for the new Web services application that will access the Customer database. You want to accomplish this goal by using the minimum amount of administrative effort, while fulfilling the companys technical requirements. 

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A. Install Internet Information Services (IIS) 6.0 on ITCertKeys B.
B. Create an implicit namespace reservation while executing the CREATE ENDPOINT command.
C. Ask the Windows administrator to create an explicit namespace reservation for the HTTP endpoint.
D. Assign the Control permission on the endpoint to all users that will use the Web services application.
E. Assign the Connect permission on the endpoint to all users that will use the Web services application.

Answer: C, E

Question 5.
You need to define the data type and the table options for a new column named Annual Review in the HR database. 

Which two options should you select? (Each correct answer presents part of the solution. Choose two.)

A. Use the text data type.
B. Use the nvarchar(max) data type.
C. Use the varchar(max) data type.
D. Set the large value types out of row option to Off.
E. Set the large value types out of row option to On.
F. Set the text in row option to Off.
G. Set the text in row option to 7000.

Answer: B, E

Question 6.
DRAG DROP 
Your boss, Mrs. ITCertKeys, wants you to design the backup schedule for the Customer database.
Not all locations have to be filled.
 
Answer:
 
Question 7.
You need to design the consolidation plan for ITCertKeys A, ITCertKeys B, and ITCertKeys C. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the companys 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 instances

Answer: D

Question 8.
You need to review the list of expected services for SQLCLUST and disable any nonessential services. 

Which two services should be disabled? (Each correct answer presents part of the solution. Choose two.)

A. Cluster service
B. World Wide Web Publishing service
C. SQL Server Agent service
D. Messenger service
E. Server service

Answer: B, D

Question 9.
You configure the new server named SQLCLUST with test versions of the Research, Engineering, and Parts databases. The data in these databases is for test purposes only and is not current. You need to move the new Research, Engineering, and Parts databases from the test stage to the production stage as efficiently as possible. 

Prior to making the databases available to users, which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

A. Use the DELETE statement to remove all test data from the three databases.
B. Run scripts on the production server to build all tables, views, and stored procedures.
C. Schedule one or more jobs to move all data from the mainframe computer databases to the new databases.
D. Build all indexes, and update the statistics on all tables.
E. Manually move all data from the mainframe computer to the new databases by using the SELECT INTO command.

Answer: B, C, D

Question 10.
You need to configure the security for the HR database to support current security needs, while minimizing the impact of future security changes that might be caused by user and table additions. 

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.) 

A. Grant the SELECT permission on all current tables to the public database role.
B. Create an HR_Readers role, add all employees in the HR department to this role, and grant the SELECT permission on all current tables to this role.
C. Add all employees to the db_datareader database role.
D. Add all hiring managers to the db_datawriter database role.
E. Create a Hiring_Managers role, add all hiring managers to this role, and grant the role the SELECT, INSERT, UPDATE, and DELETE permissions on the five tables the hiring managers need to manage.

Answer: B, E

	Web www.certsbraindumps.com