Free Salesforce ANC-301 Exam Dumps Questions & Answers

The CRM Analytics consultant at Cloud Kicks (CK) notices that a specific dashboard is showing a different date and time from their locale. Upon investigating, they find that the recipe and datasets were created from a locale with a PST time zone while CK is in the CET time zone.
What led to this problem?

• A.The developer turned off dynamic time zone in CRM Analytics settings.
• B.The dataset metadata locale Is not overridden by Individual user locale settings.
• C.Data within datasets is modified for localization or internationalization.

Universal Containers (UC) is rolling out CRM Analytics to its field sales that include dashboards withorder data from an external source.
UC has a well-defined role hierarchy where everyone is assigned to an appropriate node on the hierarchy. In addition, the order data has a reference to a Salesforce opportunity.
An individual sales rep should be able to view all orders that they own or as part of the account team or opportunity team. The sales manager should be able to view all orders for the entire sales team. Similarly, the VP of sales should be able to view orders for everyone who rolls up in that hierarchy.
The dataset has a field called Ownerld which represents the order owner.
Given this information, how should a CRM Analytics consultant implement the above requirements?

• A.As part of the recipe, use the flatten operation on the role hierarchy, create a multi-value attribute called 'ParentRoleIDs' on the dataset, and apply the following security predicate: 'ParentRoleIDs' == "$User.UserRoleld" || 'TeamMember.Id' '$User, Id" || 'Ownerld' == "$User.Id".
• B.As part of the recipe, use a formula on the Roleid fild to create an attribute called 'ParentRolelDs' on the dataset, and apply the following security predicate: 'ParentRolelDs' == ''$UserRoleId'' || Owned\ == '$User,id\\,
• C.As part of the recipe, use a multi row formula on the Roleld field to create an attribute called 'ParentRoleIDs' on the dataset, and apply the following security predicate: "$User.UserRoleld" || 'Ownerld' == "$User.Id".

Universal Containers' CRM Analytics team is building a dashboard with two widgets.
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 "Step_pie_3" and grouped by the dimension "Type" The team wants to use bindings/interactions so any selection in the List widget will filter the Donut chart. The queries use different datasets, and users should be able to choose more than one Type (multi-selection).
What is the right syntax for the binding/interaction?

• A.
• B.
• C.

In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
How should the consultant accomplish this?

• A.In the explorer's field panel, select the boolean fields and use the "edit values" option on the fields to change values and colors.
• B.Select the boolean fields in the explorer's field panel, select the boolean fields, then create a derived dimension.
• C.Create an XMD node in the recipe to change the label and color of the values in the fields.

Which timeseries statement will fix the query?

• A.q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols= ('Date_Quarter', 'Date_Month', "Q-M"), partition='Region', ignoreLast=true);
• B.q= timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols= ('Date_Year', 'Date Quarter', "Y-Q"), partition='Region', seasonality=4);
• C.q = timeserles q generate 'sum_Sales' as 'Forecasted_Sales' with (length=12, dateCols=("Date_Year', 'Date_Month', "Y-M"), partition='Region');