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

Questions 11–15

1. 11foundation · easy

   A business team needs a report that shows sales data by region, but the data model currently stores region information in a related object. Which design consideration is most important to address when building this report?

   • AConfiguring a sharing rule to grant access to the related object
   • BEnabling field history tracking on the region field
   • CCreating a formula field on the primary object to store the region
   • DEnsuring the report uses a custom report type that includes the related object
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A financial services company has a Salesforce org with over 10 million Account records. They need to run a daily report that aggregates account balances by region and product line. The report currently times out and users complain about slow performance. Which mitigation strategy is most effective?

   • AAsk users to run the report during off-peak hours.
   • BUse the REST API to pull all Account records into an external tool and run the report there.
   • CCreate a custom object to store pre-aggregated data and schedule a flow to populate it nightly, then build the report on that object.
   • DIncrease the report's row limit and use a larger dashboard font to make it appear faster.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A healthcare organization uses Salesforce to manage patient cases. They need to provide a dashboard to external auditors that shows case resolution times, but they must ensure that patient data is not exposed to unauthorized users. Which design consideration is most important?

   • AUse a CRM Analytics dashboard with row-level security that respects sharing rules and assign the auditors a permission set that limits access to only the necessary fields.
   • BBuild an external BI dashboard that connects directly to Salesforce using a system-level API user.
   • CCreate a native Salesforce report and share it publicly with the auditors.
   • DExport the data to a spreadsheet and email it to the auditors.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A reporting solution uses a nightly data extract to populate a data warehouse for BI dashboards. Which risk is most directly associated with this approach?

   • APerformance degradation, as the extract will slow down the source system.
   • BData latency, as the dashboards will not reflect real-time changes.
   • CSecurity exposure, as the extract may contain sensitive data.
   • DScalability issues, as the extract cannot handle large data volumes.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   A company is considering using an external BI tool for advanced analytics. Which trade-off is most likely when choosing an external BI tool over native Salesforce reporting?

   • AIt provides real-time data but requires complex integration.
   • BIt is cheaper than native reporting because it uses existing licenses.
   • CIt offers advanced analytical capabilities but requires data to be exported or replicated, introducing latency.
   • DIt is easier to implement than native reporting because it requires no data modeling.
   Reveal Solution Discussion Select an answer first