Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005

문제1
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, 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.

B. 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.

C. 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.

D. 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.

정답: D

문제2
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, database mirroring should be utilized.

B. To achieve the goal, failover clustering should be utilized.

C. To achieve the goal, replication should be utilized.

D. To achieve the goal, log shipping should be utilized.

정답: A

문제3
According to the company requirement, a high-availability solution should be implemented for SQL06 and SQL07, the company assigns this task to you. You have to achieve this goal with using as little expense as possible. What action should you perform to accomplish this task?

A. In order to achieve the goal, a four-node failover cluster should be used.

B. In order to achieve the goal, a three-node failover cluster should be used.

C. In order to achieve the goal, log shipping should be used.

D. In order to achieve the goal, database mirroring should be used.

정답: B

문제4
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 computer is managed by you, and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement, rows which duplicate CustName values are included should be moved from the CustInfo table every year. However, the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates.
Since you are the technical support, you are required to think out a method to have potential duplicate rows identified for manual examination.
The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task?

A. A SELECT INTO query should be utilized, and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.

B. A new unique index should be created on the CustName column. And then, IGNORE_DUP_KEY = ON should be specified when creating index.

C. A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.

D. On the CustName column, a foreign key constraint should be created, and a distinct list of CustName values is referenced by the foreign key constraint.

정답: A

문제5
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. A SQL Server Integration Services (SSIS) package is created by you. Confidential information is contained in this package. Only two company employees will use this package. The package is stored in the msdb database. You have to make sure that the package can only be executed by the appropriate employees. The company requires that you should use as little administrative effort as possible when you try to achieve this. So what action should you perform?

A. After the package is saved to a file. You should use the Encrypting File System (EFS) to encrypt the file.

B. The package should be saved to a SQL Server 2005 computer that has an IPSec Secure Server policy applied.

C. The package should be configured to use the Encrypt all with user key package protection level.

D. The package should be configured to use the Encrypt all with password package protection level.

정답: D

문제6
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 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query, and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table, and 50,000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal?

A. A view should be created, and only the four columns that the query utilizes are contained by a view.

B. A composite index should be created on the three nvarchar columns, and INCLUDE should be specified for the XML column.

C. A primary XML index should be created on the XML column.

D. Statistics should be created on the nvarchar columns.

정답: B

문제7
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 administrator a SQL Server 2005 computer named SQL01. The company has configured the SQL Server service and the SQL Server Agent service to start automatically. There are users and applications that try to access information from SQL01. You are asked to configure SQL01 to audit all the user names and application names. SQL01 must perform auditing at all times, and the results must be kept for 10 years. What action should be performed?

A. On the server properties, the C2 Audit Tracing setting should be diabled.

B. A SQL Server Agent job should be created to run the SQL Trace stored procedure. The job should be configured to start when the SQL Server Agent service starts.

C. The server authentication mode should be configured as SQL Server and Windows Authentication mode.

D. The Login auditing setting should be set to Both failed and successful logins.

정답: B

문제8
According to the company requirements, the backup strategy should be designed for the BusinessData database. A strategy should be contained for backup redundancy. From the following four backup redundancy strategies, which one should be included?

A. Merely the filegroups that are not stored in a RAID disk array should backed up.

B. The database should be backed up to a disk backup device, and then the database should be backed up to a tape device.

C. A mirrored media set should be utilized to have the database backed up to multiple backup devices of the same type.

D. Different backup devices should be utilized for full backups and transaction log backups.

정답: C

문제9
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 find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly.
SELECT * FROM Orders WHERE OrderStatus = 'InProgress'
This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least.
Which action should be performed to finish the task?

A. To finish the task, the index should be recreated to have all of the columns in the table included.

B. To finish the task, the statistics should be updated on the index.

C. To finish the task, an indexed view of the Orders table should be viewed.

D. To finish the task, the index should be built by utilizing a FILLFACTOR of 10 percent.

정답: B

문제10
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 named SQL1. And it is reported by the users report that SQL01 responses slowly. You find that the network of SQL01 is excessively utilized. You cannot utilize the graphical SQL Server administrative tools to connect to SQL01. It is doubted whether a Denial of Service (DoS) attack targets at SQL01.
SQL01 should be connected to examine the present activities. Which action should be performed first to achieve the goal?

A. To achieve the goal, the dedicated administrative connection should be utilized to connect to SQL1.

B. To achieve the goal, SQL1 should be restarted.

C. To achieve the goal, SQL Server Profiler should be utilized to connect to SQL1.

D. To achieve the goal, the SQL Server service should be stopped and restarted on SQL1.

정답: A

최신Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 - 070-447무료샘플문제

KoreaDumps의 제품으로 GO GO GO !

자격증의 중요성:

KoreaDumps 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: