Adobe Exam AD0-E903 Topic 1 Question 15 Discussion

Actual exam question for Adobe's AD0-E903 exam

Question #: 15
Topic #: 1

An executive wants to see the actual cost of projects within a selected portfolio, allowing for multiple reports with the option to select a specific portfolio, sorted in a descending order, so the most expensive projects appear on top. Which steps should be taken to create this report?

AVisit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. From the Reporting Settings dropdown, add a prompt for Portfolio Name.

BVisit the Reports area and create a new Project report. Group the results by Portfolio Name. Add a column for Actual Cost and summarize this column by SUM.

CVisit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. Group the results by Portfolio Name.

Show Suggested Answer

Suggested Answer: A

To meet the executive's request, the best approach is to create a Project Report in the Reports area. Adding a column for Actual Cost and sorting it in descending order ensures that the most expensive projects appear at the top. Additionally, by adding a prompt for Portfolio Name, the report can be filtered by the specific portfolio, allowing for tailored views across different portfolios.

by Tarra at Jan 26, 2025, 06:25 PM

Limited Time Offer

25%

Off

Get Premium AD0-E903 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Fletcher

12 hours ago

Ha! This is like a trick question. I bet the right answer is option A - that way, the executive can select the specific portfolio they want to see. Sorted in descending order, of course. Nice one!

upvoted 0 times

...

Ayesha

10 days ago

I see both points. Maybe combining both options A and C could be the best approach for this report.

upvoted 0 times

...

Deeann

11 days ago

I disagree, I believe option C is better. Sorting the Actual Cost column in descending order first will show the most expensive projects on top.

upvoted 0 times

...

Tran

16 days ago

Hmm, I'm not sure. I was thinking option B might be better, since it allows you to summarize the Actual Cost column by portfolio. That could give the executive a high-level view of the costs.

upvoted 0 times

Nicolette

15 hours ago

I think option B is a good choice. It summarizes the Actual Cost by Portfolio Name.

upvoted 0 times

...

Salena

23 days ago

Wow, this is tricky. I think option C is the way to go - grouping by Portfolio Name and sorting the Actual Cost column in descending order. That way, the executive can easily see the most expensive projects at the top.

upvoted 0 times

Lanie

2 days ago

I agree, grouping by Portfolio Name and sorting by Actual Cost in descending order will provide a clear view of the project costs.

upvoted 0 times

...

Glory

16 days ago

Option C sounds good to me too. It will make it easier for the executive to see the most expensive projects first.

upvoted 0 times

...

Rebbeca

1 months ago

I think option A is the way to go. Adding a prompt for Portfolio Name will allow for selecting a specific portfolio.

upvoted 0 times

...