Microsoft 70-432认证题库-1

Title    :  TS:MS SQL Server@ 2008,Implementation and Maintenance
Version :  Demo

1. 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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use?
A. You should use local Service account
B. You should use network Service account
C. You should use domain account
D. You should use local System account
Answer: C

2. 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. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?
A. A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
B. A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.
C. A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
D. A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.
Answer: B

3. 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
Answer: C

4. 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 two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext indexes. Several records that include the word “root” are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word “root.” You must make sure the query can return records that contain the word “root”. What should you do?
A. You should terminate and restart the MSFTESQL service
B. You should rebuild the full-text index
C. The word “root” should be added to the stop list
D. The word “root” should be added to the thesaurus file
Answer: B

5. 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 Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?
A. For the AdventureWorks database, enable Server Auditing
B. First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance
C. You should configure the data collector and make it capture the deadlock graphs
D. You should configure a SQL Profiler trace, and make it capture the deadlock graphs
Answer: B

6. 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 Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?
A. You should run the bulk copy program utility along with an output file and no format file
B. You should run the SQLCmd utility and save the output to a file
C. You should run the SQL Import and Export Data Wizard and save the output to a file.
D. You should run the bulk copy program utility along with a format file and an output file.
Answer: C

Advertisement