Exhibit:BULK INSERT Ezonexam.dbo.employeesFROM ‘tk\africe\fubar512.txt’WITH DATAFILETYPE = ‘char’,FIELD/TERMINATOR = ‘\t’,ROWTERMINATOR = ‘\n,’TABLOCKYou work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.How should yo

第1题：

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. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）

• A、To achieve the goal， DBCC DBREINDEX should be utilized.
• B、To achieve the goal， SELECT * FROM sys.indexes should be utilized.
• C、To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.
• D、To achieve the goal， DBCC INDEXDEFRAG should be utilized.

第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. 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.

第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. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）

• A、For the database, you should turn on the TRUSTWORTHY database option
• B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM
• C、For the database, the database compatibility level option should be set to 10
• D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 

第4题：

You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）

• A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
• B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
• C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.
• D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.

第5题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully.  So on InstanceB, which Transact-SQL statements should you execute?（）  

• A、USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary; 
• B、USE AdventureWorks;ALTER LOGIN Mary ENABLE; 
• C、USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = "Tk@87#34" UNLOCK; 
• D、USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;

第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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （） 

• A、You should backup the master database
• B、You should backup the default.trc file
• C、You should backup the SQL Server registry hive.
• D、You should backup the resource database 

第7题：

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, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （） 

• A、The SQL Server 2008 Upgrade Advisor should be used 
• B、You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes 
• C、You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes 
• D、You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes. 

第8题：

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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

• A、You should use Dynamic Management Views 
• B、You should use SQL Server Resource Governor 
• C、You should use SQL Server Profiler 
• D、You should use Windows System Monitor

第9题：

You are responsible for importing data into SQL Server 2005 databases.Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.You need to import the files into the sales database. What should you do？（）

• A、Create a custom format file， specifying a semicolon as the row terminator.
• B、Use the bcp command， specifying a semicolon as the field terminator.
• C、Use the bcp command with the default arguments.
• D、Use the BULK INSERT statement with the default arguments.

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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

第15题：

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 user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.  Which action should be performed to finish the task？（）

• A、To finish the task，the Products database should be backed up.
• B、To finish the task，your server should be set to utilize the full recovery model.
• C、To finish the task，your server should be set to utilize the bulk-logged recovery model.
• D、To finish the task， the msdb database should be backed up.

第16题：

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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）

• A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
• B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
• C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
• D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

第17题：

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. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

• A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
• B、You should identify whether the SQL Server Agent is started on the primary server. 
• C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
• D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

第18题：

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. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

• A、The sp_executesql batches are not being recovered from the procedure cache.
• B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
• C、One new stored procedure is created by a database administrator.
• D、Ad hoc batches are not being recovered from the procedure cache.

第19题：

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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?（）  

• A、You should use the Database Engine Tuning Advisor. 
• B、In Microsoft SQL Server Management Studio, you should create a maintenance plan 
• C、You should use the SQL Server Configuration Manager 
• D、In Microsoft SQL Server Management Studio, you should create a policy

第20题：

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 find a problem that there are three reports which are running slowly. And through detailed analysis， you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support， you are required to find out which statement is causing the slow performance. Which action should be performed first？（）

• A、SQL Server Profiler should be run with the Lock：Deadlock event class.
• B、The Database Engine Tuning Advisor （DTA） f should be run or at least one hour.
• C、SQL Server Profiler should be run with the TSQL_Duration template.
• D、The Database Engine Tuning Advisor （DTA） should be run with the default options.

第21题：

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. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? （） 

• A、You should verify that the simple recovery model is used by the database.
• B、You should verify that the full recovery model is used by the database.
• C、You should verify that the checksum page verify option is used by the database. 
• D、You should verify that the bulk-logged recovery model is used by the database. 

第22题：

第23题：