GOOGLE-WORKSPACE-ADMINISTRATOR practice question 2 of 25

In your organization, users have been provisioned with either Google Workspace Enterprise, Google Workspace Business, or no license, depending on…

Full set: 199 questions

Domain Business initiatives

In your organization, users have been provisioned with either Google Workspace Enterprise, Google Workspace Business, or no license, depending on their job duties, and the cost of user licenses is paid out of each division's budget. In order to effectively manage the license disposition, team leaders require the ability to look up the type of license that is currently assigned, along with the last logon date, for their direct reports. You have been tasked with recommending a solution to the Director of IT, and have gathered the following requirements: Team leaders must be able to retrieve this data on their own (i.e., self-service). Team leaders are not permitted to have any level of administrative access to the Google Workspace Admin panel. Team leaders must only be able to look up data for their direct reports. The data must always be current to within 1 week. Costs must be mitigated. What approach should you recommend?
Answer options
A: Export log data to BigQuery with custom scopes.
B: Use a third-party tool.
C: Use App Script and filter views within a Google Sheet. Correct answer
D: Create an app using AppMaker and App Script.
Correct Answer:
C. Use App Script and filter views within a Google Sheet.
Explanation

This approach leverages tools included within Google Workspace, directly addressing the cost mitigation requirement. An Apps Script can be developed to run with administrative privileges, using the Admin SDK's Directory and Reports APIs to fetch user license types and last login dates. This data can be populated into a central Google Sheet. The script can then create filtered views or separate tabs for each team leader, dynamically displaying only their direct reports by cross-referencing the manager information stored in user profiles. A time-driven trigger can be set to run the script weekly, ensuring the data meets the freshness requirement. This solution is self-service for leaders (they just open a Sheet) and requires no direct admin console access.

Why Incorrect

A. Export log data to BigQuery with custom scopes. This is a more complex and costly solution. While powerful, setting up and maintaining row-level security in BigQuery to scope access for each team leader is significantly more effort and incurs usage costs.
B. Use a third-party tool. This option directly contradicts the requirement to mitigate costs, as third-party tools typically involve additional subscription or licensing fees.
D. Create an app using AppMaker and App Script. Google AppMaker was shut down on January 19, 2021. Therefore, this is not a viable or valid solution. ---

References

1. Google Apps Script & Admin SDK: Apps Script can call other Google services, including the Admin SDK, which is necessary to retrieve user data. The Directory API provides user attributes like license status and manager relationships, while the Reports API provides login activity.

Source: Google Developers, Apps Script Documentation, "Calling Google APIs from Apps Script".

Reference: https://developers.google.com/apps-script/guides/services/advanced#googleworkspaceservices

2. Admin SDK API for User Data: The Users: get method in the Directory API can retrieve a user's lastLoginTime and their relations field (which contains manager information). The Users: list method can be used to iterate through users and check their license status.

Source: Google Developers, Admin SDK Directory API v1 Documentation.

Reference: https://developers.google.com/admin-sdk/directory/v1/reference/users/get

3. Apps Script Installable Triggers: To meet the requirement for data to be current within one week, a time-driven trigger can be configured to execute the script on a weekly schedule.

Source: Google Developers, Apps Script Documentation, "Installable Triggers".

Reference: https://developers.google.com/apps-script/guides/triggers/installable#time-driventriggers

4. AppMaker Shutdown: Official announcement detailing the deprecation and shutdown of the AppMaker service.

Source: Google Workspace Updates Blog.

Reference: "Heads-up: App Maker will be turned down on January 19, 2021", https://workspaceupdates.googleblog.com/2020/01/app-maker-deprecation.html

Scroll to Top