Free Salesforce ANC-301 Exam Questions

A data architect wants to use a recipe transformation to implement row level security based on role hierarchy in Salesforce. Which transformation should the architect use to level the dataset hierarchy?

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?  

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?

A data architect wants to use a recipe transformation to implement row level security based on role hierarchy in Salesforce. Which transformation should the architect use to level the dataset hierarchy?

A company realizes it has a lot of rich information around its cases, but unfortunately, most of this isunstructured/textual data. Thecompany is exploring how to include some of this information in its case prioritization. Which option within CRM Analytics should a consultant leverage?