显示标签为“70-565”的博文。显示所有博文
显示标签为“70-565”的博文。显示所有博文

2014年2月20日星期四

Microsoft 70-565認定試験に合格できる不可欠なツール

JPexamは多くのIT職員の夢を達成することであるウェブサイトです。IT夢を持っていたら、速くJPexamに来ましょう。 JPexamにはすごいトレーニング即ち Microsoftの70-565試験トレーニング資料があります。これはIT職員の皆が熱望しているものです。あなたが試験に合格することを助けられますから。

Microsoftの70-565の試験の資料やほかのトレーニング資料を提供しているサイトがたくさんありますが、Microsoftの70-565の認証試験の高品質の資料を提供しているユニークなサイトはJPexamです。Pass4Tesのガイダンスとヘルプを通して、初めにMicrosoftの70-565の認証を受けるあなたは、気楽に試験に合格すことができます。JPexamが提供した問題と解答は現代の活力がみなぎる情報技術専門家が豊富な知識と実践経験を活かして研究した成果で、あなたが将来IT分野でより高いレベルに達することに助けを差し上げます。

あなたはまだ何を待っているのですか。機会が一回だけありますよ。いまMicrosoftの70-565試験問題のフルバージョンを取ることができます。JPexamというサイトをクッリクしたらあなたの願いを果たせます。あなたが最も良いMicrosoftの70-565試験トレーニング資料を見つけましたから、JPexamの問題と解答を安心に利用してください。きっと試験に合格しますよ。

試験番号:70-565問題集
試験科目:Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5
最近更新時間:2014-02-20
問題と解答:全138問
100%の返金保証。1年間の無料アップデート。

JPexamは頼りが強い上にサービスもよくて、もし試験に失敗したら全額で返金いたしてまた一年の無料なアップデートいたします。

あなたはこのような人々の一人ですか。さまざまな資料とトレーニング授業を前にして、どれを選ぶか本当に困っているのです。もしそうだったら、これ以上困ることはないです。JPexamはあなたにとって最も正確な選択ですから。我々はあなたに試験問題と解答に含まれている全面的な試験資料を提供することができます。JPexamの解答は最も正確な解釈ですから、あなたがより良い知識を身につけることに助けになれます。JPexamを利用したら、Microsoftの70-565認定試験に受かることを信じています。それも我々が全てのお客様に対する約束です。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード:http://www.jpexam.com/70-565_exam.html

NO.1 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes a component. The component will be referenced by the .NET and COM
applications.
The component contains the following code segment.
Public Class Employee
Public Sub New(ByVal name As String)
End Sub
End Class
The .NET and COM applications must perform the following tasks:
Create objects of the Employee type.
use these objects to access the employee details.
You need to ensure that the .NET and COM applications can consume the managed component.
What should you do?
A. Change the Employee class to a generic class.
B. Change the constructor to a no-argument constructor.
C. Set the access modifier of the class to Friend.
D. Set the access modifier of the constructor to Protected.
Answer: B

Microsoft   70-565認定証   70-565認定試験   70-565認証試験   70-565参考書

NO.2 How many years of experience do you have in developing enterprise applications by using the
Microsoft .NET Framework 3.5?
A. I have not done this yet.
B. Less than 6 months
C. 6 months- 1 year
D. 1- 2 years
E. 2- 3 years
F. More than 3 years
Answer: A

Microsoft認定試験   70-565認証試験   70-565認定証

NO.3 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application has a class that contains a method named NewEvent. The NewEvent method contains
the following code segment.
using (SqlConnection cn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "prcEvent";
cmd.Parameters.Add("@Date", SqlDbType.DateTime, 4);
cmd.Parameters.Add("@Desc", SqlDbType.VarChar, 8000);
cmd.Parameters.Add("@Link", SqlDbType.VarChar, 2048);
cmd.Parameters["@Date"].Value = date;
cmd.Parameters["@Desc"].Value = eventText;
cmd.Parameters["@Link"].Value = eventLink;
cn.Open();
retcode = cmd.ExecuteNonQuery().ToString();
}
During the test process, a user executes the NewEvent method. The method fails and returns the
following error message:
"A stored procedure named prcEvent requires a parameter named @Date."
You need to resolve the error.
What should you do?
A. Set the CommandText property of the cmd object to dbo.prcEvent.
B. Set the CommandType property of the cmd object to CommandType.TableDirect.
C. Set the CommandType property of the cmd object to CommandType.StoredProcedure.
D. Replace the ExecuteNonQuery method of the cmd object with the ExecuteScalar method.
Answer: C

Microsoft   70-565   70-565認定証   70-565認証試験

NO.4 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application will be used on personal computers and mobile-based devices.
The current application design is composed of the following three layers:
User interface layer
Business layer
Data access layer
You need to ensure that the application offers a custom experience to the end user based on the type of
device used. You also need to ensure that code duplication is avoided.
What should you do?
A. Implement different business layers for mobile-based devices and personal computers. Implement a
single service layer to expose the business layer to the user interface.
B. Implement different data access layers for mobile-based devices and personal computers. Implement a
single business layer to expose business objects to the user interface.
C. Implement different user interface layers for mobile-based devices and personal computers. Implement
a single user interface process layer to expose business objects to the user interface.
D. Implement different user interface process layers for mobile-based devices and personal computers.
Implement a single user interface to expose data by using rules from the user interface process layer.
Answer: C

Microsoft   70-565   70-565練習問題

NO.5 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application has a class that contains a method named NewEvent. The NewEvent method contains
the following code segment.
Using cn As SqlConnection = New SqlConnection(connString)
Dim cmd As SqlCommand = New SqlCommand()
cmd.Connection = cn
cmd.CommandText = "prcEvent"
cmd.Parameters.Add("@Date", SqlDbType.DateTime, 4)
cmd.Parameters.Add("@Desc", SqlDbType.VarChar, 8000)
cmd.Parameters.Add("@Link", SqlDbType.VarChar, 2048)
cmd.Parameters("@Date").Value = dateValue
cmd.Parameters("@Desc").Value = eventText
cmd.Parameters("@Link").Value = eventLink
cn.Open()
retcode = cmd.ExecuteNonQuery()
End Using
During the test process, a user executes the NewEvent method. The method fails and returns the
following error message:
"A stored procedure named prcEvent requires a parameter named @Date."
You need to resolve the error.
What should you do?
A. Set the CommandText property of the cmd object to dbo.prcEvent.
B. Set the CommandType property of the cmd object to CommandType.TableDirect.
C. Set the CommandType property of the cmd object to CommandType.StoredProcedure.
D. Replace the ExecuteNonQuery method of the cmd object with the ExecuteScalar method.
Answer: C

Microsoft   70-565   70-565認定試験

NO.6 You create applications by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
You deploy a new Windows Forms application in a test environment. During the test process, an error
message that includes an incomplete stack trace is reported.
You review the following code segment that has caused the error.
public int AddNewMission(DateTime date, string mission, string missionLink)
{
try
{
DALCode pgr = new DALCode("cnWeb");
int retcode = pgr.AddNewMission(date, mission, missionLink);
return retcode;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
pgr.Dispose();
}
}
You need to modify the code segment to display the entire stack trace.
What should you do?
A. Remove the CATCH block.
B. Remove the FINALLY block.
C. Add a Using block to the TRY block.
D. Replace the THROW statement in the CATCH block with throw(ex).
Answer: A

Microsoft   70-565認定資格   70-565

NO.7 You create an ASP.NET application by using Microsoft Visual Studio .NET 2008 and the .NET
Framework 3.5.
The application uses the Session object to store data. The application is currently deployed to a single
server.
You need to ensure that the application is available in the event of failure of any single server.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Host the application in a Web farm environment.
B. Host the application in a Web garden environment.
C. Use the SQLServer mode to store the session state.
D. Use the StateServer mode to store the session state.
E. Use the Application object instead of the Session object to cache data.
Answer: AC

Microsoft参考書   70-565過去問   70-565認定資格   70-565過去問

