Question 1

Connect to the "Global Superstore" data source and find out which 'Customer Name' (ignore the customer ID) has returned the highest percentage of his\her orders?

Options :

A : Michael Oakman

B : Daniel Lacy

C : Greg Tran

D : Yoseph Carroll

Answer: B

Question 2

Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all the categories in 2015 by customers who have purchased any product in the Phones sub-category in 2014? Use Customer ID.

Options :

A : 4.90%

B : 5.03%

C : 4.53%

D : 3.45%

Answer: D

Question 3

You have a workbook that connects to a database. The database requires authentication. You plan to publish the workbook and schedule a daily refresh of the data. Which two conditions must be met to schedule the refresh? Choose two.

Options :

A : The credentials must be embedded.

B : The data source must be stored as a hyper file.

C : The data source must use a live connection.

D : The data must be extracted.

Answer: A,D

Question 4

Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?

Options :

A : Belkin Router, USB

B : Cisco Smart Phone, Full Size

C : Nokia Smart Phone, with Caller ID

D : Bush Classic Bookcase, Pine

Answer: D

Question 5

Connect to the "Kiva Loans - India" data source, which sector's funded amount is closest to the median of all the sectors?

Options :

A : Education

B : Clothing

C : Construction

D : Retail

Answer: B

Free TDA-C01 Mock Exam – Practice Online Confidently

Buying Options: