pass4sure Microsoft Partner Competency exam 74-133 v2.73

Customizing Portal Solutions with Microsoft SharePoint Products and Technologies : 74-133 Exam

Exam Number/Code: 74-133
Exam Name: Customizing Portal Solutions with Microsoft SharePoint Products and Technologies
VUE Code: 74-133
Questions Type: Multiple choice,
Exam Language(s): English

“Customizing Portal Solutions with Microsoft SharePoint Products and Technologies”, also known as 74-133 exam, is a Microsoft certification.
Preparing for the 74-133 exam? Searching 74-133 Test Questions, 74-133 Practice Exam, 74-133 Dumps?

With the complete collection of questions and answers, Pass4sure has assembled to take you through 75 questions to your 74-133 Exam preparation. In the 74-133 exam resources, you will cover every field and category in Microsoft Partner Competency exam helping to ready you for your successful Microsoft Certification.

This exam is for experienced programmers who have a minimum of six months programming experience using Microsoft Visual Studio .NET. This individual works on a team in a medium or large development environment that uses Visual Studio .NET and that team has a need to create customized Microsoft SharePoint Portal Solutions. DS

QUESTION 1
You are creating an ASP.NET Web Form that displays employee data from a DataSet object. You want
to fill the DataSet object and then you want to retrieve a reference to the employee whose primary key
has the value of 1.
You write the following code. (Line numbers are included for reference only)
01 SqlConnection(ConnectionString);
02 conn.Open();
03 SqlCommand cmd = new SqlCommand
(“SELECT * FROM Employees”, conn);
04 SqlDataAdapter da = new
SqlDataAdapter(cmd);
05 DataSet ds = new DataSet();
06
07 da.Fill(ds, “Employees”);
08
09 DataRow dr;
10 dr = ds.Tables["Employees"].Rows.Find(1);
11 nameLabel.Text = dr["Name"].ToString();
When you run the code, you receive the following error message at line 10: “Table doesn’t have a
primary key.”
You ensure that a primary key is defined on the Employees table in the database. You want to alleviate
the error to allow the code to run correctly. You also want to catch the exception that would occur if the
employee whose primary key has the value if 1 is deleted from the database.
Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

