Free Practice Salesforce ANC-201 Exam Questions 2025

ExhibitUniversal 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?

Which capability can a consultant use if “Deploy without connecting to a Salesforce Object” is selected while deploying the model?

Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps' objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company's org. Which CRM Analytics user interface features should be used to complete these requirements?

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?

The CRM Analytics project team at Universal Containers is creating an app with dashboards, datasets, and lenses. The app has been shared with multiple users with Viewer, Editor, and/or Manager access. One end user is unable to view the dashboard watchlist that was previously set up. They are receiving a “Resource not found” error while trying to access the dashboard. The team confirms that the end user has Viewer access to the app but the project team is able to view the dashboard. What is the reason for this error?