Free Google-Workspace-Administrator Actual Exam Questions - Question 6 Discussion
asked you to provide a report that shows the number of active and suspended users by organization
unit, which has been set up to match the Regions and Departments within your company. You need
to produce a Google Sheet that shows a count of all active user accounts and suspended user
accounts by Org unit.
What should you do?
I get why B looks appealing for combining data, but it sounds like extra hassle matching OrgIDs with the user list. D feels more straightforward since you get all user info—including status and Org unit—in one export. That means you can quickly pivot or filter in Sheets without additional API steps. So, I’d pick D for simplicity and less chance of messing up data joins.
Maybe D makes the most sense here since it directly gives you all user info including status and Org unit, no need for extra API work or joins. That way you can just filter and count active vs suspended in Sheets without fuss. B sounds more complicated with having to merge data sets and handle OrgIDs separately, which might slow things down. If the goal’s a quick and straightforward report, grabbing all data straight from the Users Menu seems cleaner and less error-prone.
D - Downloading all user info directly includes status and Org unit, no API needed.
B I think this is the only option that gives you both active and suspended user data with Org unit info, especially since you can pull OrgIDs from the Reports API for accurate grouping.
It’s D too, since downloading all user info including status and Org unit directly from Users Menu simplifies counting.
B imo, it's the only one letting you get both active and suspended users by Org unit in one go.
It’s B because you can get all users’ statuses and their Org unit IDs, then use Sheets to count active vs suspended by unit. The Reports API gives the detail you need that other options might miss.
Maybe B works since exporting all users plus org IDs from the Reports API could let you filter and count both active and suspended separately in Sheets. It’s more manual but covers both statuses clearly.
I’m not sure about C either. Even if the Accounts Aggregate report shows counts by Org unit, I don’t think it breaks down suspended users separately—usually those reports focus on active accounts only. D might be better since you get all user info including status, then you can filter and count active versus suspended yourself in Sheets. It’s a bit more manual but gives you exact data. Has anyone checked if the Reports API or export options in D include user status clearly? That might confirm which one actually lets you split by suspended and active.
Option C’s the best—only one that gives you active and suspended counts by Org unit.
This one’s definitely C. The Accounts Aggregate report gives you that breakdown by Org unit right away, so exporting to Sheets is straightforward.