Online Access Free 70-447 Exam Questions

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 trigger should be created, and changes are rolled back by the trigger to the Price column that violates company policy.
• B.A stored procedure should be created, and changes are disallowed by the procedure to the Price column that violates company policy.
• C.On the Price column, a foreign key constraint is created to a table that valid prices are included.
• D.On the Price column, a check constraint should be created, and a specified minimum value is required by the check constraint.

According to the company requirement, you have to design the data archiving solution for the CRM database. You must make sure that your solution implements and satisfies the research and auditing requirements by using as little administrative effort as possible. Of the following actions, which should be specified to occur at the end of each month?

• A.The CRM data should be exported to a Microsoft Excel spreadsheet and each spreadsheet should be kept for five years. The older data should be deleted from the CRM database after each spreadsheet is created.
• B.You should print a copy of the older CRM data by using SQL Server Reporting Services (SSRS), and keep each report for five years. After printing each report, delete the older data should be deleted from the CRM database after each report is printed.
• C.In order to guarantee that the older data and the newer data are kept on different table partitions, the CRM database needs to be reorganized.
• D.A full backup of the CRM database should be created and each backup should be kept for five years. After creating each backup, delete the older data should be deleted from the CRM database after each backup is created.

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 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.
• B.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.
• 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.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 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.

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 administer a SQL Server 2005 computer named SQL01. A database named DB01 is hosted on SQL01. DB1 plays the role of backend database for an application that tracks issues. DB01 helps desk technicians receive and the associated trouble tickets. When installed, the help desk application loaded several stored procedures and views that are used for data manipulation and reporting purposes. There are more than 50 tables in DB01. The bulk of the data is stored within the Employees, Issues, Assets, and AssetTracker tables. The AssetTracker table in DB01 is deleted by an application developer carelessly. The AssetTracker table is referenced by several views and functions in the database. You must make sure that critical tables cannot be removed by users such as this that are referenced by views or functions. So what action should you perform to make sure of this?

• A.For DB01, a new read-only filegroup should be created and all tables should be moved to the new filegroup.
• B.First you should identify the dependencies of each critical table. Then the syntax of each view and function should be changed to include the SCHEMABINDING syntax.
• C.First you should identify the dependencies of each view and function. Then For the Public role, the DENY-CONTROL permission should be configured on each critical table listed as a dependency.
• D.All critical tables should be added to the same schema by using the ALTER SCHEMA Transact-SQL statement. For the Public role, the DENY-DELETE permission should be configured on the schema.

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 new unique index should be created on the CustName column. And then, IGNORE_DUP_KEY = ON should be specified when creating index.
• B.A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.
• C.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.
• D.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.