Flydumps just published the newest Microsoft 70-561 dumps with all the new updated exam questions and answers.Flydumps provide the latest version of Microsoft 70-561 and VCE files with up-to-date questions and answers to ensure your exam 100% pass, on our website you will get the free new newest Microsoft 70-561 version VCE Player along with your VCE dumps.
QUESTION NO: 1
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed an application, named CKApp35, and cofigured it to reference a Microsoft SQL Server 2005 database. You have configured the use of a strongly typed DataTable class named CKEmployees that hosts employee data. You have also included a feature that imports an employee list from an untyped DataTable named newCKEmployees. You then configured the newCKEmployees DataTable columns to have an identical column type and column order to the columns in the CKEmployees DataTable.
You have received instructions to make sure that data hosted by the newCKEmployees DataTable is duplicated in the CKEmployees DataTable.
Which of the following actions should you take?
A. You should consider merging the CKEmployees Table with the newCKEmployees table.
B. You should consider merging the newCKEmployees DataTable with the CKEmployees DataTable.
C. You should consider merging the CKEmployees DataTable with the newCKEmployees DataTable, and include an indication as to whether changes should be saved.
D. You should consider merging the newCKEmployees DataTable with the CKEmployees DataTable, and include an indication as to whether changes should be saved.
Answer: A
QUESTION NO: 2
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You are in the process of developing a new application that includes a SqlDataAdapter object named CKSales. You have set the SelectCommand property of the CKSales object.
You have been tasked with creating code that allows the CKSales object to handle updates.
Which of the following actions should you take?
A. You should write the following code:
private void ModifyDataAdapter() {
DBCommandBuilder cb = new DBCommandBuilder(CKSales);CKSales.DeleteCommand = cB.
GetDeleteCommand();CKSales.InsertCommand = cB.
GetInsertCommand();CKSales.UpdateCommand = cB. GetUpdateCommand();
B. You should write the following code:
private void ModifyDataAdapter() {
SqlCommandBuilder cb = new SqlCommandBuilder(CKSales);cB. SetAllValues = true;
C. You should write the following code:
private void ModifyDataAdapter() {
SqlCommandBuilder cb = new SqlCommandBuilder(CKSales);CKSales.DeleteCommand = cB.
GetDeleteCommand();CKSales.InsertCommand = cB.
GetInsertCommand();CKSales.UpdateCommand = cB. GetUpdateCommand();
D. You should write the following code:
private void ModifyDataAdapter() {
DBCommandBuilder cb = new DBCommandBuilder(CKSales);cB. SetAllValues = true;
Answer: C
QUESTION NO: 3
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed an application and cofigured it to reference a Microsoft SQL Server 2005 database, named CKDB13, which is stored on a server named -SR35.
You have included a SqlDataReader object, two SqlCommand objects, and a SqlConnection object in the application. They are named KingReader, KingReports, KingUpdates, and KingConnection respectively. You have configured KingReader to inherit from KingReports, while KingConnection is configured to inherit from both the KingReports and KingUpdates objects. You have also configured the use of Security Support Provider Interface (SSPI).
You have been tasked with configuring the application to make use of the ExecuteNonQuery method of the KingUpdates object for every record in the KingReader object.
Which of the following actions should you take?
A. You should consider writing the following code:
var value = command. ExecuteScalar();string requiredValue = valuE. ToString();
B. You should consider writing the following code:
var value = command. ExecuteScalar();string requiredValue = valuE. ToString();
C. You should consider configuring the Asynchronous Processing setting for the connection string of the KingConnection object to be TRUE.
D. You should consider configuring the MultipleActiveResultSets setting for the connection string of the KingConnection object to be TRUE.
Answer: D
QUESTION NO: 4
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed an application that has a DataSet object named DSInvoice. DSInvoice has a DataTable, named CKInvoices, with three columns named InvoiceID, Client ID, and InvoiceDate. You then configured a SqlDataAdapter object, named daInvoices, which fills the CKInvoices table with the succeeding set of 10 records for every pageIndex value increase.
Which of the following options best represent the code that you created?
A. private void FillCKInvoicesTable(int pageIndex) {
int pageSize = 5;
string sql = “SELECT InvoiceID, ClientID, InvoiceDate FROM
Sales.InvoiceHeader”;daInvoices.SelectCommand. CommandText =
sql;daInvoices.Fill(DSInvoice, pageIndex, pageSize, “CKInvoices”);
}
B. private void FillCKInvoicesTable(int pageIndex) {
int pageSize = 5;
int startRecord = (pageIndex – 1) * pageSize;string sql = “SELECT InvoiceID, ClientID,
InvoiceDate FROM Sales.InvoiceHeader”;daInvoices.SelectCommand. CommandText =
sql;daInvoices.Fill(DSInvoice, startRecord, pageSize, “CKInvoices”);
}
C. private void FillCKInvoicesTable(int pageIndex) {
int pageSize = 5;
string sql = string.Format(“SELECT TOP {0} InvoiceID, ClientID, InvoiceDate FROM
Sales.InvoiceHeader WHERE InvoiceID > {1}”, pageSize,
pageIndex);daInvoices.SelectCommand. CommandText = sql;daInvoices.Fill(DSInvoice,
“CKInvoices”);
}
D. private void FillCKInvoicesTable(int pageIndex) {
int pageSize = 5;
int startRecord = (pageIndex – 1) * pageSize;string sql = string.Format(“SELECT TOP {0}
InvoiceID, ClientID, InvoiceDate FROM Sales.InvoiceHeader WHERE InvoiceID > {1}”, pageSize,
startRecord);daInvoices.SelectCommand. CommandText = sql;daInvoices.Fill(DSInvoice,
“CKInvoices”);
}
Answer: B
QUESTION NO: 5
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed an application and cofigured it to reference a Microsoft SQL Server 2005 database, named CKDB13.
You have been tasked with developing code that, when BLOBs are obtained from CKDB13, makes efficient use of the memory.
Which of the following options represents the code that you should create?
A. using (SqlConnection connection = new
SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand(queryString, connection);
connection.Closed();
SqlDataReader sdrdr = cmd.Reader();
while (sdrdr.Read()){
// use the data in the reader
}
}
B. using (SqlConnection connection = new
SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand(queryString, connection);
connection.Closed();
SqlDataReader sdrdr = cmd.Reader(CommandBehavior.Default);
while (sdrdr.Read()){
// use the data in the reader
}
}
C. using (SqlConnection connection = new
SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior. Operational Access);
while (sdrdr.Read()){ // use the data in the reader } }
D. using (SqlConnection connection = new
SqlConnection(connectionString)) {
SqlCommand cmd = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
while (sdrdr.Read()){
// use the data in the reader
}
}
Answer: D
QUESTION NO: 6
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed an application and cofigured it to reference a Microsoft SQL Server 2005 database, named CKDB13. You have created a web page for the application that has a GridView server control configured.
You have been tasked with making sure that data from the database table is acquired and bound to the DataSource property of the GridView server control.
Which of the following options represent the code you have written?
A. private void LoadGrid()
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = “SELECT * FROM Clients”;
connection.Open();
SqlDataReader rdr = command. ExecuteXmlWriter();connection.Close();GridView1.DataSource =
rdr;GridView1.DataBind();
}
}
B. private void LoadGrid()
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = “SELECT * FROM Clients”;
connection.Open();
SqlDataReader rdr = command. ExecuteXmlWriter();GridView1.DataSource =
rdr.Read();GridView1.DataBind();connection.Close();
}
}
C. private void LoadGrid()
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = “SELECT * FROM Clients”;
connection.Open();
SqlDataReader rdr = command. ExecuteXmlReader();Object[] values = new
Object[rdr.FieldCount];GridView1.DataSource =
rdr.GetValues(values);GridView1.DataBind();connection.Close();
}
}
D. private void LoadGrid()
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = “SELECT * FROM Clients”;
connection.Open();
DataTable dt = new DataTable();using (SqlDataReader reader = command. ExecuteReader()){
dt.Load(reader);}connection.Close();GridView1.DataSource = dt;GridView1.DataBind();
}
}
Answer: D
QUESTION NO: 7
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have recently developed an application that contains two DataTables named KingOrders and KingOrderData. KingOrders contain three columns, and KingOrderData has five columns.
You have been tasked with creating code that fills both DataTables with Data.
Which of the following actions should you take?
A. You should make use of the subsequent code:
private void GeCKingOrders(SqlDataConnection cn)
{ SqlCommand cmd = cn.CreateCommand();
cmd. CommandText = “Select * from [KingOrders];
Select * from [KingOrderData];”;
SqlDataAdapter da = new SqlDataAdapter(cmd);
dA. Fill(DSKingOrders);
}
B. You should make use of the subsequent code:
private void GeCKingOrders(SqlDataConnection cn)
{ SqlCommand cmd = cn.CreateCommand();
cmd. CommandText = “Select * from [KingOrders];
Select * from [KingOrderData];”;
SqlDataAdapter da = new SqlDataAdapter(cmd);
dA. Fill(DSKingOrders.KingOrders);dA. Fill(DSKingOrders.KingOrderData);
}
C. You should make use of the subsequent code:
private void GeCKingOrders(SqlDataConnection cn)
{ SqlCommand cmd = cn.CreateCommand();
cmd. CommandText = “Select * from [KingOrders];
Select * from [KingOrderData];”;
SqlDataAdapter da = new SqlDataAdapter(cmd);
dA. TableMappings.AddRange(new DataTableMapping[] { new DataTableMapping(“Table”,
“KingOrders”), new DataTableMapping(“Table1”, “KingOrderData”)});dA. Fill(DSKingOrders );
}
D. You should make use of the subsequent code:
private void GeCKingOrders(SqlDataConnection cn)
{ SqlCommand cmd = cn.CreateCommand();
cmd. CommandText = “Select * from [KingOrders];
Select * from [KingOrderData];”;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTableMapping mapOrder = new DataTableMapping();mapOrder.DataSetTable =
“KingOrders”;DataTableMapping mapKingOrderData = new
DataTableMapping();mapOrder.DataSetTable = “KingOrderData”;dA.
TableMappings.AddRange(new DataTableMapping[] { mapOrder, mapKingOrderData }); DA.
Fill(DSKingOrders );
}
Answer: C
QUESTION NO: 8
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed an application and cofigured it to reference a Microsoft SQL Server 2005 database.
You then receive an instruction to make sure that at runtime, all security-related exceptions are isolated from the rest of the exceptions for database processes.
Which of the following actions should you take?
A. You should consider writing code that includes the Number property, and makes use of the GetObjectData method.
B. You should consider writing code that includes the Class property, and makes use of the ToString() method.
C. You should consider writing code that includes the Class property, and makes use of the GetObjectData method.
D. You should consider writing code that includes the Data property, and makes use of the GetObjectData method.
Answer: B
QUESTION NO: 9
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have recently developed an application that provides information to Oracle by making use of the Microsoft OLE DB Provider.
During testing, you notice that an error occurs when the application attempts to return Oracle BLOB data. It is imperative that the application returns Oracle BLOB data.
Which of the following actions should you take?
A. You should reconfigure the application to make use of the OracleClient Provider in place of the OLE DB Provider.
B. You should configure the application to make use of both the OLE DB and OracleClient Provider
C. You should reconfigure the application to make use of the ODBC Provider.
D. You should consider making use of the standard .NET Framework data providers.
Answer: A
QUESTION NO: 10
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You are in the process of developing a new application that should have windows authentication, as well as the Microsoft OLE DB provider configured. You would like to configure maximum security for the OLE DB connection.
Which of the following actions should you make use of?
A. You should consider inserting parameters that configures the use of Security Support Provider Interface (SSPI).
B. You should consider inserting parameters that sets the Integrated Security setting to TRUE.
C. You should consider inserting parameters that indicates whether data that is security-sensitive is not returned as part of the OLE DB connection.
D. You should consider inserting parameters that configures the use of Kerberos authentication.
Answer: A
QUESTION NO: 11
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have recently created a new application that stores a connection string containing the username and password within the application code.
You have been tasked with making sure that this password is configured with maximum protection.
Which of the following actions should you take?
A. You should consider including the connection string to the Application.config file, before making use of protected configuration.
B. You should consider including the connection string to the machine.config file, before making use of protected configuration.
C. You should consider configuring the Persist Security Info value in the connection string with the default setting.
D. You should consider including the connection string to the WeB.config file, before making use of protected configuration.
Answer: D
QUESTION NO: 12
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You are in the process of developing an application that should be configured to populate a DataSet object, named CKClientDS with client information. You are preparing to create the necessary code.
Your code should allow for the content of the CKClientDS object to be written as XML data in conjunction with inline XML schema to the CKClients.xml file.
Which of the following actions should you take?
A. You should consider writing the following code:
System.IO.StreamWriter xmlSW =
new System.IO.StreamReader(“CKClients.xml”);
xmlSW.Read(CKClientDS.GetXml());
xmlSW.Open();
B. You should consider writing the following code:
System.IO.StreamReadr xmlSW =
new System.IO.StreamReadr(“CKClients.xml”);
CKClientDS.ReadXml(xmlSW, XmlReadModE. ReadSchema);
xmlSW.Close();
C. You should consider writing the following code:
System.IO.StreamWriter xmlSW =
new System.IO.StreamWriter(“CKClients.xml”);
CKClientDS.WriteXml(xmlSW);
xmlSW.Close();
D. You should consider writing the following code:
System.IO.StreamWriter xmlSW =
new System.IO.StreamWriter(“CKClients.xml”); CKClientDS.WriteXml(xmlSW, XmlWriteModE. WriteSchema); xmlSW.Close();
Answer: D
QUESTION NO: 13
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed a new application and cofigured it to reference a Microsoft SQL Server 2005 database. You are in the process of configuring a solution to handle exceptions for the new application.
To achieve this, you are required to locate SQL Server 2005 exceptions with a level of severity that exceeds nineteen.
Which of the following actions should you take?
A. You should consider making use of the System.Data.SqlClient.SqlException.State property
B. You should consider making use of the System.Data.SqlClient.SqlException.Number property.
C. You should consider making use of the System.Data.SqlClient.SqlException.ErrorCode property.
D. You should consider making use of the System.Data.SqlClient.SqlException.InnerException property.
Answer: D
QUESTION NO: 14
You work as an application developer at Itexamworld.com. You are making use of .NET Framework
3.5, as well as Microsoft ADO.NET for application development.
You have developed a new application and configured it to reference a Microsoft SQL Server 2005 database that has two tables named Clients and Details. You then configured the application to make use of a DataSet that has two DataTable objects configured to reference Clients and Details tables.
You then created the code shown below:
DataSet ClientsDetailsDS= new DataSet();
ClientsDetailsDS.EnforceConstraints = true;
DataRelation clientDetRel = new DataRelation(“ClientDetRel”,
ClientsDetailsDS.Tables[“Clients”].Columns[“ClientsID”],
ClientsDetailsDS.Tables[“Address”].Columns[“ClientsID”]);
ClientsDetailsDS.Relations.Add(clientDetRel);
You notice that lots of data in the Clients table is linked to data in the Details table
You then receive instruction to configure the application to update linked data in the Details table
whenever the Clients Table data is updated. You also have to make sure that any attempt to
remove linked data results in an exception being thrown.
Which of the following actions should you take?
A. You should consider making use of the following: custAddrRel.ChildKeyConstraint.DeleteRule = Rule. None;
B. You should consider making use of the following: custAddrRel.ChildKeyConstraint.DeleteRule = Rule. SetDefault;
C. You should consider making use of the following: custAddrRel.ChildKeyConstraint.DeleteRule = Rule. SetNull;
D. You should consider making use of the following: custAddrRel.ChildKeyConstraint.DeleteRule = Rule. Cascade;
Answer: A
Well-regarded for its level of detail, assessment features, and challenging review questions and hands-on exercises,Microsoft 70-561 helps you master the concepts and techniques that will enable you to succeed on the Microsoft 70-561 exam the first time.
