為大家收集整理了《微軟認(rèn)證考試70-432練習(xí)試題3》供大家參考，希望對大家有所幫助！?。?BR> QUESTION 11
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. The Orderthings table is partitioned on the OrderId column. The first partition
contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer
values greater than 200,000. What should you do?
A.A new partition function should be created
B.You should change the existing partition scheme
C.You should use a Merge clause to change the existing partition function
D.You should use a Split clause to change the existing partition function
Answer: D
QUESTION 12
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
QUESTION 13
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
QUESTION 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 which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products.
The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on
the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should
you perform to achieve this goal?
A.On the Products table, you should create a view.
B.On the RadioSize column, you should create a clustered index
C.On the RadioSize column, you should create a filtered index
D.On the RadioSize column, you should create a unique clustered index
Answer: C
QUESTION 15
You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server
2008 instance. Look at the following query:
SELECT s.*, i.*
FROM SensitiveTbl AS s
INNER JOIN InsensitiveTbl AS iON i.
OrganizationName = s.OrganizationName
You use the above query to join two tables on a column named OrganizationName.
The following error is returned when you execute the query.
"Msg 468, Level 16, State 9, Line 17
Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation."
The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully.
What should you do?
A.ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)
B.ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)
C.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS
D.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS
Answer: C