NO.8 You create a Windows Communication Foundation (WCF) application by using Microsoft Visual Studio
2008 and the .NET Framework 3.5.
You create a WCF service by using the following code segment. (Line numbers are included for reference
only.)
01 [ServiceContract]
02 public interface IContosoService
03 {
04 [OperationContract]
05
06 void ProcessTransaction();
07 }
08
09 public class ContosoService : IContosoService
10 {
11 public void ProcessTransaction() {
12 try {
13 BusinessComponent.ProcessTransaction();
14 }
15 catch (ApplicationException appEx) {
16
17 }

NO.9 How many years of experience do you have in developing enterprise applications by using any version
of the Microsoft .NET Framework?
A. I have not done this yet.
B. Less than 6 months
C. 6 months- 1 year
D. 1- 2 years
E. 2- 3 years
F. More than 3 years
Answer: A

Microsoft認定試験   70-565   70-565

NO.10 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The ASP.NET application connects to a shared Microsoft SQL Server 2008 database instance.
The application requires certain changes in the relationships represented in the data. However, any
changes to the database schema can break existing applications that share the database instance.
You need to recommend a strategy that allows the application to make the required relationship changes
without affecting the underlying database schema. You also need to ensure that the strategy uses the
minimum amount of development effort.
Which strategy should you recommend?
A. Generate a model by using LINQ to SQL. Make the relationship changes to the model.
B. Generate an ADO.NET Entity Framework model. Make the relationship changes in the model.
C. Add an HTTP endpoint to SQL Server 2008 database to retrieve the data from the database in tabular
format.
D. Create a DataSet object and add a DataTable object for each table in the database. Create a
DataRelation object for each relationship required for the application.
Answer: B

Microsoft   70-565練習問題   70-565練習問題   70-565   70-565認証試験

NO.11 Which of the following technologies do you use regularly? Choose all that apply.
A. Microsoft ASP.NET
B. Windows Forms
C. Windows Presentation Foundation (WPF)
D. Microsoft ADO.NET
E. Windows Communication Foundation (WCF)
F. Distributed technologies in .NET 3.5
Answer: A

Microsoft認定証   70-565問題集   70-565問題集

NO.12 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes multiple components. The components communicate by passing messages to
each other. You are planning to update the application to meet new business requirements.
You need to document the application logic. You also need to ensure that the documentation captures the
details of the component interaction.
What should you do?
A. Use a class diagram.
B. Use a Use case diagram.
C. Use a sequence diagram.
D. Use a component diagram.
Answer: C

Microsoft   70-565   70-565   70-565参考書

NO.13 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
Users access the application by using Windows-based client applications or Web-based client
applications. All client applications share common business logic to handle transaction processing
requests.
You need to ensure that the application is easy to maintain.
What should you do?
A. Create a single component and host the component on each client application.
B. Create a single component and host the component on a separate application tier.
C. Create separate components and host the components on each application tier.
D. Create separate components and host the components on each client application.
Answer: B

Microsoft   70-565   70-565   70-565参考書

NO.14 Rate your level of proficiency in migrating, deploying, and maintaining an application, including creating
a deployment plan, and analyzing the configuration of the production environment, performance
monitoring data, and logs.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft   70-565過去問   70-565問題集

NO.15 You create a Windows Forms application by using Microsoft Visual Studio .NET 2008 and the .NET
Framework 3.5.
The application contains the following code segment.
Public Function GetProductByID(ByVal ProductID As String) As DataSet
Dim ds As DataSet = New DataSet("ProductList")
Dim SqlSelectCommand As String = "Select * FROM PRODUCTS WHERE
PRODUCTID=" + ProductID
Try
Dim da As SqlDataAdapter = New SqlDataAdapter()
Dim cn As SqlConnection = New
SqlConnection(GetConnectionString())
Dim cmd As SqlCommand = New SqlCommand(SqlSelectCommand)
cmd.CommandType = CommandType.Text
cn.Open()
da.Fill(ds)
cn.Close()
Catch ex As Exception
Dim msg As String = ex.Message.ToString()
'Perform Exception Handling Here
End Try
Return ds
End Function
You need to ensure that the code segment is as secure as possible.
What should you do?
A. Ensure that the connection string is encrypted.
B. Use a StringBuilder class to construct the SqlSelectCommand string.
C. Add a parameter to the cmd object and populate the object by using the ProductID string.
D. Replace the SELECT * statement in the SqlSelectCommand string with the SELECT <column list>
statement.
Answer: C

Microsoft問題集   70-565認定証   70-565過去問   70-565

NO.16 }
The BusinessComponent.ProcessTransaction method will only throw exceptions from the
ApplicationException type. You plan to debug the WCF service.
You need to ensure that the WCF service meets the following requirements:
Detailed exception information is provided to the client application.
Subsequent calls can be issued to the service by using the same proxy intance after an exception is
caught in the client application.
What should you do?
A. Add the following code segment at line 08.
[ServiceBehavior(IncludeExceptionDetailInFaults=true)]
Add the following code segment at line 16.
throw appEx;
B. Add the following code segment at line 05.
[FaultContract(typeof(ApplicationException))]
Add the following code segment at line 16.
throw appEx;
C. Add the following code segment at line 08.
[ServiceBehavior(IncludeExceptionDetailInFaults=true)]
Add the following code segment at line 16.
throw new FaultException<ApplicationException>(appEx);
D. Add the following code segment at line 05.
[FaultContract(typeof(ApplicationException))]
Add the following code segment at line 16.
throw new FaultException<ApplicationException>(appEx);
Answer: D

Microsoft   70-565問題集   70-565問題集   70-565
18. You create a Windows Communication Foundation (WCF) application by using Microsoft Visual Studio
2008 and the .NET Framework 3.5.
You create a WCF service by using the following code segment. (Line numbers are included for reference
only.)
01 <ServiceContract()> _
02 Public Interface IContosoService
03
04 <OperationContract()> _
05 Sub ProcessTransaction()
06
07 End Interface
08
09 Public Class ContosoService
10 Implements IContosoService
11
12 Public Sub ProcessTransaction() _
Implements IContosoService.ProcessTransaction
13 Try
14 BusinessComponent.ProcessTransaction()
15 Catch appEx As ApplicationException
16
17 End Try
18 End Sub
19 End Class
The BusinessComponent.ProcessTransaction method will only throw exceptions from the
ApplicationException type. You plan to debug the WCF service.
You need to ensure that the WCF service meets the following requirements:
Provides detailed exception information to the client application.
Subsequent calls can be issued to the service by using the same proxy intance after an exception is
caught in the client application.
What should you do?
A. Add the following code segment at line 08.
<ServiceBehavior(IncludeExceptionDetailInFaults:=True)>
Add the following code segment at line 16.
Throw appEx
B. Add the following code segment at line 06.
<FaultContract(GetType(ApplicationException))>
Add the following code segment at line 16.
Throw appEx
C. Add the following code segment at line 08.
<ServiceBehavior(IncludeExceptionDetailInFaults:=True)>
Add the following code segment at line 16.
Throw New FaultException(Of ApplicationException)(appEx)
D. Add the following code segment at line 06.
<FaultContract(GetType(ApplicationException))>
Add the following code segment at line 16.
Throw New FaultException(Of ApplicationException)(appEx)
Answer: D

Microsoft   70-565   70-565   70-565練習問題
19. You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application design specifies the following components:
A user interface implemented as an ASP.NET 3.5 Web application
A Microsoft SQL Server 2005 database to store business data
A Windows Communication Foundation (WCF) service that authenticates users that have their
credentials stored in the SQL Server database
A business data service to transfer data between the user interface and the SQL Server database
In future releases, the application must also be able to authenticate business partners who use
non-Microsoft directory servers to store user credentials.
You need to ensure that the application design meets the extensibility requirements.
What should you do?
A. Implement the business data service as a WCF service.
B. Host the Web application on multiple load-balanced Web servers.
C. Add an abstraction layer between the user interface and the authentication service.
D. Implement database objects that store the corporate user credentials in the same SQL Server
database as the business data.
Answer: C

Microsoft問題集   70-565   70-565認定証

NO.17 You create a Windows Forms application by using Microsoft Visual Studio .NET 2008 and the .NET
Framework 3.5.
The application contains the following code segment.
public DataSet GetProductByID(string ProductID)
{
DataSet ds = new DataSet("ProductList");
string SqlSelectCommand = "Select * FROM PRODUCTS WHERE
PRODUCTID=" + ProductID;
try
{
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection cn = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand(SqlSelectCommand);
cmd.CommandType = CommandType.Text;
cn.Open();
da.Fill(ds);
cn.Close();
}
catch (Exception ex)
{
string msg = ex.Message.ToString();
//Perform Exception Handling Here
}
return ds;
}
You need to ensure that the code segment is as secure as possible.
What should you do?
A. Ensure that the connection string is encrypted.
B. Use a StringBuilder class to construct the SqlSelectCommand string.
C. Add a parameter to the cmd object and populate the object by using the ProductID string.
D. Replace the SELECT * statement in the SqlSelectCommand string with the SELECT <column list>
statement.
Answer: C

Microsoft   70-565認証試験   70-565   70-565

NO.18 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The ASP.NET application connects to a shared Microsoft SQL Server 2008 database instance.
The application requires certain changes in the relationships represented in the data. However, any
changes to the database schema can break existing applications that share the database instance.
You need to recommend a strategy that allows the application to make the required relationship changes
without affecting the underlying database schema. You also need to ensure that the strategy uses the
minimum amount of development effort.
Which strategy should you recommend?
A. Generate a model by using LINQ to SQL. Make the relationship changes to the model.
B. Generate an ADO.NET Entity Framework model. Make the relationship changes in the model.
C. Add an HTTP endpoint to SQL Server 2008 database to retrieve the data from the database in tabular
format.
D. Create a DataSet object and add a DataTable object for each table in the database. Create a
DataRelation object for each relationship required for the application.
Answer: B

Microsoft練習問題   70-565認定試験   70-565

NO.19 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application design specifies the following components:
A user interface implemented as an ASP.NET 3.5 Web application
A Microsoft SQL Server 2005 database to store business data
A Windows Communication Foundation (WCF) service that authenticates users that have their
credentials stored in the SQL Server database
A business data service to transfer data between the user interface and the SQL Server database
In future releases, the application must also be able to authenticate business partners who use
non-Microsoft directory servers to store user credentials.
You need to ensure that the application design meets the extensibility requirements.
What should you do?
A. Implement the business data service as a WCF service.
B. Host the Web application on multiple load-balanced Web servers.
C. Add an abstraction layer between the user interface and the authentication service.
D. Implement database objects that store the corporate user credentials in the same SQL Server
database as the business data.
Answer: C

Microsoft   70-565過去問   70-565参考書

NO.20 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application will be used on personal computers and mobile-based devices.
The current application design is composed of the following three layers:
User interface layer
Business layer
Data access layer
You need to ensure that the application offers a custom experience to the end user based on the type of
device used. You also need to ensure that code duplication is avoided.
What should you do?
A. Implement different business layers for mobile-based devices and personal computers. Implement a
single service layer to expose the business layer to the user interface.
B. Implement different data access layers for mobile-based devices and personal computers. Implement a
single business layer to expose business objects to the user interface.
C. Implement different user interface layers for mobile-based devices and personal computers. Implement
a single user interface process layer to expose business objects to the user interface.
D. Implement different user interface process layers for mobile-based devices and personal computers.
Implement a single user interface to expose data by using rules from the user interface process layer.
Answer: C

Microsoft   70-565認定試験   70-565認定試験

NO.21 Rate your level of proficiency in stabilizing and testing an application, including defining a functional test
strategy, performing integration testing, and performing a code review.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft認定資格   70-565   70-565   70-565   70-565

NO.22 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
Users access the application by using Windows-based client applications or Web-based client
applications. All client applications share common business logic to handle transaction processing
requests.
You need to ensure that the application is easy to maintain.
What should you do?
A. Create a single component and host the component on each client application.
B. Create a single component and host the component on a separate application tier.
C. Create separate components and host the components on each application tier.
D. Create separate components and host the components on each client application.
Answer: B

Microsoft   70-565練習問題   70-565   70-565   70-565   70-565

NO.23 Rate your level of proficiency in designing and developing an application framework, including
choosing an appropriate implementation approach for the application design logic, defining the interaction
between framework components, and defining validation and event logging strategies.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft   70-565過去問   70-565認定資格   70-565

NO.24 }

