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

Questions 6–10

1. 6foundation · easy

   During requirements analysis for an analytics solution, a customer states that business users need to explore data interactively and create their own visualizations without writing code. Which requirement is most important to capture?

   • AThe level of user self-service and technical skill
   • BThe physical location of the customer's headquarters
   • CThe color scheme of the company logo
   • DThe number of Salesforce licenses the customer owns
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A large retail company uses Salesforce for sales transactions and stores product inventory in an external data warehouse. The sales team needs to analyze sales trends alongside inventory levels to identify stockouts. They want a solution that allows them to combine these data sources in a single analytics tool with minimal custom development. Which approach should a data architect recommend?

   • ACreate a custom Apex integration to sync external inventory data into custom objects in Salesforce, then use standard reports.
   • BExport Salesforce data to the external warehouse and build reports there using the warehouse's native BI tool.
   • CUse CRM Analytics with a dataflow that connects to the external warehouse via a connector and joins it with Salesforce data.
   • DUse Tableau Desktop to connect directly to both Salesforce and the warehouse, but require users to manually refresh data.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A marketing agency reports that a SOQL query used in a Lightning component is timing out. The query filters on a custom field 'Lead_Source__c' that is not indexed. The data architect needs to diagnose the issue. Which tool should the architect use to confirm that the query is non-selective?

   • ACheck the dashboard cache status to see if the query is cached.
   • BUse the Event Monitoring feature to track query performance.
   • CUse the Query Plan tool in the Developer Console to see the query's execution plan.
   • DEnable debug logs for the Lightning component and analyze the logs.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A sales operations team reports that a specific report is running slowly. The report joins multiple objects and filters on a custom field that is not indexed. The data architect needs to identify the cause of the slow performance. Which tool or log should the architect use first?

   • ACheck the dashboard cache status to see if the report is being cached.
   • BUse the Developer Console's Query Plan tool to analyze the SOQL query behind the report.
   • CEnable debug logs for the report and analyze the execution time.
   • DUse the Event Monitoring feature to track report views and performance.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A manufacturing company has a custom object 'Work_Order__c' with 100 million records. Users need to run reports and SOQL queries on recent work orders, but the large data volume is causing performance issues. The company wants to retain historical data for compliance but does not need it for daily operations. Which strategy should a data architect recommend?

   • AUse the 'WITH SYSTEM_MODE' clause to bypass sharing rules and improve query performance.
   • BCreate a skinny table with only the fields needed for reporting and query that table.
   • CArchive records older than a defined period to an external data store and delete them from Salesforce.
   • DUse a custom index on the 'CreatedDate' field to speed up queries on recent records.
   Reveal Solution Discussion Select an answer first