SF-Data-Arch Salesforce Data Management Practice Question
Universal Containers uses a Big Object named 'Log__b' to store audit trails. They need to generate a report that aggregates this data weekly for compliance. Standard SOQL queries are failing due to the volume of records. What should the architect recommend?
⚠ Common exam trap
Candidates often suggest using standard SOQL or Async SOQL, forgetting that Async SOQL has been retired and standard SOQL cannot perform aggregations on massive Big Object datasets.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use CRM Analytics (formerly Tableau CRM) to ingest and aggregate the data.
Big Objects are optimized for massive scale but do not support standard SOQL features like aggregate functions or complex filtering over large sets. Async SOQL was the historical solution, but it has been retired. The modern recommendation is to use CRM Analytics or external reporting tools to process Big Object data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a Skinny Table on the Big Object to improve query performance.
Why it's wrong here
Skinny Tables are not available for Big Objects. Skinny Tables are a performance optimization for standard and custom objects that contain a high volume of records and frequently used fields, but they do not apply to the specialized architecture of Big Object storage.
- ✓
Use CRM Analytics (formerly Tableau CRM) to ingest and aggregate the data.
Why this is correct
CRM Analytics is designed to handle and aggregate massive datasets that exceed standard Salesforce limits. It can ingest data from Big Objects and perform complex aggregations and visualizations, making it the preferred architectural choice for reporting on high-volume audit logs or historical data.
- ✗
Create a Summary Report in Salesforce and schedule it for weekly delivery.
Why it's wrong here
Standard Salesforce reports cannot access Big Objects directly. Big Objects are not available as source objects in the report builder, and even if they were, the volume of data would likely exceed report execution limits, leading to timeouts or incomplete data in the compliance report.
- ✗
Write an Apex batch job to query the Big Object using the 'GROUP BY' clause.
Why it's wrong here
SOQL queries against Big Objects do not support the 'GROUP BY' clause. Furthermore, Apex batch jobs would still be subject to the query limitations of Big Objects, which require filtering by the defined index and do not allow for the broad aggregations required for weekly compliance reporting.
About these practice questions
One of 222 original SF-Data-Arch practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Data-Arch practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Data-Arch exam.