70-549CSHARP Exam

It can be downloaded after you paying for it without any delay!

Free 70-549CSHARP Dumps Download

VisualExams offer 70-549CSHARP practice test,it will help you pass the exam.Also we offer free 70-549CSHARP test demo. They are a part of the full questions,you can view the question on our test engine before you decide to purchase.Click the link below to download our test engine,install it,search 70-549CSHARP,then click download demo.

Free download Test Engine

Free download 70-549CSHARP PDF

　
　
Exam : Microsoft 70-549CSharp
Title : Designing and Developing Enterprise Applications Using CSharp


1. 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 double GetTotalOrderAmount() {
SqlConnection con = new SqlConnection(GetConnectionString());
string sql = "GetTotalOrderAmount";
SqlCommand cmd = new SqlCommand(sql,con);
IDataReader rd;
con.Open();
rd = cmd.ExecuteReader();
double amt = 0.0;
if (rd.Read()) {
amt = rd.GetDouble(0);
}
rd.Close();
con.Close();
return amt;
}
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

2. You are an enterprise application developer. You are performing a peer code review for an entry-level developer. The developer is implementing server-side business objects.
The business objects must be accessed and activated by using .NET Framework remoting. In addition, the business objects must meet the following requirements:
·Implement an interface for client-side access.
·Inherit from a base business object class.
The developer writes the following code segment.
public class UserObject : BaseBizObject, MarshalByRefObject, IUserObject {}
When the developer attempts to compile the code, an error message is received.
You need to review the code and recommend a solution.
What should you recommend?
A. The class must derive from the MarshalByRefObject class. The UserObject class can access methods in the BaseBizObject class by creating an instance of the BaseBizObject class.
B. The class must derive from the BaseBizObject class. The BaseBizObject class must derive from the MarshalByRefObject class.
C. Change the approach so that the client computer accesses a wrapper class that derives from the MarshalByRefObject class.
D. The class must derive from the MarshalByValue class instead of the MarshalByRefObject class.
Answer: B

3. 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 abstract 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 sealed keyword to the component definition.
F. Apply the public keyword to the component definition.
Answer: AEF

4. 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.
abstract class MyCollectionBase : System.Collections.CollectionBase {
abstract public void Sort();
}
public class CustomerCollection : MyCollectionBase {
//Code overriding CollectionBase methods
public override void Sort(){
//Customer sorting code }}
public class SupplierCollection : MyCollectionBase {
//Code overriding CollectionBase methods
public override void Sort(){
//Supplier sorting code}}
public class ProductCollection : MyCollectionBase {
//Code overriding CollectionBase methods
public override void Sort(){
//Product sorting code}}
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<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

5. You are an enterprise application developer. You are performing a peer code review for an entry-level developer. The developer is implementing server-side business objects.
The business objects must be accessed and activated by using .NET Framework remoting. In addition, the business objects must meet the following requirements:
·Implement an interface for client-side access.
·Inherit from a base business object class.
The developer writes the following code segment.
Public Class UserObject
Inherits BaseBizObject, MarshalByRefObject
Implements IUserObject
End Class
When the developer attempts to compile the code, an error message is received.
You need to review the code and recommend a solution. What should you recommend?
A. The class must derive from the MarshalByRefObject class. The UserObject class can access methods in the BaseBizObject class by creating an instance of the BaseBizObject class.
B. The class must derive from the BaseBizObject class. The BaseBizObject class must derive from the MarshalByRefObject class.
C. Change the approach so that the client computer accesses a wrapper class that derives from the MarshalByRefObject class.
D. The class must derive from the MarshalByValue class instead of the MarshalByRefObject class.
Answer: B

VisualExams 70-549CSHARP Exam Description

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

Guarantee to Pass Your 70-549CSHARP Exam

We provide the latest high quality 70-549CSHARP practice exam for the customers,we guarantee your success at the first attempt with only our 70-549CSHARP exam questions, if somehow you do not pass the exam at the first time, we will Free update for you!

The Tenet Of VisualExams

Our on-site online training experts create all of the Microsoft 70-549CSHARP 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-549CSHARP exam are now continuously updating and accepting this challenge is itself a task. This 70-549CSHARP practice test is an important part of Microsoft certifications and at MCPD braindumps we have the resources to prepare you for this. The 70-549CSHARP 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-549CSHARP Value Pack and save time and money while developing your skills to pass your Microsoft Certified Network Associate (MCPD) Exam'? Let VisualExams help you climb that ladder of success and pass your 70-549CSHARP now!