問題文
A monthly delivery of nine million rows must be handed to a data warehouse. A team member proposes scheduling a report and letting the report output be picked up as the delivery. Which extraction method should be used for this monthly delivery?
選択肢
- A list view export, since a list view can be filtered to the same rows the report would have shown and exported by the same person each month, and the nine million rows are written out in a single file for the warehouse.
- The synchronous export of the desktop loader with the export unit raised as high as it goes, because the desktop loader reads through the whole result set in pages and therefore has no practical upper limit on the number of rows it can deliver.
- The query capability of the bulk framework, because a result set of this size exceeds what a report can return and a report is also shaped by the access of whoever runs it.
- A scheduled report, provided it runs at night when the org is quiet, with the output collected from the subscription email at the start of each month.