70-549VB Exam

Quality and Value for the 70-549VB Exam

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

Guarantee to Pass Your 70-549VB Exam

If you prepare for the exam using our 4cert testing engine, we guarantee your success in the first attempt. If you do not pass the MCPD 70-549VB Exam exam (PRO:Design & Develop Enterprise Appl by Using MS.NET Frmwk) on your first attempt we will give you a FREE UPDATE of your purchasing fee AND send you another same value product for free.

Microsoft 70-549VB Exams (in EXE format)

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

70-549VB Downloadable, Interactive Testing engines

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


1. You are an enterprise application developer. You are creating a component that will be deployed as part of a class library. The component must meet the following specifications:
·The interface of the component must be accessible to components outside the hosting assembly.
·The interface of the component must be interoperable with components written in any other .NET Framework languages.
·The implementation of the component cannot be expanded upon by a derived class.
You need to design the interface of the component.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)
A. Apply the CLSCompliant(True) attribute to the assembly and component definition.
B. Apply the MustInherit keyword to the component definition.
C. Apply the ComVisible(True) attribute to the assembly and component definition.
D. Create a primary interop assembly for the assembly that hosts your component.
E. Apply the NotInheritable keyword to the component definition.
F. Apply the Public keyword to the component definition.
Answer: AEF

2. You are an enterprise application developer. You are manipulating a collection of customer, product, and supplier objects.
The collection objects must fulfill the following requirements:
·The objects must use custom sort methods on different properties of the respective classes.
·The objects must be strongly typed.
A developer from your team decides to use the following collection classes.
Public MustInherit Class MyCollectionBase
Inherits System.Collections.CollectionBase
Public MustOverride Sub Sort()
End Class
Public Class CustomerCollection
Inherits MyCollectionBase
'Code overrriding CollectionBase methods
Public Overrides Sub Sort()
'Customer sorting method
End Sub
End Class
Public Class SupplierCollection
Inherits MyCollectionBase
'Code overrriding CollectionBase methods
Public Overrides Sub Sort()
'Supplier sorting method
End Sub
End Class
Public Class ProductCollection
Inherits MyCollectionBase
'Code overrriding CollectionBase methods
Public Overrides Sub Sort()
'Product sorting method
End Sub
End Class
You need to review the code and recommend improvements to simplify maintenance, if necessary.
What should you conclude and recommend?
A. The code does not need to be modified.
B. The code needs to be modified. The MyCollectionBase class must implement the ICollection interface instead of inheriting from the CollectionBase class.
C. The code needs to be modified. Use List(Of T) class instead of creating custom collections.
D. The code needs to be modified. The child collection classes must inherit from the CollectionBase class instead of the MyCollectionBase class.
Answer: C

3. You are an enterprise application developer.
The Data Access Layer (DAL) of an application contains the following code segment. (Line numbers are included for reference only.)
01 Public Shared Function GetEmployees() As List(Of Employee)
02 Dim employees As New List(Of Employee)()
03 Using cnn As New SqlConnection(_cnnStr)
04 Dim cmd As New SqlCommand("GetEmployees", cnn)
05 cnn.Open()
06 Dim ds As New DataSet()
07 Dim da As New SqlDataAdapter(cmd)
08 da.Fill(ds)
09 For Each row As DataRow In ds.Tables(0).Rows
10 Dim emp As New Employee()
11 emp.ID = Convert.ToInt32(row("Id"))
12 emp.Name = Convert.ToString(row("Name"))
13 employees.Add(emp)
14 Next
15 End Using
16 Return employees
17 End Function
You review the code segment and discover that it takes a long time to execute.
You need to modify the code segment to improve the performance.
What should you do?
A. ·Create a SqlDataReader object.
·Iterate through a DataReader object to populate the employees list.
B. ·Fill a DataTable object by using the DataTable.Load method.
·Iterate through the DataTable to populate the employees list.
C. ·Fill a DataTable object by using a SqlDataAdapter object.
·Iterate through the DataTable to populate the employees list.
D. ·Fill a DataTable object by using the DataTable.Load method.
·Create a DataTableReader object from the DataTable.
·Iterate through the DataTableReader to populate the employees list.
Answer: A

4. You are an enterprise application developer.
You are reviewing the following code segment. (Line numbers are included for reference only.)
01 Public Class MyResource
02 Implements IDisposable
03
04 Private disposed As Boolean = False
05
06 Public Sub Dispose() Implements IDisposable.Dispose
07 Dispose(True)
08 End Sub
09
10 Private Sub Dispose(ByVal disposing As Boolean)
11 If Not Me.disposed Then
12 If disposing Then
13 ReleaseManagedResources()
14 End If
15 ReleaseUnmanagedResources()
16 disposed = True
17 End If
18 End Sub
19
20 Protected Overrides Sub Finalize()
21 Try
22 ReleaseManagedResources()
23 ReleaseUnmanagedResources()
24 Finally
25 MyBase.Finalize()
26 End Try
27 End Sub
28
29 End Class
You discover that the dispose pattern is implemented incorrectly.
You need to modify the code segment to ensure that the dispose pattern is implemented correctly.
What should you do?
A. ·Insert the following line of code after line 07.
GC.SuppressFinalize(Me)
·Replace lines 22 and 23 with the following line of code.
Dispose(True)
B. ·Insert the following line of code after line 07.
GC.SuppressFinalize(Me)
·Replace lines 22 and 23 with the following line of code.
Dispose(False)
C. ·Insert the following line of code after line 21.
GC.SuppressFinalize(Me)
·Replace lines 22 and 23 with the following line of code.
Dispose(False)
D. ·Insert the following line of code after line 21.
GC.SuppressFinalize(Me)
·Replace lines 22 and 23 with the following line of code.
Dispose(True)
Answer: B

5. You are an enterprise application developer. You create a data access layer for an order processing application.
The data access layer meets the following criteria:
·The data access layer contains a GetConnectionString method to retrieve and return the connection string for the database.
·The data access layer contains a stored procedure named GetTotalOrderAmount.
·The stored procedure runs a select query to return only the sum of the OrderAmount column for the active orders. At times, there might be no active orders.
You create the following method to execute the stored procedure and return the total.
Public Function GetTotalOrderAmount() As Double
Dim con As New SqlConnection(GetConnectionString())
Dim sql As String = "GetTotalOrderAmount"
Dim cmd As New SqlCommand(sql, con)
Dim rd As IDataReader = cmd.ExecuteReader()
Dim amt As Double = 0.0
If rd.Read() Then
amt = rd.GetDouble(0)
End If
rd.Close()
con.Close()
Return amt
End Function
You need to review the code and recommend modifications to simplify the code and improve performance, if necessary.
What should you conclude and recommend?
A. The code does not need to be modified.
B. The code needs to be modified. You must remove the condition that verifies whether the DataReader object returned any rows.
C. The code needs to be modified. You must use a DataSet object instead of a DataReader object.
D. The code needs to be modified. You must use the ExecuteScalar method instead of the ExecuteReader method.
Answer: D

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