New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Discussions
  3. Google
  4. Google Cloud Platform
  5. Associate-Data-Practitioner Discussions
  6. Associate-Data-Practitioner Exam Topic 3 Question 29 Discussion

Google Cloud Associate Data Practitioner (ADP Exam) Associate-Data-Practitioner Question # 29 Topic 3 Discussion

 Google Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Google Cloud Associate Data Practitioner (ADP Exam) Associate-Data-Practitioner Question # 29 Topic 3 Discussion

Associate-Data-Practitioner Exam Topic 3 Question 29 Discussion:
Question #: 29
Topic #: 3

Your organization is conducting analysis on regional sales metrics. Data from each regional sales team is stored as separate tables in BigQuery and updated monthly. You need to create a solution that identifies the top three regions with the highest monthly sales for the next three months. You want the solution to automatically provide up-to-date results. What should you do?
A.

Create a BigQuery table that performs a union across all of the regional sales tables. Use the row_number() window function to query the new table.

B.

Create a BigQuery table that performs a cross join across all of the regional sales tables. Use the rank() window function to query the new table.

C.

Create a BigQuery materialized view that performs a union across all of the regional sales tables. Use the rank() window function to query the new materialized view.

D.

Create a BigQuery materialized view that performs a cross join across all of the regional sales tables. Use the row_number() window function to query the new materialized view.

Get Premium Associate-Data-Practitioner Questions
Actual exam question for Google Associate-Data-Practitioner exam by Nyx1112 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next