Instantly download 070-447 training test engine

According to the company business and technical requirements, a high-availaQbility strategy should be designed for the proseware_projects database. Which strategy should be utilized to achieve the goal?

• A. To achieve the goal, replication should be utilized.
• B. To achieve the goal, database mirroring should be utilized.
• C. To achieve the goal, failover clustering should be utilized.
• D. To achieve the goal, log shipping should be utilized.

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 vendor company's application is utilized, and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor, and the new OLE DB driver will be utilized when the application database is queried. According the company requirements, the connections between the SQL Server database and the application database is prohibited, except when this data is queried. You should think out a method to have data queried from the application database.
Which action should be performed to achieve the goal?

• A. To achieve the goal, a Linked Server connection should be configured to the application database.
• B. To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.
• C. To achieve the goal, a Remote Server connection to the application database should be configured.
• D. To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.

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 called SQL01. SQL01 is in a Microsoft Active Directory domain. No rights or privileges are assigned to you to have domain administration performed. However, the company has granted you membership in the local Administrators group on SQL01. Most of the management of SQL01 is performed from your administrative workstation. However, according to the company security requirements, you intend to have all attempts for interactive logons and network connections to SQL1 tracked. Which action should be performed?

• A. A Group Policy object (GPO) should be created, and the GPO is set to audit success and failure of the Audit account logon events setting. And then, the domain administrator should be requested to link the GPO to the object including SQL01.
• B. The local security policy of SQL1 should be edited. Then, success and failure auditing should be set on the Audit logon events setting.
• C. The SQL Server service should be set on SQL01 to audit all successful and failed logon attempts.
• D. The SQL Server Profiler should be run and a standard default template should be utilized.

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. Transaction information for the company's Web-based order system is stored by a database on one of the company's SQL Server 2005 computers. The company configures the database to utilize the full recovery model. Quite few orders are received between the hours of 19:00 and 04:00. And the risk for data loss which the company can accept should not be longer than an hour. The company requires performing the Database backups in the shortest time. A maintenance plan should be developed to administrate this risk. Which action should be performed?

• A. A Back Up Database task should be set to do a full backup of the database every day at
  19:00.
  And then, a second Back Up Database task should be set to do differential backups at 09:00 and 14:00. At last, a third Back Up Database task should be set to do transaction log backups every hour.
• B. A Back Up Database task should be set to do a full backup at 09:00 and 14:00. And then, a second Back Up Database task should be set to do transaction log backups every hour.
• C. A Back Up Database task should be set to do a full backup of the database every hour. And then, a Check Database Integrity task should be set to run every hour.
• D. A Back Up Database task should be set to do a full backup of the database every day at
  19:00.
  And then, a second Back Up Database task should be set to do differential backups at 09:00 and 14:00. At last, a Check Database Integrity task should be set to run every hour.

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. There is a SQL Server 2005 computer named SQL01 in the company. A stores sales history data is stored in a database on SQL01 for the company's Web-based order system. Twenty of the business analysts in the company create ad hoc queries against the database. SQL01 has a slow performance all the time. Since you work as the technical support, the company asks you to identify which business analyst is causing the problem. What action should you perform to achieve this goal? (Choose more than one.)

• A. In order to achieve the goal, you should gather database activity by running SQL Trace system stored procedures.
• B. In order to achieve the goal, you should view the activity of specific business analysts by using the Activity Monitor.
• C. In order to achieve the goal, the sp_who system stored procedure should be run.
• D. In order to achieve the goal, you should use SQL Server Profiler to create a trace that uses a predefined template.