Google Cloud Professional Collaboration Engineer — Question 72

In your organization, users have been provisioned with either G Suite Enterprise, G Suite 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 G Suite 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.
• D. Create an app using AppMaker and App Script.

Correct answer: C

Explanation

The correct answer is C because using App Script in combination with Google Sheets allows team leaders to access the required information without administrative privileges while maintaining a self-service approach. This solution is cost-effective and can be set up to ensure data is updated within the necessary timeframe. Options A and D involve more complexity and potential costs, and option B may not provide the necessary self-service capability specific to direct reports.