70-549VB Exam

Free 70-549VB Dumps Download

Exam4dumps offers free 70-549VB dumps,70-549VB Practice exam,70-549VB exam questions for MCPD certification(Microsoft Certified Network Associate). You can check out the question quality and usability of our 70-549VB practice exam before you decide to buy it.Before you purchase our 70-549VB Q&A,you can click the link below to download the latest 70-549VB pdf dumps.
　
　
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

Free download:Free 70-549VB dumps

Download 70-549VB Exam Testing Engine

Exam4dumps 70-549VB Exam Description

70-549VB exam training is available in various formats to best suit your needs and learning style from Exam4dumps. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, we has the 70-549VB resources that will guarantee you to pass your 70-549VB practice exam at the first time!

Guarantee to Pass Your 70-549VB Exam

We provide the latest high quality 70-549VB practice exam for the customers,we guarantee your success at the first attempt with only our 70-549VB exam questions, if somehow you do not pass the exam at the first time, we will not only arrange FULL REFUND for you, but also provide you another exam of your claim, ABSOLUTELY FREE!

The Tenet Of Exam4dumps

Our on-site online training experts create all of the Microsoft 70-549VB exam products available through Actual-Exams. Our main goal is that you get more kownleage with less money.You will find our price is very cheap.

After-sales Service

Once you purchase our products,we will offer you the best service.After you purchase our product, we will offer free update in time for 90 days.Whatever you have any questions,we will help you solve it. And in 3 weeks we will offer you free updates,so please pay attention our site at all times.

Acquiring Microsoft MCPD certifications are becoming a huge task in the field of I.T. More over these exams like 70-549VB exam are now continuously updating and accepting this challenge is itself a task. This 70-549VB practice test is an important part of Microsoft certifications and at MCPD braindumps we have the resources to prepare you for this. The 70-549VB exam is essential and core part of Microsoft certifications and once you clear the exam you will be able to solve the real time problems yourself.Wamt to take advantage of the Real 70-549VB Value Pack and save time and money while developing your skills to pass your 'Microsoft Certified Network Associate (MCPD) Exam'? Let Exam4dumps help you climb that ladder of success and pass your 70-549VB now!