70-444-writting and pictorial information published together

I have said writting and pictorial information will published together a few days later,now this information finally become really.We let you wait for some days,but our metarial with images can let you remeber it more easilier than before.it’s worth waiting for it.now share the new product.

1.You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 replicates with other SQL Server computers and manages multiserver automation jobs. It also exports data to staging databases for export to a data warehouse. After a few months without incident, SQL1 fails to start after a reboot. You review the security log, which returns the results that the Security Log Results exhibit shows. (Click the Exhibit button.) You then review an individual audit entry, which the Individual Audit Entry exhibit shows. (Click the Exhibit button.) The Default Domain Group Policy object (GPO) is configured with a Password Policy and Account Lockout Policy as shown in the following table. Enforce password history:24 passwords rememberedMaximum password age:42 daysMinimum password age:1 daysMinimum password length:7 charactersPassword must meet complexity requirements:EnabledStore passwords using reversible encryption:DisabledAccount lockout duration:0Account lockout threshold:5Reset account lockout counter after:60 minutes You need to ensure that SQL1 runs properly. What should you do?

 

A: Enable the contoso\sqlsrvc account. Then, change the password to a strong one. Finally, configure the account so that users cannot change the password. Configure the SQL Server services to use the new account password.
B: Delete the current contoso\sqlsrvc account. Then, create a new contoso\sqlsrvc account and ensure a strong password. Finally, configure the account so that users cannot change the password. Configure the SQL Server services to use the new account password.
C: Unlock the contoso\sqlsrvc account. Then, configure the account with a strong password. Configure the SQL Server services to use the new account password.
D: Configure the contoso\sqlsrvc account as a member of the local administrators group on SQL1. Configure the SQL Server services to use the new account password.
Correct Answers:  C

2.You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use?
A: DBCC DBREINDEX
B: SELECT * FROM sys.dm_db_index_physical_stats
C: DBCC INDEXDEFRAG
D: SELECT * FROM sys.indexes
Correct Answers:  B
3.You are a database administrator for your company. You have separate SQL Server 2005 development and production environments. You use the Business Intelligence Development Studio to create a SQL Server Integration Services (SSIS) package in your development environment. Then, you use the SSIS package to import data into your development environment from one of your company’s trading partners. You need to deploy the SSIS package to your production environment. Your production environment uses different table names than your development environment. What should you do?
A: Create a SQL Server Integration Services (SSIS) package configuration. Build a deployment utility. Copy the deployment folder for your SSIS project to your production server. Execute the manifest file.
B: Save the SQL Server Integration Services (SSIS) package to a file. Copy the file to the production server. Configure the SSIS package on the production server to use the new file.
C: Back up the master database and restore it to the production server. Rename the appropriate tables inside the master database.
D: Back up the msdb database and restore it to the production server. Rename the appropriate tables inside the msdb database.
Correct Answers:  A
4.You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 is configured to automatically perform transaction log backups, database integrity checks, and other maintenance tasks on a regular basis. Another administrator uses the SQL Server Surface Area Configuration tool to reconfigure SQL1. You notice that SQL1 no longer performs the automated maintenance tasks.  You need to ensure that the maintenance tasks on SQL1 are completed automatically. What should you do?
A: Reconfigure the SQL Server service to log on by using an administrative user account.
B: Reconfigure the server so that the SQL Server Agent service starts automatically.
C: Manually perform a full backup of the msdb database.
D: Reconfigure SQL1 to use Windows Integrated authentication.

Correct Answers:  B