his company doesn’t have enough staff to provide good customer service.
the sales in his company is decreasing gradually.
the customers’ complaints are on the rise.
第1题:
You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.
The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
What should you do?
A.Create an UPDATE trigger that sends an e-mail message.
B.Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
C.Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D.Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
第2题:
第3题:
第4题:
第5题:
第6题:
第7题:
A customer is getting ready to install a new pSeries system into their data center. They are concerned about providing the appropriate clearance around their 7014-T42 to allow for maintenance. What reference material should the pSeries technical specialist provide to the customer?()
第8题:
第9题:
Send the customer information on VMware
Send the customer information on IBM BladeCenter
Call the customer to ask why they are consolidating
Send the customer information on IBM System P
第10题:
gives them opportunities to order
provides good service and quality
guarantees the quickest delivery
sends new catalogues to them
第11题:
his company doesn’t have enough staff to provide good customer service.
the sales in his company is decreasing gradually.
the customers’ complaints are on the rise.
第12题:
A solution sizing questionnaire
Verify the customer has the proper racks
A Technical Delivery Assessment
Verify the customer has enough cooling in the computer room
第13题:
第14题:
第15题:
第16题:
第17题:
第18题:
A customer has been working with your company to purchase an iDataPlex cluster. They have a configuration from IBM and are getting ready to place an order. Which should be done of the following?()
第19题:
第20题:
第21题:
第22题:
A rival company, which charges no start-up fee, offers an unlimited calling plan for $40 per month.
Two-thirds of the company’s customers use less than 500 minutes per month.
Studies have shown that customers using unlimited calling plans will increase their monthly usage of minutes by over 50 percent.
One-fifth of the company’s customers use in excess of 1,000 minutes per month.
In recent months the company has received several complaints of insufficient signal strength and poor customer service.
第23题:
Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
第24题: