Pass4Test에서는 시장에서 가장 최신버전이자 적중율이 가장 높은 MCITP 70-447 (UPGRADE:MC DBA Skills to MCITP DB Admin by Using MS SQL 2005) 덤프를 제공해드립니다.MCITP 70-447 (UPG RADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005) 덤프는 IT업종에 몇십년간 종사한 IT전문가가 실제 시험문제를 연구하여 제작한 고품질 공부자료로서 시험패스율이 장난 아닙니다. 덤프를 구매하여 시험에서 불합격성적표를 받으시면 덤프비용 전액을 환불해드립니다.

 

 

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 the administrator of a SQL Server 2005 computer,
and the computer is called SQL1. There are two databases on the SQL1, and the two databases are
respectively named Production and DW. A new database named Staging is created. When the data are
moving from the Production database into the DW database, the Staging database is utilized temporarily
to store and manipulate data. Since you are the database administrator, you are required to make sure
the points listed below. First, the tables should not be removed from the Staging database. Second, any
attempts to have tables migrated should be logged. Third, your solution should not impact on other
databases. Which action should be performed to achieve the goal?
A.To achieve the goal, a DML trigger on each table should be created to prevent deletion of data.
B.To achieve the goal, a DDL trigger should be created, and that the ON DATABASE parameter is utilized
by DDL trigger for the Staging database.
C.To achieve the goal, an event notification should be created to fire when the TRUNCATE TABLE
Transact-SQL statement is submitted to the Staging database.
D.To achieve the goal, a DDL trigger should be created, and the ON ALL SERVER parameter is utilized by
the DDL trigger.
Answer:B

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 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.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
the computer is called SQL01. The users complain the slow response of all client applications which
connect to SQL01. You find that the CPU and memory utilization of SQL01 is low. In addition, the disk
activity is low. The cause of the performance problem should be identified. Which action should be
performed?
A.System Monitor should be utilized to have SQL1s cache hit ratio examined.
B.The sys.dm_db_index_physical_stats dynamic management function (DMF) should be examined.
C.The sys.dm_db_partition_stats dynamic management view (DMV) should be examined.
D.Task Manager should be utilized to have utilization of SQL1s network adapter examined.
Answer:D

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 user
database named Products is included by your SQL Server 2005 computer. SQL Server Integration
Services (SSIS) packages are utilized to export data from the Products database to a text file. You deliver
the text file to your company's trading partners by utilizing FTP. You are required to make sure that your
SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to
finish the task?
A.To finish the task, the Products database should be backed up.
B.To finish the task, your server should be set to utilize the full recovery model.
C.To finish the task, your server should be set to utilize the bulk-logged recovery model.
D.To finish the task, the msdb database should be backed up.
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 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.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 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