Adobe AD0-E903 Exam - 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

Argelia

3 months ago

Not sure about A, seems too simple for what they want.

upvoted 0 times

...

Terrilyn

3 months ago

Wait, can you really sort and group at the same time?

upvoted 0 times

...

Emily

3 months ago

C is a solid choice too, grouping by Portfolio makes sense.

upvoted 0 times

...

Bernardo

4 months ago

I think B is better since it summarizes costs by portfolio.

upvoted 0 times

...

Lina

4 months ago

Option A sounds right, sorting by Actual Cost is key.

upvoted 0 times

...

Cristal

4 months ago

I’m leaning towards option A, but I’m a bit confused about whether we should include a summary for the costs or just sort them.

upvoted 0 times

...

Lashawn

4 months ago

I feel like option C might be the right choice since it combines sorting and grouping, which seems important for clarity.

upvoted 0 times

...

Madelyn

4 months ago

I remember a practice question where we had to summarize costs, but I can't recall if we needed to group by Portfolio or just sort it.

upvoted 0 times

...

Verona

5 months ago

I think we need to sort by Actual Cost, but I'm not sure if grouping by Portfolio Name is necessary for this report.

upvoted 0 times

...

Jamika

5 months ago

Option A looks good to me. Sorting the projects by Actual Cost in descending order and allowing the executive to select a specific portfolio should give them the information they need.

upvoted 0 times

...

Kirk

5 months ago

I think option B is the way to go. Grouping the results by Portfolio Name and summarizing the Actual Cost column will give us the total cost per portfolio, which is what the executive wants to see.

upvoted 0 times

...

Alline

5 months ago

Hmm, I'm a bit confused. Do we need to group the results by Portfolio Name as well? Option C looks like it might be the right approach, but I'm not sure.

upvoted 0 times

...

Ty

5 months ago

This seems straightforward. I'd go with option A - create a new project report, add the Actual Cost column, sort it descending, and add a prompt for Portfolio Name.

upvoted 0 times

...

Sylvia

12 months ago

Ugh, these project management questions can be so tedious. But I have to admit, option C does seem like the most straightforward solution. The executive can get a clear view of the top-spending projects. Efficiency at its finest!

upvoted 0 times

Shawnta

12 months ago

Yeah, I think sorting the projects by actual cost in descending order will really help the executive see the big picture.

upvoted 0 times

...

Leatha

12 months ago

I agree, option C seems like the best choice. It's simple and effective.

upvoted 0 times

...

Avery

1 year ago

Haha, the executive must be a real cost-conscious person. I like option C the best - it's clean, simple, and gets the job done. Grouping by portfolio and sorting by cost, can't go wrong with that!

upvoted 0 times

...

Fletcher

1 year 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

Ria

12 months ago

Yeah, I agree. It's important for the executive to have that flexibility in the report. Option A covers all the requirements.

upvoted 0 times

...

Laticia

12 months ago

I think you're right, option A seems like the best choice. It allows for selecting a specific portfolio and sorting by actual cost in descending order.

upvoted 0 times

...

Ayesha

1 year ago

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

upvoted 0 times

...

Deeann

1 year 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

1 year 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

Chuck

12 months ago

That's a good point. It really depends on what the executive is looking for in the report.

upvoted 0 times

...

Reita

12 months ago

True, but option B provides a high-level view by grouping the results by Portfolio Name.

upvoted 0 times

...

Tammy

12 months ago

But option A allows for sorting the Actual Cost in descending order, which might be helpful.

upvoted 0 times

...

Nicolette

1 year ago

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

upvoted 0 times

...

Salena

1 year 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

1 year 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

1 year 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 year 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

...