Microsoft 70-647 Tests

Practice tests in VCE format:

Files from PDF Store available for converting:

QUESTION 1
You develop a Windows-based application. Its users will view and edit employee
attendance data. The application uses a DataSet object named customerDataSet to
maintain the data while users are working with it.
After a user edits data, business rule validation must be performed by a middle-tier
component named CertK Component. You must ensure that your application sends
only edited data rows from customDataSet to CertK Component.
Which code segment should you use?
A. DataSet changeDataSet = new DataSet(); if
(customDataSet.HasChanges) {
CertK Component.Validate(changeDataSet); }
B. DataSet changeDataSet = new DataSet(); if
(customDataSet.HasChanges) {
CertK Component.Validate(customDataSet); }
C. DataSet changeDataSet = customDataSet.GetChanges();
CertK Component.Validate(changeDataSet);
D. DataSet changeDataSet = customDataSet.GetChanges();
CertK Component.Validate(customDataSet);
Answer: C
QUESTION 2

Actualtests.org – The Power of Knowing
You develop a Windows-based application that will retrieve Certkiller employee
vacation data and display it in a DataGrid control. The data is managed locally in a
DataSet object named employeeDataSet.
You need to write code that will enable users to sort the data by department.
Which code segment should you use?
A. DataView dvDept = new DataView(); dvDept.Table =
employeeDataSet.Tables[0]; dvDept.Sort = “ASC”;
DataGrid1.DataSource = dvDept;
B. DataView dvDept = new DataView(); dvDept.Table =
employeeDataSet.Tables[0]; dvDept.Sort = “Department”;
DataGrid1.DataSource = dvDept;
C. DataView dvDept = new DataView(); dvDept.Table =
employeeDataSet.Tables[0]; dvDept.ApplyDefaultSort = true;
DataGrid1.DataSource = dvDept;
D. DataView dvDept = new DataView(); dvDept.Table =
employeeDataSet.Tables[0]; dvDept.ApplyDefaultSort = false;
DataGrid1.DataSource = dvDept;
Answer: B
QUESTION 3
You develop a Windows-based application to manage business contacts. The
application retrieves a list of contacts from a central database. The list is managed
locally in a DataSet object named listDataSet, and it is displayed in a DataGrid
control.
You create a procedure that will conduct a search after you enter a combination of
personal name and family name. You application currently includes the following
code segment:
DataView dv = new DataView();
int i;
dv.Table = listDataSet.Tables(0);
dv.Sort = “FamilyName, PersonalName”;
DataGrid1.DataSource = dv;
You need to search for a conduct whose personal name is Jack and whose family
name is Bill. Which code segment should you use?
A. object[] values = {“Bill”, “Jack”};
i = dv.Find(values);
DataGrid1.CurrentRowIndex = i;
B. object() values = {“Bill, Jack”};
i = dv.Find(values);
DataGrid1.CurrentRowIndex = i;
C. object[] values = {“Jack”, “Bill”};
i = dv.Find(values);

Actualtests.org – The Power of Knowing
DataGrid1.CurrentRowIndex = i;
D. object[] values = {“Jack, Bill”};
i = dv.Find(values);
DataGrid1.CurrentRowIndex = i;
Answer: A
Explanation: We load the search parameters into an array. We use two separate
values. The first value is the FamilyName and the second is PersonalName as it is
used in the sort command:
dv.Sort = “FamilyName, PersonalName”
The family name is Bill. The personal name is Jack.
Reference: 70-306/70-316 Training kit, Filtering and Sorting in a DataSet, Page 306
Incorrect Answers
B, D: There are two columns. We must separate the Family name and the Personal into
two separate strings.
C: Wrong order of the search parameters. The family name Bill must be the first search
parameter.

free down1:testking microsoft 70-647

free down2:pass4sure 70-647