Absolute Free Analytics-Con-201 Exam Practice for Comprehensive Preparation 

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?

A CRM Analytics consultant has been asked to bring data from an external database as well as five external Salesforce environments into CRMAnalytics. Twenty-five objects have been enabled from the local Salesforce connector. The requirements are: * 10 objects should be enabled from an external database * 12 objects each from three of the external Salesforce environments * 15 objects each from the remaining two external Salesforce environments The consultant estimates each connector will, per object, bring between 1,000 and 1 million rows of data. Which limit will be exceeded?