Free CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT Web TestEngine Demo

Q11 Single choice

Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

How should a CRM Analytics consultant help UC build this lens?

A
Use a "Compare Table" and add a column leveraging the "Running Total" function.
B
Use a "Compare Table" and use the "Show summary" option.
C
Use a SAQL query leveraging the "fill" statement with a "partition" parameter.
D
Use a SAQL query to create fake rows for any data that is missing data from the dataset.

CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT Web TestEngine demo