자신을 부단히 업그레이드하려면 많은 노력이 필요합니다. IT업종 종사자라면 국제승인 IT인증자격증을 취득하는것이 자신을 업그레이드하는것과 같습니다.MCITP 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) 시험을 패스하여 원하는 자격증을 취득하려면 Pass4Test의 MCITP 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) 덤프를 추천해드립니다. 하루빨리 덤프를 공부하여 자격증 부자가 되세요.

NO.1 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 primary XML index should be created on the XML column.
B.Statistics should be created on the nvarchar columns.
C.A view should be created, and only the four columns that the query utilizes are contained by a view.
D.A composite index should be created on the three nvarchar columns, and INCLUDE should be
specified for the XML column.
Answer:D

NO.2 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 a financial services
company. Replication is configured between two SQL Server 2005 computers, and the servers are
respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is
utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a
large amount of data. Since you are the database administrator, you need to make sure that data is
replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during
replication. In addition, you need to make sure that this data is replicated securely. Which action should
be performed?
A.Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for
a standard subscription.
B.Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard
subscriber for a standard subscription.
C.Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an
updateable subscription.
D.Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard
subscriber for an updateable subscription.
Answer:B

NO.3 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. The
users report the slow performance of a SQL Server 2005 application. You are required to identify the
queries which perform slowly because of blocking. Which action should you perform?
A.In a SQL Trace log file, you should look for queries with low duration values and high read and write
values.
B.In a query execution plan, you should look for queries with missing or out-of-date statistics.
C.In a SQL Trace log file, you should look for queries with high duration values and low read and write
values.
D.In a query execution plan, you should look for queries with a large number of table scans.
Answer:C

NO.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 the database administrator for your company. You
find a problem that there are three reports which are running slowly. And through detailed analysis, you
conclude that no error messages are generated from these reports. Not only the indexing strategy but
also the status of the current indexes is tested by you. You confirm that the slow performance of the
financial reports is not caused by it. Since you are the technical support, you are required to find out which
statement is causing the slow performance. Which action should be performed first?
A.SQL Server Profiler should be run with the Lock:Deadlock event class.
B.The Database Engine Tuning Advisor (DTA) f should be run or at least one hour.
C.SQL Server Profiler should be run with the TSQL_Duration template.
D.The Database Engine Tuning Advisor (DTA) should be run with the default options.
Answer:C

NO.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 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.The sp_executesql batches are not being recovered from the procedure cache.
B.A database administrator executed UPDATE STATISTICS statements on all tables, and the most
common stored procedures reference all the tables.
C.One new stored procedure is created by a database administrator.
D.Ad hoc batches are not being recovered from the procedure cache.
Answer:B

NO.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. Your job is
to manage a SQL Server 2005 database, and there are several indexes in the SQL Server 2005. A stored
procedure should be written, and the procedure should be utilized to check the indexes for fragmentation.
From the following four Transact-SQL statements, which one should be utilized achieve the goal.
A.To achieve the goal, DBCC DBREINDEX should be utilized.
B.To achieve the goal, SELECT * FROM sys.indexes should be utilized.
C.To achieve the goal, SELECT * FROM sys.dm_db_index_physical_stats should be utilized.
D.To achieve the goal, DBCC INDEXDEFRAG should be utilized.
Answer:C

NO.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 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 stored procedure should be created, and changes are disallowed by the procedure to the Price
column that violates company policy.
B.On the Price column, a check constraint should be created, and a specified minimum value is required
by the check constraint.
C.A trigger should be created, and changes are rolled back by the trigger to the Price column that violates
company policy.
D.On the Price column, a foreign key constraint is created to a table that valid prices are included.
Answer:C