ExamGecko
Question list
Search
Search

List of questions

Search

Question 4 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and create a view to show only those orders which were returned. What is the unique number of orders returned in the North Africa region in the office supplies category? Consider only those orders which were shipped using Standard Class ship mode.

A.
16
Answers
A.
16
B.
12
Answers
B.
12
C.
14
Answers
C.
14
D.
10
Answers
D.
10
Suggested answer: B

Explanation:

Create an inner join between Orders and Returns table using Order ID

Create a calculated field to find the unique order.

Drop Region, Ship Mode, and Category to Rows. And drop 'countd order' field to Text. The final view would look like this:

asked 23/09/2024
claudine Nguepnang
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first