100% Microsoft 070-447 Guaranteed Success With Testing Engine

Microsoft 070-447 Exam Overview:

Microsoft 070-447 Exam Syllabus Topics:

Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 Sample Questions:

Question #1
According to the company business and technical requirements,a management plan should be created for the goldengenius_biz database. The action which should be taken is needed to be specified, before manually inserting data through a bulk load process. The availability and recoverability business requirements should be met, and the least amount of administrative effort should be utilized. From the following four actions, which one should be specified to finish the task?

A. To finish the task, a differential backup should be created.
B. To finish the task, a full backup should be created.
C. To finish the task, a database snapshot should be created.
D. To finish the task, replication should be configured.

Question #2
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company.10 SQL Server 2005 computers are managed by you. The computers are located on an isolated portion of the company's network that has been limited from accessing the Internet. The SQL Server 2005 computers can only be accessed by intranet client computers. In order to identify only the missing operating system or SQL Server patches, hotfixes, and service packs, you are asked to audit the SQL Server computers. What action should you perform?

A. The Microsoft SQL Server Best Practices Analyzer should be run from a client computer on the network.
B. You should scan the IP address of the 10 SQL Server 2005 computers by running the Microsoft Baseline Security Analyzer (MBSA) from a client computer on the network. MBSA should be configured to check for SQL Server vulnerabilities and security updates against a network Windows Server Update Services (WSUS) server.
C. You should scan the IP address of the 10 SQL Server 2005 computers by running the Microsoft Baseline Security Analyzer (MBSA) from a client computer on the network. MBSA should be configured to check for Microsoft Windows vulnerabilities, SQL Server vulnerabilities, and security updates against Microsoft Windows Update.
D. For Services and Connections, the SQL Server Surface Area Configuration should be run on each SQL Server computer.

Question #3
You are a professional level SQL Server 2005 database administrator in an international
corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You administrator a SQL Server 2005 computer named SQL01. The company has configured the SQL Server service and the SQL Server Agent service to start automatically. There are users and applications that try to access information from SQL01. You are asked to configure SQL01 to audit all the user names and application names. SQL01 must perform auditing at all times, and the results must be kept for 10 years. What action should be performed?

A. On the server properties, the C2 Audit Tracing setting should be diabled.
B. A SQL Server Agent job should be created to run the SQL Trace stored procedure. The job should be configured to start when the SQL Server Agent service starts.
C. The server authentication mode should be configured as SQL Server and Windows Authentication mode.
D. The Login auditing setting should be set to Both failed and successful logins.

Question #4
DRAG DROP
According to the company requirement, the backup schedule should be designed for the customer database.
Which action should be performed to achieve the goal? (Drag the proper backup type to the right location in the answer area.)

Question #5
According to the company business and technical requirements, security is designed for the HTTP endpoint for the proseware_projects application. Which login or logins should be granted the CONNECT permission on the HTTP endpoint should be identified. From the following four logins, which one or two should you utilize? (Choose all that apply.)

A. You should utilize EdsA local Windows group including the PROSEWARE\Editors domain global group.
B. You should utilize ContractWritersA local Windows group including the PROSEWARE\Contractors domain global group.
C. You should utilize BUILTIN\UsersA local Windows group including the PROSEWARE\DomainUsers domain global group.
D. You should utilize PMsA local Windows group including the PROSEWARE\ProjectManagers domain global group.

Solutions: