Download Valid Salesforce Analytics-Con-301 Dumps for Best Preparation
Exam : Analytics-Con-301
Title : Salesforce Certified Tableau
Consultant
https://www.passcert.com/Analytics-Con-301.html
1/8
, Download Valid Salesforce Analytics-Con-301 Dumps for Best Preparation
1.A consultant wants to improve the performance of reports by moving calculations to the data layer and
materializing them in the extract.
Which calculation should the consultant use?
A. ZN([Sales])*(1 - ZN([Discount]))
B. CASE [Sector Parameter]WHEN 1 THEN "green"WHEN 2 THEN "yellow"
C. SUM([Profit])/SUM([Sales])
D. POWER(ZN(SUM([Sales]))/LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))- 1END
Answer: C
Explanation:
To improve performance by moving calculations to the data layer and materializing them in the extract,
the consultant should choose calculations that benefit from pre-computation and significantly reduce the
load during query time:
Aggregation-Level Calculation: The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an aggregate
level, which is ideal for pre-computation. Materializing this calculation in the extract means that the
complex division operation is done once and stored, rather than being recalculated every time the report
is accessed.
Performance Improvement: By pre-computing this aggregate ratio, Tableau can utilize the pre-calculated
fields directly in visualizations, which speeds up report loading and interaction times as the heavy lifting of
data processing is done during the data preparation stage.
Reference: Materialization in Extracts: This concept involves pre-calculating and storing complex
aggregations or calculations within the Tableau data extract itself, improving performance by reducing the
computational load during visualization rendering.
2.A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three
groups of users are organized on Tableau Server with the following levels of data access that they can be
granted.
. Group 1: Viewers who cannot see any information on profitability
. Group 2: Viewers who can see profit and profit margin
. Group 3: Viewers who can see profit margin but not the value of profit
Which approach should the consultant use to provide the required level of access?
A. Use user filters to access data on profitability to all groups. Then, create a calculated field that allows
visibility of profit value to Group 2 anduse the calculation in the view in the report.
B. Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or
none of these. Then, use the tabledata to create user filters in the report.
C. Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated
field that limits visibility of profit value toGroup 2 and use the calculation in the view in the report.
D. Specify with user filters in each view individuals who can see profit, profit margin, or none of these.
Answer: C
Explanation:
The approach of using user filters to control access to data on profitability for Groups 2 and 3, combined
with a calculated field that restricts the visibility of profit value to only Group 2, aligns with Tableau’s best
practices for managing content permissions. This method ensures that each group sees only the data
they are permitted to view, with Group 1 not seeing any profitability information, Group 2 seeing both profit
and profit margin, and Group 3 seeing only the profit margin without the actual profit values. This setup
2/8
Exam : Analytics-Con-301
Title : Salesforce Certified Tableau
Consultant
https://www.passcert.com/Analytics-Con-301.html
1/8
, Download Valid Salesforce Analytics-Con-301 Dumps for Best Preparation
1.A consultant wants to improve the performance of reports by moving calculations to the data layer and
materializing them in the extract.
Which calculation should the consultant use?
A. ZN([Sales])*(1 - ZN([Discount]))
B. CASE [Sector Parameter]WHEN 1 THEN "green"WHEN 2 THEN "yellow"
C. SUM([Profit])/SUM([Sales])
D. POWER(ZN(SUM([Sales]))/LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))- 1END
Answer: C
Explanation:
To improve performance by moving calculations to the data layer and materializing them in the extract,
the consultant should choose calculations that benefit from pre-computation and significantly reduce the
load during query time:
Aggregation-Level Calculation: The formula SUM([Profit])/SUM([Sales]) calculates a ratio at an aggregate
level, which is ideal for pre-computation. Materializing this calculation in the extract means that the
complex division operation is done once and stored, rather than being recalculated every time the report
is accessed.
Performance Improvement: By pre-computing this aggregate ratio, Tableau can utilize the pre-calculated
fields directly in visualizations, which speeds up report loading and interaction times as the heavy lifting of
data processing is done during the data preparation stage.
Reference: Materialization in Extracts: This concept involves pre-calculating and storing complex
aggregations or calculations within the Tableau data extract itself, improving performance by reducing the
computational load during visualization rendering.
2.A consultant builds a report where profit margin is calculated as SUM([Profit]) / SUM([Sales]). Three
groups of users are organized on Tableau Server with the following levels of data access that they can be
granted.
. Group 1: Viewers who cannot see any information on profitability
. Group 2: Viewers who can see profit and profit margin
. Group 3: Viewers who can see profit margin but not the value of profit
Which approach should the consultant use to provide the required level of access?
A. Use user filters to access data on profitability to all groups. Then, create a calculated field that allows
visibility of profit value to Group 2 anduse the calculation in the view in the report.
B. Specify in the row-level security (RLS) entitlement table individuals who can see profit, profit margin, or
none of these. Then, use the tabledata to create user filters in the report.
C. Use user filters to allow only Groups 2 and 3 access to data on profitability. Then, create a calculated
field that limits visibility of profit value toGroup 2 and use the calculation in the view in the report.
D. Specify with user filters in each view individuals who can see profit, profit margin, or none of these.
Answer: C
Explanation:
The approach of using user filters to control access to data on profitability for Groups 2 and 3, combined
with a calculated field that restricts the visibility of profit value to only Group 2, aligns with Tableau’s best
practices for managing content permissions. This method ensures that each group sees only the data
they are permitted to view, with Group 1 not seeing any profitability information, Group 2 seeing both profit
and profit margin, and Group 3 seeing only the profit margin without the actual profit values. This setup
2/8
