MCTSMCTS(70-432)章节练习(2019.04.29)

单项选择题
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
单项选择题
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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （）
A.You should configure SQL Server VSS Writer
B.You should configure Distributed File System
C.You should configure SQL Server
D.You should configure SQL Server Full Text
单项选择题
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. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use? （）
A.You should use database snapshots
B.You should use database backup and restore
C.You should use database backup and restore along with compression
D.You should use schema-bound views in a read-only database. The database resides on the same instance.
单项选择题
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 contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features. These features will be discontinued. What should you do？（）
A.The SQL Server 2008 Upgrade Advisor should be used.
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.
单项选择题
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 stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？（）
A.You should create a job which is assigned to the Database Maintenance category
B.You should create an Alert which will run another to delete the maintenance job.
C.You should create a job. You schedule the job to run only once.
D.You should create a job. The job uses the Automatically delete job option
单项选择题
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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check? （）
A.You should check SQL1.log
B.You should check SQLAGENT.OUT
C.You should check log_xx.trc
D.You should check ERRORLOG
单项选择题
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. On two cluster-ready nodes, you intend to perform an installation of a SQL Server 2008 mission-critical cluster. Constant availability is needed by the mission-critical cluster. You have to configure the SQL Server cluster to failover and reduce the service disruption to the least. Which failover option should you use?（）
A.You should allow failback only during non-business hours
B.You should immediately allow failback
C.You should prevent automatic failback
D.You should allow failback only during business hours
单项选择题
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. DB1 is available to a Windows group which is named WIIKIGO\Supervisors. A Windows user named User1 is a member of the WIIKIGO\Supervisors group. WIIKIGO\Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）
A. DROP LOGIN "WIIKIGO\User1";
B. EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C. EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1';
D. CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1";
单项选择题
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 latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. So what action should you perform to achieve this goal?（）
A.You should restore the full backup
B.You should restore the database snapshot from 16:30 hours.
C.You should restore the database snapshot from 17:30 hours
D.You should restore both the full backup and the differential backup.
单项选择题
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 you get an order from your company CIO， you have to identify whether a database integrity check （DBCC CHECKDB） was run for a particular database. Which log file should you examine？（）
A.log.trc
B.default.trc
C.ERRORLOG
D.SQLAGENT