Study with Analytics-Con-201 Actual Test Questions

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 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.
• 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 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.

A CRM Analytics consultant has prepared a CSV file to be uploaded to CRM Analytics. By mistake, one of the column headers is modified as random non-alphanumeric characters "* & **( & *(%", which went unnoticed prior to uploading the file.
What is the expected behavior of the uploaded CSV column?

• A. The column header is auto-updated to "Column" + column number.
• B. The column header Is set to * & **( & *(%.
• C. The columnheaderis prefixed with "X" upon upload.

CRM Analytics users at Cloud Kicks are granted access to an app with specific dashboards. When trying to download a specific widget, they are unable to do so.

• A. The permission set for the users is missing the download data permission.
• B. The dashboard has been created for internal use and theusers have a view only license.
• C. The users have access to the dashboard but not the dataset.

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?

• A. As part of the recipe, use a formula on the Roleid fildto create an attribute called 'ParentRolelDs' on the dataset, and apply the following security predicate: 'ParentRolelDs' ==''$UserRoleId'' || Owned\ ==
  '$User,id\\,
• B. As part of the recipe, use a multi row formula on the Roleld field to create an attribute called
  'ParentRoleIDs' on the dataset, and apply the following security predicate:"$User.UserRoleld" ||
  'Ownerld' == "$User.Id".
• C. As part of the recipe, use the flatten operation on the role hierarchy, create a multi-value attribute called
  'ParentRoleIDs' on the dataset, and apply the following security predicate: 'ParentRoleIDs' == "$User.
  UserRoleld" || 'TeamMember.Id' '$User, Id" || 'Ownerld' == "$User.Id".

A CRM Analytics consultant is updating an existing recipe.
They are looking to add a few additional fields onto the Account dataset. One of the fields to be added is a multi-select picklist field that needs to be shown as text on the dashboard.
What should the consultant do to accomplish this?

• A. Use the array multivalue function to convert this field to a text prior to registering the dataset.
• B. Use the array_join multivalue runcuen co convert this field to a text prior to registering the dataset.
• C. Use the string multivalue function to convert this field to a text prior to registering the dataset.