Explanation/Reference:
B: The Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they're used when appropriate.
C: The wizard then shows me a preview of the script it's going to generate, and asks me if I want to create any more summaries. Here's how the preview script looks - note that it's not SQL, it's a script language that the BI Server understands and uses as the specification for an aggregation job, which it then turns into separate CREATE TABLE, INSERT ... SELECT and so on SQL statements, "optimized" for the particular back-end database platform.
Script example:
"ag_Items"
for "Seminar - Complete"."Items"("Quantity")
at levels ("Seminar - Complete"."Customerdim"."State", "Seminar - Complete"."Productdim"."Category",
"Seminar - Complete"."Timedim"."Year")
using connection pool "custdw"."CUSTDW_Pool"
in "custdw".."CUSTDW";
Incorrect answers:
A: Not required.