Question 1

Cloud Kicks (CK) wants to use CRM Analytics to analyze trends of its sales pipeline in order to accelerate the company's sales process. To do so, CK needs to know the average time an opportunity

spends in each stage. The data can be found in the Opportunity History object, but the value is not pre-calculated in Salesforce, so a consultant recommends using a recipe to calculate it.

How should the consultant use a recipe to calculate the average time an opportunity spends in each stage?

AAn aggregate transformation with offset parameter to calculate the duration

BFlatten transformation with offset expressions to calculate the duration

CCustom transformation with a multiple row formula to calculate the duration

Answer : C

Question 2

Cloud Kicks has a dashboard that displays accounts and opportunities data in a table that contains actions to open the records in Salesforce. Since the company has allowed several accounts to be

created with the same names, when users try to perform actions, they are prompted with only a record ID to select, leaving the users confused and unable to act.

How should the CRM Analytics consultant solve this problem?

AInsert more fields in the dataset action 'Display Fields' so the users know which account they are acting on.

BDiscuss with the stakeholders If the action Is really necessary for the table.

CAsk the admin to start applying duplicate rules based on the account's Name field.

Answer : A

Question 3

Which timeseries statement will fix the query?

Aq= timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=
('Date_Year', 'Date Quarter', 'Y-Q'), partition='Region', seasonality=4);

Bq = timeserles q generate 'sum_Sales' as 'Forecasted_Sales' with (length=12,
dateCols=('Date_Year', 'Date_Month', 'Y-M'), partition='Region');

Cq = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=
('Date_Quarter', 'Date_Month', 'Q-M'), partition='Region', ignoreLast=true);

Answer : B

Question 4

consultant is tasked with creating an opportunity dataset for a new analytics app. One requirement is to make sure users only see the opportunities they have access to in Salesforce. Opportunity records are private but shared using the role hierarchy. The consultant runs

the sharing inheritance coverage assessment and finds that the VP of sales is not covered by the sharing inheritance. The consultant decides to proceed with using sharing inheritance for the dataset.

What else does the consultant need to do?

ASet the organization-wide default for the Opportunity object to Public Read/Write.

BCreate a manual sharing rule to extend access to the VP of sales from the opportunity record.

CFlatten the role hierarchy in the recipe and set a backup security predicate based on opportunity owner and role path.

Answer : C

Question 5

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?

AUse a 'fill' statement in SAQL query with a 'partition' parameter.

BUse a ''Compare Table' and add a column leveraging the ''Running Total'' function.

CUse a 'Compare Table' and use the 'Show Totals' option.