70-549CSharp Exam
PRO:Design & Develop Enterprise Appl by Using MS.NET Frmwk
- Exam Number/Code : 70-549CSharp
- Exam Name : PRO:Design & Develop Enterprise Appl by Using MS.NET Frmwk
- Questions and Answers : 139 Q&As
- Update Time: 2011-02-02
- Price:
$ 119.00$ 69.00
Free 70-549CSharp Demo Download
TestInside offers free demo for MCPD 70-549CSharp 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.
Microsoft MCPD 70-549CSharp exam braindumps questions and answers
¡¡
¡¡
Exam : Microsoft 70-549CSharp
Title : Designing and Developing Enterprise Applications Using CSharp
1. You are an enterprise application developer. You are evaluating a component that monitors a Web-based application.
The component stores monitoring information in a database and performs the following functions:
¡¤Retrieves the number of orders placed per second.
¡¤Tracks the data for peak usage of the application and displays the data in a tabular form.
Subsequently, monitoring requirements change in the following manner:
¡¤Users must be able to view data graphically.
¡¤Users must be able to analyze data in real time.
¡¤Users must be able to correlate the number of orders placed per second with the memory usage in the Web server.
You need to evaluate whether the component meets the new requirements and propose a solution, if required.
What should you conclude?
A. The component meets the new requirements.
B. The component does not meet the new requirements. You need to update a text file by using trace statements instead of storing data in a database.
C. The component does not meet the new requirements. You need to update a custom performance counter instead of a database.
D. The component does not meet the new requirements. You need to update a custom event log instead of a database.
Answer: C
2. You are an enterprise application developer. You are creating an application. Within your application, an order contains order lines. Order lines are always contained within an order.
You need to analyze this structure and show the link between the order and the order line by using a class diagram.
Which diagram should you choose?
A.
B.
C.
D.
Answer: A
3. You are an enterprise application developer. You are creating an application for the sales department.
Users in the sales department are occasionally connected to the network. Users enter orders through a smart client interface. The orders are sent to a business component that is installed on an application server. The business component updates the orders. You need to ensure that the orders are reliably delivered to the server.
Which technology should you choose?
A. .NET Remoting
B. Web services
C. Message Queuing
D. DCOM
Answer: C
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: IDisposable {
02
03 private bool disposed = false;
04
05 public void Dispose() {
06 Dispose(true);
07 }
08
09 private void Dispose(bool disposing) {
10 if(!this.disposed) {
11 if(disposing) {
12 ReleaseManagedResources();
13 }
14 ReleaseUnmanagedResources();
15 disposed = true;
16 }
17 }
18
19 ~MyResource() {
20 ReleaseManagedResources();
21 ReleaseUnmanagedResources();
22 }
23 }
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 06.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(true);
B. ¡¤Insert the following line of code after line 06.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(false);
C. ¡¤Insert the following line of code after line 19.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(false);
D. ¡¤Insert the following line of code after line 19.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(true);
Answer: B
5. You are an enterprise application developer. You are creating a client/server application. You need to install the application on the company network.
The client/server application must meet the following criteria:
¡¤The server component is a class library that is created by using the .NET Framework.
¡¤The client component is a Microsoft Windows-based application that is created by using the .NET Framework.
¡¤The client component and the server component must communicate by using a binary protocol.
¡¤The fewest possible ports are opened between the client component and the server component.
You need to identify a technology that permits the server to communicate with the client component through the TCP/IP protocol.
Which technology should you use?
A. Message Queuing
B. .NET Remoting
C. Web services
D. DCOM
Answer: B
6. 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
7. You are an enterprise application developer.
The data access layer of an application contains the following code segment. (Line numbers are included for reference only.)
01 static public List<Employee> GetEmployees(){
02 List<Employee> employees = new List<Employee>();
03 using (SqlConnection cnn = new SqlConnection(_cnnStr)){
04 SqlCommand cmd = new SqlCommand("GetEmployees", cnn);
05 cnn.Open();
06 DataSet ds = new DataSet();
07 SqlDataAdapter da = new SqlDataAdapter(cmd);
08 da.Fill(ds);
09 foreach (DataRow row in ds.Tables[0].Rows){
10 Employee emp = new Employee();
11 emp.ID = Convert.ToInt32(row["Id"]);
12 emp.Name = Convert.ToString(row["Name"]);
//
13 employees.Add(emp);
14 }
15 }
16 return employees;
17 }
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 a 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 a DataTable.Load method.
¡¤Create a DataTableReader object from the DataTable.
¡¤Iterate through the DataTableReader to populate the employees list.
Answer: A
8. You are an enterprise application developer.
You are working on a component in an application that provides a business workflow solution.
The component will be used as a workflow to manage purchase requisitions.
You discover that a WebException is raised when you use the GetApprover private method to invoke a method of a Web Service.
You need identify a code that allows the component to invoke the following methods:
¡¤The GetDefaultApprover method if a WebException is raised
¡¤The ReportError method if any other exception is raised
¡¤The GoToNextStep method if no exception is raised
Which code segment should you use?
A. try{
GetApprover ();
GoToNextStep();}
catch (WebException ex){
GetDefaultApprover ();}
catch (Exception ex){
ReportError();}
B. try{
GetApprover ();
GoToNextStep();}
catch (WebException ex){
GetDefaultApprover ();
}
catch (SqlException ex){
ReportError();
}
C. try{
GetApprover ();
}
catch (WebException ex){
GetDefaultApprover ();
}
catch (Exception ex){
ReportError();
}
finally{
GoToNextStep();
}
D. try{
GetApprover ();
}
catch (WebException ex){
GetDefaultApprover ();
}
catch (SqlException ex){
ReportError();
}
finally{
GoToNextStep();
}
Answer: A
9. 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
10. 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
11. You are an enterprise application developer. You create a component that has a method named IsPrinterLicensed. The method invokes a Web service named printLicensing. The Web service provides a method named checkLicense.
You want to recieve the feedback from the Web service when the call to the Web service is completed.
You write the following code segment. void pl_Completed(Object sender,
printLicense.checkLicenseCompletedEventArgs args)
{
bool Result = args.Result;
// process result
}
You need to invoke the Web service asynchronously. You also need to ensure that the component is notified when the call to the Web service is completed. Which code fragment should you use?
A. pl = new printLicense.printLicensing();
pl.checkLicenseCompleted += pl_Completed;
pl.checkLicense(companyName, printerIP);
B. pl = new printLicense.printLicensing();
pl.checkLicenseCompleted += pl_Completed;
pl.checkLicenseAsync(companyName, printerIP);
C. pl = new printLicense.printLicensing();
pl.checkLicenseAsync(companyName, printerIP);
pl.checkLicenseCompleted += pl_Completed;
D. pl = new printLicense.printLicensing();
pl.AllowAutoRedirect = true;
pl.checkLicenseAsync(companyName, printerIP);
Answer: B
12. 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
13. 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
14. You are an enterprise application developer. You create an application to provide an enterprise-wide barcode printing solution. You are developing a component that contains a method named InitializePrinter. The method will call a private function named IsPrinterLicensed to verify the license of the printer for the application. You need to ensure that the exceptions raised by the IsPrinterLicensed function bubble up to the application that calls the InitializePrinter method. You also need to ensure that the exceptions contain contextual information. Which code segment should you use?
A. nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName);
B. try {
nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName) ;}
catch (Exception ex){
throw ex; }
C. try {
nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName) ;}
catch (Exception ex){
throw new Exception("Exception thrown from InitializePrinter");}
D. try {
nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName) ;}
catch (Exception ex){
throw new Exception("Exception thrown from InitializePrinter", ex);}
Answer: D
Click Online chat to talk with us , get more informations about Cisco CCNP 642-892 practice exam study guides questions and answers
¡¡
Exam : Microsoft 70-549CSharp
Title : Designing and Developing Enterprise Applications Using CSharp
1. You are an enterprise application developer. You are evaluating a component that monitors a Web-based application.
The component stores monitoring information in a database and performs the following functions:
¡¤Retrieves the number of orders placed per second.
¡¤Tracks the data for peak usage of the application and displays the data in a tabular form.
Subsequently, monitoring requirements change in the following manner:
¡¤Users must be able to view data graphically.
¡¤Users must be able to analyze data in real time.
¡¤Users must be able to correlate the number of orders placed per second with the memory usage in the Web server.
You need to evaluate whether the component meets the new requirements and propose a solution, if required.
What should you conclude?
A. The component meets the new requirements.
B. The component does not meet the new requirements. You need to update a text file by using trace statements instead of storing data in a database.
C. The component does not meet the new requirements. You need to update a custom performance counter instead of a database.
D. The component does not meet the new requirements. You need to update a custom event log instead of a database.
Answer: C
2. You are an enterprise application developer. You are creating an application. Within your application, an order contains order lines. Order lines are always contained within an order.
You need to analyze this structure and show the link between the order and the order line by using a class diagram.
Which diagram should you choose?
A.
B.
C.
D.
Answer: A
3. You are an enterprise application developer. You are creating an application for the sales department.
Users in the sales department are occasionally connected to the network. Users enter orders through a smart client interface. The orders are sent to a business component that is installed on an application server. The business component updates the orders. You need to ensure that the orders are reliably delivered to the server.
Which technology should you choose?
A. .NET Remoting
B. Web services
C. Message Queuing
D. DCOM
Answer: C
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: IDisposable {
02
03 private bool disposed = false;
04
05 public void Dispose() {
06 Dispose(true);
07 }
08
09 private void Dispose(bool disposing) {
10 if(!this.disposed) {
11 if(disposing) {
12 ReleaseManagedResources();
13 }
14 ReleaseUnmanagedResources();
15 disposed = true;
16 }
17 }
18
19 ~MyResource() {
20 ReleaseManagedResources();
21 ReleaseUnmanagedResources();
22 }
23 }
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 06.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(true);
B. ¡¤Insert the following line of code after line 06.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(false);
C. ¡¤Insert the following line of code after line 19.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(false);
D. ¡¤Insert the following line of code after line 19.
GC.SuppressFinalize(this);
¡¤Replace lines 20 and 21 with the following line of code.
Dispose(true);
Answer: B
5. You are an enterprise application developer. You are creating a client/server application. You need to install the application on the company network.
The client/server application must meet the following criteria:
¡¤The server component is a class library that is created by using the .NET Framework.
¡¤The client component is a Microsoft Windows-based application that is created by using the .NET Framework.
¡¤The client component and the server component must communicate by using a binary protocol.
¡¤The fewest possible ports are opened between the client component and the server component.
You need to identify a technology that permits the server to communicate with the client component through the TCP/IP protocol.
Which technology should you use?
A. Message Queuing
B. .NET Remoting
C. Web services
D. DCOM
Answer: B
6. 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
7. You are an enterprise application developer.
The data access layer of an application contains the following code segment. (Line numbers are included for reference only.)
01 static public List<Employee> GetEmployees(){
02 List<Employee> employees = new List<Employee>();
03 using (SqlConnection cnn = new SqlConnection(_cnnStr)){
04 SqlCommand cmd = new SqlCommand("GetEmployees", cnn);
05 cnn.Open();
06 DataSet ds = new DataSet();
07 SqlDataAdapter da = new SqlDataAdapter(cmd);
08 da.Fill(ds);
09 foreach (DataRow row in ds.Tables[0].Rows){
10 Employee emp = new Employee();
11 emp.ID = Convert.ToInt32(row["Id"]);
12 emp.Name = Convert.ToString(row["Name"]);
//
13 employees.Add(emp);
14 }
15 }
16 return employees;
17 }
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 a 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 a DataTable.Load method.
¡¤Create a DataTableReader object from the DataTable.
¡¤Iterate through the DataTableReader to populate the employees list.
Answer: A
8. You are an enterprise application developer.
You are working on a component in an application that provides a business workflow solution.
The component will be used as a workflow to manage purchase requisitions.
You discover that a WebException is raised when you use the GetApprover private method to invoke a method of a Web Service.
You need identify a code that allows the component to invoke the following methods:
¡¤The GetDefaultApprover method if a WebException is raised
¡¤The ReportError method if any other exception is raised
¡¤The GoToNextStep method if no exception is raised
Which code segment should you use?
A. try{
GetApprover ();
GoToNextStep();}
catch (WebException ex){
GetDefaultApprover ();}
catch (Exception ex){
ReportError();}
B. try{
GetApprover ();
GoToNextStep();}
catch (WebException ex){
GetDefaultApprover ();
}
catch (SqlException ex){
ReportError();
}
C. try{
GetApprover ();
}
catch (WebException ex){
GetDefaultApprover ();
}
catch (Exception ex){
ReportError();
}
finally{
GoToNextStep();
}
D. try{
GetApprover ();
}
catch (WebException ex){
GetDefaultApprover ();
}
catch (SqlException ex){
ReportError();
}
finally{
GoToNextStep();
}
Answer: A
9. 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
10. 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
11. You are an enterprise application developer. You create a component that has a method named IsPrinterLicensed. The method invokes a Web service named printLicensing. The Web service provides a method named checkLicense.
You want to recieve the feedback from the Web service when the call to the Web service is completed.
You write the following code segment. void pl_Completed(Object sender,
printLicense.checkLicenseCompletedEventArgs args)
{
bool Result = args.Result;
// process result
}
You need to invoke the Web service asynchronously. You also need to ensure that the component is notified when the call to the Web service is completed. Which code fragment should you use?
A. pl = new printLicense.printLicensing();
pl.checkLicenseCompleted += pl_Completed;
pl.checkLicense(companyName, printerIP);
B. pl = new printLicense.printLicensing();
pl.checkLicenseCompleted += pl_Completed;
pl.checkLicenseAsync(companyName, printerIP);
C. pl = new printLicense.printLicensing();
pl.checkLicenseAsync(companyName, printerIP);
pl.checkLicenseCompleted += pl_Completed;
D. pl = new printLicense.printLicensing();
pl.AllowAutoRedirect = true;
pl.checkLicenseAsync(companyName, printerIP);
Answer: B
12. 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
13. 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
14. You are an enterprise application developer. You create an application to provide an enterprise-wide barcode printing solution. You are developing a component that contains a method named InitializePrinter. The method will call a private function named IsPrinterLicensed to verify the license of the printer for the application. You need to ensure that the exceptions raised by the IsPrinterLicensed function bubble up to the application that calls the InitializePrinter method. You also need to ensure that the exceptions contain contextual information. Which code segment should you use?
A. nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName);
B. try {
nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName) ;}
catch (Exception ex){
throw ex; }
C. try {
nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName) ;}
catch (Exception ex){
throw new Exception("Exception thrown from InitializePrinter");}
D. try {
nResult = IsPrinterLicensed(printerName);
InitPrinter(printerName) ;}
catch (Exception ex){
throw new Exception("Exception thrown from InitializePrinter", ex);}
Answer: D
Click Online chat to talk with us , get more informations about Cisco CCNP 642-892 practice exam study guides questions and answers
Exam Description
It is well known that 70-549CSharp exam test is the hot exam of Microsoft certification. TestInside offer you all the Q&A of the 70-549CSharp real test . It is the examination of the perfect combination and it will help you pass 70-549CSharp exam at the first time!
Why choose TestInside 70-549CSharp braindumps
Quality and Value for the 70-549CSharp Exam
100% Guarantee to Pass Your 70-549CSharp Exam
Downloadable, Interactive 70-549CSharp Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.
TestInside 70-549CSharp Exam Features
Quality and Value for the 70-549CSharp Exam
TestInside Practice Exams for Microsoft 70-549CSharp are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your 70-549CSharp Exam
If you prepare for the exam using our TestInside testing engine, we guarantee your success in the first attempt. If you do not pass the MCPD 70-549CSharp exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.
Microsoft 70-549CSharp Downloadable, Printable Exams (in PDF format)
Our Exam 70-549CSharp Preparation Material provides you everything you will need to take your 70-549CSharp Exam. The 70-549CSharp 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-549CSharp 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-549CSharp Exam will provide you with free 70-549CSharp dumps 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-549CSharp Exam:100% Guarantee to Pass Your MCPD exam and get your MCPD Certification.
TestInside 70-549CSharp practice exam preparation workTestInside 70-549CSharp braindumps examination test
TestInside 70-549CSharp pdf exam history test questions
TestInside 70-549CSharp video
TestInside 70-549CSharp certification professionals
TestInside 70-549CSharp actual
TestInside 70-549CSharp braindumps notes
TestInside 70-549CSharp study guide questions
TestInside 70-549CSharp practice exam guide
TestInside 70-549CSharp examination guide
TestInside 70-549CSharp certificate file
TestInside 70-549CSharp certification practice tests
TestInside 70-549CSharp preparation work
TestInside 70-549CSharp certified certification
TestInside 70-549CSharp sample certification
TestInside 70-549CSharp braindumps
http://www.saletestinside.com/70-549CSharp-exam.html The safer.easier way to get MCPD Certification.
