Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Salesforce Consultant Tableau-CRM-and-Einstein-Discovery-Consultant Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Tableau-CRM-and-Einstein-Discovery-Consultant Premium Access

View all detail and faqs for the Tableau-CRM-and-Einstein-Discovery-Consultant exam

Go to Exam

664 Students Passed

95% Average Score

92% Same Questions

Viewing page 5 out of 8 pages

Viewing questions 41-50 out of questions

Questions # 41:

Philip adds a recently created Seed Bank Orders dataset to an Einstein Analytics app forwhich the Mosaic Seed Bank project team has the Viewer app role. How much data in the Seed Bank Orders dataset can a project team member see?

Options:

None of the data

Only rows designated by the Salesforce administrator

All rows and fields in the datasets

Only rows designated by the App Manager

Questions # 42:

A consultant built an Einstein Analytics app for the Sales Operations team. The Sales Operations team wants to share their app with other people at the company. The consultant recommends distributing the app as an Einstein Analytics template app.

What can the consultant do to give the Sales team more choices and options with future apps that are generated from the Sales Operations app'

Options:

Update contents in the Sales Operations app and changes will be pushed down to its generated apps.

Ensure the Sales team has the necessary permissions to customize their apps.

Create a configuration wizard for the app.

Update contents in the Sales Operations app and create new template versions of the app.

Questions # 43:

The Universal Containers company uses a Microsoft Azure SQL Data Warehouse to gather information about sales representatives' objectives. They want to use Einstein Analytics to gain insights from this data; therefore, they need to automatically load the warehouse's data into an Einstein Analytics dataset on a daily basis. The data alsoneeds to be transformed and merged with data from the company's org.

Which three Einstein Analytics user interface features can be used to complete these requirements? Choose 3 answers

Options:

Dataflow

Microsoft Azure SQL Data Warehouse Connector

Einstein Analytics Connector for Excel

Recipes

Analytics REST API

Answer

A, D, E

Explanation

To automate the loading of data from a Microsoft Azure SQL Data Warehouse into an Einstein Analytics dataset, transform it, and merge it with company data daily, the followingEinstein Analytics user interface features can be used:

A: Dataflow: This tool allows for the creation and management of complex data transformation and integration processes necessary for combining data sources.

D: Recipes: Recipes provide a user-friendlyinterface for performing data transformation tasks without writing code, which can be used for merging and transforming data.

E: Analytics REST API: The API can automate data ingestion and management tasks, providing flexibility and control over data integration from external systems.

[Reference: https://developer.salesforce.com/, , QUESTIONNO: 71, A dashboard dataset is growing and the Einstein Analytics consultant notices an impact on performance. The consultant needs to make a few adjustments., Which three actions can the consultant take to improve dashboard performance? Choose 3 answers, A.Reorganize the dashboard widgets., B. Distribute steps among separate pages., C. Use SAQL code to join datasets at runtime., D. Replace separate step filters with a global filter., E. Move calculations to a dataflow., Answer: BDE, , To improve dashboard performance in the face of growing datasets, the Einstein Analytics consultant can take the following actions:, B: Distribute steps among separate pages: This reduces the load on any single page, enhancing performance by only loading data necessary for the view being accessed., D: Replace separate step filters with a global filter: This reduces the number of queries and processing needed as the global filter applies universally, streamlining data handling., E: Move calculations to a dataflow: Offloading calculationsto a dataflow minimizes the processing required at runtime, which can significantly improve dashboard performance., These actions optimize the performance of Einstein Analytics dashboards by efficiently managing how data is processed and displayed.Reference: https://help.salesforce.com/, ]

Questions # 44:

A company used Einstein Analytics to create two datasets:

1. "Opportunity With Account- dataset, which contains data from the Opportunity standard objectaugmented 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 number of Opportunities and Cases per Account. How can a consultant help them build this lens'

Options:

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

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

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

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

Answer

Explanation

To build a lens showing the total number of Opportunities and Cases per Account using two separate datasets, the consultant can:

D: Use a SAQL query to group and jointhe "OpportunityWithAccount" and "CaseWithAccount" datasets then generate the results. This method involves writing a SAQL query that groups the data by Account and aggregates the number of Opportunities and Cases, providing a unified view of the data across both datasets.

[Reference: https://developer.salesforce.com/, , QUESTIONNO: 91, The client is trying to create a SAQL step to predict sales in each sales region. They cannot get the query to return any results, but have identified that the error is in the time series statement. They have asked an Einstein Consultant to review the following query and fix any errors., , Which timeseries statement will fix the query', A. q = timeseries q generate 'sum_Sales' as Forecasted_Sales' with (dateCols=('Date_Year, Date_Quarter', "Y-Q"), partition=Region', ignoreLast=true);, B. q = timeseriesq generate 'sum_Sales' as Forecasted_Sales' with (Iength = 12, dateCols=('Date_Year', 'Date_Month". "Y-M"), partition='Region');, C. q = timeseries q generate 'sum_Sales' as Torecasted_Sales' with (dateCols=('Date_Year', Date_Quarter', "Y-Q"), partition='Region', seasonality=4);, D. q = timeseries q generate 'sum_Sales' as Torecasted_Sales' with (dateCols=('Date_Year', Date_Quarter', "Y-Q"), partition='Region');, Answer: C, , The correct timeseries statement to fix the SAQL query for predicting sales in each sales region is:, C: q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Year', 'Date_Quarter', "Y-Q"), partition='Region', seasonality=4). This statement correctly specifies the required parameters for a timeseries analysis, including the date columns, the partition by 'Region', and the seasonality factor, which is crucial for accurate forecasting in time series analysis., This adjustment addresses typical issues in timeseries queries related to date handling and regional partitioning, ensuring the query returns meaningful forecasting results.Reference: https://developer.salesforce.com/, ]

Questions # 45:

What can you do on the Edit Field Attributes page when uploading a CSV file to Analytics?

Options:

Change a field's name

Change a field's format

Change a field's type

All of the above

Questions # 46:

Einstein Discoverygives you several different kinds of recommended insights. Which of these insights is descriptive?

Options:

What Happened

Why It Happened

Predictions & Improvements

What Is the Difference

Questions # 47:

Permissions of which 2 internal users are used by Analytics to gain access to Salesforce data?

Options:

Each user has a corresponding Profile assigned (Analytics Cloud Integration User and AnalyticsCloud Security User profiles).

When you query a dataset that has row-level security based on the User object, Analytics uses the permissions of the Security User to access the User object and its fields.

Analytics uses the permissions of the Integration User to extract data from Salesforce objects and fields when a dataflow job runs.

Questions # 48:

Which set of statements generates monthly amount on a cumulative basis annually?

Question # 48

Options:

Option A

Option B

Option C

Option D

Questions # 49:

Max of objects that can be enabled for Data Sync

Options:

200

100

150

Questions # 50:

Your sales team requests that datasets for their dashboards arerefreshed every hour. You agree to investigate if this is possible and find that the dashboards use A datasets created from two recipes. The first recipe takes 43 min to run and the second recipe takes 25 min to run.

Is it possible to refresh data every hour?