A Data Analyst needs to calculate the first Tuesday of each month in the data.
Which set of functions should the analyst use to perform this calculation?

• A.DATEDIFF, DATEPART
• B.DATEADD, DATENAME
• C.DATETRUNC, DATEADD
• D.DATETRUNC, DATEPART

Comment: *

Name: *

Email: *

Verification: *

Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.

Comment: *

Name: *

Email: *

Verification: *

You have a dataset that contains people and the awards they have won.
Which formula should you use to get the number of different types of awards that have been won?

• A.COVAR({Award})
• B.COUNTD({Award})
• C.COUNTD {(NAME])
• D.MAX {(Award})
• E.INDEX()

Comment: *

Name: *

Email: *

Verification: *

A Data Analyst wants to create the following table in a view:

Which function should the analyst use to create the Position column?

• A.INDEX
• B.RANK
• C.FIRST
• D.LAST

Comment: *

Name: *

Email: *

Verification: *

A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?

• A.Export mdb
• B.Book1.twb
• C.Sales.hyper
• D.Sales.csv

Comment: *

Name: *

Email: *

Verification: *