Universal Containers has a single dataset that contains the attainment and commission fields for all sales reps. Each sales rep should be able view the attainment data for each rep in their division. Each rep should only be able to see their own commission dat a.
Which option should a CRM Analytics consultant use to enforce this requirement?

• A. Utilize a single dataset and apply security predicates and/or sharing inheritance.
• B. Add the sales organization to the attainment dataset access list to be able to view commission data.
• C. Create separate datasets for attainment and commission, and apply security Predicates and/or sharing inheritance.

The CRM Analytics consultant at Universal Containers has set data syncs and recipe runs back to back. However, they notice that the data syncs and recipe run jobs fail repeatedly. Upon investigation, they realize the data syncs and recipes are tightly coupled which leads to too many runs being queued and eventually being canceled.
How should the consultant resolve this issue?

• A. Enable priority scheduling to automatically queue shorter or smaller runs before longer or larger ones.
• B. Set up failure notifications so that the CRM Analytics consultant gets notified when this happens and can fix the Issue.
• C. Raise a case with Salesforce Support to help Increase the concurrency limits of the org.

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?

• A. Use a "Compare Table" and add a column leveraging the "Running Total" function.
• B. Use a "fill" statement in SAQL query with a "partition" parameter.
• C. Use a "Compare Table" and use the "Show Totals" option.

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?

• A. CRM Analytics Connector for Excel used in conjunction with dataflows/recipes
• B. Microsoft Azure SQL Data Warehouse Connector used in Conjuction with dataflows/recipes
• C. Analytics REST API used in conjunction with dataflows/recipes.

A versioning feature allows CRM Analytics users to be added as Publishers and make changes separately while a 'Live' version is still being used by other users. Once the changes are complete, the user can then set their updated version as the Live version.
Which CRM Analytics item is this leveraged for?

• A. App
• B. goats
• C. Dataset