Microsoft Certification Questions

• In Microsoft Word 2010, new blank documents use a default template that stores built in styles, custom styles, macros, and other settings as you modify them. What is the name of this core template file?
• You are experiencing repeated crashes when starting Microsoft Word 2010 and the program never fully loads. A colleague suggests starting Word in a special diagnostic state that disables add ins and customizations. Which startup mode should you use?
• In a long Microsoft Word document that contains many meeting notes, you need to find all instances of the words derive, dive, or dave by using the Find and Replace dialog box with wildcards. What is the most efficient wildcard search pattern to use?
• You are a web developer for a company named XYZ. Your ASP.NET application needs to connect by using Windows Integrated authentication to the FactoryDB database in a SQL Server 2000 named instance called Factory on server XYZ01. Which SqlConnection connection string should you use?
• An ASP.NET application uses a DataSet named EXorderEntry with two DataTable objects, orderNames and OrderDetails, linked by a ForeignKeyConstraint called orderDetailsKey. When you try to delete a row from orderNames that still has related rows in OrderDetails, an exception is thrown. Which delete rule value on the foreign key constraint most likely causes this exception?
• You are creating an ASP.NET page for a travel service that uses a CheckBoxList control bound to a list of destinations, sorted by popularity rank. The list has three columns, and you want the most popular destination to appear in the top row from left to right at run time. Which CheckBoxList property setting should you use?
• An ASP.NET corporate news application is used by employees in New Zealand. A label on Default.aspx displays the current date by using DateTime.Now.ToString(\"D\"). You need to ensure that the long date string is formatted correctly for New Zealand users. What should you configure?
• You are creating an ASP.NET page for selling movie tickets. Users select a region and then a city, and the site displays a list of theaters from a database table. To minimize the time required to retrieve and display the theater list for each region and city combination, which caching strategy should you configure on the page?
• You create an ASP.NET page that uses images to represent clickable actions, and all users browse with Internet Explorer. You want a pop up tooltip to appear when the user moves the mouse pointer over an image, showing text that explains what action will occur if they click it. How should you configure the Image controls?
• You have English, French, and German resource files for a test engine ASP.NET application. You want your installer to deploy only the location specific resource files that match the language settings of the target server. How should you configure the installer?
• You plan to deploy an ASP.NET application over the company intranet. The application uses SQL Server and you want to use SQL Server connection pooling, protect confidential data, and minimize administrative overhead. Which security configuration should you choose?
• In a Data Access Layer method, you execute a command that selects from dbo.Documents, where one column contains large binary data. You want to read this column as a stream. Which ExecuteReader option should you use when creating the DbDataReader?
• You created a WCF Data Services service, and client applications receive errors when they submit PUT or DELETE requests. You need to support these operations, even when intermediaries do not allow those HTTP verbs directly. Which header and request type combination should the client use?
• Your application uses the ADO.NET Entity Framework with a local data store that users can modify while disconnected. When the user reconnects and retrieves data from the central store, you must preserve local changes but update unmodified entities with the latest values from the store. How should you configure the merge behavior?
• In an ADO.NET DataSet named customerOrders, you enforce constraints and define a ForeignKeyConstraint ordersFK between the Customers and Orders tables. You want an exception to be thrown if code attempts to delete a Customer row that still has related Order rows. Which delete rule setting should you apply to the foreign key constraint?
• Your application uses the ADO.NET Entity Framework to manage customers and related orders. You add a new Order entity for an existing Customer and need to associate the two entities in the object model. What should you do to correctly link the order to the customer?
• Your .NET application stores encrypted credit card numbers in a SQL Server database. You must be able to retrieve and decrypt the numbers when necessary. Which cryptography provider should you use to encrypt the data?
• Your application uses the ADO.NET Entity Framework with an AdventureWorksEntities context. You create a LINQ query that retrieves customers in London ordered by company name. You want the context to compare unmodified property values with values from the data source and mark properties as modified when differences are detected. Which MergeOption setting should you use?
• You use LINQ to SQL with stored procedures that return multiple result sets. You want each result set to be returned as strongly typed values. How should you configure the stored procedure function in your data context?
• In a Microsoft .NET Framework 4 application that uses the ADO.NET Entity Data Model (EDM), you have defined a Customer entity. You want to add a new Customer row to the data store without having to set all of the Customer properties explicitly before the object is created. What is the correct way to create this new Customer instance so that default values are handled correctly by the Entity Framework?