Certification Questions

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

1 2191
Q:

Project Communications Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Performance Reporting?

Answer

I. Inputs



  • Work performance information

  • Performance measurements

  • Forecasted completion

  • Quality control measurements

  • Project management plan


                - Performance measurement baseline



  • Approved change requests

  • Deliverables


II. Tools and Techniques



  • Information presentation tools

  • Performance information gathering and compilation

  • Status review meetings

  • Time reporting systems

  • Cost reporting systems


III. Outputs



  • Performance reports

  • Forecasts

  • Requested changes

  • Recommended corrective actions

  • Organizational process assets (updates)

Report Error

View answer Workspace Report Error Discuss

0 2186
Q:

Project Scope Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Scope Verification ?

Answer

I. Inputs



  • Project scope statement

  • WBS dictionary

  • Project scope management plan

  • Deliverables


II. Tools and Techniques



  • Inspection


III. Outputs



  • Accepted  deliverables

  • Requested changes

  • Recommended corrective actions

Report Error

View answer Workspace Report Error Discuss

0 2186
Q:

Which of the following statements about distribution channel are correct?

A. It is responsible for the distribution of goods and services

B. It is assigned to a company code

C. It is assigned to a sales organization

D. It is the means at which goods and services reach the customer

Answer

Answer : C ,D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP SD

0 2186
Q:

Project Integration Management - Processes

Describe the Inputs, Tools and Techniques, Outputs of Develop project management plan phase?

Answer

I. Inputs



  • Preliminary project scope statement

  • Project management processes

  • Enterprise environmental factors

  • Organizational process assets


II. Tools and Techniques



  • Project management methodology

  • Project management information system

  • Expert Judgment


III. Outputs



  • Project management plan

Report Error

View answer Workspace Report Error Discuss

0 2181
Q:

Project Integration Management - Processes

Describe the Inputs, Tools and Techniques, Outputs of Develop Project Charter phase?

Answer

I. Inputs



  • Contract (when applicable)

  • Project statement of work

  • Enterprise environmental factors

  • Organizational process assets


II. Tools and Techniques



  • Project selection methods

  • Project management methodology

  • Project management information system

  • Expert Judgment


III. Outputs


         1. Project charter

Report Error

View answer Workspace Report Error Discuss

0 2181
Q:

When is Cost Per Thousand Impressions (CPM) bidding not available?

Answer

If your campaign is opted in to the Search Network.

Report Error

View answer Workspace Report Error Discuss

0 2181
Q:

Project Cost Management - Processes

Describe the Inputs, Tools and Techniques , Outputs included in the Cost Budgeting ?

Answer

I. Inputs



  • Project scope statement

  • Work breakdown structure

  • WBS dictionary

  • Activity cost estimates

  • Activity cost estimate supporting detail

  • Project schedule 

  • Resource calendars 

  • Contract

  • Cost management plan


II. Tools and Techniques



  • Cost aggregation

  • Reserve analysis

  • Parametric estimating 

  • Funding limit reconciliation


III. Outputs



  • Cost baseline 

  • Project funding requirements 

  • Cost management plan (updates)

  • Requested changes

Report Error

View answer Workspace Report Error Discuss

0 2179