75only - Ends in 0d 00h 00m 00s - Coupon code = 75only

Pass the Salesforce Consultant Analytics-Con-201 Questions and answers with Dumpstech

Exam Analytics-Con-201 Premium Access

View all detail and faqs for the Analytics-Con-201 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 3 out of 4 pages
Viewing questions 21-30 out of questions
Questions # 21:

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?

Options:

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.

Questions # 22:

CRM Analytics team plans to enable data sync.

Which limit specific to data syne should the team consider before enabling the feature because it may impact existing jobs?

Options:

A.

Maximum number of data sync jobs cannot exceed the limit

B.

Maximum number of Full Sync connection mode enabled

C.

Maximum number of objects that can be enabled for data sync

Questions # 23:

Universal Containers (UC) has a "Sales Manager” dashboard. UC has a compare table that has multiple groupings and columns added showing the Total and Subtotals of the numeric values. A consultant is

asked to add additional groups to enhance details about UC's customers.

Which feature should the consultant use to make the navigation of the compare tables easier for the end user?

Options:

A.

Create the table using SAQL query to accommodate this and make It user friendly.

B.

Select the Enable Expand or Collapse option from the table properties.

C.

Scroll to the very end to see the details.

Questions # 24:

A new picklist value was added for the Category field on the Account object. This field is already added as part of the Account object data sync and the respective recipe that uses this field.

The CRM Analytics team reports that when they start the recipe it runs successfully with no errors or warnings, but theyare unable to See this new valueson their existing dashboards.

What is the oridi4 of this issue?

Options:

A.

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

B.

The Integration User profile does not have access to the field.

C.

There are no records in Salesforce with this new plicklist value.

Questions # 25:

Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing

the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

Question # 25

How should a CRM Analytics consultant help UC build this lens?

Options:

A.

Use a "fill" statement in SAQL query with a "partition" parameter.

B.

Use a “Compare Table" and add a column leveraging the “Running Total” function.

C.

Use a "Compare Table" and use the "Show Totals" option.

Questions # 26:

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.

Options:

A.

The users have access to the dashboard but not the dataset.

B.

The dashboard has been created for internal use and theusers have a view only license.

C.

The permission set for the users is missing the download data permission.

Questions # 27:

Universal Containers uses CRM Analytics to build dashboards for different departments: Sales, Service, and Marketing. Users in the samedepartment have the same role and need to have access to the same dashboards. Dashboards for different departments use some common datasets with the same row-level security.

How should a CRM Analytics consultant address this need?

Options:

A.

Create one app for each department, put common datasets in the shared app, and use roles to share apps.

B.

Create one app for each department, put common datasets in the shared app, and use profiles to share apps.

C.

Create one app for each department, put common datasets in the shared app, and use permission sets to share apps.

Questions # 28:

Universal Containers (UC) recently activated data sync in the CRM Analytics data manager. After running the sync, UC notices that the aggregate sum of a field within the company's dataset is different

than what they manually calculated by summing the same data in the Salesforce object.

What is causing the issue with the newly synced data?

Options:

A.

Differences involving flow-updated fields

B.

Differences involving formula fields

C.

Differences involving trigger-updated fields

Questions # 29:

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?

Options:

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

C.

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

Questions # 30:

A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data wasuploaded successfully. Upon analyzing the data using a lens, they find

they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.

What is causing the problem?

Options:

A.

JSON metadata file was not uploaded along with the CSV data file.

B.

The field value added in the CSV file was contained within double quotes.

C.

Proper transformations need to be performed at the external source prior to External Data API callout.

Viewing page 3 out of 4 pages
Viewing questions 21-30 out of questions