70-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 database administrator for your company. You administer a SQL Server 2005 computer which contains a database named DB01.A table named CustInfo is included in DB01. The table includes an identity column named CustID and an nvarchar column named CustName. According to the requirement of the company policy, rows containing duplicate CustName values should be removed from the CustInfo table once each year. But only when rows have been manually examined and verified as being duplicatesm, they can be removed from the CustInfo table. Since you are the technical support, the company asks you to provide a way to identify potential duplicate rows for manual examination. You should use as little administrative effort as possible when you try to achieve this. So what action should you perform?

• A.Create a trigger for the CustInfo table that rolls back INSERT queries that contain duplicate data.
• B.On the CustName column, a new unique index should be created. When index is being created, Specify IGNORE_DUP_KEY = ON.
• C.You should create a new table that contains duplicate rows from the CustInfo table by using a SELECT INTO query that includes GROUP BY and HAVING clauses.
• D.A foreign key constraint should be created on the CustName column. This constraint references a distinct list of CustName values.

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.

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 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.
• B.All employees should be added to the db_datareader database role.
• C.The SELECT permission on all current tables should be granted to the public database role.
• D.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.
• E.All hiring managers should be added to the db_datawriter database 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 administer a SQL Server 2005 computer named SQL01. Backups of all user databases are performed on Sunday nights. Backups of all system databases are performed on Saturday nights. All backups are stored in an off-site facility. SQL01 shuts down unexpectedly because of a power failure. The SQL Server service fails to start when SQL01 is brought back online. The SQL Server error log is shown in the exhibit below. Since you are the technical support, you have to return SQL01 to working order in a minimum possible time. What action should you perform first?

• A.After the SQL Server 2005 installation CD is inserted, you should reinstall the default instance by running the setup utility.
• B.Setup.exe should be run from a command line and a rebuild of the master database
  should be specified.
• C.All of the system databases should be restored.
• D.All of the user databases should be restored from backup.

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.10 SQL Server 2005 computers are managed by you. The computers are located on an isolated portion of the company's network that has been limited from accessing the Internet. The SQL Server 2005 computers can only be accessed by intranet client computers. In order to identify only the missing operating system or SQL Server patches, hotfixes, and service packs, you are asked to audit the SQL Server computers. What action should you perform?

• A.The Microsoft SQL Server Best Practices Analyzer should be run from a client computer on the network.
• B.You should scan the IP address of the 10 SQL Server 2005 computers by running the Microsoft Baseline Security Analyzer (MBSA) from a client computer on the network. MBSA should be configured to check for Microsoft Windows vulnerabilities, SQL Server vulnerabilities, and security updates against Microsoft Windows Update.
• C.For Services and Connections, the SQL Server Surface Area Configuration should be run on each SQL Server computer.
• D.You should scan the IP address of the 10 SQL Server 2005 computers by running the Microsoft Baseline Security Analyzer (MBSA) from a client computer on the network. MBSA should be configured to check for SQL Server vulnerabilities and security updates against a network Windows Server Update Services (WSUS) server.