Question 1

Universal Containers (UC) recently activated data sync in the CRM Analytics data manager. After running the sync, UC notices that the aggregate sum of a field within the company's dataset is different

than what they manually calculated by summing the same data in the Salesforce object.

What is causing the issue with the newly synced data?

ADifferences involving flow-updated fields

BDifferences involving formula fields

CDifferences involving trigger-updated fields

Answer : B

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.

Answer : B

Free Practice Questions for Salesforce ANC-301 Exam

Question 1

Question 2

Question 3

Question 4

Question 5