Free Salesforce Analytics-Con-301 Exam Questions

Question 1

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud. The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer] Which column in the table below should the data analyst reference in the calculation?

A : Abbreviated Name

B : Email

C : Lower case Name

Answer: B

Question 2

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud. The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer] Which column in the table below should the data analyst reference in the calculation?

A : Abbreviated Name

B : Email

C : Lower case Name

Answer: B

Question 3

A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server. Which two features should the business analyst use to create the view? Choose two.

A : Relationships

B : Cross-Database Joins

C : Data Blending

D : Union

Answer: A,B

Question 4

A client has a sales dataset that contains fields named Customer ID, Region, Item, and Sales Amount. Each row represents a single sale. There may be multiple sales for each Customer ID. The client wants to visualize the average total customer sales by region. Which Level of Detail (LOD) expression should a consultant recommend?

A : AVG({EXCLUDE [Region]: SUM([Sales Amount])})

B : {FIXED [Region]: AVG([Sales Amount])}

C : AVG({FIXED [Customer ID], [Region]: SUM([Sales Amount])})

D : {FIXED [Customer ID], [Region]: AVG([Sales Amount])}

Answer: C

Question 5