MCITP 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) 덤프로 MCI TP 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) 시험을 패스,하지 못하셨다구요? 최선을 다했는데도 실패하였다는 말은 영원히 하지마세요.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 20 05) 덤프로 시험에 다시 도전해보세요.

 

 

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

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 the administrator of a SQL Server 2005 computer.
And recently the server performs gradually slowly. The indexing environment is troubleshooted by you.
The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The
most frequently accessed nonclustered index will be optimized by you. The
sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the
results from the table listed below. When the entire index is not read, the nonclustered index which is
being utilized the most frequently should be identified. From the following four object_id and index_id
combinations, which one should be utilized to finish the task?
A.To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
B.To finish the task, the object_id 869578136 and the index_id 5 should be utilized.
C.To finish the task, the object_id 309576141 and the index_id 1 should be utilized.
D.To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.
E.To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
Answer:B

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 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 trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data
is included.
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.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.
D.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.
Answer:D

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