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

Questions 1–5

1. 1foundation · easy

   When designing an analytics architecture that must scale to support thousands of users and large data volumes, which design principle is most important?

   • ASeparate the data storage layer from the analytics processing layer
   • BAvoid using any external data sources
   • CUse only real-time data connections
   • DStore all data in a single Salesforce org
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which data volume management technique is designed to improve query performance by storing a subset of frequently accessed fields in a separate, optimized table?

   • AData archiving
   • BSkinny table
   • CReport summarization
   • DExternal data storage
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A data architect is designing an enterprise analytics architecture that must combine Salesforce data with data from an external data lake. Which approach is most appropriate for this integration?

   • AUse Salesforce Reports to query the external data lake directly
   • BUse a data integration tool to extract Salesforce data into the data lake and then connect the analytics tool to the data lake
   • CStore all external data in Salesforce custom objects
   • DUse a point-to-point connection between Salesforce and the analytics tool without any data movement
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A customer wants to perform advanced data visualization and analysis on data from multiple sources, including Salesforce and an external data warehouse. They do not require the dashboards to be embedded inside Salesforce. Which analytics tool is most appropriate for this scenario?

   • ACRM Analytics
   • BSalesforce Reports
   • CEinstein Discovery
   • DTableau
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A dashboard is loading slowly because it queries a large dataset every time a user opens it. Which optimization technique would most directly reduce the load time?

   • ARemove all filters from the underlying report
   • BIncrease the number of dashboard components
   • CUse a dashboard filter that shows all data
   • DEnable dashboard caching or use a scheduled refresh
   Reveal Solution Discussion Select an answer first