Prepare with Salesforce Analytics-Con-301 exam torrent, pass for sure

An executive-level workbook leverages 37 of the 103 fields included in a data source. Performance for the workbook is noticeably slower than other workbooks on the same Tableau Server.
What should the consultant do to improve performance of this workbook while following best practice?

• A. Use filters, hide unused fields, and aggregate values.
• B. Connect to the data source via a custom SQL query.
• C. Split some visualizations on the dashboard into many smaller visualizations on the same dashboard.
• D. Restrict users from accessing the workbook to reduce server load.

A client is evaluating which user roles to assign to managers. The managers need to view dashboards, create Data-Driven Alerts, and perform ad hoc analysis of existing Tableau data sources. A consultant must provide a solution that minimizes licensing costs.
Which role should the consultant recommend be assigned to the managers?

• A. Site Administrator
• B. Explorer
• C. Creator
• D. Viewer

A client has a pipeline dashboard that takes a long time to load. The dashboard is connected to only one large data source that is an extract.
It contains two calculated fields:
. TOTAL([Opportunities])
SUM([Value])
It also contains two filters:
. A Relative Date filter on Created Date, a Date field containing values from 5 years ago until today
. A Multiple Values (Dropdown) filter on Account Name, a String field containing 1,000 distinct values A consultant creates a Performance Recording to troubleshoot the issue, and finds out that the longest-running event is "Executing Query." Which step should the consultant take to resolve this issue?

• A. Replace SUM([Value]) with WINDOW_SUM([Value]).
• B. Replace the Relative Date filter with a Multiple Values (Dropdown) filter on YEAR([Created Date]).
• C. Replace the Multiple Values (Dropdown) filter with a Multiple Values (Custom List) filter.
• D. Replace the TOTAL([Opportunities]) calculation with a Grand Total.

A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version.
The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.

The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed.
The client wants to improve the performance of
the dashboard while also getting an accurate count of site visitors.
Which modifications to the data tables and join should the consultant recommend?

• A. Continue to use NULL as the BrowserID in the Site Visitor Table and leave the Referential Integrity set to "Some Records Match."
• B. Add an "Unknown" option to the Browser Table, reference its BrowserID in the Site Visitor Table, and leave the Referential Integrity set to
  "Some Records Match."
• C. Continue to use NULL as the BrowserID in the Site Visitor Table and change the Referential Integrity to "All Records Match."
• D. Add an "Unknown" option to the Browser Table, reference its BrowserID in the Site Visitor Table, and change the Referential Integrity to "All Records Match."

A client has a large data set that contains more than 10 million rows.
A consultant wants to calculate a profitability threshold as efficiently as possible. The calculation must classify the profits by using the following specifications:
. Classify profit margins above 50% as Highly Profitable.
. Classify profit margins between 0% and 50% as Profitable.
. Classify profit margins below 0% as Unprofitable.
Which calculation meets these requirements?

• A. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• B. IF [ProfitMargin]>=0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSE 'Unprofitable'
  END
• C. IF([ProfitMargin]>=0.50,'Highly Profitable', 'Profitable')ELSE 'Unprofitable'END
• D. IF [ProfitMargin]>0.50 Then 'Highly Profitable'
  ELSEIF [ProfitMargin]>=0 Then 'Profitable'
  ELSEIF [ProfitMargin] <0 Then 'Unprofitable'END