NO.25 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes a component. The component will be referenced by the .NET and COM
applications.
The component contains the following code segment.
public class Employee
{
public Employee(string name)
{
}
}
The .NET and COM applications must perform the following tasks:
Create objects of the Employee type.
use these objects to access the employee details.
You need to ensure that the .NET and COM applications can consume the managed component.
What should you do?
A. Change the Employee class to a generic class.
B. Change the constructor to a no-argument constructor.
C. Set the access modifier of the class to internal.
D. Set the access modifier of the constructor to protected.
Answer: B

Microsoft   70-565   70-565認定試験   70-565   70-565

NO.26 You create applications by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
You deploy a new Windows Forms application in a test environment. During the test process, an error
message that includes an incomplete stack trace is reported.
You review the following code segment that has caused the error.
Public Function AddNewMission(ByVal missiondate As DateTime, _
ByVal mission As String, ByVal missionLink As String) As Integer
Dim pgr As DALCode = New DALCode("cnWeb")
Try
Dim retcode As Int16 = _
pgr.AddNewMission(missiondate, mission, missionLink)
Return retcode
Catch ex As Exception
Throw New Exception(ex.Message.ToString())
Finally
pgr.Dispose()
End Try
End Function
You need to modify the code segment to display the entire stack trace.
What should you do?
A. Remove the CATCH block.
B. Remove the FINALLY block.
C. Add a Using block to the TRY block.
D. Replace the THROW statement in the CATCH block with Throw (ex).
Answer: A

Microsoft認定試験   70-565認定資格   70-565   70-565   70-565認証試験

NO.27 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes multiple components. The components communicate by passing messages to
each other. You are planning to update the application to meet new business requirements.
You need to document the application logic. You also need to ensure that the documentation captures the
details of the component interaction.
What should you do?
A. Use a class diagram.
B. Use a Use case diagram.
C. Use a sequence diagram.
D. Use a component diagram.
Answer: C

Microsoft   70-565   70-565問題集

NO.28 Rate your level of proficiency in envisioning and designing an application, including analyzing and
refining the logical, physical, and database designs of the application.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft   70-565   70-565   70-565   70-565

NO.29 Rate your level of proficiency in designing application components, including creating the high-level
design of a component, defining the internal architecture of a component, and defining the data handling
for a component.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft   70-565練習問題   70-565練習問題

JPexamは最新の1Z0-027問題集と高品質のLOT-406問題と回答を提供します。JPexamの000-N38 VCEテストエンジンとC_TPLM30_66試験ガイドはあなたが一回で試験に合格するのを助けることができます。高品質の70-561 PDFトレーニング教材は、あなたがより迅速かつ簡単に試験に合格することを100%保証します。試験に合格して認証資格を取るのはそのような簡単なことです。

記事のリンク:http://www.jpexam.com/70-565_exam.html

2013年9月8日星期日

Latest Microsoft 70-565 of exam practice questions and answers

In this age of advanced network, there are many ways to prepare Microsoft 70-565 certification exam. IT-Tests.com provides the most reliable training questions and answers to help you pass Microsoft 70-565 certification exam. . IT-Tests.com have a variety of Microsoft certification exam questions, we will meet you all about IT certification.

In order to help you more IT-Tests.com the Microsoft 70-565 exam eliminate tension of the candidates on the Internet. 70-565 study materials including the official Microsoft 70-565 certification training courses, Microsoft 70-565 self-paced training guide, 70-565 exam IT-Tests.com and practice, 70-565 online exam 70-565 study guide. 70-565 simulation training package designed by IT-Tests.com can help you effortlessly pass the exam. Do not spend too much time and money, as long as you have IT-Tests.com learning materials you will easily pass the exam.

With IT-Tests.com's Microsoft 70-565 exam training materials you can pass the Microsoft 70-565 exam easily. The training tools which designed by our website can help you pass the exam the first time. You only need to download the IT-Tests.com Microsoft 70-565 exam training materials, namely questions and answers, the exam will become very easy. IT-Tests.com guarantee that you will be able to pass the exam. If you are still hesitant, download our sample of material, then you can know the effect. Do not hesitate, add the exam material to your shopping cart quickly. If you miss it you will regret for a lifetime.

Exam Code: 70-565
Exam Name: Microsoft (Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5)
Free One year updates to match real exam scenarios, 100% pass and refund Warranty.
Total Q&A: 138 Questions and Answers
Last Update: 2013-09-08

70-565 certification exam is a very import component Microsoft certification exam. But passing Microsoft certification 70-565 exam is not so simple. In order to give to relieve pressure and save time and effort for candidates who take a preparation for the 70-565 certification exam, IT-Tests.com specially produce a variety of training tools. So you can choose an appropriate quick training from IT-Tests.com to pass the exam.

Dear candidates, have you thought to participate in any Microsoft 70-565 exam training courses? In fact, you can take steps to pass the certification. IT-Tests.com Microsoft 70-565 exam training materials bear with a large number of the exam questions you need, which is a good choice. The training materials can help you pass the certification.

Selecting IT-Tests.com can 100% help you pass the exam. According to Microsoft 70-565 test subjects' changing, we will continue to update our training materials and will provide the latest exam content. IT-Tests.com can provide a free 24-hour online customer service for you . If you do not pass Microsoft certification 70-565 exam, we will full refund to you.

70-565 (Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5) Free Demo Download: http://www.it-tests.com/70-565.html

NO.1 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The ASP.NET application connects to a shared Microsoft SQL Server 2008 database instance.
The application requires certain changes in the relationships represented in the data. However, any
changes to the database schema can break existing applications that share the database instance.
You need to recommend a strategy that allows the application to make the required relationship changes
without affecting the underlying database schema. You also need to ensure that the strategy uses the
minimum amount of development effort.
Which strategy should you recommend?
A. Generate a model by using LINQ to SQL. Make the relationship changes to the model.
B. Generate an ADO.NET Entity Framework model. Make the relationship changes in the model.
C. Add an HTTP endpoint to SQL Server 2008 database to retrieve the data from the database in tabular
format.
D. Create a DataSet object and add a DataTable object for each table in the database. Create a
DataRelation object for each relationship required for the application.
Answer: B

Microsoft dumps   70-565 test answers   70-565

NO.2 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application will be used on personal computers and mobile-based devices.
The current application design is composed of the following three layers:
User interface layer
Business layer
Data access layer
You need to ensure that the application offers a custom experience to the end user based on the type of
device used. You also need to ensure that code duplication is avoided.
What should you do?
A. Implement different business layers for mobile-based devices and personal computers. Implement a
single service layer to expose the business layer to the user interface.
B. Implement different data access layers for mobile-based devices and personal computers. Implement a
single business layer to expose business objects to the user interface.
C. Implement different user interface layers for mobile-based devices and personal computers. Implement
a single user interface process layer to expose business objects to the user interface.
D. Implement different user interface process layers for mobile-based devices and personal computers.
Implement a single user interface to expose data by using rules from the user interface process layer.
Answer: C

Microsoft answers real questions   70-565   70-565

NO.3 }
The BusinessComponent.ProcessTransaction method will only throw exceptions from the
ApplicationException type. You plan to debug the WCF service.
You need to ensure that the WCF service meets the following requirements:
Detailed exception information is provided to the client application.
Subsequent calls can be issued to the service by using the same proxy intance after an exception is
caught in the client application.
What should you do?
A. Add the following code segment at line 08.
[ServiceBehavior(IncludeExceptionDetailInFaults=true)]
Add the following code segment at line 16.
throw appEx;
B. Add the following code segment at line 05.
[FaultContract(typeof(ApplicationException))]
Add the following code segment at line 16.
throw appEx;
C. Add the following code segment at line 08.
[ServiceBehavior(IncludeExceptionDetailInFaults=true)]
Add the following code segment at line 16.
throw new FaultException<ApplicationException>(appEx);
D. Add the following code segment at line 05.
[FaultContract(typeof(ApplicationException))]
Add the following code segment at line 16.
throw new FaultException<ApplicationException>(appEx);
Answer: D

