Suppose You Are Creating The Physical Design For The Customer Category Data Model. For Reportingpurposes, You Want To Optimize Access To Customer Category Data. You Define A Customer Tableand A Category Table. What Should You Do Next?A. Define Three Foreign Key Columns In The Category Table, Such That Each Column References Adifferent Parent Row In The Customer Table. Define Indexes On The Foreign Key Columns.B. Define Three Foreign Key Columns In The Customer Table, Such That Each Column References Adifferent Parent Row In The Category Table. Define Indexes On The Foreign Key Columns.C. Define A Foreign Key Column In The Category Table That References The Parent Row In TheCustomer Table. Define An Index On The Foreign Key Column.D. Define A Foreign Key Column In The Customer Table That References The Parent Row In TheCategory Table. Define An Index On The Foreign Key Column.

⟩ Suppose You are creating the physical design for the customer category data model. For reportingpurposes, you want to optimize access to customer category data. You define a Customer tableand a Category table. What should you do next?A. Define three foreign key columns in the Category table, such that each column references adifferent parent row in the Customer table. Define indexes on the foreign key columns.B. Define three foreign key columns in the Customer table, such that each column references adifferent parent row in the Category table. Define indexes on the foreign key columns.C. Define a foreign key column in the Category table that references the parent row in theCustomer table. Define an index on the foreign key column.D. Define a foreign key column in the Customer table that references the parent row in theCategory table. Define an index on the foreign key column.

D. Define a foreign key column in the Customer table that references the parent row in the

Category table. Define an index on the foreign key column.

Is this answer helpful?
0 Yes | 0 No

144 views

Suppose You use Visual Studio .NET to develop a Windows-based application. Your application willdisplay customer order information from a Microsoft SQL Server database. The orders will bedisplayed on a Windows Form that includes a DataGrid control named XYZGrid1. XYZGrid1 isbound to a DataView object. Users will be able to edit order information directly in XYZGrid1.You must give users the option of displaying only edited customer orders and updated values inXYZGrid1.What should you do?A. Set the RowStateFilter property of the DataView object toDataViewRowState.ModifiedOriginal.B. Set the RowStateFilter property of the DataView object to DataViewRowState.ModifiedCurrent.C. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedOriginal.D. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedCurrent.

Suppose You develop a Windows-based inventory management application that interacts with a MicrosoftSQL Server database. Your application enables users to update information about items ininventory. Each time a user changes an inventory item, your application executes a SQL Serverstored procedure XYZSP to update rows in the database. XYZSP will run many times during eachuser session.Your application will use a SqlCommand object to execute XYZSP. You must revise your code sothat the use of this object optimizes query performance.What should you do?A. Call the SqlCommand.DeriveParameters method before each call toSqlCommand.ExecuteNonQuery.B. Call the SqlCommand.Prepare method before each call to SqlCommand.ExecuteNonQuery.C. Call the SqlCommand.DeriveParameters method before the first call toSqlCommand.ExecuteNonQuery.D. Call the SqlCommand.Prepare method before the first call to SqlCommand.ExecuteNonQuery.

As a developer at XYZ you develop a new sales analysis application that reuses existing dataaccess components. One of these components returns a DataSet object that contains the data forall customer orders for the previous year.You want your application to display orders for individual product numbers. Users will specify theappropriate product numbers at run time.What should you do?A. Use the DataSet.Reset method.B. Set the RowFilter property of the DataSet object by using a filter expression.C. Create a DataView object and set the RowFilter property by using a filter expression.D. Create a DataView object and set the RowStateFilter property by using a filter expression..

You are preparing a localized version of a Windows Form named XYZLocal. Users of XYZLocalspeak a language that prints text from right to left. User interface elements on the form need toconform to this alignment.You must ensure that all user interface elements are properly formatted when the localizedWindows Form runs. You must also ensure that XYZLocal is easy to update and maintain.What should you do?A. Set the RightToLeft property of each control on the form to Yes.B. Set the RightToLeft property of the form to Yes.C. Set the Language property of the form to the appropriate language.D. Set the Localizable property of the form to True.

Suppose You develop a Windows Form that provides online help for users. You want the help functionalityto be available when users press the F1 key. Help text will be displayed in a pop-up window forthe text box that has focus.To implement this functionality, you need to call a method of the HelpProvider control and passthe text box and the help text.Which method should you call?A. SetShowHelpB. SetHelpStringC. SetHelpKeywordD. ToString

Suppose You develop a Windows-based application. The application uses a DataSet object that containstwo DataTable objects. The application will display data from the two data tables. One tablecontains customer information, which must be displayed in a data-bound ListBox control. Theother table contains order information, which must be displayed in a DataGrid control.You need to modify your application to enable the list box functionality. What should you do?A. Use the DataSet.Merge method.B. Define primary keys for the DataTable objects.C. Create a foreign key constraint on the DataSet object.D. Add a DataRelation object to the Relation collection of the DataSet object.

Suppose You develop a Windows-based application that includes the following code segment. (Linenumbers are included for reference only.)01 Public Sub password_Validating (ByVal sender As _02 Object, ByVal e As _.03 System.ComponentModel.CancelEventArgs)04 Handles password.Validating05 If ValidPassword() = False Then06 Insert new code.07 End If08 End SubYou must ensure that users cannot move control focus away from textPassword ifValidPassword returns a value of False. You will add the required code on line 6.Which code segment should you use?A. e.Cancel = TrueB. sender = textNameC. password.AcceptsTab = FalseD. password.CausesValidation =False

You are creating an XML Web service that processes highly confidential messages. The serviceexposed a Web method named RetrieveMessage that takes as input a code name and returns anencrypted message.You create a SOAP extension and override the extension?s ProcessMessage method so that youcan encrypt the message before it is sent back to the caller.You need to encrypt only the data within the RetrieveMessageResult node of the SOAPresponse. You create a function named EncryptMessage that encrypts theRetrieveMessageResult node. You need to ensure that this method gets called before sendingthe message back to the caller.During which SoapMessageStage should you call EncryptMessage?A. BeforeSerializeB. AfterSerializeC. BeforeDeserializeD. AfterDeserialize

You create a .NET Remoting object named EXPatientinfo that exposes medical patientinformation.Because of the confidential nature of the information, you must ensure that the data remainssecure.You want client applications to connect to EXPatientinfo over a secure communication channel.You want to accomplish this task by writing the minimum amount of code.What should you do?A. Create your own host application and use a TcpChannel and BinaryFormatter.B. Create your own host application and use an HttpChannel and a SoapFormatter.C. Install EXPatientinfo in an Internet Information Services (IIS) virtual directory.Configure EXPatientinfo to use a TcpChannel and a BinaryFormatter.Configure IIS to use SSL.D. Install EXPatientinfo in an Internet Information Services (IIS) virtual directory.Configure EXPatientinfo to use an HttpChannel and a SoapFormatter.Configure IIS to use SSL.

Question and Answer:

Home MCSD.NET - 70-300

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links: