You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort. Which code should you use?

The correct answer is A. Option A. / During your investigation, you discover that the sales force reports are causing significant /Sales force data access Salespeople at both the headquarters office and the satellite office must generate reports that read from the Product and SalesOrderDetail tables. No updates or

Design and implement database solutions

Question

You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort. Which code should you use?

Exhibit

Options

AOption A
BOption B
COption C
DOption D

How the community answered

(14 responses)

A
71% (10)
B
7% (1)
C
7% (1)
D
14% (2)

Explanation

/ During your investigation, you discover that the sales force reports are causing significant /Sales force data access Salespeople at both the headquarters office and the satellite office must generate reports that read from the Product and SalesOrderDetail tables. No updates or inserts are ever made by sales people. These reports are run at random times and there can be no reporting downtime to refresh the data set except during the monthly maintenance window. The reports that run from the satellite office are process intensive queries with large data sets. Regardless of which office runs a sales force report, the SalesOrderDetail table should only return valid, committed order data; any orders not yet committed should be ignored.

Topics

#data access#reporting#views#query design

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice