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 questionsDomain Business initiatives
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.
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. ---
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
Keep practicing
Take the free GOOGLE-WORKSPACE-ADMINISTRATOR practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other GOOGLE-WORKSPACE-ADMINISTRATOR practice questions
- Question 1You work for an international organization and your CEO frequently travels to other count…
- Question 3Your organization has just appointed a new CISO. They have signed up to receive admin ale…
- Question 4In the years prior to your organization moving to Google Workspace, it was relatively com…
- Question 5All Human Resources employees at your company are members of the “HR Department” Team Dri…
- Question 6Your Accounts Payable department is auditing software license contracts companywide and h…
- Question 7Your Chief Information Security Officer is concerned about phishing. You implemented 2 Fa…
