Given a Customer Scenario, Recommend Approaches for Leveraging Salesforce (and Partner) Analytics Offerings to Enhance/optimize Customer's Enterprise Analytics Capabilities as Well as Recommending Techniques to Maintain the Desired Performance Level (SOQL Queries, Reports) Given Customer's Large Data Volumes. DATA-ARCHITECT Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   A developer is writing a SOQL query that filters on a custom field that is not indexed. To optimize performance on a large object, which technique is most appropriate?

   • AAdd a filter on an indexed field such as Id or an external ID in addition to the custom field
   • BUse a non-selective filter on the custom field alone
   • CRemove all filters and query all records
   • DUse a wildcard in the filter to match more records
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A Salesforce org has a large data volume that is slowing down reports. Which data volume management strategy is most appropriate for historical data that is rarely accessed?

   • AUse a skinny table to store all historical data
   • BArchive the historical data to an external storage system
   • CKeep all historical data in Salesforce to avoid data loss
   • DCreate more reports on the historical data
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   A report is running slowly, and the architect wants to see if the slowness is due to a specific dashboard component. Which monitoring tool would be most useful?

   • AEvent Monitoring
   • BSalesforce Optimizer
   • CDebug logs
   • DData Export Service
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A retail company wants to give its store managers a daily snapshot of sales performance, including sales by product, store, and employee. The managers are not technical and need a simple, easy-to-use interface. The company has a small budget and wants to minimize additional licensing costs. Which solution should a data architect recommend?

   • AUse CRM Analytics to build a custom dashboard with advanced visualizations.
   • BUse Tableau to create a dashboard and publish it to Tableau Public.
   • CUse standard Salesforce reports and dashboards with a scheduled email delivery.
   • DUse Salesforce Connect to create external objects and build reports on them.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   A report on a large data volume is running slowly. Which technique is most effective for improving report performance?

   • ARemove all filters from the report
   • BUse a summary report with pre-aggregated data
   • CAdd more columns to the report
   • DUse a tabular report with all detail rows
   Reveal Solution Discussion Select an answer first