Online Access Free 070-447 Practice Test

In order to satisfy the security requirements of the company, you are asked to make recommendations for tracking usage on the acct1 database. What should you recommend?

• A.In SQL Trace, the Security Audit event category should be set up to track the Audit Schema Object Access event class.
• B.On all sensitive tables, DDL triggers should be created.
• C.On all sensitive tables, DML triggers should be created.
• D.In SQL Trace, the Security Audit event category in SQL Trace should be set up to track the Audit Database Object Management event class.

A most proper archiving strategy for the SalesData.Orders table in the Sales database should be identified. The archiving strategy should be implemented with the least amount of effect on performance. Which action should be performed?

• A.First, a table named ArchivedData.Orders should be created. Second, the SalesData.Orders table and its indexes should be partitioned. At last, MERGE, SPLIT, and SWITCH functions should be utilized every three months to remove old order data into ArchivedData.Orders.
• B.First, the Sales database should be backed up to tape every three months, and then a DELETE statement should be utilized to migrate archived data from the SalesData.Orders table.
• C.First, a database snapshot of the Sales database should be created every three months, and then a DELETE statement should be utilized to remove archived data from the SalesData.Orders table.
• D.First, a table named ArchivedData.Orders should be created. Second, an INSERT statement will be utilized to copy data from the SalesData.Orders table into ArchivedData.Orders every three months. At last a DELETE statement should be utilized to remove archived data from SalesData.Orders.

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.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.
• B.For Services and Connections, the SQL Server Surface Area Configuration should be run on each SQL Server computer.
• C.The Microsoft SQL Server Best Practices Analyzer should be run from a client computer on the network.
• D.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.

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 a database administrator for your company. A mission-critical customer relationship management (CRM) database is hosted by a new SQL Server 2005 computer, and the new SQL Server 2005 computer is called SQL2. The CRM database is available to all of the company's 500 employees in the sales and marketing departments. The purchase of new hardware and software should not exceed the annual budget for your department. A monitoring strategy should be devised, and the strategy enables you to make decisions about the history of server performance. In addition, how to arrange the most efficient method to allocate funds for hardware upgrades should be suggested by the monitoring strategy. Which action should be performed?

• A.SQL Server Profiler should be utilized to capture information to a SQL Server database table. And then, this task should be performed at regular intervals during periods of peak server activity.
• B.A counter log should be set to capture information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. And then, the log should be scheduled to execute at regular intervals, and the information should be stored in a comma-delimited text file.
• C.System Monitor in graph mode should be utilized to display information about %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec. And then, this task should be performed at regular intervals during periods of peak server activity.
• D.A series of performance alerts should be created to notify you when the acceptable thresholds are exceeded by %Processor Time, Average Disk Queue Length, Pages/sec, and Bytes Total/sec.

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 a database administrator for your company. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy, you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method, the company makes updates to the Price column. For instance, the utilization of ad hoc queries is one of the methods. Since you are the database administrator, you should confirm that this company policy takes its effect.which action should be performed?

• A.A trigger should be created, and changes are rolled back by the trigger to the Price column that violates company policy.
• B.A stored procedure should be created, and changes are disallowed by the procedure to the Price column that violates company policy.
• C.On the Price column, a foreign key constraint is created to a table that valid prices are included.
• D.On the Price column, a check constraint should be created, and a specified minimum value is required by the check constraint.