LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Google Professional Data Engineer

Google Professional Data Engineer

Get started today

Ultimate access to all questions.


As a data engineer for a large fast food restaurant chain with over 400,000 employees, you are responsible for managing employee information stored in Google BigQuery. The employee data is currently held in a Users table, which has separate fields for FirstName and LastName. An IT team member is developing an application and has requested that you adjust the schema and data so the application can query a FullName field. This FullName field should contain the concatenated values of the FirstName and LastName fields, separated by a space, for each employee. How can you modify the schema and data to make the FullName field available while minimizing costs?

Exam-Like



Powered ByGPT-5