Microsoft braindump   70-565   70-565 exam   70-565 demo
18. You create a Windows Communication Foundation (WCF) application by using Microsoft Visual Studio
2008 and the .NET Framework 3.5.
You create a WCF service by using the following code segment. (Line numbers are included for reference
only.)
01 <ServiceContract()> _
02 Public Interface IContosoService
03
04 <OperationContract()> _
05 Sub ProcessTransaction()
06
07 End Interface
08
09 Public Class ContosoService
10 Implements IContosoService
11
12 Public Sub ProcessTransaction() _
Implements IContosoService.ProcessTransaction
13 Try
14 BusinessComponent.ProcessTransaction()
15 Catch appEx As ApplicationException
16
17 End Try
18 End Sub
19 End Class
The BusinessComponent.ProcessTransaction method will only throw exceptions from the
ApplicationException type. You plan to debug the WCF service.
You need to ensure that the WCF service meets the following requirements:
Provides detailed exception information to the client application.
Subsequent calls can be issued to the service by using the same proxy intance after an exception is
caught in the client application.
What should you do?
A. Add the following code segment at line 08.
<ServiceBehavior(IncludeExceptionDetailInFaults:=True)>
Add the following code segment at line 16.
Throw appEx
B. Add the following code segment at line 06.
<FaultContract(GetType(ApplicationException))>
Add the following code segment at line 16.
Throw appEx
C. Add the following code segment at line 08.
<ServiceBehavior(IncludeExceptionDetailInFaults:=True)>
Add the following code segment at line 16.
Throw New FaultException(Of ApplicationException)(appEx)
D. Add the following code segment at line 06.
<FaultContract(GetType(ApplicationException))>
Add the following code segment at line 16.
Throw New FaultException(Of ApplicationException)(appEx)
Answer: D

Microsoft   70-565 test answers   70-565 questions
19. You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application design specifies the following components:
A user interface implemented as an ASP.NET 3.5 Web application
A Microsoft SQL Server 2005 database to store business data
A Windows Communication Foundation (WCF) service that authenticates users that have their
credentials stored in the SQL Server database
A business data service to transfer data between the user interface and the SQL Server database
In future releases, the application must also be able to authenticate business partners who use
non-Microsoft directory servers to store user credentials.
You need to ensure that the application design meets the extensibility requirements.
What should you do?
A. Implement the business data service as a WCF service.
B. Host the Web application on multiple load-balanced Web servers.
C. Add an abstraction layer between the user interface and the authentication service.
D. Implement database objects that store the corporate user credentials in the same SQL Server
database as the business data.
Answer: C

Microsoft   70-565 exam   70-565 certification   70-565 pdf

NO.4 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
Users access the application by using Windows-based client applications or Web-based client
applications. All client applications share common business logic to handle transaction processing
requests.
You need to ensure that the application is easy to maintain.
What should you do?
A. Create a single component and host the component on each client application.
B. Create a single component and host the component on a separate application tier.
C. Create separate components and host the components on each application tier.
D. Create separate components and host the components on each client application.
Answer: B

Microsoft certification training   70-565 exam   70-565   70-565

NO.5 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes a component. The component will be referenced by the .NET and COM
applications.
The component contains the following code segment.
Public Class Employee
Public Sub New(ByVal name As String)
End Sub
End Class
The .NET and COM applications must perform the following tasks:
Create objects of the Employee type.
use these objects to access the employee details.
You need to ensure that the .NET and COM applications can consume the managed component.
What should you do?
A. Change the Employee class to a generic class.
B. Change the constructor to a no-argument constructor.
C. Set the access modifier of the class to Friend.
D. Set the access modifier of the constructor to Protected.
Answer: B

Microsoft   70-565 test answers   70-565 braindump

NO.6 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
Users access the application by using Windows-based client applications or Web-based client
applications. All client applications share common business logic to handle transaction processing
requests.
You need to ensure that the application is easy to maintain.
What should you do?
A. Create a single component and host the component on each client application.
B. Create a single component and host the component on a separate application tier.
C. Create separate components and host the components on each application tier.
D. Create separate components and host the components on each client application.
Answer: B

Microsoft   70-565 study guide   70-565   70-565 exam   70-565

NO.7 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application has a class that contains a method named NewEvent. The NewEvent method contains
the following code segment.
using (SqlConnection cn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "prcEvent";
cmd.Parameters.Add("@Date", SqlDbType.DateTime, 4);
cmd.Parameters.Add("@Desc", SqlDbType.VarChar, 8000);
cmd.Parameters.Add("@Link", SqlDbType.VarChar, 2048);
cmd.Parameters["@Date"].Value = date;
cmd.Parameters["@Desc"].Value = eventText;
cmd.Parameters["@Link"].Value = eventLink;
cn.Open();
retcode = cmd.ExecuteNonQuery().ToString();
}
During the test process, a user executes the NewEvent method. The method fails and returns the
following error message:
"A stored procedure named prcEvent requires a parameter named @Date."
You need to resolve the error.
What should you do?
A. Set the CommandText property of the cmd object to dbo.prcEvent.
B. Set the CommandType property of the cmd object to CommandType.TableDirect.
C. Set the CommandType property of the cmd object to CommandType.StoredProcedure.
D. Replace the ExecuteNonQuery method of the cmd object with the ExecuteScalar method.
Answer: C

Microsoft   70-565   70-565 dumps

NO.8 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application will be used on personal computers and mobile-based devices.
The current application design is composed of the following three layers:
User interface layer
Business layer
Data access layer
You need to ensure that the application offers a custom experience to the end user based on the type of
device used. You also need to ensure that code duplication is avoided.
What should you do?
A. Implement different business layers for mobile-based devices and personal computers. Implement a
single service layer to expose the business layer to the user interface.
B. Implement different data access layers for mobile-based devices and personal computers. Implement a
single business layer to expose business objects to the user interface.
C. Implement different user interface layers for mobile-based devices and personal computers. Implement
a single user interface process layer to expose business objects to the user interface.
D. Implement different user interface process layers for mobile-based devices and personal computers.
Implement a single user interface to expose data by using rules from the user interface process layer.
Answer: C

Microsoft certification training   70-565 certification   70-565   70-565

NO.9 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes a component. The component will be referenced by the .NET and COM
applications.
The component contains the following code segment.
public class Employee
{
public Employee(string name)
{
}
}
The .NET and COM applications must perform the following tasks:
Create objects of the Employee type.
use these objects to access the employee details.
You need to ensure that the .NET and COM applications can consume the managed component.
What should you do?
A. Change the Employee class to a generic class.
B. Change the constructor to a no-argument constructor.
C. Set the access modifier of the class to internal.
D. Set the access modifier of the constructor to protected.
Answer: B

Microsoft   70-565   70-565 original questions   70-565 exam simulations   70-565 braindump

NO.10 Rate your level of proficiency in designing application components, including creating the high-level
design of a component, defining the internal architecture of a component, and defining the data handling
for a component.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft dumps   70-565   70-565 questions

NO.11 You create applications by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
You deploy a new Windows Forms application in a test environment. During the test process, an error
message that includes an incomplete stack trace is reported.
You review the following code segment that has caused the error.
public int AddNewMission(DateTime date, string mission, string missionLink)
{
try
{
DALCode pgr = new DALCode("cnWeb");
int retcode = pgr.AddNewMission(date, mission, missionLink);
return retcode;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
pgr.Dispose();
}
}
You need to modify the code segment to display the entire stack trace.
What should you do?
A. Remove the CATCH block.
B. Remove the FINALLY block.
C. Add a Using block to the TRY block.
D. Replace the THROW statement in the CATCH block with throw(ex).
Answer: A

Microsoft   70-565   70-565 braindump

NO.12 How many years of experience do you have in developing enterprise applications by using the
Microsoft .NET Framework 3.5?
A. I have not done this yet.
B. Less than 6 months
C. 6 months- 1 year
D. 1- 2 years
E. 2- 3 years
F. More than 3 years
Answer: A

Microsoft original questions   70-565   70-565   70-565   70-565

NO.13 You create applications by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
You deploy a new Windows Forms application in a test environment. During the test process, an error
message that includes an incomplete stack trace is reported.
You review the following code segment that has caused the error.
Public Function AddNewMission(ByVal missiondate As DateTime, _
ByVal mission As String, ByVal missionLink As String) As Integer
Dim pgr As DALCode = New DALCode("cnWeb")
Try
Dim retcode As Int16 = _
pgr.AddNewMission(missiondate, mission, missionLink)
Return retcode
Catch ex As Exception
Throw New Exception(ex.Message.ToString())
Finally
pgr.Dispose()
End Try
End Function
You need to modify the code segment to display the entire stack trace.
What should you do?
A. Remove the CATCH block.
B. Remove the FINALLY block.
C. Add a Using block to the TRY block.
D. Replace the THROW statement in the CATCH block with Throw (ex).
Answer: A

Microsoft exam   70-565   70-565 pdf   70-565   70-565 dumps

NO.14 You create an ASP.NET application by using Microsoft Visual Studio .NET 2008 and the .NET
Framework 3.5.
The application uses the Session object to store data. The application is currently deployed to a single
server.
You need to ensure that the application is available in the event of failure of any single server.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Host the application in a Web farm environment.
B. Host the application in a Web garden environment.
C. Use the SQLServer mode to store the session state.
D. Use the StateServer mode to store the session state.
E. Use the Application object instead of the Session object to cache data.
Answer: AC

Microsoft   70-565   70-565 exam prep   70-565

