Salesforce ANC-201 Exam Practice Test Instant Access

Question 1

Universal Containers' CRM Analytics team is building a dashboard with two widgets, and the queries use different datasets.

1. List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)

2. Donut chart widget associated to the query "Query_pie_3" and grouped by the dimension "Type"

The team wants any selection in the List widget to filter the Donut chart and vice vers

a. Users should be able to choose more than one Type (multi-selection).

What is the recommended way to accomplish the required filtering?

AUse 'Connect Data Sources' to create a mapping of the two fields from the two datasets.

BCreate a selection based Interaction and apply It to the query of 'Query ple 3'.

CSet up a result and selection based interaction for each query.

Answer : C

Question 2

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

Question 3

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 4

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 5

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 6

Which recommended technique should a CRM Analytics consultant

use to access CRM Analytics data from a remote app or website?

AUse HTTPS to call the /wave/query API, supplying an encoded SAQL query as a parameter.

BUse an iFrame to embed the Salesforce page in a remote site.

CExport the data to a CSV file and load it on the remote site.

Answer : A

Question 7

Universal Containers builds a new sales dashboard and wants to make sure account managers can access the dashboard while traveling.

What should the consultant consider doing in this process?

AA Set the optimal Dashboard width for the Phone layout to get a more accurate preview.

BMake sure the dashboard automatically is optimized for mobile viewing.

CEnable mobile optimization in the analytics settings under Setup.

Answer : A

Salesforce ANC-201 Building Lenses, Dashboards, and Apps in CRM Analytics Exam Practice Test