Exam 70-444 study material Made available by Testkingprep.com
Free 70-444 Exam Preparation Questions Exam 70-444: Optimizing and Maintaining a Database Administration Solution by Using SQL Server 2005
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
Question:1 If a DDL trigger that applies to a database uses FOR DDL_TABLE_EVENTS,which of the following Transact-SQL statements will cause it to fire? (Choose all that apply.) A. CREATE TABLE B. ALTER TABLE C. CREATE DATABASE D. ALTER DATABASE Answer: A, B Question:2 You are mastering a SQL Server 2005 computer, which is called SQLTEST1. SQLTEST1 does a job which performs a full backup of a database called HTESTR. And it also does a job which performs differential backups each weeknight. All jobs have the option enabled to verify data in the backup. The HTESTR database is always unable to be restored after a failure due to errors with the data stored on the tape. You have to ensure that as much data as possible is restored by designing a restore process even when errors occur. So what should you do ? A. You should develop a database restore process by utilizing Transact-SQL Trigger, including the CHECKSUM option. B. You should develop a database restore process by utilizing Transact-SQL.you should include the CONTINUE_AFTER_ERROR option. C. You should develop a database restore process by utilizing SQL Distributed Management Objects (SQL-DMO). You should configure the ReplaceDatabase property to False. D. You should develop a database restore process by utilizing SQL Server Management Studio. Before restoring each backup, you should enable the selection to Prompt. Answer: B Question:3 If problems occur after the installation of a service pack, which of the following steps should a database administrator take first? A. Roll back the service pack. B. Perform Automated System Recovery. C. Restore all system databases. D. Restore all user databases. Answer: A Question:4 You are mastering the company database, including the SQL Server 2005 computer called SQLTEST1. SQLTEST1replicates with other SQL Server computers and controls multilevel automation work. It also export data to staging databases for export to a database warehouse. SQLTEST1 could not start after a reboot few months later. You check the security log which returns the results that the Security Log Results exhibit shows. (Click the Exhibit button.) The Default Domain Group Policy object (GPO) is configured with a Password Policy and Account Lockout Policy as displayed in the following table. Enforce password history:24 passwords remembered Maximum password age:42 days Minimum password age:1 days Minimum password length:7 characters Password need to satisfy complexity requirements:EnabledStore passwords utilizing reversible encryption:DisabledAccount lockout duration:0Account lockout threshold:5Reset account lockout counter after:60 minutes. What should you do to ensure that SQL1 runs properly?
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
A. You should add the BHR \sqlsrvc account as a member of the local administrators group on SQL1. Then set the SQL Server services to utilize the new one. B. You should unlock the BHR\sqlsrvc account. Then configure the account with a strong password. Set the SQL Server services to utilize the new account password. C. You should enable the BHR \sqlsrvc account. You should alter the password to a strong one. Finally, Add the account so that users couldn??t change the password. Set the SQL Server services to utilize the new account password. D. You should remove the current BHR \sqlsrvc account. Then, you should develop a new BHR \sqlsrvc account and ensure a strong password. Finally, you should configure the account so that users cannot change the password. Set the SQL Server services to utilize the new account password. Answer: B Question:5 Which of the following tools can be used to determine whether a Windows Server 2003 computer has the most recent service packs, hotfixes, and updates installed? A. SQL Server Management Studio (SSMS) B. Windows Server Update Services (WSUS) C. Microsoft Baseline Security Analyzer (MBSA) D. Business Intelligence Development Studio (BIDS) Answer: C Question:6
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
You are mastering 12 SQL Server 2005 computers. One of the SQL Server computers called SQL9 is unavailable after 16:00 for almost an hour. During this time, one of the other SQL Server administrators performed a quick routine maintenance task including a restart. The SQL Server logs on SQL9 during the period in question is shown in the exhibit. (Click the Exhibit button.) What you should do is to make this situation not occur again. So what should you do to achieve this?
A. You should ask the other SQL Server administrators not to start the SQL Server service in single user mode for routine maintenance. B. In order to start the SQL Server service, you should teach the other SQL Server administrators to utilize a Windows domain user account. C. You should teach the other SQL Server administrators not to utilize the net start sqlserveragent command to run the SQL Server Agent service. D. In order to start the SQL Server service ,You should teach the other SQL Server administrators not to utilize the net start mssqlserver command. Answer: A Question:7 Which of the following maintenance tasks will compact a clustered index? A. Shrink Database B. Reorganize Index C. Check Database Integrity D. Update Statistics Answer: B Question:8 Which of the following maintenance tasks is used to ensure that the query optimizer has up-to-date information about the distribution of data values within database tables? A. Rebuild Index B. Reorganize Index C. Check Database Integrity
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
D. Update Statistics Answer: D Question:9 As the administrator of the database in your company, you are managing the Microsoft Windows Server 2003 computer called SQLTEST. SQL Server 2005 runs on the SQLTEST computer, which is a member of the Microsoft Active Directory domain named Bhr.com. All the deploy settings have been configured on the domain; The information security team utilizes the Microsoft Windows XP Professional, Apple operating systems to run assessments. The team workers of the information security request you to develop the new logon accounts for them to access to SQLTEST. They want the logon accounts to have the following user names and passwords: User name\password for first account: adminTest1\ passwordTest1 User name\password for second account: adminTest2\passwordTest2. So what should you do to supply the information security team with the requested access to SQLTEST. Which is the correct answer? A. you should develop LOGIN [BHR\adminTest1] FROM WINDOWS CREATE LOGIN [BHR \ passwordTest2] FROM WINDOWS B. you should develop LOGIN adminTest1 WITH PASSWORD = ' passwordTest1 ' CREATE LOGIN hacktestWITH PASSWORD = 'password' C. you should develop LOGIN adminTest1 WITH PASSWORD = ' passwordTest1 ' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = ON D. you should develop LOGIN adminTest1WITH PASSWORD = ' passwordTest1 ' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = OFF Answer: D Question:10 You are the administrator of a SQL Server 2005 computer named SQLA which runs Windows Server 2003 and hosts a database named DB A. DBA 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. Recently a hard disk failure occurred on SQL1 that leads to a system downtime. You buy two new hardware RAID controllers named Controller1 and Controller2. In trying to prevent the hardwarerelated downtime reoccurring, you buy five new hard disk drives which are configured as shown in the following table. Disk driveSizeRPMDisk1100 GB7200Disk2100 GB7200Disk3100 GB7200Disk460 GB7200Disk560 GB7200 The operating system is configured for redundancy. You plan to build a RAID5 array on Controller1 and a RAID1 array on Controller2. So what should you do to ensure that DB1 continues to perform even if there??s a disk failure. To answer, drag the appropriate disk items and file types to the correct controller locations in the answer area. Answer & Explanation Correct Answer Explanations No more information available
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
Answer: Pending Question:11 Which of the following maintenance plan tasks allows an administrator to schedule the execution of a custom SSIS package? A. Execute SQL Server Agent Job B. Clean Up History C. Update Statistics D. Check Database Integrity Answer: A
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
Question:12 You are managing your company database. There is a SQL Server 2005 computer including a single user database named DBTEST1 in the company. All company employees link to DBTEST1. The database should be fault-tolerant and that failovers asks for no administrative effort according to the company policy. You should provide fault tolerance for the database. What you should do is to make sure that client computers are able to link to the database, even when a complete hardware failure occurs on the SQL Server 2008 computer, including a failure of all disks. So what should you do? A. You should run Transactions to another SQL Server 2008 computer. B. You should run a new server cluster which includes the database. C. You should run database mirroring to another SQL Server 2008 computer. D. You should run transactional replication to another SQL Server 2008 computer. Answer: C Question:13 Which dynamic management view should you query to display all tape backup devices installed on a computer hosting a SQL Server 2005 instance? A. sys.dm_io_backup_tapes B. sys.dm_io_pending_io_requests C. sys.dm_io_cluster_shared_drives D. sys.dm_io_virtual_file_stats Answer: A Question:14 You are managing your company database. You manage a SQL Server 2005 database called ContractTEST, which breaks down. You use the following Transact-SQL script to operate a restore. RESTORE DATABASE ContractTESTFROM contracts_bu_deviceWITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY The SQL Server logs show errors in some of the page restores after the restores. What you should do is to repair the database pages which are corrupted as soon as possible. So which Transact-SQL statement should you use? A. you should add code: ALTER DATABASE Contracts SET TRUSTWORTHY ON B. you should add code: ALTER DATABASE Contracts SET TORN_PAGE_DETECTION ON C. you should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH TABLOCK D. you should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS Answer: C Question:15 Which of the built-in reporting services roles are allowed to perform the Create Linked Reports task outside of the My Reports folder? (Choose all that apply.) A. Content Manager B. Publisher C. Browser D. Report Builder Answer: A, B Question:16 You are managing a SQL Server 2005 computer named SQLTEST2, which runs a single SQL Server instance. You manage SQLTEST2 from an administrative workstation named DBATEST1. SQLTEST2 fails to respond to user queries intermittently. At present it is not responding to your connection through SQL Server Management Studio. So what should you do to solve this problem? A. You should restart the SQL Server Browser on SQLTEST2. B. By utilizing the Administrator logon account which is built into Microsoft Windows. You should Log on to SQLTEST2.
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
C. By utilizing the SA logon account that is built into SQL Server, you should Log on to the SQL Server instance on SQLTEST2. D. You should Log on interactively to SQLTEST2 as an administrator. Then build a dedicated administrator connection to the SQL Server instance. Answer: D Question:17 You need to assign several Reporting Services users the ability to create resources outside the My Reports folder. Which of the following roles could you assign to these users? A. Publisher B. System User C. My Reports D. Browser Answer: A Question:18 You are logged on to a SQL Server computer that has Reporting Services installed. You want to use Internet Explorer to connect to the local instance of Report Manager. Which of the following URLs should you use? A. localhost/ReportManager B. localhost/ReportServer C. localhost/Reports D. localhost/ Answer: C Question:19 The transaction log for an applications database is stored on a RAID10 volume.Auto-growth is not enabled. You suspect that the log might be running out of space. The storage capacity of the RAID10 array is not an issue. Which SQLServer:Databases counter should you monitor? A. Log Cache Hit Ratio B. Percent Log Used C. Log Growths D. Log Shrinks Answer: B Question:20 You are managing your company database. There is a stored procedure in one of the databases on a SQL Server 2005 computer. The stored procedure is used by users to import data into a table, and the stored procedure has to use the TRUNCATE TABLE command before importing new data into the table. However, the users who run the stored procedure have no permission to truncate the table. What you should do is to provide a way for the stored procedure to truncate the table before new data is imported. So what should you do? A. In the table, you should grant the users UPDATE permission. B. You should add the users to the db_datawriter fixed database role. C. You should set the stored procedure to use the EXECUTE AS command. D. You should set the stored procedure to be owned by the same database user as the table Answer: C Question:21 Which of the following conditions are necessary to support self-mapping?(Choose all that apply.) A. The destination instance is configured to support Windows authentication. B. The connecting instance is configured to support SQL Server authentication. C. The connecting instance is configured to support Windows authentication. D. The destination instance is configured to support SQL Server authentication.
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
Answer: A, C Question:22 You are managing Microsoft Windows Server 2003 computer. Your company buys a new enterprise sales application, which runs SQL Server 2005. The application uses stored procedures including the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy indicates that all enterprise applications must run under the context of a service account which requires the minimum amount of privileges. What you should do is to configure the SQL Server service to run under the proper context for the installation of the new enterprise sales application. So what should you do? A. You should make the SQL Server run under the context of the remote account. B. You should make the SQL Server run under the context of the domain user account. C. You should make the SQL Server run implement under the context of the administrator account D. You should make the SQL Server run under the context of the local Administrator account Answer: B Question:23 Three users of the system for which you are the administrator are able to execute distributed queries through a linked-server configuration. Another user is unable to. All four users authenticate with the connecting server using Windows authentication. Login mappings use default settings, and no login mappings have been configured for any users. Which of the following is the most likely reason that only the fourth user is unable to execute distributed queries against the linked server? A. The destination instance does not support Windows authentication. B. The destination instance does not support SQL Server authentication. C. The Account Is Trusted For Delegation account property is set in Active Directory. D. The Account Is Sensitive And Cannot Be Delegated account property is set in Active Directory. Answer: D Question:24 You are managing two SQL Server 2005 computers, which are called SQLTEST1 and SQLTEST2. You were not in charge of the original installation of SQL Server on these computers. but you should make sure that both of the computers are configured according to the requirements followed. Even if the system is unresponsive, administrators can still remotely link to SQLTEST1 and SQLTEST2 for troubleshooting. SQLTEST1 and SQLTEST2 should not have the ability to implement commands related to the operating system. Database access must be allowed by using Simple Object Access Protocol (SOAP) messages over HTTP. SQLTEST1 and SQLTEST 2 should not have the ability to send e-mail by using stored procedures. Use of the OPENROWSET and OPENDATASOURCE Transact-SQL statements should not be allowed. Stored procedures for generating HTML should not be allowed. So what should you do to configure SQL1 and SQL2 to meet these requirements? A. You should utilize SQL Server Surface Area Configuration for Features. B. You should utilize SQL Server Surface Area Setting for Services and Connections. C. You should utilize Web Service to configure the proper server features on SQLTEST1 and SQLTEST2. D. You should utilize Transactions log to confugire the appropriate server features on SQLTEST1 and SQLTEST2. Answer: A
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html
For complete Exam 70-444 Training kits and Self-Paced Study Material Visit: http://www.testkingprep.com/70-444.html
http://www.testkingprep.com/
For Latest 70-444 Exam Questions and study guides- visit- http://www.testkingprep.com/70-444.html