Online Access Free 70-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 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 Remote Server connection to the application database should be configured.
• B.To achieve the goal, a Linked Server connection should be configured to the application database.
• C.To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.
• D.To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.

According to the company requirement, you are asked to design a stored procedure to import the registry information from AppServer1. The company requires that you do not execute unmanaged code. So what action should you perform to accomplish your task?

• A.In order to accomplish your task, a CLR stored procedure with the EXTERNAL_ACCESS permission set should be used.
• B.In order to accomplish your task, a regular stored procedure that calls xp_cmdshell should be used.
• C.In order to accomplish your task, an extended stored procedure should be used.
• D.In order to accomplish your task, a CLR stored procedure with the SAFE permission set should be used.
• E.In order to accomplish your task, a CLR stored procedure with the UNSAFE permission set should be used.

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. The company uses a SQL Server 2005 computer. Reporting Services are run by this computer. The server runs reports which include only data from the previous days sales. When reports are run during business hours, you notice that an OLTP database application runs slowly and that reports sometimes time out. Since you are the technical support, you have to resolve the problem and prevent it from recurring. So what action should you perform to achieve the goal?

• A.In order to achieve the goal, the report definitions should be stored on a separate server.
• B.In order to achieve the goal, the reports should be configured to run under the Snapshot isolation level.
• C.In order to achieve the goal, the size of the ReportServerTempDB database should be increased.
• D.In order to achieve the goal, the reports should be configured to use report snapshots. The report snapshots should be scheduled to run after business hours.

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 C2 Audit Tracing setting should be disabled on the server properties.
• D.The server authentication mode should be set as SQL Server and Windows Authentication mode.

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 hour. And then, a Check Database Integrity task should be set to run 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 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.
• 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.