NO.15 You create a Windows Forms application by using Microsoft Visual Studio .NET 2008 and the .NET
Framework 3.5.
The application contains the following code segment.
Public Function GetProductByID(ByVal ProductID As String) As DataSet
Dim ds As DataSet = New DataSet("ProductList")
Dim SqlSelectCommand As String = "Select * FROM PRODUCTS WHERE
PRODUCTID=" + ProductID
Try
Dim da As SqlDataAdapter = New SqlDataAdapter()
Dim cn As SqlConnection = New
SqlConnection(GetConnectionString())
Dim cmd As SqlCommand = New SqlCommand(SqlSelectCommand)
cmd.CommandType = CommandType.Text
cn.Open()
da.Fill(ds)
cn.Close()
Catch ex As Exception
Dim msg As String = ex.Message.ToString()
'Perform Exception Handling Here
End Try
Return ds
End Function
You need to ensure that the code segment is as secure as possible.
What should you do?
A. Ensure that the connection string is encrypted.
B. Use a StringBuilder class to construct the SqlSelectCommand string.
C. Add a parameter to the cmd object and populate the object by using the ProductID string.
D. Replace the SELECT * statement in the SqlSelectCommand string with the SELECT <column list>
statement.
Answer: C

Microsoft braindump   70-565   70-565 practice test   70-565 test questions   70-565

NO.16 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes multiple components. The components communicate by passing messages to
each other. You are planning to update the application to meet new business requirements.
You need to document the application logic. You also need to ensure that the documentation captures the
details of the component interaction.
What should you do?
A. Use a class diagram.
B. Use a Use case diagram.
C. Use a sequence diagram.
D. Use a component diagram.
Answer: C

Microsoft   70-565 certification training   70-565   70-565 exam prep   70-565 exam prep

NO.17 You create a Windows Forms application by using Microsoft Visual Studio .NET 2008 and the .NET
Framework 3.5.
The application contains the following code segment.
public DataSet GetProductByID(string ProductID)
{
DataSet ds = new DataSet("ProductList");
string SqlSelectCommand = "Select * FROM PRODUCTS WHERE
PRODUCTID=" + ProductID;
try
{
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection cn = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand(SqlSelectCommand);
cmd.CommandType = CommandType.Text;
cn.Open();
da.Fill(ds);
cn.Close();
}
catch (Exception ex)
{
string msg = ex.Message.ToString();
//Perform Exception Handling Here
}
return ds;
}
You need to ensure that the code segment is as secure as possible.
What should you do?
A. Ensure that the connection string is encrypted.
B. Use a StringBuilder class to construct the SqlSelectCommand string.
C. Add a parameter to the cmd object and populate the object by using the ProductID string.
D. Replace the SELECT * statement in the SqlSelectCommand string with the SELECT <column list>
statement.
Answer: C

Microsoft answers real questions   70-565 test questions   70-565   70-565 exam dumps   70-565   70-565 exam

NO.18 How many years of experience do you have in developing enterprise applications by using any version
of the Microsoft .NET Framework?
A. I have not done this yet.
B. Less than 6 months
C. 6 months- 1 year
D. 1- 2 years
E. 2- 3 years
F. More than 3 years
Answer: A

Microsoft certification   70-565   70-565

NO.19 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The ASP.NET application connects to a shared Microsoft SQL Server 2008 database instance.
The application requires certain changes in the relationships represented in the data. However, any
changes to the database schema can break existing applications that share the database instance.
You need to recommend a strategy that allows the application to make the required relationship changes
without affecting the underlying database schema. You also need to ensure that the strategy uses the
minimum amount of development effort.
Which strategy should you recommend?
A. Generate a model by using LINQ to SQL. Make the relationship changes to the model.
B. Generate an ADO.NET Entity Framework model. Make the relationship changes in the model.
C. Add an HTTP endpoint to SQL Server 2008 database to retrieve the data from the database in tabular
format.
D. Create a DataSet object and add a DataTable object for each table in the database. Create a
DataRelation object for each relationship required for the application.
Answer: B

Microsoft test questions   70-565 exam prep   70-565 pdf   70-565 answers real questions   70-565   70-565

NO.20 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application design specifies the following components:
A user interface implemented as an ASP.NET 3.5 Web application
A Microsoft SQL Server 2005 database to store business data
A Windows Communication Foundation (WCF) service that authenticates users that have their
credentials stored in the SQL Server database
A business data service to transfer data between the user interface and the SQL Server database
In future releases, the application must also be able to authenticate business partners who use
non-Microsoft directory servers to store user credentials.
You need to ensure that the application design meets the extensibility requirements.
What should you do?
A. Implement the business data service as a WCF service.
B. Host the Web application on multiple load-balanced Web servers.
C. Add an abstraction layer between the user interface and the authentication service.
D. Implement database objects that store the corporate user credentials in the same SQL Server
database as the business data.
Answer: C

Microsoft   70-565   70-565   70-565   70-565 answers real questions

NO.21 Which of the following technologies do you use regularly? Choose all that apply.
A. Microsoft ASP.NET
B. Windows Forms
C. Windows Presentation Foundation (WPF)
D. Microsoft ADO.NET
E. Windows Communication Foundation (WCF)
F. Distributed technologies in .NET 3.5
Answer: A

Microsoft answers real questions   70-565   70-565 test answers   70-565

NO.22 Rate your level of proficiency in designing and developing an application framework, including
choosing an appropriate implementation approach for the application design logic, defining the interaction
between framework components, and defining validation and event logging strategies.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft certification   70-565   70-565   70-565   70-565

NO.23 }

NO.24 Rate your level of proficiency in stabilizing and testing an application, including defining a functional test
strategy, performing integration testing, and performing a code review.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft exam dumps   70-565   70-565   70-565 practice test   70-565 exam dumps

NO.25 Rate your level of proficiency in migrating, deploying, and maintaining an application, including creating
a deployment plan, and analyzing the configuration of the production environment, performance
monitoring data, and logs.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft certification training   70-565   70-565   70-565 braindump   70-565

NO.26 Rate your level of proficiency in envisioning and designing an application, including analyzing and
refining the logical, physical, and database designs of the application.
A. I am considered an expert on this. I have successfully done this multiple times without assistance or
error. I train or supervise others on this activity. Others come to me when they have questions or need
assistance with this.
B. I have successfully done this without assistance and with few errors, but I do not train or supervise
others on this activity.
C. I am proficient at this. I have successfully done this on my own, but I occasionally require assistance
for some types of problems encountered when doing this and/or occasionally make minor errors.
D. I have successfully done this with the assistance of others or specific instructions.
E. I am a novice. I have not yet done this or am learning.
Answer: A

Microsoft   70-565   70-565 dumps   70-565 test answers   70-565 certification

