為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題16》供大家參考，希望對(duì)大家有所幫助！??！
QUESTION 76 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. According to the requirements of the security audit policy, only successful and failed logon attempts are recorded in log files; if records cannot be written to the log files, the SQL Server instance is shut down. You have to make the SQL Server instance comply with the security audit policy by performing the configuration. Which Transact-SQL statements should you run? A.sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'default trace enabled', 1;GORECONFIGUREGO B.sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'common criteria compliance enabled', 1;GORECONFIGUREGO C.CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\Audit\' ) WITH (ON_FAILURE = SHUTDOWN);GOCREATE DATABASE AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO D.CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\Audit\' ) WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO Answer: D QUESTION 77 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced. So what action should you perform to achieve this goal? (choose more than one) A.You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert B.You should modify all logins by using the ALTER LOGIN ... HASHED statement. C.You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to.、 D.You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement. E.You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules Answer: CE QUESTION 78 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. The table below shows the backup strategy for DB1. Your company stores the system databases, user database data, and log files on separate disks. A user report that the hard disks which store the user database data files have failed at 15:00 on Wednesday. According to the requirement of the company CIO, you have to restore Tdb1from the database backups, and you must reduce the data loss as soon as possible. So what action should you perform to achieve this goal? A.First you should restore the full backup taken on Sunday. Then you restore the differential backup taken on Wednesday. B.First you should back up the transaction log. Then restore the full backup taken on Sunday. At last restore all transaction log backups C.First you should back up the transaction log. Second, restore the full backup taken on Sunday. Third, restore the differential backup taken on Tuesday and restore all transaction log backups taken during Wednesday. D.First you should restore the full backup taken on Sunday. Then restore the differential backup taken on Monday and Tuesday and restore the transaction log backups taken at 08:00 hours and at 12:00 hours on Wednesday. Answer: C QUESTION 79 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the requirement of the company CIO, users on the SQL Server instance must be able to use the OPENROWSET() function to query remote data source. In the options below, which sp_configure configuration option should you configure? A.Agent XPs B.remote access C.remote proc trans D.Ad Hoc Distributed Queries Answer: D QUESTION 80 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.) 01 CREATE PROCEDURE Sales.Procedure1 02 AS 03 IF OBJECT_ID('Service.Table') IS NOT NULL 04 DROP TABLE Service.Table; 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 11 ... 12 GO The following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions. What action should you do perform? A.Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause. B.Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement. C.You should give the user the ALTER permission on the Service schema D.You should give the CREATE TABLE permission and permit the user to drop the Service.Table table. Answer: A
QUESTION 76 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. According to the requirements of the security audit policy, only successful and failed logon attempts are recorded in log files; if records cannot be written to the log files, the SQL Server instance is shut down. You have to make the SQL Server instance comply with the security audit policy by performing the configuration. Which Transact-SQL statements should you run? A.sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'default trace enabled', 1;GORECONFIGUREGO B.sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'common criteria compliance enabled', 1;GORECONFIGUREGO C.CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\Audit\' ) WITH (ON_FAILURE = SHUTDOWN);GOCREATE DATABASE AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO D.CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\Audit\' ) WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO Answer: D QUESTION 77 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced. So what action should you perform to achieve this goal? (choose more than one) A.You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert B.You should modify all logins by using the ALTER LOGIN ... HASHED statement. C.You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to.、 D.You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement. E.You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules Answer: CE QUESTION 78 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. The table below shows the backup strategy for DB1. Your company stores the system databases, user database data, and log files on separate disks. A user report that the hard disks which store the user database data files have failed at 15:00 on Wednesday. According to the requirement of the company CIO, you have to restore Tdb1from the database backups, and you must reduce the data loss as soon as possible. So what action should you perform to achieve this goal? A.First you should restore the full backup taken on Sunday. Then you restore the differential backup taken on Wednesday. B.First you should back up the transaction log. Then restore the full backup taken on Sunday. At last restore all transaction log backups C.First you should back up the transaction log. Second, restore the full backup taken on Sunday. Third, restore the differential backup taken on Tuesday and restore all transaction log backups taken during Wednesday. D.First you should restore the full backup taken on Sunday. Then restore the differential backup taken on Monday and Tuesday and restore the transaction log backups taken at 08:00 hours and at 12:00 hours on Wednesday. Answer: C QUESTION 79 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the requirement of the company CIO, users on the SQL Server instance must be able to use the OPENROWSET() function to query remote data source. In the options below, which sp_configure configuration option should you configure? A.Agent XPs B.remote access C.remote proc trans D.Ad Hoc Distributed Queries Answer: D QUESTION 80 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.) 01 CREATE PROCEDURE Sales.Procedure1 02 AS 03 IF OBJECT_ID('Service.Table') IS NOT NULL 04 DROP TABLE Service.Table; 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 11 ... 12 GO The following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions. What action should you do perform? A.Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause. B.Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement. C.You should give the user the ALTER permission on the Service schema D.You should give the CREATE TABLE permission and permit the user to drop the Service.Table table. Answer: A