Online Access Free Analytics-DA-201 Practice Test

You have the following calculated fields in a worksheet.
[Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Correct Answer:

Explanation:

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and
[Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]

Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

• A.the column banding size to 1
• B.the row banding size to 1
• C.the column banding size to 3
• D.the row banding size to 3

A Data Analyst has the following two tables named Orders and Returns.

The analyst needs to get the Customer ID and Customer Name for only the orders that were returned. Orders will be the leading table.
Which type of join should the analyst perform in Tableau Prep?

• A.Unmatched only join
• B.Inner join
• C.Full join
• D.Left join

You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

• A.Add both sheets to the dashboard. Set Fit to Fix width.
• B.Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
• C.Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
• D.Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.