ANC-301試験無料問題集「Salesforce Implement and Manage Tableau CRM 認定」
Exhibit.
Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?
Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?
正解：A
解答を投票する
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?
How should a CRM Analytics consultant help UC build this lens?
正解：A
解答を投票する
A CRM Analytics consultant has been asked to refactor a dashboard so that it loads quicker. After some analysis, the consultant found that most of the dashboard queries run in less than 5 seconds; however, the Opportunities Table takes more time to load when scrolled down from its initial view.
How should the consultant improve the performance of this dashboard?
How should the consultant improve the performance of this dashboard?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
An CRM Analytics consultant is working with Ursa Major Solar to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account should only have one active subscription. The consultant notices the Opportunity record does NOT specify whether it is a renewal or a net new subscription.
Which data transformation should the consultant use to determine if a subscription is new or a renewal?
Which data transformation should the consultant use to determine if a subscription is new or a renewal?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
A CRM Analytics administrator is working on deploying a dashboard and a dataset from a developer sandbox to a full sandbox. They have deployed the dataset via change set and manually copy-pasted the dashboard JSON into the target org. However, they notice that the conditional formatting and the widget-specific number formats have been lost in the target environment.
What is causing this issue?
What is causing this issue?
正解：C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
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?
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?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
At Universal Containers, a dashboard is built to track sales metrics. The Opportunity amount field has conditional formatting added - it turns green for closed won and red for closed lost.
How should a CRM Analytics consultant enhance the dashboard design to become more accessible to users with color vision challenges?
How should a CRM Analytics consultant enhance the dashboard design to become more accessible to users with color vision challenges?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)