NO.27 You create a Windows Communication Foundation (WCF) application by using Microsoft Visual Studio
2008 and the .NET Framework 3.5.
You create a WCF service by using the following code segment. (Line numbers are included for reference
only.)
01 [ServiceContract]
02 public interface IContosoService
03 {
04 [OperationContract]
05
06 void ProcessTransaction();
07 }
08
09 public class ContosoService : IContosoService
10 {
11 public void ProcessTransaction() {
12 try {
13 BusinessComponent.ProcessTransaction();
14 }
15 catch (ApplicationException appEx) {
16
17 }

NO.28 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application has a class that contains a method named NewEvent. The NewEvent method contains
the following code segment.
Using cn As SqlConnection = New SqlConnection(connString)
Dim cmd As SqlCommand = New SqlCommand()
cmd.Connection = cn
cmd.CommandText = "prcEvent"
cmd.Parameters.Add("@Date", SqlDbType.DateTime, 4)
cmd.Parameters.Add("@Desc", SqlDbType.VarChar, 8000)
cmd.Parameters.Add("@Link", SqlDbType.VarChar, 2048)
cmd.Parameters("@Date").Value = dateValue
cmd.Parameters("@Desc").Value = eventText
cmd.Parameters("@Link").Value = eventLink
cn.Open()
retcode = cmd.ExecuteNonQuery()
End Using
During the test process, a user executes the NewEvent method. The method fails and returns the
following error message:
"A stored procedure named prcEvent requires a parameter named @Date."
You need to resolve the error.
What should you do?
A. Set the CommandText property of the cmd object to dbo.prcEvent.
B. Set the CommandType property of the cmd object to CommandType.TableDirect.
C. Set the CommandType property of the cmd object to CommandType.StoredProcedure.
D. Replace the ExecuteNonQuery method of the cmd object with the ExecuteScalar method.
Answer: C

Microsoft   70-565 answers real questions   70-565 test answers   70-565

NO.29 You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
The application includes multiple components. The components communicate by passing messages to
each other. You are planning to update the application to meet new business requirements.
You need to document the application logic. You also need to ensure that the documentation captures the
details of the component interaction.
What should you do?
A. Use a class diagram.
B. Use a Use case diagram.
C. Use a sequence diagram.
D. Use a component diagram.
Answer: C

Microsoft   70-565 answers real questions   70-565   70-565   70-565   70-565

IT-Tests.com offer the latest JN0-533 Questions & Answers and high-quality 850-001 PDF Practice Test. Our 200-120 VCE testing engine and 00M-654 study guide can help you pass the real exam. High-quality 646-365 Real Exam Questions can 100% guarantee you pass the exam faster and easier. Pass the exam to obtain certification is so simple.

Article Link: http://www.it-tests.com/70-565.html

2013年7月27日星期六

Best Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 test training guide

IT-Tests.com Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 exam questions and answers provide you test preparation information with everything you need. About Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 exam, you can find these questions from different web sites or books, but the key is logical and connected. Our questions and answers will not only allow you effortlessly through the exam first time, but also can save your valuable time.


Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 is a certification exam to test IT expertise and skills. If you find a job in the IT industry, many human resource managers in the interview will reference what Microsoft related certification you have. If you have Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 certification, apparently, it can improve your competitiveness.


Everyone has a utopian dream in own heart. Dreams of imaginary make people feel disheartened. In fact, as long as you take the right approach, everything is possible. You can pass the Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 exam easily. Why? Because you have IT-Tests.com's Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 exam training materials. IT-Tests.com's Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 exam training materials are the best training materials for IT certification. It is famous for the most comprehensive and updated by the highest rate. It also can save time and effort. With it, you will pass the exam easily. If you pass the exam, you will have the self-confidence, with the confidence you will succeed.


Exam Code: 70-685

Exam Name: Microsoft (Pro: Windows 7, Enterprise Desktop Support Technician)

Exam Code: 70-658

Exam Name: Microsoft (TS: System Center Data Protection Manager 2007, Configuring (English))

Exam Code: 70-686

Exam Name: Microsoft (Pro: Windows 7, Enterprise Desktop Administrator)

Exam Code: MB7-840

Exam Name: Microsoft (NAV 2009 C/SIDE Introduction)

Exam Code: 70-565

Exam Name: Microsoft (Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5)

Exam Code: 70-561

Exam Name: Microsoft (TS: MS .NET Framework 3.5, ADO.NET Application Development)

IT-Tests.com is a website that provide the counseling courses for IT professionals to participate in Microsoft certification 70-685 70-658 70-686 MB7-840 70-565 70-561 exam and help them get the Microsoft 70-685 70-658 70-686 MB7-840 70-565 70-561 certification. The courses of IT-Tests.com is developed by experienced experts' extensive experience and expertise and the quality is very good and have a very fast update rate. Besides, exercises we provide are very close to the real exam questions, almost the same. When you select IT-Tests, you are sure to 100% pass your first time to participate in the difficult and critical Microsoft certification 70-685 70-658 70-686 MB7-840 70-565 70-561 exam.


70-561 (TS: MS .NET Framework 3.5, ADO.NET Application Development) Free Demo Download: http://www.it-tests.com/70-561.html


NO.1 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

Microsoft   70-561 pdf   70-561   70-561

NO.2 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a SqlDataAdapter object named daOrder. The SelectCommand property of the
daOrder object is set.
You write the following code segment. (Line numbers are included for reference only.)
01 private void ModifyDataAdapter() {
02
03 }
You need to ensure that the daOrder object can also handle updates.
Which code segment should you insert at line 02?
A. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.RefreshSchema();
B. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.SetAllValues = true;
C. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
daOrder.DeleteCommand = cb.GetDeleteCommand();
daOrder.InsertCommand = cb.GetInsertCommand();
daOrder.UpdateCommand = cb.GetUpdateCommand();
D. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.RefreshSchema();
cb.GetDeleteCommand();
cb.GetInsertCommand();
cb.GetUpdateCommand();
Answer: C

Microsoft questions   70-561 test questions   70-561 exam   70-561 questions   70-561

NO.3 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 connection string of the application is defined in the following manner.
"Server=Prod;Database=WingtipToys;Integrated
Security=SSPI;Asynchronous Processing=true"
The application contains the following code segment. (Line numbers are included for reference only.)
01 Protected Sub UpdateData(ByVal cmd As SqlCommand)
02 cmd.Connection.Open()
03
04 lblResult.Text = "Updating ..."
05 End Sub
The cmd object takes a long time to execute.
You need to ensure that the application continues to execute while cmd is executing.
What should you do?
A. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(New AsyncCallback( _
AddressOf UpdateComplete), cmd)
Add the following code segment.
Private Sub UpdateComplete (ByVal ar As IAsyncResult)
Dim count As Integer = CInt(ar.AsyncState)
LogResults(count)
End Sub
B. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(New AsyncCallback( _
AddressOf UpdateComplete), cmd)
Add the following code segment.
Private Sub UpdateComplete(ByVal ar As IAsyncResult)
Dim cmd As SqlCommand = DirectCast(ar.AsyncState, SqlCommand)
Dim count As Integer = cmd.EndExecuteNonQuery(ar)
LogResults(count)
End Sub
C. Insert the following code segment at line 03.
AddHandler cmd.StatementCompleted, AddressOf UpdateComplete
cmd.ExecuteNonQuery()
Add the following code segment.
Private Sub UpdateComplete(ByVal sender As Object, _
ByVal e As StatementCompletedEventArgs)
Dim count As Integer = e.RecordCount
LogResults(count)
End Sub
D. Insert the following code segment at line 03.
Dim notification As New _
SqlNotificationRequest("UpdateComplete ", "", 10000)
cmd.Notification = notification
cmd.ExecuteNonQuery()
Add the following code segment.
Private Sub UpdateComplete (ByVal notice As SqlNotificationRequest)
Dim count As Integer = Integer.Parse(notice.UserData)
LogResults(count)
End Sub
Answer: B

Microsoft certification   70-561 certification   70-561 answers real questions

NO.4 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

Microsoft   70-561 questions   70-561 exam dumps

NO.5 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 ex As System.Security.SecurityException
'Handle all database security related exceptions.
End Try
B. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).[Class].ToString() = "14" Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
C. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).Number = 14 Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
D. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).Message.Contains("Security") Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
Answer: B

Microsoft certification training   70-561   70-561   70-561 questions

NO.6 {

NO.7 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 write the following code segment.
Dim query As String = _ "Select EmpNo, EmpName from dbo.Table_1; " + _ "select Name,Age from
dbo.Table_2"
Dim command As New SqlCommand(query, connection)
Dim reader As SqlDataReader = command.ExecuteReader()
You need to ensure that the application reads all the rows returned by the code segment.
Which code segment should you use?
A. While reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
reader.Read()
End While
B. While reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
reader.NextResult()
End While
C. While reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
reader.NextResult()
while reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
D. While reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
reader.Read()
while reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
Answer: C

Microsoft questions   70-561 braindump   70-561 test questions   70-561

NO.8 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 analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 Using connection As New SqlConnection(sourceConnectionString)
02 Using connection2 As _
New SqlConnection(destinationConnectionString)
03 Using command As New SqlCommand()
04 connection.Open()
05 connection2.Open()
06 Using reader As SqlDataReader = command.ExecuteReader()
07 Using bulkCopy As New SqlBulkCopy(connection2)
08
09 End Using
10 End Using
11 End Using
12 End Using
13 End Using
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 08?
A. reader.Read()
bulkCopy.WriteToServer(reader)
B. bulkCopy.DestinationTableName = "Transactions"
bulkCopy.WriteToServer(reader)
C. bulkCopy.DestinationTableName = "Transactions"
AddHandler bulkCopy.SqlRowsCopied, _
AddressOf bulkCopy_SqlRowsCopied
D. While reader.Read()
bulkCopy.WriteToServer(reader)
End While
Answer: B

Microsoft   70-561 certification training   70-561 practice test   70-561 demo   70-561

NO.9 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application has a DataTable object named OrderDetailTable. The object has the following columns:
ID
OrderID
ProductID
Quantity
LineTotal
The OrderDetailTable object is populated with data provided by a business partner. Some of the records
contain a null value in the LineTotal field and 0 in the Quantity field.
You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn col = new DataColumn("UnitPrice", typeof(decimal));
02
03 OrderDetailTable.Columns.Add(col);
You need to add a DataColumn named UnitPrice to the OrderDetailTable object.
Which line of code should you insert at line 02?
A. col.Expression = "LineTotal/Quantity";
B. col.Expression = "LineTotal/ISNULL(Quantity, 1)";
C. col.Expression = "LineTotal.Value/ISNULL(Quantity.Value,1)";
D. col.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";
Answer: D

Microsoft exam prep   70-561 certification training   70-561 exam simulations   70-561 questions

NO.10 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a SqlDataAdapter object named daOrder. The SelectCommand property of the
daOrder object is set.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub ModifyDataAdapter()
02
03 End Sub
You need to ensure that the daOrder object can also handle updates.
Which code segment should you insert at line 02?
A. Dim cb As New SqlCommandBuilder(daOrder)
cb.RefreshSchema()
B. Dim cb As New SqlCommandBuilder(daOrder)
cb.SetAllValues = True
C. Dim cb As New SqlCommandBuilder(daOrder)
daOrder.DeleteCommand = cb.GetDeleteCommand()
daOrder.InsertCommand = cb.GetInsertCommand()
daOrder.UpdateCommand = cb.GetUpdateCommand()
D. Dim cb As New SqlCommandBuilder(daOrder)
cb.RefreshSchema()
cb.GetDeleteCommand()
cb.GetInsertCommand()
cb.GetUpdateCommand()
Answer: C

Microsoft practice test   70-561 exam dumps   70-561   70-561

NO.11 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named orderDS. The object contains a table named Order as
shown in the following exhibit.
The application uses a SqlDataAdapter object named daOrder to populate the Order table.
You write the following code segment. (Line numbers are included for reference only.)
01 private void FillOrderTable(int pageIndex) {
02 int pageSize = 5;
03
04 }
You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value.
Which code segment should you insert at line 03?
A. string sql = "SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader";
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, pageIndex, pageSize, "Order");
B. int startRecord = (pageIndex - 1) * pageSize;
string sql = "SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader";
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, startRecord, pageSize, "Order");
C. string sql = string.Format("SELECT TOP {0} SalesOrderID, CustomerID,
OrderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}", pageSize, pageIndex);
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, "Order");
D. int startRecord = (pageIndex - 1) * pageSize;
string sql = string.Format("SELECT TOP {0} SalesOrderID, CustomerID,
OrderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}",
pageSize, startRecord);
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, "Order");
Answer: B