Actualtests.org – The Power of Knowing
A. Add the following code at line 06:
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
B. Add the following code at line 06:
da.MissingSchemaAction = MissingSchemaAction.Add;
C. Add the following code at line 06:
da.MissingSchemaAction = MissingSchemaAction.Ignore;
D. Add the following code at line 06:
da.MissingSchemaAction = MissingSchemaAction.Error;
E. Place line 07 in a structured exception handling block.
F. Place lines 10 and 11 in a structured exception handling block.
Answer: A, F
Explanation:
A: The Fill method of the DataAdapter fills a DataSet only with table columns and rows from a data source.
No constraints are applied though constraints are commonly set by the data source. To populate a
DataSet with existing primary key constraint information from a data source, you can either call the
FillSchema method of the DataAdapter, or set the MissingSchemaAction property of the DataAdapter to
AddWithKey before calling Fill.
F: We must put the code that updates the DataSet within a structured exception handling block. This will
ensure that exceptions caused by the primary key constraint are caught.
Reference:
.NET Framework Developer’s Guide, Adding Existing Constraints to a DataSet [C#]
.NET Framework Class Library, MissingSchemaAction Enumeration [C#]
Incorrect Answers
B: The MissingSchemaAction.Add adds the necessary columns to complete the schema.
C: The MissingSchemaAction.Ignore ignores the extra columns.
D: The MissingSchemaAction.Error generates a SystemException.
E: Errors due to the primary key constraint would not occur when the DataSet is filled.
QUESTION 2You are creating an ASP.NET page that presents data to users in an updatable DataGrid control. Users
update data in the grid. Your code uses the System.Data namespace and the System.Data.OleDb
namespace.
Data changes are saved in an ADO.NET DataTable object. You want a user’s changes to be saved to a
database when the user finishes making changes. You write the following procedure to accomplish this
task:
string sql, string connectionString, DataTable dataTable)
{
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbConnection cnn =
new OleDbConnection(connectionString);
dataTable.AcceptChanges();
da.UpdateCommand.CommandText = sql;

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Actualtests.org – The Power of Knowing
da.UpdateCommand.Connection = cnn;
da.Update(dataTable);
da.Dispose();
}
This code runs to completion, but no data changes appear in the database. You test the update query and
the connection string that you are passing to the procedure, and they both work correctly.
You need to alter the code to ensure that data changes appear in the database.
What should you do?
A. Add the following two lines of code before calling the Update method:
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
cb.GetUpdateCommand();
B. Add the following line of code before calling the Update method:
da.UpdateCommand.Connection.Open();
C. Delete thus line of code:
dataTable.AcceptChanges();
D. Delete this line of code:
da.Dispose();
Answer: C
Explanation: The DataTable.AcceptChanges method commits all the changes made to this table since the last
time AcceptChanges was called. We should only use AcceptChanges after the updates has been made to the
dataset.
Reference: .NET Framework Class Library, DataTable.AcceptChanges Method [C#]
Incorrect Answers
A: The OleDbCommandBuilder provides a means of automatically generating single-table commands used
to reconcile changes made to a DataSet with the associated database. It is not useful here.
B: The OleDbConnection.Open method opens a database connection with the property settings specified by
the ConnectionString.
D: The DataAdapter.Dispose method Releases the resources used by the DataAdapter. It is a good practice
to use it when the dataadapter no longer will be used.
QUESTION 3
You create an ASP.NET application for Certkiller . This application will display information about
products that the company sells. The application uses a Microsoft SQL Server database.
You add two DropDownList controls to your .aspx page. One drop-down list box will display product
information. The control for this drop-down list box is named Products. The other drop-down list box
will display category information. The control for this drop-down lost box is named Category. You have
an open SqlConnection object named con.
The Page.Load event handler uses the following code segment to populate the drop-down list boxes by
binding the SqlDataReader. (Line numbers are included for reference only)
01 SqlCommand cmd1 = new SqlCommand(“SELECT * FROM Products”,con);
02 SqlDataReader dr1 = cmd1.ExecuteReader();
03 Products.DataTextField = “ProductName”;

Actualtests.org – The Power of Knowing
04 Products.DataValueField = “ProductID”;
05 Products.DataSource = dr1;
06 Products.DataBind();
07 cmd1.CommandText = “SELECT * FROM Category”;
08 SqlDataReader dr2 = cmd1.ExecuteReader();
09 Category.DataTextField = “CategoryName”;
10 Category.DataValueField = “CategoryID”
11 Category.DataSource = dr2;
12 Category.DataBind();
During testing, the page raises an invalid operation exception. You need to ensure that the page displays
correctly without raising an exception.
What should you do?
A. Replace the code for line 02 of the code segment with the following code:
dr1.ExecuteReader(CommandBehavior.CloseConnection;
B. Add the following code between line 06 and line 07 of the code segment:
dr1.Close();
C. Replace the code for line 07 and line 08 of the code segment with the following code:
SqlCommand cmd2 = new SqlCommand(“SELECT * FROM Category”,con);
SqlDataReader dr2 = cmd2.ExecuteReader();
D. Remove the code for line 06 of the code segment.
Replace the code for line 12 of the code segment with the following
code:
Page.DataBind();
Answer: B
Explanation: You must explicitly call the Close method when you are through using the SqlDataReader to use
the associated SqlConnection for any other purpose.
Reference: .NET Framework Class Library, SqlDataReader.Close Method [C#]

Free download:pass4sure Microsoft 74-133
Free download:testking Microsoft 74-133

password:www.certbible.org

High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.Contact Us:Sales@PassGuide.com

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
PDF	All Certbible 's Exam Dumps	597	1 days ago	Available

PassGuide Training Materials & Practice Tests

• Download Pass4sure Microsoft Microsoft Windows Vista, Configuring
• Pass4sure Microsoft Exam mb2-631 v2.73
• pass4sure Microsoft Business Solutions Exam MB2-632 v2.83
• Pass4sure Microsoft TS 70-649 Exam v2.85
• Microsoft Pass4Sure 70-526 v2 73 2008-04-30 by Moataz G Salama 82q.vce
• p4s microsoft 70-290 corrections
• Microsoft Pass4Sure 70-291 v2008 by Mahmoud Manchester 104q.vce
• Microsoft Pass4Sure 70-640 by Hazem hafez 84q.vce
• (offer) Pass4sure Microsoft 70-270 Ver 2.93
• Microsoft Preparation Certification for Microsoft Candidates