1.You are a database administrator for your company. You are configuring a linked server named DB2 on a local server named DB1. You need to configure the options so that any administrator who is a member of the LocalDBAdmins group can connect to the linked server by using the remote logon of DBAdmin with a password of DBAdmin!1. All other users should be able to connect by using the remote logon of Guest with a password of Guest!1. What should you do? To answer, drag the appropriate security group, login, or password to the correct location or locations in the answer area.Drag and drop question. Drag the items to the proper locations.Correct Answers:2.You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 runs Windows Server 2003 and hosts a database named DB1. DB1 is used for a critical, enterprise-level application that all sales representatives in the company use. The database is currently 87 GB and grows 5 GB each quarter. SQL1 recently experienced a hard disk failure that resulted in significant system downtime. You purchase two new hardware RAID controllers named Controller1 and Controller2. You also purchase five new hard disk drives to try to prevent reoccurrences of hardware-related downtime. The new hard disk drives are configured as shown in the following table. Disk driveSizeRPMDisk1100 GB7200Disk2100 GB7200Disk3100 GB7200Disk460 GB7200Disk560 GB7200 The operating system is configured for redundancy. You decide to build a RAID5 array on Controller1 and a RAID1 array on Controller2. You need to ensure that DB1 continues to perform in the event of a disk failure. What should you do? To answer, drag the appropriate disk items and file types to the correct controller locations in the answer area.Drag and drop question. Drag the items to the proper locations.Correct Answers:3.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 DBREINDEXB: SELECT * FROM sys.dm_db_index_physical_statsC: DBCC INDEXDEFRAGD: SELECT * FROM sys.indexesCorrect Answers:  B 4.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 5.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 6.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.

本新闻共2页,当前在第1页  1  2