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 3)

Questions 11–15

1. 11expert · hard

   A manufacturing company has a dashboard with multiple reports that aggregate production data. The dashboard is slow, and the data architect has already implemented summary formulas and caching. The dashboard is still slow because the underlying reports query a large custom object with millions of records. The company wants to keep the data in Salesforce for operational reporting but is willing to move historical data to an external store. Which additional action should the architect take?

   • AArchive historical records to an external data store and delete them from Salesforce.
   • BAdd more custom indexes on the fields used in the report filters.
   • CUse the 'WITH SYSTEM_MODE' clause in the report's underlying SOQL query.
   • DIncrease the dashboard refresh frequency to keep data fresh.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A data architect needs to identify which SOQL queries are taking the longest time in a Salesforce org. Which tool or log would provide this information?

   • AEvent Monitoring
   • BDebug logs
   • CReport Builder
   • DSalesforce Optimizer
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A large e-commerce company has a custom object 'Order__c' with 500 million records. They need to run real-time SOQL queries for order status checks and also generate daily sales reports. The company is experiencing performance issues with both. The data architect has already implemented archiving and skinny tables. Which additional strategy should the architect consider?

   • AUse a separate external data store for historical orders and keep only recent orders in Salesforce.
   • BUse a custom index on every field used in SOQL queries and reports.
   • CUse a dashboard with more components to display more data at once.
   • DUse the 'WITH SYSTEM_MODE' clause in all SOQL queries to bypass sharing rules.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   A data architect is comparing analytics tools for a customer that needs to embed interactive dashboards directly inside Salesforce records. Which Salesforce-native analytics offering is designed for this purpose?

   • ACRM Analytics (formerly Einstein Analytics)
   • BEinstein Discovery
   • CTableau Desktop
   • DSalesforce Reports and Dashboards
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   A customer needs analytics that combine Salesforce data with data from an external data warehouse and deliver dashboards to executives via mobile devices. Which requirement is most critical to document during requirements analysis?

   • AThe customer's annual revenue
   • BThe data sources and the target audience for the dashboards
   • CThe customer's preferred programming language
   • DThe number of Salesforce administrators
   Reveal Solution Discussion Select an answer first