DATA-ARCHITECT practice question 9 of 35

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement?

Full set: 257 questions
Answer options
A: Standard reports and dashboards
B: Async SOQL with a custom object Correct answer
C: Standard SOQL queries
D: Einstein Analytics Correct answer
Correct Answer:
B. Async SOQL with a custom object; D. Einstein Analytics
Explanation

Big Objects are designed to store massive datasets on the Salesforce platform but have specific query and reporting limitations. The two primary native methods for reporting on them are:
1. Async SOQL: This is used to run queries against Big Objects, which can process huge volumes of data in the background. The results of an Async SOQL query can be directed to a standard or custom object, which can then be used as a source for standard Salesforce reports and dashboards.
2. CRM Analytics (formerly Einstein Analytics): This advanced analytics platform can directly connect to and query Big Objects. It is designed to handle large datasets and provides sophisticated visualization and dashboarding capabilities well beyond standard reports.

Why Incorrect

A. Standard reports and dashboards Standard Salesforce reports and dashboards cannot directly query or source data from Big Objects due to their scale and architecture.
C. Standard SOQL queries Standard, synchronous SOQL is not supported for querying Big Objects. Only Async SOQL can be used to process queries against the large volumes of data they contain.

References

1. Salesforce Developer Documentation, Big Objects Implementation Guide, "Query Big Objects". The guide explicitly states, "Use Async SOQL to process the large amounts of data in a big object... You can’t use standard SOQL with a big object."

2. Salesforce Developer Documentation, Async SOQL. The documentation details how to use Async SOQL to query Big Objects and output the results to an object. "The target object can be a standard object, a custom object, or a big object."

3. Salesforce Help, CRM Analytics and Big Objects. The documentation states, "CRM Analytics can access and analyze data in big objects without having to first copy the data into a dataset. With direct access to big object data, CRM Analytics can query and explore billions of rows of data in seconds."

Scroll to Top