Online Access Free 070-447 Exam Questions

DRAG DROP
Drag Drop question

Correct Answer:

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 computer is called SQL01. Three instances of SQL Server are run by the SQL01. After implementing the recovery plan, the dedicated administrative connection is available on each instance of SQL Server. After the ability is tested, a problem has been found that the dedicated administrative connection on SQL01s default instance can be connected, while the dedicated administrative connection on the two other instances on SQL1 cannot be connected. You confirm that the instances are running and the instances can be accessed by the client applications. In addition, the dedicated administrative connection is enabled for all instances. What??s more, there is no connection that is tried to by other administrators to any dedicated administrative connections on SQL1.
Since you are the administrator, you are required to make sure the dedicated administrative connection can be connected on all three instances. To achieve the goal, which action should be utilized?

• A.The default instance should be set to utilize an administrative port number which differs from 1434.
• B.The non-default instances of SQL Server should be stopped and restarted.
• C.The SQL Server Browser service should be started. And then, the service should be set to start automatically.
• D.The Sqlcmd.exe tool should be utilized to make the dedicated administrative connection.

According to the company requirement, you have to design the data archiving solution for the CRM database. You must make sure that your solution implements and satisfies the research and auditing requirements by using as little administrative effort as possible. Of the following actions, which should be specified to occur at the end of each month?

• A.In order to guarantee that the older data and the newer data are kept on different table partitions, the CRM database needs to be reorganized.
• B.You should print a copy of the older CRM data by using SQL Server Reporting Services (SSRS), and keep each report for five years. After printing each report, delete the older data should be deleted from the CRM database after each report is printed.
• C.A full backup of the CRM database should be created and each backup should be kept for five years. After creating each backup, delete the older data should be deleted from the CRM database after each backup is created.
• D.The CRM data should be exported to a Microsoft Excel spreadsheet and each spreadsheet should be kept for five years. The older data should be deleted from the CRM database after each spreadsheet is created.

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. You utilize the SP:Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options, which one is the most possible cause of the problem?

• A.Ad hoc batches are not being recovered from the procedure cache.
• B.The sp_executesql batches are not being recovered from the procedure cache.
• C.One new stored procedure is created by a database administrator.
• D.A database administrator executed UPDATE STATISTICS statements on all tables, and the most common stored procedures reference all the tables.

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, you should use SQL Server Profiler to create a trace that uses a predefined template.
• D.In order to achieve the goal, the sp_who system stored procedure should be run.