Pass4Test의 MCITP 70-447 (UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 200 5) 덤프는 착한 가격에 100%에 달하는 적중율과 패스율을 보장해드립니다. 시험에서 불합격성적표를 받으시면 덤프구매시 지불한 덤프비용을 환불처리해드립니다. Pass4Test의  MCITP 70-447 (UPGRA DE: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. 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 built by utilizing a FILLFACTOR of 10 percent.
B.To finish the task, the index should be recreated to have all of the columns in the table included.
C.To finish the task, an indexed view of the Orders table should be viewed.
D.To finish the task, the statistics should be updated on the index.
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 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.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 named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers
belong to a Microsoft Active Directory domain. According to the company written security policy, strong
passwords are mandated for all domain, local, and application accounts. The company utilizes a Group
Policy object (GPO) to deploy the proper domain password policy. MS-DOS-based or UNIX-based
operating systems are run by many of the company's computers. Varying levels of access to a database
named Services on SQL1 is requested by the computers. Since you are the database administrator, you
are required to confirm that the Services database can be accessed by these computers. And the
company's written security policy should not be violated. Which action should be performed by you?
A.A domain account should be created for each of the company's users. And then, each domain account
should be offered with access to SQL1 and the Services database.
B.A local logon account should be created on SQL1 for each of the company's users. And then, each
logon account should be offered with access to SQL1 and the Services database.
C.One SQL Server logon account should be created for all of the company's computers running MS-DOS
or UNIX-based operating systems. And then, the Enforce password policy option should be enabled for
users' accounts. At last, the logon accounts should be provided with access to the Services database.
D.A SQL Server logon account should be created for each of the company's users. And then, the Enforce
password policy option should be enabled for each logon account. At last, each logon account should be
offered with access to the Services database.
E.A virtual directory should be configured through Internet Information Services (IIS) for access to SQL1.
And then, users should be directed to the virtual directory for data access.
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 a database administrator for your company. There is a
Data Transformation Services (DTS) package, and the DTS package is stored in SQL Server 2000. And
you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically
configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition (VBScript).
The SQL Server 2005 Package Migration Wizard is run by you, but the wizard cannot convert the
package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS
package runs in SQL Server 2005. And the package should be run in the shortest time. Which action
should be utilized?
A.The SQL Server 2000 Data Transformation Services (DTS) package should be wrapped in an Execute
DTS 2000 Package task.
B.The SQL Server 2000 Data Transformation Services (DTS) package should be manually recreated as a
SQL Server Integration Services (SSIS) package.
C.The SQL Server 2000 Data Transformation Services (DTS) task should be configured to not utilize
precedence constraints. Then, the SQL Server 2005 Package Migration Wizard should be run again.
D.The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails, a Transfer
SQL Server Objects task should be run.
Answer:A

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