Microsoft test answers   70-561   70-561 demo   70-561 questions

NO.12 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

Microsoft questions   70-561 exam simulations   70-561 exam   70-561 answers real questions

NO.13 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 write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
SqlConnection(connectionString)) {
02 SqlCommand cmd = new SqlCommand(queryString, connection);
03 connection.Open();
04
05 while (sdrdr.Read()){
06 // use the data in the reader
07 }
08 }
You need to ensure that the memory is used efficiently when retrieving BLOBs from the database.
Which code segment should you insert at line 04?
A. SqlDataReader sdrdr = cmd.ExecuteReader();
B. SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.Default);
C. SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
D. SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
Answer: D

Microsoft   70-561 certification   70-561 exam dumps   70-561 exam dumps   70-561 certification training

NO.14 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(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

Microsoft exam dumps   70-561   70-561   70-561

NO.15 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 write the following code segment.
string query = "Select EmpNo, EmpName from dbo.Table_1;
select Name,Age from dbo.Table_2";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
You need to ensure that the application reads all the rows returned by the code segment.
Which code segment should you use?
A. while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.Read();
}
B. while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.NextResult();
}
C. while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.NextResult();
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
D. while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.Read();
while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
Answer: C

Microsoft   70-561 test questions   70-561 original questions

NO.16 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a TextBox control named txtProductID. The application will return a list of active
products that have the ProductID field equal to the txtProductID.Text property.
You write the following code segment. (Line numbers are included for reference only.)
01 private DataSet GetProducts(SqlConnection cn) {
02 SqlCommand cmd = new SqlCommand();
03 cmd.Connection = cn;
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05 DataSet ds = new DataSet();
06
07 da.Fill(ds);
08 return ds;
09 }
You need to populate the DataSet object with product records while avoiding possible SQL injection
attacks.
Which code segment should you insert at line 06?
A. cmd.CommandText = string.Format("sp_sqlexec 'SELECT ProductID,
Name FROM Product WHERE ProductID={0} AND IsActive=1'", txtProductID.Text);
B. cmd.CommandText = string.Format("SELECT ProductID, Name FROM
Product WHERE ProductID={0} AND IsActive=1", txtProductID.Text);
cmd.Prepare();
C. cmd.CommandText = string.Format("SELECT ProductID, Name FROM
Product WHERE ProductID={0} AND IsActive=1", txtProductID.Text);
cmd.CommandType = CommandType.TableDirect;
D. cmd.CommandText = "SELECT ProductID, Name FROM Product WHERE
ProductID=@productID AND IsActive=1";
cmd.Parameters.AddWithValue("@productID", txtProductID.Text);
Answer: D

Microsoft   70-561 exam dumps   70-561   70-561

NO.17 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 write the following code segment.
string queryString = "Select Name, Age from dbo.Table_1";
SqlCommand command = new SqlCommand(queryString, (SqlConnection)connection));
You need to get the value that is contained in the first column of the first row of the result set returned by
the query.
Which code segment should you use?
A. var value = command.ExecuteScalar();
string requiredValue = value.ToString();
B. var value = command.ExecuteNonQuery();
string requiredValue = value.ToString();
C. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[0].ToString();
D. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[1].ToString();
Answer: A

Microsoft   70-561 certification training   70-561 questions

NO.18 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 analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
SqlConnection(sourceConnectionString))
02 using (SqlConnection connection2 = new
SqlConnection(destinationConnectionString))
03 using (SqlCommand command = new SqlCommand())
04 {
05 connection.Open();
06 connection2.Open();
07 using (SqlDataReader reader = command.ExecuteReader())
08 {
09 using (SqlBulkCopy bulkCopy = new
SqlBulkCopy(connection2))
10 {
11
12 }
13 }
14 }
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 11?
A. reader.Read()
bulkCopy.WriteToServer(reader);
B. bulkCopy.DestinationTableName = "Transactions";
bulkCopy.WriteToServer(reader);
C. bulkCopy.DestinationTableName = "Transactions";
bulkCopy.SqlRowsCopied += new
SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
D. while (reader.Read())
{
bulkCopy.WriteToServer(reader);
}
Answer: B

Microsoft   70-561   70-561 certification training   70-561

NO.19 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application has a DataTable object named OrderDetailTable. The object has the following columns:
ID
OrderID
ProductID
Quantity
LineTotal
The OrderDetailTable object is populated with data provided by a business partner. Some of the records
contain a null value in the LineTotal field and 0 in the Quantity field.
You write the following code segment. (Line numbers are included for reference only.)
01 Dim col As New DataColumn("UnitPrice", GetType(Decimal))
02
03 OrderDetailTable.Columns.Add(col)
You need to add a DataColumn named UnitPrice to the OrderDetailTable object.
Which line of code should you insert at line 02?
A. col.Expression = "LineTotal/Quantity"
B. col.Expression = "LineTotal/ISNULL(Quantity, 1)"
C. col.Expression = "LineTotal.Value/ISNULL(Quantity.Value, 1)"
D. col.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)"
Answer: D

Microsoft   70-561   70-561   70-561   70-561 test

NO.20 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a TextBox control named txtProductID. The application will return a list of active
products that have the ProductID field equal to the txtProductID.Text property.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Function GetProducts(ByVal cn _
As SqlConnection) As DataSet
02 Dim cmd As New SqlCommand()
03 cmd.Connection = cn
04 Dim da As New SqlDataAdapter(cmd)
05 Dim ds As New DataSet()
06
07 da.Fill(ds)
08 Return ds
09 End Function
You need to populate the DataSet object with product records while avoiding possible SQL injection
attacks.
Which code segment should you insert at line 06?
A. cmd.CommandText = _
String.Format("sp_sqlexec 'SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1'", _
txtProductID.Text)
B. cmd.CommandText = _
String.Format("SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1", _
txtProductID.Text)
cmd.Prepare()
C. cmd.CommandText = _
String.Format("SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1", _
txtProductID.Text)
cmd.CommandType = CommandType.TableDirect
D. cmd.CommandText = "SELECT ProductID, " + _
"Name FROM Product WHERE ProductID=@productID AND IsActive=1"
cmd.Parameters.AddWithValue("@productID", txtProductID.Text)
Answer: D

Microsoft original questions   70-561 questions   70-561   70-561   70-561 exam prep   70-561

NO.21 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

Microsoft   70-561   70-561   70-561 exam   70-561

NO.22 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as
shown in the following exhibit.
You write the following code segment. (Line numbers are included for reference only.)
01 private void GetOrders(SqlDataConnection cn) {
02 SqlCommand cmd = cn.CreateCommand();
03 cmd.CommandText = "Select * from [Order];
Select * from [OrderDetail];";
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05
06 }
You need to ensure that the Order and the OrderDetail tables are populated.
Which code segment should you insert at line 05?
A. da.Fill(OrderDS);
B. da.Fill(OrderDS.Order);
da.Fill(OrderDS.OrderDetail);
C. da.TableMappings.AddRange(new DataTableMapping[] {
new DataTableMapping("Table", "Order"),
new DataTableMapping("Table1", "OrderDetail")});
da.Fill(OrderDS);
D. DataTableMapping mapOrder = new DataTableMapping();
mapOrder.DataSetTable = "Order";
DataTableMapping mapOrderDetail = new DataTableMapping();
mapOrder.DataSetTable = "OrderDetail";
da.TableMappings.AddRange(new DataTableMapping[]
{ mapOrder, mapOrderDetail });
Da.Fill(OrderDS);
Answer: C

Microsoft   70-561 exam dumps   70-561   70-561   70-561 demo   70-561 answers real questions

NO.23 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named orderDS. The object contains a table named Order as
shown in the following exhibit.
The application uses a SqlDataAdapter object named daOrder to populate the Order table.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub FillOrderTable(ByVal pageIndex As Integer)
02 Dim pageSize As Integer = 5
03
04 End Sub
You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value.
Which code segment should you insert at line 03?
A. Dim sql As String = "SELECT SalesOrderID, CustomerID, " + _
"OrderDate FROM Sales.SalesOrderHeader"
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, pageIndex, pageSize, "Order")
B. Dim startRecord As Integer = (pageIndex - 1) * pageSize
Dim sql As String = "SELECT SalesOrderID, CustomerID, " + _
"OrderDate FROM Sales.SalesOrderHeader"
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, startRecord, pageSize, "Order")
C. Dim sql As String = _
String.Format("SELECT TOP {0} SalesOrderID, " + _
"CustomerID, OrderDate FROM Sales.SalesOrderHeader " + _
"WHERE SalesOrderID > {1}", pageSize, pageIndex)
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, "Order")
D. Dim startRecord As Integer = (pageIndex - 1) * pageSize
Dim sql As String = _
String.Format("SELECT TOP {0} SalesOrderID, " + _
"CustomerID, OrderDate FROM Sales.SalesOrderHeader " + _
"WHERE SalesOrderID > {1}", pageSize, startRecord)
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, "Order")
Answer: B

Microsoft test   70-561   70-561   70-561 practice test   70-561 dumps   70-561 exam dumps

