Microsoft Certification Questions

You develop an inventory management application called XYZManagement that will call a Microsoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter. This total will be displayed to users in a message box.

Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write the
following code to call sp_GetDailyXYZSales:
SqlConnection cnn = new SqlConnection(myConnString);
SqlCommand cmd = new SqlCommand(“sp_GetDaily XYZ Sales”, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter prm = cmd.Parameters.Add(“@ItemTotal”,SqlDbType.Int);
prm.Direction = ParameterDirection.Output;
cnn.Open();
cmd.ExecuteNonQuery();

Now you must write additional code to access the output parameter. Which code segment should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. You discover that when an application submits a PUT or DELETE request to the Data Services service, it receives an error. You need to ensure that the application can access the service. Which header and request type should you use in the application?

You want to configure synchronization settings for your office files. Which tool should you use?

You want to create and format a simple volume on a Windows 2000 computer. Which tool should you use?

You are upgrading your single master Windows NT Server 4.0 network to Windows 2000. Which computer should you upgrade first?

A large document contains meeting notes from all meeting that took place between HR and Finance. You need to find all instances of 'derive' or 'dive' or 'dave'. What would be the most efficient way to find these terms using the Find & Replace dialog box?

You are a developer for a XYZ Inc that provides free software over the Internet. You are developing en e-mail application that users all over the world can download.

The application displays text strings in the user interface. At run time, these text strings must appear in the language that is appropriate to the locale setting of the computer running the application.

You have resources to develop versions of the application for only four different cultures.You must ensure that your application will also be usable by people of other cultures.
How should you prepare the application for deployment?

You get a great deal on a refurbished laser printer. The printer is plug and play compliant and connects to your USB port. The printer is on the current Windows 2000 Hardware Compatibility List (HCL). You install the printer and run the manufacturers setup program. During the installation, you receive the error shown in the exhibit (See the exhibit below). What should you do?