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 questionsBig 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.
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.
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."
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
