GOOGLE-WORKSPACE-ADMINISTRATOR practice question 6 of 25

Your Accounts Payable department is auditing software license contracts companywide and has asked you to provide a report that shows the number of…

Full set: 199 questions

Domain Data access and security

Your Accounts Payable department is auditing software license contracts companywide and has 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?
Answer options
A: From the Admin Console Billing Menu, turn off auto-assign, and then click into Assigned Users and export the data to Sheets.
B: From the Admin Console Users Menu, download a list of all Users to Google Sheets, and join that with a list of ORGIDs pulled from the Reports API.
C: From the Google Workspace Reports Menu, run and download the Accounts Aggregate report, and export the data to Google Sheets. Correct answer
D: From the Admin Console Users Menu, download a list of all user info columns and currently selected columns.
Correct Answer:
C. From the Google Workspace Reports Menu, run and download the Accounts Aggregate report, and export the data to Google Sheets.
Explanation

The Accounts Aggregate report within the Google Workspace Admin Console is the most direct and efficient tool for this task. This report is specifically designed to provide summary data on user accounts. It allows an administrator to view the total number of users, as well as counts for specific statuses like 'active' and 'suspended'. Crucially, the report can be filtered and organized by organizational unit (OU), directly fulfilling the Accounts Payable department's request. The generated report can then be exported to Google Sheets for auditing purposes.

Why Incorrect

A. The Billing menu is for managing licenses and subscriptions, not for generating detailed reports on user status across organizational units.
B. This method is unnecessarily complex. The user list downloaded from the Users menu already contains OU information, making a separate API pull and join redundant and inefficient.
D. This action downloads a raw, unaggregated list of all users. It would require significant manual data manipulation (e.g., creating a pivot table) in Google Sheets to get the required counts.

References

1. Google Workspace Admin Help, "Accounts reports." This official documentation details the capabilities of the Accounts report within the Aggregate reports section. It states, "You can use the Accounts report to view a summary of your account's user status... You can also see how many users are active, suspended, or blocked..." and "To see the report for a specific organizational unit, select it from the list." This directly supports option C.

Source: Google Workspace Admin Help, Reports > Aggregate reports > Accounts reports.

2. Google Workspace Admin Help, "Download a list of users." This document describes the process of downloading user information from the Users list. The output is a CSV file containing individual user data, not an aggregated summary. This confirms that option D provides raw data requiring further processing, making it less efficient than option C.

Source: Google Workspace Admin Help, Directory > Users > Manage user accounts > Download a list of users.

Scroll to Top