Salesforce Salesforce Consultant TABLEAU-CRM-AND-EINSTEIN-DISCOVERY-CONSULTANT Questions & Answers

• Question 21:

  In an org, some of the Activity records do not have related Opportunity records. Additionally, there are Opportunity records that do not have related Activity records.

  Which SAQL statement will fetch all Opportunities, even if they don't have associated Activities, and fetchrelated Activity data, if it exists?

  A. q = cogroup Opportunity by 'Id', Activities by 'Opportunityld';

  B. q = cogroup Opportunity by 'Id', Activities by 'Opportunityld' left;

  C. q = cogroup Opportunity by 'Id' right, Activities by 'Opportunityld';

  D. q =cogroup Opportunity by 'Id' left, Activities by 'Opportunityld';

  Correct Answer: D

  https://developer.salesforce.com/docs/atlas.en- us.bi_dev_guide_saql.meta/bi_dev_guide_saql/ bi_saql_statement_cogroup.htm

• Question 22:

  A company used Einstein Analytics to create two datasets:

  1.

  "Opportunity With Account- dataset, whichcontains data from the Opportunity standard object augmented by the Account data.

  2.

  "Case with Account" dataset. which contains data from the Case standard object augmented by the Account data.

  The company wants to build a lens showing the total numberof Opportunities and Cases per Account. How can a consultant help them build this lens'

  A. Create a recipe to generate a new dataset from the "OpportunityWithAccount" and "CaseWithAccount" datasets aggregated by Account, and use the generated dataset in alens.

  B. Use "Compare Table" to join the "OpportunityWithAccount" and "CaseWithAccount" datasets using the "Accountld" and then aggregate by Account.

  C. Set up Connect Data Sources in the UI between the "OpportunityWithAccount" and "CaseWithAccount" datasets.

  D. Use a SAQL query to group and join the "OpportunityWithAccount" and "CaseWithAccount" datasets then generate the results.

  Correct Answer: D

• Question 23:

  A data architect wants to use a dataflow transformation to implement row-level security that is based on role hierarchy in Salesforce. Which transformation should be used to level the dataset hierarchy'

  A. digest transformation

  B. flatten transformation

  C. delta transformation

  D. sfdcDigest transformation

  Correct Answer: B

• Question 24:

  The Universal Containers Einstein Analytics team built a dashboard with two widgets:

  1.

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

  2.

  Pie chart widget associated to the step "Step_pie_3" and grouped by the dimension "Type"

  The team wants to use bindings so any selection in the List widget will filterthe Pie chart. Additional notes:

  1.

  The steps use different datasets.

  2.

  Users should be able to choose more than one Type (multi-selection). What is the right syntax for the binding?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 25:

  Is there a need for a separate Permission SetLicence for an Analytics app?

  A. Yes

  B. No

  Correct Answer: A

• Question 26:

  Number of queries per user per day

  A. 10,000

  B. 50,000

  C. 1,000

  D. 20,000

  Correct Answer: A

• Question 27:

  An Einstein Analytics team wants to create a dashboard that displays values from an external, on-premise Oracle database.

  What are two options to load the data from the Oracle database into Einstein Analytics? Choose 2 answers

  A. Use theSalesforce SOAP interface.

  B. Use the Analytics External Data API.

  C. Use Oracle database connector.

  D. Load the data as a CSV file.

  Correct Answer: BC

• Question 28:

  An Einstein Analytics team reports that when they start their dataflow it runs successfully with no errors or warnings, but one of the fields does not return values when it is queried.

  What can be the origin of this issue7

  A. Thefield does not contain any data in Salesforce.

  B. The user who runs the dataflow does not have access to the field.

  C. The "Integration User Profile" does not have access to the field.

  D. The ""Security User Profile" does not have access to the field.

  Correct Answer: A

• Question 29:

  The Universal Containers company used Einstein Analytics to create two datasets:

  Dataset A: contains a list of activities with an "activitylD" dimension and a "userlD" dimension Dataset B: contains a list of users with a "userlD" dimension

  The team wants to delete from Dataset A all activities related to users in Dataset B.

  How can an Einstein Consultant help them achieve this?

  A. Use the dataflow transformation "delete"and set "userlD" as the deletion ID.

  B. Use a combination of dataflow transformations: "augment" and "filter."

  C. Use an external ETL tool to extract both datasets and delete records.

  D. Use the recipe operation "delete" and set "userlD" as the deletion ID.

  Correct Answer: B

• Question 30:

  Universal Containers (UC) is a multinational company that utilizes Salesforce and has avariety of internal systems. UC uses Einstein Analytics for their data analysis platform and they want to automate their weekly manual process to create a dataset from their on- premise data warehouse. Which solution should a consultant recommend to meet this requirement?

  A. Utilize a Salesforce weekly export feature

  B. Utilize Analytics Connector.

  C. Utilize middleware with Analytics External Data API

  D. Utilize a dataflow

  Correct Answer: C