ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 16 - Professional Google Workspace Administrator discussion

Report
Export

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?

A.
Export log data to BigQuery with custom scopes.
Answers
A.
Export log data to BigQuery with custom scopes.
B.
Use a third-party tool.
Answers
B.
Use a third-party tool.
C.
Use App Script and filter views within a Google Sheet.
Answers
C.
Use App Script and filter views within a Google Sheet.
D.
Create an app using AppMaker and App Script.
Answers
D.
Create an app using AppMaker and App Script.
Suggested answer: C

Explanation:

Develop an App Script:

Write an App Script to retrieve user data from the Google Workspace directory, including license type and last login date.

Ensure the script filters data based on the team leader's direct reports.

Create a Google Sheet:

Set up a Google Sheet to display the retrieved data.

Use filter views to restrict the data visible to each team leader, showing only their direct reports.

Automate Data Refresh:

Schedule the App Script to run periodically (e.g., once a week) to ensure the data is up-to-date.

Share with Team Leaders:

Share the Google Sheet with team leaders, ensuring they have view-only access to the relevant filter views.

Google Workspace Admin Help: App Script

Google Workspace Admin Help: Filter views in Google Sheets

asked 18/09/2024
Anna Pytka
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first