Free Microsoft 70-447 Exam Dumps Questions & Answers

The security for the HR database should be set to support present security needs. And the impact of future security changes that might be caused by user and table additions should be cut to the least. From the four actions, which two should be performed? (Choose more
than one)

• A.  A Hiring_Managers role should be created, and then all hiring managers should be added to this role, at last the role the SELECT, INSERT, UPDATE, and DELETE permissions should be granted on the five tables that the hiring managers need to manage.
• B.  All hiring managers should be added to the db_datawriter database role.
• C.  All employees should be added to the db_datareader database role.
• D.  The SELECT permission on all current tables should be granted to the public database role.
• E.  A HR_Readers role should be created, and then all employees in the HR department should be added to this role, at last the SELECT permission should be granted on all present tables to this role.

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

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.  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.
• 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.  On SQL02, a new database should be created. Between internet_rentals and the new database, transactional 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, merge replication should be configured.
• E.  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.

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 named SQL01 in the company. A stores sales history data is stored in a database on SQL01 for the company's Web-based order system. Twenty of the business analysts in the company create ad hoc queries against the database. SQL01 has a slow performance all the time. Since you work as the technical support, the company asks you to identify which business analyst is causing the problem. What action should you perform to achieve this goal? (Choose more than one.)

• A.  In order to achieve the goal, you should gather database activity by running SQL Trace system stored procedures.
• B.  In order to achieve the goal, you should view the activity of specific business analysts by using the Activity Monitor.
• C.  In order to achieve the goal, you should use SQL Server Profiler to create a trace that uses a predefined template.
• D.  In order to achieve the goal, the sp_who system stored procedure should be run.

According to the company requirement, you are asked to design a stored procedure to import the registry information from AppServer1. The company requires that you do not execute unmanaged code. So what action should you perform to accomplish your task?

• A.  In order to accomplish your task, a CLR stored procedure with the EXTERNAL_ACCESS permission set should be used.
• B.  In order to accomplish your task, a CLR stored procedure with the UNSAFE permission set should be used.
• C.  In order to accomplish your task, a regular stored procedure that calls xp_cmdshell should be used.
• D.  In order to accomplish your task, an extended stored procedure should be used.
• E.  In order to accomplish your task, a CLR stored procedure with the SAFE permission set should be used.