Sawaal
  • Home/
  • Searching for go

 Searching for "go"

Q:

You are creating an ASP.NET application for XYZ. The company data is stored in a Microsoft SQL Server 6.5 database. Your application generates accounting summary reports based on transaction tables that contain million of rows.


You want your application to return each summary report as quickly as possible. You need to configure your application to connect to the database and retrieve the data in a away that achieves this goal.


What should you do?

A) Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data. B) Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.
C) Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format. D) Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data.
 
Answer & Explanation Answer: B) Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.

Explanation:

We need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier). 

 

Incorrect Answers:

 

A: We could use a SqlConnection object only if the SQL Server were SQL Server 7.0, 2000 or later.

 

C: HTTP functionality is not required in this scenario. It would introduce unnecessary overhead.

 

D: ADODB is a legacy standard and should not be used here

Report Error

View Answer Report Error Discuss

Filed Under: MCSD-Microsoft Certified Solutions Developer

Q:

You develop a Windows-based application that enables to enter product sales. You add a subroutine named XYZ.

 

You discover that XYZ sometimes raises an IOException during execution. To address this problem you create two additional subroutines named LogError and CleanUp. These subroutines are governed by the following rules:

• LogError must be called only when XYZ raises an exception.
• CleanUp must be called whenever XYZ is complete.

 

 You must ensure that your application adheres to these rules. Which code segment should you use?

A) try { XYZ(); LogError(); } catch (Exception e) { CleanUp(e); } B) try { XYZ(); } catch (Exception e) { LogError(e); CleanUp(); }
C) try { XYZ(); } catch (Exception e) { LogError(e); } finally { CleanUp(); } D) try { XYZ(); } catch (Exception e) { CleanUp(e); } finally { LogError(); }
 
Answer & Explanation Answer: C) try { XYZ(); } catch (Exception e) { LogError(e); } finally { CleanUp(); }

Explanation:

We must use a try…catch…finally construct. First we run the Comapany() code in the try block.Then we use the LogError() subroutine in the catch statement since all exceptions are handled here. Lastly we put the CleanUp() subroutine in the finally statement since this code will be executed regardless of whether an exception is thrown or not.

Report Error

View Answer Report Error Discuss

Filed Under: MCAD - Microsoft Certified Application Developer

Q:

[CO-OM-CCA] When a cost center is created, certain basic data must be entered. Which of the following are needed when creating a cost center.

A. Assignment to company code          B. Validity period

C. Assignment to cost element            D. Selection of activity unit

E. Cost center category

Answer

Answer : A , B , E

Report Error

View answer Workspace Report Error Discuss

Subject: SAP CO

Q:

Identify the steps in the asap methodology

A. Realization Project preparation
B. Roll out
C. Go live & support
D. Final preparation.
E. Business blueprint

Answer

Answer : A , C , D , E

Report Error

View answer Workspace Report Error Discuss

Subject: SAP Solution Manager

Q:

Which of the Item Category system determine in Consigment Processing

A. Consignment Pick up - KAN
B. Consignment Return - KRN
C. Consignment issue - KEN
D. Consignment fill up - KBN

Answer

Answer : A , B , C ,D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD

Q:

For materials that require batch control, the batch number can be specified in:

A. The billing document.

B. The picking overview screen.

C. At post goods issue.

D. The sales order line item.

Answer

Answer : B , C , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD

Q:

Partial deliveries are controlled by an indicator thet you set in the:

A. Sold to master record.

B. Delivery schedule line category.

C. Delivery document type.

D. Customer material information record.

Answer

Answer : A , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD

Q:

At which point can goods issue be posted if qualitiy inspection is configured with Sales&Distribuiton?

A. Upon acceptance of the inspection lot.

B. Upon completing the delivery.

C. Upon creating the transfer order.

D. Upon confirming the picking quantities.

Answer

Answer : A

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD