70-549VB Exam

Free 70-549VB Demo Download

pass999.info offers free demo for MCPD 70-549VB exam (PRO:Design & Develop Enterprise Appl by Using MS.NET Frmwk). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

Download 70-549VB Exam Testing Engine

70-549VB Exam Description

It is well known that latest 70-549VB exam test is the hot exam of Microsoft certification. pass999.info offer you all the Q&A of the 70-549VB real test . It is the examination of the perfect combination and it will help you pass 70-549VB exam at the first time!

　
　
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