Salesforce - Priscilla Hong

Question 1:

To model customer value, a consultant decided to aggregate the amount ($) individual customers spent over a 2-year span. With reference to the outcome variable, which action should the consultant take?

A. Create five bins of revenues, ranging from Very High Value, High Value, Average Value, Low Value, and Very Low Value in the dataflow.

B. Select the option： Are you expecting a whole number greater than or equal to 0?

C. Select to minimize the outcome variable.

D. Create five bins of revenues, ranging from Very High Value, High Value, Average Value, Low Value, and Very Low Value in data prep.

Answer: B

Question 2:

A training dataset is being prepared for Einstein Discovery story. One of its predictor (input) fields is skewed with outliers. What action should the Einstein consultant take?

A.    Remove the field because it has bad data.

B.    Nothing, because the field is not the outcome variable.

C.    Change the method of binning to fixed width.

D.    Remove the outlier rows.

Answer: C

Question 3:

A consultant built a Tableau CRM Dashboard for a company. The company then requested an enhancement to the dashboard and provided additional data that needs to be displayed. As a result, the consultant decides to 'augment' the dataflow. Which phrase describes this transformation?

A.    Add data as a lookup relationship (left side is the lowest grain)

B.    Add data based on the right-side grain

C.    Join data similar to an SQL statement

D.    Join data based on a many-to-many relationship

Answer: A

Question 4:

In Tableau CRM, which node is used in a dataflow to extract data from a registered dataset?

A.    export

B.    edgemart

C.    digest

D.    sfdcDigest

Answer: B

Question 5:

The edgemart transformation gives the dataflow access to an existing, registered dataset that can contain Salesforce data, external data, or a combination of both. Where is an edgemart transformation specified?

A.    Query Editor

B.    Settings

C.    Dataflow Editor

D.    Recipes Editor

Answer: C

Explanation:https://help.salesforce.com/s/articleView?id=sf.bi_integrate_edgemart_transformation.htm&language=en_US&r=https%3A%2F%2Fwww.google.com%2F&type=5

Question 6:

A Tableau CRM Consultant is working with a subscriptions based company to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account can only have one active subscription. Unfortunately the Opportunity record does not specify whether it is a renewal or a net new subscription. Which data transformation should be used to determine if a subscription is new or a renewal?

A. computeRelative

B. flatten

C. augment

D. computeExpression

Answer: A

Question 7:

A Tableau CRM consultant decides to use a recipe to create a new dataset. Which two source types can be used for the recipe? Choose 2 answers

A.    Connected data (Synced)

B.    Existing datasets

C.    Records from a Salesforce object

D.    Dataset lens

Answer: A, B

Question 8:

The edgemart transformation gives the dataflow access to an existing, registered dataset that can contain Salesforce data, external data, or a combination of both. Where is an edgemart transformation specified?

A.    Dataflow Editor

B.    Recipes Editor

C.    Step Editor

D.    Settings

Answer: A

Explanation: https://help.salesforce.com/articleView?id=bi_integrate_edgemart_transformation.htm&type=5

Question 9:

What can you do with the dataflow?

A.    Extract data from an external CSV file into Analytics

B.    Extract Salesforce object data into Analytics

C.    Build a dashboard

D.    Explore a dataset

Answer: B

Question 10:

Universal Containers (UC) is a multinational company that utilizes Salesforce and has a variety of internal systems. UC uses Tableau CRM 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

Answer: C