To mitigate the risk of performance degradation when running complex reports on large datasets, which strategy is most effective?

Using data aggregation to pre-summarize data and reduce query load.

Using a custom report type for every report.

Increasing the number of report columns to provide more detail.

Disabling sharing rules to speed up queries.

To mitigate the risk of security exposure in a reporting solution, which strategy is most appropriate?

Caching report data to reduce access times.

Increasing the number of report folders to organize data.

Using data aggregation to hide sensitive details.

Implementing field-level security to restrict sensitive fields from unauthorized users.

A sales manager needs a dashboard that shows real-time pipeline data, but the dashboard will be viewed by a large number of users. Which design consideration is most important to ensure the dashboard performs well?

Using a custom report type for each component

Limiting the number of dashboard components and using efficient report queries

Storing dashboard data in a separate data warehouse

Enabling field-level security for the dashboard

A global company uses Salesforce for sales and has users in multiple time zones. They need a dashboard that shows real-time sales performance, but they are concerned about performance degradation during peak usage hours. Which mitigation strategy is most effective?

Use CRM Analytics with a scheduled dataflow that refreshes data every 15 minutes and cache the dashboard results.

Use native Salesforce dashboards with real-time data and no caching.

Limit dashboard access to only a few users to reduce load.

Use an external BI tool that queries Salesforce directly in real-time.

When building a custom report or dashboard in Salesforce, which platform constraint is most likely to affect the performance of a report that queries a large dataset?

Governor limits on SOQL queries

SalesforceCertified Technical Architect

Domain 1Objective 2

Given a Scenario, Describe the Design and Platform Considerations, Trade-Offs, and Risks for Reporting and Analytics. TECHNICAL-ARCHITECT Practice Questions (Page 1)

Part of the SYSTEM ARCHITECTURE domain, which makes up ~17% of our current practice bank.

15questions here

3free pages

6concepts

Questions 1–5

1foundation · easy
To mitigate the risk of performance degradation when running complex reports on large datasets, which strategy is most effective?
Select an answer first
2foundation · easy
To mitigate the risk of security exposure in a reporting solution, which strategy is most appropriate?
Select an answer first
3foundation · easy
A sales manager needs a dashboard that shows real-time pipeline data, but the dashboard will be viewed by a large number of users. Which design consideration is most important to ensure the dashboard performs well?
Select an answer first
4application · medium
A global company uses Salesforce for sales and has users in multiple time zones. They need a dashboard that shows real-time sales performance, but they are concerned about performance degradation during peak usage hours. Which mitigation strategy is most effective?
Select an answer first
5foundation · easy
When building a custom report or dashboard in Salesforce, which platform constraint is most likely to affect the performance of a report that queries a large dataset?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to TECHNICAL-ARCHITECT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “TECHNICAL-ARCHITECT” is a trademark of its owner, used for identification only.