Online Access Free 070-447 Exam Questions

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 administer a SQL Server 2005 computer named SQL01. A database named DB01 is hosted on SQL01. DB1 plays the role of backend database for an application that tracks issues. DB01 helps desk technicians receive and the associated trouble tickets. When installed, the help desk application loaded several stored procedures and views that are used for data manipulation and reporting purposes. There are more than 50 tables in DB01. The bulk of the data is stored within the Employees, Issues, Assets, and AssetTracker tables. The AssetTracker table in DB01 is deleted by an application developer carelessly. The AssetTracker table is referenced by several views and functions in the database. You must make sure that critical tables cannot be removed by users such as this that are referenced by views or functions. So what action should you perform to make sure of this?

• A.First you should identify the dependencies of each view and function. Then For the Public role, the DENY-CONTROL permission should be configured on each critical table listed as a dependency.
• B.First you should identify the dependencies of each critical table. Then the syntax of each view and function should be changed to include the SCHEMABINDING syntax.
• C.All critical tables should be added to the same schema by using the ALTER SCHEMA Transact-SQL statement. For the Public role, the DENY-DELETE permission should be configured on the schema.
• D.For DB01, a new read-only filegroup should be created and all tables should be moved to the new filegroup.

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 administrator of a SQL Server 2005 computer, and the SQL Server 2005 computer is named SQL1. The company set the SQL Server service and the SQL Server Agent service to start automatically. SQL01 should be set to audit all user names and application names that try to access information from SQL01. Auditing should be performed by SQL01 at all times. And the company requires keeping the results for 10 years. Which action should be performed?

• A.A SQL Server Agent job should be created to run the SQL Trace stored procedure. And then, the job should be set to start when the SQL Server Agent service starts.
• B.The Login auditing setting should be set to not only failed but also successful logins.
• C.The server authentication mode should be set as SQL Server and Windows Authentication mode.
• D.The C2 Audit Tracing setting should be disabled on the server properties.

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 administrator of a SQL Server 2005 computer. An e-mail message should be sent to the company database auditing department, when the SQL Server service and the SQL Server Agent service are started, stopped, or paused. In addition, an e-mail message should be sent to them, when the users utilize the EXECUTE AS option with stored procedures and other commands.
Since you are the administrator, you are required to make sure that the e-mail messages that the auditing department needs should be sent to them. What should you do to finish the task? (Choose more than one.)

• A.To finish the task, SQL Server Profiler should be utilized to track the Audit Statement Permission event class.
• B.To finish the task, an Event Notification should be created on the Audit Server Starts and Stops event class.
• C.To finish the task, SQL Server Profiler should be utilized to track the Audit Server Principal Impersonation event class.
• D.To finish the task, a Windows Group Policy Object should be created to audit System Events.
• E.To finish the task, SQL Server Profiler should be utilized to track the Audit Server Starts and Stops event class.
• F.To finish the task, an Event Notification should be created on the Audit Server Principal Impersonation event class.

According to the company requirements, the interim disk availability solution should be designed for SQL1. Windows RAID functionality will be utilized. A most proper RAID configuration should be identified to meet the availability requirements. From the following four RAID configurations, which one should be utilized?

• A.A mirrored volume should be created for the system files and database logs, and a stripe set with parity should be created for the data files.
• B.A stripe set with parity should be created for the system files, database logs, and data files.
• C.A mirrored volume should be created for the system files and database logs, and a stripe set without parity should be created for the data files.
• D.A mirrored volume should be created for the system files, database logs, and data files.

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 a database administrator for your company. There is a Data Transformation Services (DTS) package, and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition (VBScript). The SQL Server 2005 Package Migration Wizard is run by you, but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005.
You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized?

• A.The SQL Server 2000 Data Transformation Services (DTS) package should be wrapped in an Execute DTS 2000 Package task.
• B.The SQL Server 2000 Data Transformation Services (DTS) package should be manually recreated as a SQL Server Integration Services (SSIS) package.
• C.The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails, a Transfer SQL Server Objects task should be run.
• D.The SQL Server 2000 Data Transformation Services (DTS) task should be configured to not utilize precedence constraints. Then, the SQL Server 2005 Package Migration Wizard should be run again.