Free Salesforce Analytics-Con-301 Exam Dumps Questions & Answers

A Tableau consultant tasked with evaluating a data structure is handed the below sample dataset.
Which two statements are true about the dataset? Choose two.

• A.The data can be pivoted in order to enable a year selector.
• B.The names of the columns are accurate and indicate what the data values actually mean.
• C.The data needs to be denormalized before it can be used.
• D.The data structure will require a lot of maintenance, as maintenance will need to be done to handle a new column for a new year.

In what way does View Acceleration improve performance?

• A.By improving the performance of views that contain long-running queries with transient functions
• B.By optimizing the performance of views built only on extract-based data sources
• C.By precompiling and fetching workbook data in a background process
• D.By enhancing the rendering speed of visuals, such as drawing shapes and maps

A business analyst is creating a view of the top 10 customers for each region. The analyst has set a "Top 10" filter on Customer Name. However, it did not display the top 10 customers per region, as shown in the image below.

Which type of filter should the business analyst add to filter for region?

• A.Context filter
• B.Extract filter
• C.Table Calculation filter
• D.Dimension filter

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.SUM([Profit])/SUM([Sales])
• C.CASE [Sector Parameter]
  WHEN 1 THEN "green"
  WHEN 2 THEN "yellow"
• D.POWER(ZN(SUM([Sales]))/
  LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))- 1END

A client has several long-term shipping contracts with different vendors that set rates based on shipping volume and speed. The client requests a dashboard that allows them to model shipping costs for the next week based on the selected shipping vendor. Speed for the end user is critical.
Which dashboard building strategy will deliver the desired result?

• A.Aggregate the orders then use a calculated field that refers to a user-selected parameter to calculate the shipping costs.
• B.Use a calculated field that refers to a user-selected parameter to calculate shipping costs for each order and then display the aggregate values.
• C.Calculate the potential shipping cost for each order with each vendor, display the aggregate costs in a large table, and use quick filters to limit the options visible to the user.
• D.Recommend that the client model for only profitability for the next 24 hours instead of a full week.