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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

A.On the local server, enable the XP_MSVER stored procedure 
B.On the remote server, enable the XP_MSVER stored procedure. 
C.On the production server, use the dta.exe utility along with an XML input file. 
D.You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file

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 

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