ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 63 - Professional Google Workspace Administrator discussion

Report
Export

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?

A.
From the Admin Console Billing Menu, turn off auto-assign, and then click into Assigned Users and export the data to Sheets.
Answers
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.
Answers
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.
Answers
C.
From the Google Workspace Reports Menu, run and download the Accounts Aggregate report, and export the data to Google Sheets.
D.
From the Admin Console Users Menu, download a list of all user info columns and currently selected columns.
Answers
D.
From the Admin Console Users Menu, download a list of all user info columns and currently selected columns.
Suggested answer: C

Explanation:

Admin Console: Log into the Google Admin console at admin.google.com.

Reports Menu: Navigate to Reports > Reports.

Accounts Aggregate Report:

Under the ''Reports'' section, select ''Accounts''.

Click on ''Aggregate'' to view the report.

Download Data:

Click on the download icon and choose ''Google Sheets'' as the format to export the data.

This report includes a count of active and suspended users by organizational unit.

Google Sheets:

Open the downloaded report in Google Sheets.

Review and organize the data as needed to present it by Org unit, ensuring it matches the Regions and Departments within your company.

Google Workspace Admin: Reports overview

Google Workspace Admin: Aggregate reports

asked 18/09/2024
Dennis Spring
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first