Salesforce Certified Platform Data Architect (Plat-Arch-201) Exam - Topic 1 Question 65 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Data Architect (Plat-Arch-201) exam

Question #: 65
Topic #: 1

[All Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions]

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

AUse triggers to populate denormalized related fields on the Account.

BUse an indexed data field with bounded data filters.

CUse Formula fields to surface information I related entities on the report.

DUse unbounded date ranges to filter the report.

Show Suggested Answer

Suggested Answer: B, C

Using an indexed data field with bounded data filters can improve the report performance by making the query more selective and reducing the number of records to scan.Using formula fields to surface information from related entities on the report can also enhance the report performance by avoiding joins and complex calculations

by Tiara at Aug 13, 2025, 07:47 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Platform Data Architect (Plat-Arch-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Clement

2 months ago

Surprised that D is even an option, unbounded ranges? Really?

upvoted 0 times

...

Julian

2 months ago

C seems inefficient for large datasets.

upvoted 0 times

...

Detra

2 months ago

I disagree, A could work too if set up right.

upvoted 0 times

...

Lamar

3 months ago

B is definitely the way to go for performance!

upvoted 0 times

...

Rosalind

3 months ago

B is the best choice, indexed fields are key!

upvoted 0 times

...

Jonell

3 months ago

I recall that unbounded date ranges can lead to performance issues, so I would avoid option D based on what we studied.

upvoted 0 times

...

Rolande

3 months ago

I think we practiced a similar question where using bounded filters helped improve report performance, so I would lean towards option B again.

upvoted 0 times

...

Angella

4 months ago

I'm not entirely sure about using triggers for denormalization; it feels like it could complicate things.

upvoted 0 times

...

Quentin

4 months ago

I remember we discussed the importance of using indexed fields for performance in reports, so option B seems like a solid choice.

upvoted 0 times

...

Deeann

4 months ago

This is a good opportunity to showcase my Salesforce skills. I'm feeling confident I can recommend the right solution to satisfy the business need.

upvoted 0 times

...

Shanice

4 months ago

Definitely don't want to use unbounded date ranges - that's a recipe for slow performance with millions of records. Gotta keep those filters tight.

upvoted 0 times

...

Leonor

4 months ago

I'm a bit confused on the difference between using formula fields and denormalized fields. I'll need to review those options more closely.

upvoted 0 times

...

Jennie

5 months ago

Okay, I think I've got a strategy here. Using denormalized fields and bounded data filters seems like the way to go to optimize performance.

upvoted 0 times

...

Julie

5 months ago

Hmm, this looks like a tricky one. I'll need to think carefully about the best approach to make this report perform well.

upvoted 0 times

...

Markus

5 months ago

B and C seem like the way to go. Denormalizing data can get messy, and unbounded date ranges will likely choke the system with millions of accounts.

upvoted 0 times

Renay

1 month ago

Yeah, denormalizing can complicate things. Better to keep it simple.

upvoted 0 times

...

Elfriede

2 months ago

I think B is essential for performance. Can't risk unbounded ranges!

upvoted 0 times

...

Jacob

2 months ago

C could work, but it might slow things down too.

upvoted 0 times

...

Theola

3 months ago

I agree, B is definitely a better choice. Indexed fields help a lot.

upvoted 0 times

...

Quentin

7 months ago

I think option B is a good choice because it will help with performance.

upvoted 0 times

...