070-447 무료 덤프문제 온라인 액세스

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. MSDOS-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 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.
• C.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.
• D.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.
• E.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.

According to the company requirements, a unique nonclustered index will be created on
the CustomerID, LastName, and FirstName columns of the CustomerData.Customers table in the CRM database. The variables should be identified to help estimate the space requirements for the index.
Estimated number of rowsClustered index key Number of columns in the indexFixed data sizeNumber of variable-length columnsAverage variable-length data size.
The most significant additional variable that will enhance the estimated index size should be identified. From the following four additional variables, which one should be identified to accomplish the task?

• A.To accomplish the task, automatically generated uniqueifier value should be identified.
• B.To accomplish the task, null bitmap should be identified.
• C.To accomplish the task, current number of rows should be identified.
• D.To accomplish the task, fill factor should be identified.

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. There is a SQL Server 2005 computer in the company. A single user database named DB01 is contained in this computer. All company employees connect to DB1. According to the requirement of the company policy, the database should be fault-tolerant and that failovers require no administrative effort. Therefore, you are asked to provide fault tolerance for the database.
Your solution must guarantee that even if a complete hardware failure occurs on the SQL Server 2005 computer, client computers are able to connect to the database, including a failure of all disks. What action should you perform to achieve your goal?

• A.A two-node server cluster that contains the database needs to be implemented.
• B.Database mirroring to another SQL Server 2005 computer needs to be implemented.
• C.Transactional replication needs to be implemented to another SQL Server 2005 computer.
• D.Log shipping needs to be implemented to another SQL Server 2005 computer.

According to the performance and availability requirements of the company, you are asked to implement the new read-only copy of the internet_rentals database on SQL02. What should you do?

• A.On SQL02, a new instance of SQL Server 2005 should be installed. A new database should be created. Between internet_rentals and the new database, transactional replication should be configured.
• B.A new SQL Server 2005 computer should be installed. Then a new database should be created on that server. Between internet_rentals and the new database, snapshot replication should be configured.
• C.A new SQL Server 2005 computer should be installed. Then a new database should be created on that server. Between internet_rentals and the new database, merge replication should be configured.
• D.A new SQL Server 2005 computer should be installed. Then a new database should be created on that server. Between internet_rentals and the new database, transactional replication should be configured.
• E.On SQL02, a new database should be created. Between internet_rentals and the new database, transactional replication should be configured.

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 new SQL Server 2005 computer is set by you. There are five hard disks on the computer. Since you are the database administrator, you are required to make sure that the server can still function when a single hard disk fails. What will you do? (Choose more than one.)

• A.A RAID-5 volume that utilizes three hard disks should be configured. And then, the transaction log and data files should be placed on the RAID-5 volume.
• B.A RAID-5 volume that utilizes four hard disks should be configured. And then, the transaction log and data files should be placed on the RAID-5 volume.
• C.A RAID-1 volume that utilizes two hard disks should be configured. And then, IMicrosoft Windows Server 2003 and SQL Server should be installed on the RAID-1 volume.
• D.A non-RAID volume that utilizes one hard disk should be configured. And then, IMicrosoft Windows Server 2003 and SQL Server should be installed on the non-RAID volume.
• E.A RAID-0 volume that utilizes three hard disks should be configured. And then, the transaction log and data files should be placed on the RAID-0 volume.