Online Access Free Desktop-Certified-Associate Practice Test

Connect to the "Global Superstore" data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales. Which of the following sub-categories has met or exceed the target profit?

• A.Tables
• B.Labels
• C.Copiers
• D.Paper

How to add reference lines in a view? (Select correct two answers)

• A.Using Analysis Menu
• B.Right Click on Axis and Add Reference Line
• C.Using Data Pane
• D.Using Analytics pane

Connect to the "Global Superstore" data source and use the Orders table. Find out how many distinct customers have made 6 orders?

• A.31
• B.29
• C.30
• D.None of the above

What is the default join type when you blend two data sources?

• A.Left outer join
• B.Right join
• C.Inner join
• D.Outer join

We can create variable size bins using ___________?

• A.Calculated Fields
• B.Sets
• C.Groups
• D.Hierarchies