70-561 Exam

Quality and Value for the 70-561 Exam

4cert Practice Exams for Microsoft 70-561 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

Guarantee to Pass Your 70-561 Exam

If you prepare for the exam using our 4cert testing engine, we guarantee your success in the first attempt. If you do not pass the TS 70-561 Exam exam (TS: MS .NET Framework 3.5, ADO.NET Application Development) on your first attempt we will give you a FREE UPDATE of your purchasing fee AND send you another same value product for free.

Microsoft 70-561 Exams (in EXE format)

Our Exam 70-561 Preparation Material provides you everything you will need to take your 70-561 Exam. The 70-561 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

70-561 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Microsoft 70-561 Exam will provide you with exam questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 70-561 Exam:100% Guarantee to Pass Your TS exam and get your TS Certification.
　
　
Exam : Microsoft 70-561
Title : TS: MS .NET Framework 3.5, ADO.NET Application Development


1. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
You need to separate the security-related exceptions from the other exceptions for database operations at run time.
Which code segment should you use?
A. catch (System.Security.SecurityException ex)
{
//Handle all database security related exceptions.
}
B. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Class.ToString() == "14") {
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
C. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Number == 14){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
D. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Message.Contains("Security")){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
Answer: B

2. You create an application by using the Microsoft .NET Framework 5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
The application throws an exception when the SQL Connection object is used.
You need to handle the exception.
Which code segment should you use?
A. try
{
if(null!=conn)
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Open();
}
B. try
{
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Open();
}
C. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Close();
}
D. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Close();
}
Answer: C

3. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
You need to ensure that the application can connect to any type of database.
What should you do?
A. Set the database driver name in the connection string of the application, and then create the connection object in the following manner.
Dim connection As DbConnection = _ New OdbcConnection(connectionString)
B. Set the database provider name in the connection string of the application, and then create the connection object in the following manner.
Dim connection As DbConnection = _ New OleDbConnection(connectionString)
C. Create the connection object in the following manner.
Dim factory As DbProviderFactory = _ DbProviderFactories.GetFactory("System.Data.Odbc")
Dim connection As DbConnection = _ factory.CreateConnection()
D. Create the connection object in the following manner.
Dim factory As DbProviderFactory = _ DbProviderFactories.GetFactory(databaseProviderName)
Dim connection As DbConnection = factory.CreateConnection()
Answer: D

4. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
The application throws an exception when the SQL Connection object is used.
You need to handle the exception.
Which code segment should you use?
A. Try
If conn IsNot Nothing Then
conn.Close()
' code for the query
End If
Catch ex As Exception
' handle exception
Finally
If conn Is Nothing Then
conn.Open()
End If
End Try
B. Try
' code for the query
conn.Close()
Catch ex As Exception
' handle exception
Finally
If conn IsNot Nothing Then
conn.Open()
End If
End Try
C. Try
' code for the query
conn.Open()
Catch ex As Exception
' handle exception
Finally
If conn IsNot Nothing Then
conn.Close()
End If
End Try
D. Try
' code for the query
conn.Open()
Catch ex As Exception
' handle exception
Finally
If conn Is Nothing Then
conn.Close()
End If
End Try
Answer: C

5. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
You need to ensure that the application can connect to any type of database.
What should you do?
A. Set the database driver name in the connection string of the application, and then create the connection object in the following manner.
DbConnection connection = new OdbcConnection(connectionString);
B. Set the database provider name in the connection string of the application, and then create the connection object in the following manner.
DbConnection connection = new OleDbConnection(connectionString);
C. Create the connection object in the following manner.
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.Odbc");
DbConnection connection = factory.CreateConnection();
D. Create the connection object in the following manner.
DbProviderFactory factory = DbProviderFactories.GetFactory(databaseProviderName);
DbConnection connection = factory.CreateConnection();
Answer: D

http://www.4cert.com The safer.easier way to get TS Certification.