ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 2 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 2
Topic #: 1
[All Associate Data Practitioner Questions]

Your company has several retail locations. Your company tracks the total number of sales made at each location each day. You want to use SQL to calculate the weekly moving average of sales by location to identify trends for each store. Which query should you use?

  • A.
    -------------------------
  • B.
    -------------------------
  • C.
    -------------------------
  • D.
    -------------------------
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by trashbox at Jan. 22, 2025, 1:46 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
trashbox
2 weeks, 1 day ago
Selected Answer: C
Should be partitioned by store_id to keep averages separate: A or C Then, should be ordered by date for chronological window calculation: C
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago