DEX-403 practice question 11 of 35

Which two report formats can be used as a source report to configure a reporting snapshot? Choose 2 answers

Full set: 291 questions
Answer options
A: Tabular format Correct answer
B: Summary format Correct answer
C: Joined format
D: Matrix format
Correct Answer:
A. Tabular format; B. Summary format
Explanation

A reporting snapshot captures data from a source report at a specific point in time and loads it into a target custom object. According to Salesforce documentation, the source report for a reporting snapshot must be either a tabular or a summary report. These formats provide a straightforward, row-based structure that can be easily mapped to the fields of the target custom object. More complex report formats like matrix and joined reports are not supported for this feature due to their multi-dimensional or combined data structures, which complicate the direct mapping process.

Why Incorrect

C. Joined format: Joined reports combine data from multiple report types in different blocks and are explicitly not supported as a source for reporting snapshots.
D. Matrix format: Matrix reports summarize data in a grid format, similar to a pivot table, which is incompatible with the row-to-field mapping required by reporting snapshots.

References

1. Salesforce Help Documentation, "Set Up a Reporting Snapshot": Under Step 1, "Create a Source Report," the documentation states, "The source report must be in tabular or summary format."

2. Salesforce Help Documentation, "Reporting Snapshot Limitations": This article explicitly lists limitations, stating, "The source report must be a tabular or summary report. Matrix and joined reports aren't supported as source reports."

3. Salesforce Help Documentation, "Reporting Snapshots": The overview section implicitly supports this by describing the process as mapping columns from a source report to fields on a custom object, a process best suited for the linear structure of tabular and summary reports.

Scroll to Top