Cloud Kicks needs a CRM Analytics consultant to install the Appointment Analytics App. After installation, they realize the wrong field was picked and the app did not have access to a newly created field that should be used instead of the old one.
What is the first step the consultant should take to prevent erroneous dataset/dashboard creation?

• A. Stop the recipe from running in Data Manager.
• B. Update the app with the new field after installation.
• C. Cancel running installations from Setup

Universal Containers wants to create two dashboards and has two user groups. The 'Regional Performance' dashboard should be accessible to sales reps and managers/executives to keep track of how sales reps are performing in each region. Sales reps must only be able to see data pertaining to their respective region. The 'National Performance' dashboard is using the same data as the other dashboard but should only be accessible to managers/executives to compare data across all regions.
In addition to row-level security to view only regional data, how should a consultant ensure that sales reps are unable to view the 'National Performance' dashboard?

• A. Create two datasets, one app; store both 'Regional Performance' dashboard, 'National Performance' dashboard, and dataset in the app; and provide access to both user groups to this app.
• B. Create one dataset, one app; store both 'Regional Performance' dashboard, 'National Performance' dashboard, and dataset in the app; and provide access to both user groups to this app. Use row-level security to restrict sales repsfrom seeing data in 'National Performance' dashboard.
• C. Create one dataset, two apps; store 'Regional Performance' dashboard and dataset In one app; and provide access to both user groups to this app. Store 'National Performance' dashboard in another app and only provide access tomanagers/executives.

A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data wasuploaded successfully. Upon analyzing the data using a lens, they find they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.
What is causing the problem?

• A. JSON metadata file was not uploaded along with the CSV data file.
• B. The field value added in the CSV file was contained within double quotes.
• C. Proper transformations need to be performed at the external source prior to External Data API callout.

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 "fill" statement in SAQL query with a "partition" parameter.
• B. Use a "Compare Table" and add a column leveraging the "Running Total" function.
• C. Use a "Compare Table" and use the "Show Totals" option.

The marketing team at Cloud Kicks has five dashboards in an app. Four widgets are replicas of each other in three of the dashboards.
What is the best way to maintain these widgets?

• A. Create/Edit a component for the widgets.
• B. Create/Edit the widgets individually on each dashboard.
• C. Create/Edit a lens and add each dashboard.