nerdexam
CompTIA

DA0-001 · Question #359

A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for its region and the combined sales for…

The correct answer is A. Creating a single report with a region filter. Creating a single report with a region filter is the most efficient solution because it requires maintaining only one report. By setting up parameterized or dynamic filters, each sales team receives a view filtered to their region, while a combined view can show all regions…

Data Analysis

Question

A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for its region and the combined sales for all regions. Which of the following would be the most efficient method for meeting the requirements?

Options

  • ACreating a single report with a region filter
  • BCreating report distribution lists for the sales teams in each region
  • CCreating a unique copy of the report for each sales team region
  • DCreating a unique copy of the report for each recipient

How the community answered

(37 responses)
  • A
    73% (27)
  • B
    14% (5)
  • C
    8% (3)
  • D
    5% (2)

Explanation

Creating a single report with a region filter is the most efficient solution because it requires maintaining only one report. By setting up parameterized or dynamic filters, each sales team receives a view filtered to their region, while a combined view can show all regions. Creating unique copies per region or per recipient (options C and D) creates significant maintenance overhead - every change must be replicated across many copies. Distribution lists alone (option B) do not address the filtering requirement. A single filtered report scales easily and is simple to update.

Topics

#Report Design#Report Distribution#Efficiency#Data Filtering

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice