Salesforce CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT Online Practice Questions and Exam Preparation

Salesforce CRM-ANALYTICS-AND-EINSTEIN-DISCOVERY-CONSULTANT Online Questions & Answers

• Question 1:

  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 "*and**(and*(%", which went unnoticed prior to uploading the file. What is the expected behavior of the uploaded CSV column?

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

• Question 2:

  Universal Containers has a well-defined role hierarchy in Salesforce where everyone is assigned to an appropriate node. The accounts within their instance are categorized by their demography.

  An individual sales rep should be able to view all accounts that they own. In addition, sales reps should be able to see any accounts where the value of the account demography matches the demography defined on their user record. A user

  could have more than one demography defined on their user record.

  To meet this requirement, the CRM Analytics consultant has set up a security predicate of the existing 'Account' dataset as follows:

  

  This, however, does not seem to be working as expected. What is causing the issue?

  A. The Sales Rep is not provided access permission on custom field Demographic__c on the User object.
  B. The security predicate needs to be updated as 'Ownerld' == "sUser.id" || `Demography' = "$User.Demographic__c'.
  C. The Analytics Security User is not provided access permission on custom field Demographic_c on the User object.
  A. The Sales Rep is not provided access permission on custom field Demographic__c on the User object.

• Question 3:

  AW Computing will start using Tableau Online to report on some of its Salesforce data to users who do NOT have an SFDC license. What is the first step the CRM Analytics consultant should take?

  A. Use MuleSoft to generate an API ta connect and push data from SFDC to Tableau.
  B. Select the output connection in the "write to" option of the recipe.
  C. Enable the Tableau output connection in the Analytics settings.
  C. Enable the Tableau output connection in the Analytics settings.

• Question 4:

  Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.

  The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep,

  the file contains a target for every month of the current year as well as all previous years.

  Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?

  A. Overwrite
  B. Update
  C. Append
  A. Overwrite

• Question 5:

  A project team member uploads a CSV file to CRM Analytics, and they notice a few records failed during the upload. The manager wants to view the error log generated so this can be fixed and uploaded again. The manager has the CRM Analytics administrator permissionbut is unable to download the error log details.

  Why is the manager unable to download the log details?

  A. They do not have the Upload External Data to CRM Analytics permission enabled.
  B. They do not have the Download CRM Analytics Data permission enabled.
  C. Only the user who uploaded the external data file can download the error log.
  C. Only the user who uploaded the external data file can download the error log.

• Question 6:

  Universal Containers is setting up a Sales Analytics app to track the sales performance across all regions. The role hierarchy is well-structured with separate branches for various global regions. Viewer access has been provided to the regional sales reps based on the following roles.

  1. Regional Sales - APAC

  2. Regional Sales - EMEA

  3. Regional Sales - LATAM

  4. Regional Sales - NA

  The CRM Analytics project team receives a request to extend Editor access to the app to 20 'Superusers' across all regions.

  What is the optimal solution?

  A. Create a new public group with these users and assign it the Editor app access.
  B. Create new roles for these users and assign them the Editor app access.
  C. Create a new sharing rule for these users and assign it the Editor app access.
  A. Create a new public group with these users and assign it the Editor app access.

• Question 7:

  Universal Containers' CRM Analytics team is building a dashboard with two widgets, and the queries use different datasets.

  1.List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)

  2.Donut chart widget associated to the query "Query_pie_3" and grouped by the dimension "Type"

  The team wants any selection in the List widget to filter the Donut chart and vice versa. Users should be able to choose more than one Type (multi-selection).

  What is the recommended way to accomplish the required filtering?

  A. Use "Connect Data Sources" to create a mapping of the two fields from the two datasets.
  B. Create a selection based Interaction and apply It to the query of "Query ple 3".
  C. Set up a result and selection based interaction for each query.
  C. Set up a result and selection based interaction for each query.

• Question 8:

  The CRM Analytics consultant at Universal Containers (UC) has set up data sync for the Salesforce Opportunity object with the Amount currency field added. This is being used in multiple datasets and dashboards, as UC is a multi-currency

  organization.

  The currency used in Salesforce records is set up in GBP but the data on the dashboard is converting to USD. Conversion logic is not set up on any of the recipes.

  Why is the currency converting?

  A. The ANS local currency is set up as USD.
  B. The Integration User currency is set up as USD.
  C. The org corporate currency is set up as USD.
  C. The org corporate currency is set up as USD.

• Question 9:

  A CRM Analytics administrator is working on deploying a dashboard and a dataset from a developer sandbox to a full sandbox. They have deployed the dataset via change set and manually copy-pasted the dashboard JSON into the target org. However, they notice that the conditional formatting and the widget-specific number formats have been lost in the target environment.

  What is causing this issue?

  A. Analytics Dataset XMD was NOT included as part of the deployment package,
  B. The recipe that generated the dataset also needs to be included as part of the package.
  C. Analytics Dashboard XMD was NOT included as part of the deployment package.
  A. Analytics Dataset XMD was NOT included as part of the deployment package,

• Question 10:

  In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.

  How should the consultant accomplish this?

  A. Create an XMD node in the recipe to change the label and color of the values in the fields.
  B. In the explorer's field panel, select the boolean fields and use the "edit values" option on the fields to change values and colors.
  C. Select the boolean fields in the explorer's field panel, select the boolean fields, then create a derived dimension.
  B. In the explorer's field panel, select the boolean fields and use the "edit values" option on the fields to change values and colors.