NO.24 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as
shown in the following exhibit.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub GetOrders(ByVal cn As SqlConnection)
02 Dim cmd As SqlCommand = cn.CreateCommand()
03 cmd.CommandText = "Select * from [Order]; " + _
"Select * from [OrderDetail];"
04 Dim da As New SqlDataAdapter(cmd)
05
06 End Sub
You need to ensure that the Order and the OrderDetail tables are populated.
Which code segment should you insert at line 05?
A. da.Fill(OrderDS)
B. da.Fill(OrderDS.Order)
da.Fill(OrderDS.OrderDetail)
C. da.TableMappings.AddRange(New DataTableMapping() _
{New DataTableMapping("Table", "Order"), _
New DataTableMapping("Table1", "OrderDetail")})
da.Fill(OrderDS)
D. Dim mapOrder As New DataTableMapping()
mapOrder.DataSetTable = "Order"
Dim mapOrderDetail As New DataTableMapping()
mapOrder.DataSetTable = "OrderDetail"
da.TableMappings.AddRange(New DataTableMapping() _
{mapOrder, mapOrderDetail})
da.Fill(OrderDS)
Answer: C

Microsoft   70-561   70-561 certification training   70-561   70-561 study guide   70-561

NO.25 }
You need to compute the total number of records processed by the Select queries in the RecordCount
variable.
Which code segment should you insert at line 16?
A. myReader = myCommand.ExecuteReader();
RecordCount = myReader.RecordsAffected;
B. while (myReader.Read())
{
//Write logic to process data for the first result.
}
RecordCount = myReader.RecordsAffected;
C. while (myReader.HasRows)
{
while (myReader.Read())
{
//Write logic to process data for the second result.
RecordCount = RecordCount + 1;
myReader.NextResult();
}
}
D. while (myReader.HasRows)
{
while (myReader.Read())
{
//Write logic to process data for the second result.
RecordCount = RecordCount + 1;
}
myReader.NextResult();
}
Answer: D

Microsoft exam   70-561   70-561 answers real questions
22. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application uses Microsoft SQL Server 2005.
You write the following code segment. (Line numbers are included for reference only.)
01 Dim myConnString As String = _
02 "User ID=<username>;password=<strong password>;" + _
03 "Initial Catalog=pubs;Data Source=myServer"
04 Dim myConnection As New SqlConnection(myConnString)
05 Dim myCommand As New SqlCommand()
06 Dim myReader As DbDataReader
07 myCommand.CommandType = CommandType.Text
08 myCommand.Connection = myConnection
09 myCommand.CommandText = _
10 "Select * from Table1;Select * from Table2;"
11 Dim RecordCount As Integer = 0
12 Try
13 myConnection.Open()
14
15 Catch ex As Exception
16 Finally
17 myConnection.Close()
18 End Try
You need to compute the total number of records processed by the Select queries in the RecordCount
variable.
Which code segment should you insert at line 14?
A. myReader = myCommand.ExecuteReader()
RecordCount = myReader.RecordsAffected
B. While myReader.Read()
'Write logic to process data for the first result.
End While
RecordCount = myReader.RecordsAffected
C. While myReader.HasRows
While myReader.Read()
'Write logic to process data for the second result.
RecordCount = RecordCount + 1
myReader.NextResult()
End While
End While
D. While myReader.HasRows
While myReader.Read()
'Write logic to process data for the second result.
RecordCount = RecordCount + 1
End While
myReader.NextResult()
End While
Answer: D

Microsoft   70-561   70-561 test questions
23. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application uses data from a Microsoft SQL Server 2005 database table. A Web page of the
application contains a GridView server control.
You write the following code segment. (Line numbers are included for reference only.)
01 private void LoadGrid()
02 {
03 using (SqlCommand command = new SqlCommand())
04 {
05 command.Connection = connection;
06 command.CommandText = "SELECT * FROM Customers";
07 connection.Open();
08
09 }
10 }
You need to retrieve the data from the database table and bind the data to the DataSource property of the
GridView server control.
Which code segment should you insert at line 08?
A. SqlDataReader rdr = command.ExecuteReader();
connection.Close();
GridView1.DataSource = rdr;
GridView1.DataBind();
B. SqlDataReader rdr = command.ExecuteReader();
GridView1.DataSource = rdr.Read();
GridView1.DataBind();
connection.Close();
C. SqlDataReader rdr = command.ExecuteReader();
Object[] values = new Object[rdr.FieldCount];
GridView1.DataSource = rdr.GetValues(values);
GridView1.DataBind();
connection.Close();
D. DataTable dt = new DataTable();
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
connection.Close();
GridView1.DataSource = dt;
GridView1.DataBind();
Answer: D

Microsoft   70-561 exam simulations   70-561
24. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application uses data from a Microsoft SQL Server 2005 database table. A Web page of the
application contains a GridView server control.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub LoadGrid()
02 Using command As New SqlCommand()
03 command.Connection = connection
04 command.CommandText = "SELECT * FROM Customers"
05 connection.Open()
06
07 End Using
08 End Sub
You need to retrieve the data from the database table and bind the data to the DataSource property of the
GridView server control.
Which code segment should you insert at line 06?
A. Dim rdr As SqlDataReader = command.ExecuteReader()
connection.Close()
GridView1.DataSource = rdr
GridView1.DataBind()
B. Dim rdr As SqlDataReader = command.ExecuteReader()
GridView1.DataSource = rdr.Read()
GridView1.DataBind()
connection.Close()
C. Dim rdr As SqlDataReader = command.ExecuteReader()
Dim values As Object() = New Object(rdr.FieldCount - 1) {}
GridView1.DataSource = rdr.GetValues(values)
GridView1.DataBind()
D. Dim dt As New DataTable()
Using reader As SqlDataReader = command.ExecuteReader()
dt.Load(reader)
End Using
connection.Close()
GridView1.DataSource = dt
GridView1.DataBind()
Answer: D

Microsoft   70-561 test answers   70-561 test questions   70-561 exam

NO.26 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application uses Microsoft SQL Server 2005.
You write the following code segment. (Line numbers are included for reference only.)
01 String myConnString = "User
02 ID=<username>;password=<strong password>;Initial
03 Catalog=pubs;Data Source=myServer";
04 SqlConnection myConnection = new
05 SqlConnection(myConnString);
06 SqlCommand myCommand = new SqlCommand();
07 DbDataReader myReader;
08 myCommand.CommandType =
09 CommandType.Text;
10 myCommand.Connection = myConnection;
11 myCommand.CommandText = "Select * from Table1;
Select * from Table2;";
12 int RecordCount = 0;
13 try
14 {
15 myConnection.Open();
16
17 }
18 catch (Exception ex)
19 {
20 }
21 finally

NO.27 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 write the following code segment.
Dim queryString As String = "Select Name, Age from dbo.Table_1"
Dim command As New _SqlCommand(queryString, DirectCast(connection, SqlConnection))
You need to get the value that is contained in the first column of the first row of the result set returned by
the query.
Which code segment should you use?
A. Dim value As Object = command.ExecuteScalar()
Dim requiredValue As String = value.ToString()
B. Dim value As Integer = command.ExecuteNonQuery()
Dim requiredValue As String = value.ToString()
C. Dim value As SqlDataReader = _command.ExecuteReader(CommandBehavior.SingleRow)
Dim requiredValue As String = value(0).ToString()
D. Dim value As SqlDataReader = _command.ExecuteReader(CommandBehavior.SingleRow)
Dim requiredValue As String = value(1).ToString()
Answer: A

Microsoft certification   70-561 dumps   70-561 exam dumps   70-561 certification training   70-561 practice test   70-561

NO.28 myConnection.Close();

NO.29 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 connection string of the application is defined in the following manner.
"Server=Prod;Database=WingtipToys;Integrated
Security=SSPI;Asynchronous Processing=true"
The application contains the following code segment. (Line numbers are included for reference only.)
01 protected void UpdateData(SqlCommand cmd) {
02 cmd.Connection.Open();
03
04 lblResult.Text = "Updating ...";
05 }
The cmd object takes a long time to execute.
You need to ensure that the application continues to execute while cmd is executing.
What should you do?
A. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(new AsyncCallback(UpdateComplete), cmd);
Add the following code segment.
private void UpdateComplete (IAsyncResult ar) {
int count = (int)ar.AsyncState;
LogResults(count);
}
B. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(new AsyncCallback(UpdateComplete), cmd);
Add the following code segment.
private void UpdateComplete (IAsyncResult ar) {
SqlCommand cmd = (SqlCommand)ar.AsyncState;
int count = cmd.EndExecuteNonQuery(ar);
LogResults(count);
}
C. Insert the following code segment at line 03.
cmd.StatementCompleted += new
StatementCompletedEventHandler(UpdateComplete);
cmd.ExecuteNonQuery();
Add the following code segment.
private void UpdateComplete (object sender, StatementCompletedEventArgs e) {
int count = e.RecordCount;
LogResults(count);
}
D. Insert the following code segment at line 03.
SqlNotificationRequest notification = new
SqlNotificationRequest("UpdateComplete", "", 10000);
cmd.Notification = notification;
cmd.ExecuteNonQuery();
Add the following code segment.
private void UpdateComplete(SqlNotificationRequest notice) {
int count = int.Parse(notice.UserData);
LogResults(count);
}
Answer: B

Microsoft original questions   70-561 test   70-561   70-561 answers real questions

NO.30 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 write the following code segment. (Line numbers are included for reference only.)
01 Using connection As New SqlConnection(connectionString)
02 Dim cmd As New SqlCommand(queryString, connection)
03 connection.Open()
04
05 While sdrdr.Read()
06 ' use the data in the reader
07 End While
08 End Using
You need to ensure that the memory is used efficiently when retrieving BLOBs from the database.
Which code segment should you insert at line 04?
A. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader()
B. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.[Default])
C. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.SchemaOnly)
D. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.SequentialAccess)
Answer: D

Microsoft questions   70-561   70-561 exam dumps   70-561